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 can 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 ();
At this point, if a "registerforeventvalidation can only be invoked during the execution of the Render ()" error message occurs.
There are two ways to fix this:
1. Modify Web.config (not recommended) <pages enableEventValidation = "false" ></pages>
2. Directly in the export of execl page modification
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.
