C#将GridView中的数据导出为excel文件

赵 XiaoQin

已于 2022-10-25 17:02:10 修改

阅读量601

点赞数

文章标签： c# excel ui

于 2022-10-25 16:59:04 首次发布

本文链接：https://blog.csdn.net/beautiful77moon/article/details/127516874

版权

protected void exportBtn_Click(object sender, EventArgs e)
    {
        Response.Clear();   //清除缓冲区流中的所有内容输出
        Response.AppendHeader("Content-Disposition", "attachment;filename=SatffInformation.xls");//将HTTP头添加到输出流
        //设置输出流的编码方式
        Response.Charset = "GB2312";
        Response.ContentEncoding = System.Text.Encoding.GetEncoding(Response.Charset);
        //设置输出文件类型
        Response.ContentType = "application/ms-excel";
        //数据写入
        StringWriter sw = new StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);
        InfoGV.RenderControl(htw);
        Response.Write(sw.ToString());
        Response.Flush();
        Response.End();
            
    }
    public override void VerifyRenderingInServerForm(System.Web.UI.Control control)
    {
            
    }