Response.ContentType = "application/vnd.ms-excel";
External table is not in the expected format.
Response.Clear(); Response.Buffer = true; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("content-disposition", "attachment;filename=LatestReport.xls"); Response.Charset = ""; this.EnableViewState = false; using (StringWriter sw = new StringWriter()) { HtmlTextWriter hw = new HtmlTextWriter(sw); //To Export all pages gvProduct.AllowPaging = false; gvProduct.Columns[3].HeaderText = "SKU_CODE"; gvProduct.Columns[5].HeaderText = "SKU_PRICE"; gvProduct.Columns[10].HeaderText = "SKU_QOH"; gvProduct.Columns[16].HeaderText = "ITEM_ATTRIB1"; gvProduct.Columns[18].HeaderText = "PDT_TITLE"; gvProduct.Columns[29].HeaderText = "ECOM_DEPT"; Bind(); gvProduct.Columns[0].Visible = false; gvProduct.Columns[1].Visible = true; gvProduct.Columns[2].Visible = true; gvProduct.Columns[4].Visible = true; gvProduct.Columns[6].Visible = true; gvProduct.Columns[7].Visible = true; gvProduct.Columns[8].Visible = true; gvProduct.Columns[9].Visible = true; gvProduct.Columns[11].Visible = true; gvProduct.Columns[12].Visible = true; gvProduct.Columns[13].Visible = true; gvProduct.Columns[14].Visible = true; gvProduct.Columns[15].Visible = true; gvProduct.Columns[17].Visible = true; gvProduct.Columns[19].Visible = true; gvProduct.Columns[20].Visible = true; gvProduct.Columns[21].Visible = true; gvProduct.Columns[22].Visible = true; gvProduct.Columns[23].Visible = true; gvProduct.Columns[24].Visible = true; gvProduct.Columns[25].Visible = true; gvProduct.Columns[26].Visible = true; gvProduct.Columns[27].Visible = true; gvProduct.Columns[28].Visible = true; gvProduct.Columns[30].Visible = true; gvProduct.Columns[31].Visible = false; gvProduct.Columns[32].Visible = false; gvProduct.Columns[33].Visible = false; //gvProduct gvProduct.Columns[gvProduct.Columns.Count - 1].Visible = false; gvProduct.RenderControl(hw); //style to format numbers to string StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("&lt;html xmlns:v='urn:schemas-microsoft-com:vml' xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:x='urn:schemas-microsoft-com:office:excel' xmlns='http://www.w3.org/TR/REC-html40'> &lt;head>&lt;meta http-equiv='Content-Type' content='text/html;charset=windows-1252'><!--[if gte mso 9]>&lt;xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>ExportToExcel</x:Name><x:WorksheetOptions><x:Panes></x:Panes></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook>&lt;/xml><![endif]-->&lt;/head> <body>"); sBuilder.Append(sw + "</body></html>"); Response.Write(sBuilder.ToString()); Response.End(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)