Three steps output the ES0en.Net page to EXCEL

In fact, it is easy to output WORD, EXCEL, TXT, HTM, and other types of documents with the specified content using ASP.NET. It is mainly divided into 3 steps.
1. Define document type and character encoding

 
Response.Clear(); 
　　 Response.Buffer= true; 
　　 Response.Charset="utf-8";　　 
　　 // The next line is very important,  attachment  The parameter representation is downloaded as an attachment, which you can change  online Online open  
　　 //filename=FileFlow.xls  Specify the name of the output file. Note that the extension matches the specified file type. It can be: .doc 　　 .xls 　　 .txt 　　.htm　　 
　　 Response.AppendHeader("Content-Disposition","attachment;filename=FileFlow.xls"); 
　　 Response.ContentEncoding=System.Text.Encoding.GetEncoding("utf-8");　　 
　　 //Response.ContentType Specify file type   Can I do for application/ms-excel 　　 application/ms-word 　　 application/ms-txt 　　 application/ms-html 　　  Or other browsers can directly support documents  
　　 Response.ContentType = "application/ms-excel"; 
　　 this.EnableViewState = false;　　 

2. Define an input stream

 
　　 System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); 
　　 System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); 

3. Bind target data to input stream output

 
this.RenderControl(oHtmlTextWriter); 　　 
　　 //this  Represents the output page, which you can also bind to datagrid, Or other support obj.RenderControl() Control for properties  
　　 Response.Write(oStringWriter.ToString()); 
　　 Response.End();　　 

Summary: This routine has been tested on the Microsoft Visual ES19en. NET 2003 platform and is suitable for C# and VB. When using VB, the this keyword is changed to me.