喜的朋友,
我从数据库到Excel工作表中的数据提取。 Excel工作表随身携带超过40000行和90列。看看下面的代码,我在我的网站使用,
string fileName = "attachment;filename= ArchivalReportOn_" + DateTime.Now.ToString("dd-MM-yyyy-hh-mm-ss") + ".xls";
Response.Clear();
Response.AddHeader("content-disposition", fileName);
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/ms-excel";
GridView gridview1 = new GridView();
gridview1.DataSource = dt;
gridview1.HeaderStyle.CssClass = "gridHeader";
gridview1.HeaderStyle.BackColor = System.Drawing.Color.Red;
gridview1.HeaderStyle.ForeColor = System.Drawing.Color.White;
gridview1.DataBind();
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
gridview1.RenderControl(htmlWrite);
string s_styleInfo = @"<style> td { mso-number-format:""" + "\\@" + @"""; }</style>";
string s_excel = stringWrite.ToString();
Response.Write(s_styleInfo + s_excel);
Response.End();
60; 检索数据时,我得到的错误"问题加载文件和丢失的文件一样。CSS",所以任何一个可以建议我如何修复这个错误。:SARAVANAKUMAR.M