About how to export EXCEL from Asp.net recently found this section on the csdn Forum Code , You can export the page to excel like ASP, so that you can export some complicated Excel pages without using complicated methods such as templates! Public Void Outputexcel ()
{
// Define document type and character encoding
Response. Clear ();
Response. Buffer = True ;
Response. charset = " Gb2312 " ;
// 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 ( " Gb2312 " );
// Response. contenttype specifies the file type which 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 ;
// Define an input stream
System. Io. stringwriter ostringwriter = New System. Io. stringwriter ();
System. Web. UI. htmltextwriter ohtmltextwriter = New System. Web. UI. htmltextwriter (ostringwriter );
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 ();
}
After calling page_load, You can output the Asp.net page to excel.
