ASP.NET2.0中，怎样把GridView中的数据导入到excel中？

yexd2008 2006-05-12 03:32:46

基本的代码都有不过总是要出错，希望有正确的代码，谢谢。

...全文

134 1 打赏收藏转发到动态举报

写回复

用AI写文章

1 条回复

切换为时间正序

请发表友善的回复…

发表回复

playboyzys12 2006-07-06

打赏
举报

public void Export(){

Response.Clear();

Response.Buffer = true;

Response.Charset = "GB2312";

Response.AppendHeader("Content-Disposition", "attachment;filename=Data.xls");

Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");

Response.ContentType = "application/ms-excel";

EnableViewState = false;

System.IO.StringWriter oStringWriter = new System.IO.StringWriter();

System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);

GridView1.RenderControl(oHtmlTextWriter);

Response.Write(oStringWriter.ToString());

Response.End();
}