一般导出Excel的方法

最新推荐文章于 2024-09-30 17:00:00 发布

yclt84

最新推荐文章于 2024-09-30 17:00:00 发布

阅读量484

点赞数

文章标签： excel datagrid

本文链接：https://blog.csdn.net/yclt84/article/details/1325993

版权

DataGrid2.DataSource =(DataTable)ViewState["oldDate"];
    DataGrid2.DataBind();
    HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename="+ HttpUtility.UrlEncode(TitleLabel.Text + ".xls", System.Text.Encoding.UTF8));
    HttpContext.Current.Response.Charset = "GB2312";
    HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF7;
    HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
    System.IO.StringWriter tw = new System.IO.StringWriter();
    System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
    DataGrid2.RenderControl(hw);
    HttpContext.Current.Response.Write(tw.ToString());
    HttpContext.Current.Response.End();