asp.net gridview 生成excel及word

最新推荐文章于 2022-01-01 16:40:23 发布

lJean

最新推荐文章于 2022-01-01 16:40:23 发布

阅读量752

点赞数

分类专栏：报表文章标签： excel asp.net string button object

本文链接：https://blog.csdn.net/lJean/article/details/4282842

版权

报表专栏收录该内容

6 篇文章 0 订阅

订阅专栏

Excel:

private void Export(string FileType, string FileName)
    {
        Response.Charset = "GB2312";
        Response.ContentEncoding = System.Text.Encoding.UTF7;
        Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
        Response.ContentType = FileType;
        this.EnableViewState = false;
        StringWriter tw = new StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(tw);
        GridView1.RenderControl(hw);
        Response.Write(tw.ToString());
        Response.End();
    }

调用：

   protected void Button1_Click(object sender, EventArgs e)
    {
        Export("application/ms-excel", "Excel1.xls");
    }
    public override void VerifyRenderingInServerForm(Control control)
    {
    }

Word:

private void Export(string FileType, string FileName)
    {
        Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
        Response.ContentType = FileType;
        this.EnableViewState = false;
        StringWriter tw = new StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(tw);
        GridView1.RenderControl(hw);
        Response.Write(tw.ToString());
        Response.End();
    }

调用：

protected void Button1_Click(object sender, EventArgs e)
    {
        Export("application/ms-word", "Word1.doc");
    }
    public override void VerifyRenderingInServerForm(Control control)
    {
    }