C#导入导出excel文件案例 c#经典案例.pdf

C#导⼊导出导⼊导出 excel⽂件案例⽂件案例

个⼈总结导出excel报表的案例：

//导出报表

protected void btnExport_Click(object sender, EventArgs e)

{

List<ProOutContract> list = GetDataTableFromIList();

if (list == null || (list != null && list.Count == 0))

{

FileInfo DownloadFile = new FileInfo(savePath); //设置要下载的⽂件

Response.Clear(); //清除缓冲区流中的所有内容输出

Response.ClearHeaders(); //清除缓冲区流中的所有头

Response.Buffer = false; //设置缓冲输出为false

//设置输出流的 HTTP MIME 类型为application/octet-stream

Response.ContentType = "application/octet-stream";//将 HTTP 头添加到输出流

Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("⼯程信息外部合同登记表.xls", System.Text.Encoding.UTF8));

//Response.AppendHeader("Content-Length", DownloadFile.Length.ToString());//将指定的⽂件直接写⼊ HTTP 内容输出流。

//Response.WriteFile(DownloadFile.FullName);

Response.WriteFile(savePath);

{

int pageNumber = 1;

PageBean page = new PageBean();

page.CurrentPage = pageNumber;

page.PageSize = 100000;

ProOutContract pb = null;

if (ViewState["queryModel"] != null)

{

pb = ViewState["queryModel"] as ProOutContract;

}