asp.net page output to excel

asp.net|excel| page In fact, it's easy to use asp.net to output the word, Excel, TXT, HTM, and other types of documents you specify. Mainly divided into three steps to complete.

I. Define document type, character encoding

Response.Clear ();

Response.buffer= true;

Response.charset= "Utf-8";

The following line is very important, the attachment parameter means that as an attachment to download, you can change to online open

Filename=fileflow.xls Specify the name of the output file, note that its extension matches the specified file type, and can be:. doc. xls. txt. htm

Response.appendheader ("Content-disposition", "Attachment;filename=fileflow.xls");

Response.contentencoding=system.text.encoding.getencoding ("Utf-8");

RESPONSE.CONTENTTYPE Specifies that the file type can be Application/ms-excel Application/ms-word application/ms-txt application/ms-html or other browsers to support documents directly

Response.ContentType = "Application/ms-excel";

This. EnableViewState = false;

Second, define an input stream

System.IO.StringWriter ostringwriter = new System.IO.StringWriter ();

System.Web.UI.HtmlTextWriter ohtmltextwriter = new System.Web.UI.HtmlTextWriter (ostringwriter);

binding target data to input stream output

This. RenderControl (Ohtmltextwriter);

This is the output page, and you can also bind the DataGrid, or other support obj. Control of the RenderControl () property

Response.Write (Ostringwriter.tostring ());

Response.End ();

Summary: This routine is tested under Microsoft Visual Studio. NET 2003 Platform for C # and VB, when VB is used to change the This keyword to me.