ASP. NET export DataSet to an Excel table

There are many ways to Operate Excel in (www.bkjia.com) Tutorial C #. Here, we use Response to export the stream to the browser to form an excel file.

Method Code:

Reference content is as follows: Public void ExportResult (DataSet ds, string excelName) { HttpContext. Current. Response. Clear (); HttpContext. Current. Response. Charset = ""; HttpContext. Current. Response. ContentType = "application/vnd. ms-xls "; StringWriter stringWrite = new StringWriter (); HtmlTextWriter htmlWrite = new HtmlTextWriter (stringWrite ); DataGrid dg = new DataGrid (); Dg. DataSource = ds; Dg. DataBind (); Dg. RenderControl (htmlWrite ); HttpContext. Current. Response. AddHeader ("Content-disposition", "attachment; filename =" + HttpUtility. UrlEncode (excelName )) HttpContext. Current. Response. Write (stringWrite. ToString ()); HttpContext. Current. Response. End (); }