asp.net导出excel表

一时失言乱红尘 2021-11-01 23:56 301阅读 0赞

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][] Code   
publicvoid OutPutExcel(string filename)  
\{  
//定义文档类型、字符编码   
 Response.Clear();  
Response.Buffer =true;  
Response.Charset ="GB2312";  
//下面这行很重要， attachment 参数表示作为附件下载，您可以改成 online在线打开  
//filename=FileFlow.xls 指定输出文件的名称，注意其扩展名和指定文件类型相符，可以为：.doc 　　 .xls 　　 .txt 　　.htm   
 Response.AppendHeader("Content-Disposition", "attachment;filename="\+ filename);  
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");  
//Response.ContentType指定文件类型 可以为application/ms-excel、application/ms-word、application/ms-txt、application/ms-html 或其他浏览器可直接支持文档   
 Response.ContentType ="application/ms-excel";  
this.EnableViewState =false;  
//　定义一个输入流   
 System.IO.StringWriter oStringWriter =new System.IO.StringWriter();  
System.Web.UI.HtmlTextWriter oHtmlTextWriter =new System.Web.UI.HtmlTextWriter(oStringWriter);  
  
this.GridView1.RenderControl(oHtmlTextWriter);  
//this.RenderControl(oHtmlTextWriter);  
//this 表示输出本页，你也可以绑定datagrid,或其他支持obj.RenderControl()属性的控件   
 Response.Write(oStringWriter.ToString());  
Response.End();  
\}  
publicoverridevoid VerifyRenderingInServerForm(Control control)  
\{  
// Confirms that an HtmlForm control is rendered for  
 \}

转载于:https://www.cnblogs.com/honghu3000/archive/2009/10/04/1578001.html

[ContractedBlock.gif]: https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif
[ExpandedBlockStart.gif]: /images/20211101/e2953d616eee4aa9925778efb8172fee.png