外部表格不是预期的格式 [英] External table is not in expected format
本文介绍了外部表格不是预期的格式的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
亲爱的Al,
我的程序使用
Dear Al,
My program exported a excel file by using
Response.ContentType = "application/vnd.ms-excel";
下载后,当我使用Microsoft Excel驱动程序将其导入我的系统时,我收到了一个错误。
after downloading the same when i import it back to my system using Microsoft Excel driver, i got an error.
External table is not in the expected format.
以下是我的代码:
Below is my code :
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();
}
有谁知道怎么解决?
尝试了很多寻找解决方案,但没有得到完美的解决方案。请帮助或建议。
问候,
Does anyone know how to solve it?
Tried a lot searching for the solution but did not get the perfect one. Kindly help or suggest.
Regards,
推荐答案
看到一些,解决了问题,有时他们会帮助你。
http://stackoverflow.com/questions/1139390/excel-external-table-is-not-in-the-expected-format [ ^ ]
外部表格不符合预期格式。 [ ^ ]
See some, Solved problems, Some times they will help you.
http://stackoverflow.com/questions/1139390/excel-external-table-is-not-in-the-expected-format[^]
External table is not in the expected format.[^]
这篇关于外部表格不是预期的格式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文