返回首页

喜的朋友,

我从数据库到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

回答