asp.net中数据导出(Word,Excel)以及文件下载

最新推荐文章于 2019-05-23 17:13:00 发布

IT-Style

最新推荐文章于 2019-05-23 17:13:00 发布

阅读量680

点赞数

分类专栏： .Net 文章标签： excel asp.net byte

本文链接：https://blog.csdn.net/softkexin/article/details/5980166

版权

.Net 专栏收录该内容

29 篇文章 0 订阅

订阅专栏

一.数制导出(Word)

Response.Clear();
Response.Buffer = true;
Response.AddHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToShortDateString() + ".doc");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.ContentType = "application/ms-word";

Response.Write(strTable.ToString());

Response.End();

二.数据导出(Excel)

Response.Clear();
Response.Buffer = true;
Response.AddHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToShortDateString() + ".xls");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.ContentType = "application/ms-Excel";

Response.Write(strTable.ToString());

Response.End();

三.数据下载

FileStream fsUpload = new FileStream(strPath, FileMode.Open);
byte [] bytesUpload=new byte[(int)fsUpload.Length];
fsUpload.Read(bytesUpload, 0, bytesUpload.Length);
fsUpload.Close();

Response.Clear();
Response.ContentType = "application/octet-stream";
Response.AddHeader("Content-Disposition", "attachment; filename=" + HttpUtility.UrlEncode(strFileName, System.Text.Encoding.UTF8));
Response.BinaryWrite(bytesUpload);
Response.Flush();
Response.End();