Export data directly to excel without interacting with the Excel Control

 
private void ExportToExcel(DataTable dt, string fileName, string worksheetName)        {            Response.Clear();            Response.AddHeader("content-disposition", "attachment;filename="+ fileName + "");            Response.ContentType = "application/vnd.ms-excel";     
Response. charset = "gb2312"; // The encoding settings solve the garbled problem. Of course, you can also set response. contentencoding = encoding. getencoding ("gb2312") in the HTML header ");
            StringWriter stringWriter = new StringWriter();            HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWriter);            DataGrid dataExportExcel = new DataGrid();            dataExportExcel.ItemDataBound += new DataGridItemEventHandler(dataExportExcel_ItemDataBound);            dataExportExcel.DataSource = dt;            dataExportExcel.DataBind();            dataExportExcel.RenderControl(htmlWrite);            StringBuilder sbResponseString = new StringBuilder();            sbResponseString.Append("
Article transferred from: http://blog.weareon.net/export-datatable-to-excel-in-asp-net-without-using-excel-interop-part-ii/