我用如下方法把gridview中的数据导出到EXCEL时,在office2003下很正常的可打开,但换了office2007时打开出错,
错误提示:Excel 无法打开文件“test[2].xls”,因为文件格式或文件扩展名无效......
我换了.xlsx扩展名也不行。Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=test.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
GridView1.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
错误提示:Excel 无法打开文件“test[2].xls”,因为文件格式或文件扩展名无效......
我换了.xlsx扩展名也不行。Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=test.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
GridView1.RenderControl(htmlWrite);
Response.Write(stringWrite.ToString());
Response.End();
{
//base.VerifyRenderingInServerForm(control);
}