Output the Asp. Net page to EXCEL

In fact, it is easy to use ASP. NET to output documents of the WORD, EXCEL, TXT, HTM, and other types of specified content. It can be completed in three steps.


1. Define document type and character encoding

Response. Clear ();

Response. Buffer = true;

Response. Charset = "UTF-8 ";

// The following line is very important. The attachment parameter indicates downloading as an attachment. You can change it to online.

// Filename=FileFlow.xls specifies the name of the output file. Note that the extension is consistent with 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 the specified file type can be 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 the target data to the input stream output

This. RenderControl (oHtmlTextWriter );

// This indicates that the current page is output. You can also bind the datagrid or other controls that support the obj. RenderControl () attribute.

Response. Write (oStringWriter. ToString ());

Response. End ();

　　Summary:This routine is tested and passed in Microsoft Visual Studio. NET 2003. It is applicable to C # and VB. When VB is used, this keyword is changed to me.