导出到excle

来源：互联网发布：java判断目录是否存在编辑：程序博客网时间：2024/05/18 13:30

Tool.UpLoadFile(Tool.GetValueFromWebConfig("help") + fileName, fileUpLoad.PostedFile.InputStream, 256);

/// <summary>
/// 上传文件
/// </summary>
/// <param name="FileName">要上传的文件路径（虚拟路径）</param>
/// <param name="stream">文件流</param>
/// <param name="size">文件的大小</param>
public static void UpLoadFile(string FileName, System.IO.Stream stream, int size)
{
string path = HttpContext.Current.Server.MapPath(FileName);
string directory = path.Substring(0, path.LastIndexOf(@"\"));
if (!System.IO.Directory.Exists(directory))
{
System.IO.Directory.CreateDirectory(directory);
}
int updateLoadLength = 20480;
long filelength = stream.Length;
byte[] byt = new byte[updateLoadLength];
System.IO.Stream writeStream = new System.IO.FileStream(path, System.IO.FileMode.OpenOrCreate);
while (filelength > 0)
{
stream.Read(byt, 0, updateLoadLength);
writeStream.Write(byt, 0, updateLoadLength);
filelength = filelength - updateLoadLength;
}
writeStream.Close();
writeStream.Dispose();
stream.Close();
stream.Dispose();
}

Tool.DownLoadFile(tab_atta.AttachName, Tool.GetValueFromWebConfig("path") + tab_atta.AttachRealName);

/// <summary>

/// 下载附件
/// </summary>
/// <param name="fileName">附件名称</param>
/// <param name="path">附件所在的路径(虚拟)</param>
public static void DownLoadFile(string fileName, string path)
{

byte[] buffer = new Byte[10000];
path = HttpContext.Current.Server.MapPath(path);
System.IO.FileInfo fileInfo = new System.IO.FileInfo(path);
if (fileInfo.Exists)
{
HttpContext.Current.Response.Clear();
System.IO.FileStream iStream = System.IO.File.OpenRead(path);
long dataLengthToRead = iStream.Length;//获取下载的文件总大小
HttpContext.Current.Response.ContentType = "application/octet-stream";
HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(fileName));

while (dataLengthToRead > 0 && HttpContext.Current.Response.IsClientConnected)
{
int lengthRead = iStream.Read(buffer, 0, Convert.ToInt32(10000));//读取的大小
HttpContext.Current.Response.OutputStream.Write(buffer, 0, lengthRead);
HttpContext.Current.Response.Flush();
dataLengthToRead = dataLengthToRead - lengthRead;
}
HttpContext.Current.Response.Close();
}
}

/// <summary>
/// 将指定的内容导出为word文档
/// </summary>
/// <param name="context">文本内容</param>
/// <param name="path">导出的路径</param>
public static void ExportWord(string context, string path)
{
byte[] filedata = System.Text.Encoding.UTF8.GetBytes(context);
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ContentType = "application/msword";
HttpContext.Current.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", HttpUtility.UrlEncode(path)));
HttpContext.Current.Response.Flush();
HttpContext.Current.Response.BinaryWrite(filedata);
HttpContext.Current.Response.End();
}

Tool.ExportExcel(divContent.InnerHtml.ToString(), "33333.xls");

#region 导出Excel文档
/// <summary>
/// 导出Excel文档
/// </summary>
/// <param name="datacontext">excel的内容</param>
/// <param name="filename">文件的名称</param>
public static void ExportExcel(string datacontext, string filename)
{
byte[] filedata = System.Text.Encoding.UTF8.GetBytes(datacontext);
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ContentType = "application/ms-word";
HttpContext.Current.Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}", HttpUtility.UrlEncode(filename)));
HttpContext.Current.Response.Flush();
HttpContext.Current.Response.BinaryWrite(filedata);
HttpContext.Current.Response.End();
}
#endregion