Import Table data in ASP.net to Execl

// Define the 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. Table_Report.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 ();