asp.net 导出到excel的越线问题
IT流渊 2007-10-29 11:13:08 datagrid的数据导出到excel中,下面代码是可以实现的,但是当datagrid的行数多余65535时,导出到
excel中,打开excel时,65535之后的数据就显示不了了。有没有在导出时就判断数据大小,然后在代码实现
excel的自动另外创建一个工作文件,来存放多余的数据。......
Response.Clear();
Response.Buffer = true;
Response.Charset = "utf-8";
string dd = DateTime.Now.ToString();
Response.AppendHeader("Content-Disposition","attachment;filename=WDExcel_"+sData+".xls");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
Response.ContentType = "application/ms-excel";
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
HtmlTextWriter oHtmlTextWriter = new HtmlTextWriter(oStringWriter);
DataGrid1.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();