怎样将DataGrid中的数据导入Excel中

最新推荐文章于 2008-07-24 17:02:00 发布

babyan

最新推荐文章于 2008-07-24 17:02:00 发布

阅读量532

点赞数

分类专栏： ASp.net 文章标签： datagrid excel

本文链接：https://blog.csdn.net/babyan/article/details/2540174

版权

ASp.net 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

//摘自http://www.dotnetsky.net/netsave/ShowTopic-77067.html //

try{

Response.Clear();

Response.Buffer= true;

Response.Charset="GB2312";

Response.ContentEncoding=System.Text.Encoding.GetEncoding("UTF-8");//设置输出流为简体中文Response.AppendHeader("Content-Disposition","attachment;filename=test.xls"); Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。 this.EnableViewState = false;

CultureInfo myCItrad = new CultureInfo("ZH-CN",true); HtmlGenericControl div=new HtmlGenericControl(); System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); div.InnerHtml = oStringWriter.ToString(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); // 下载页面显示的

DataGrid1.RenderControl(oHtmlTextWriter); // LZ 注意此处DataGrid1div.InnerHtml =oStringWriter.ToString();

Response.Write(div.InnerText); Response.End();

}

catch( Exception ex)

{MsgBox("",ex.Message);}