导出数据到Excel/Word

最新推荐文章于 2024-08-12 21:05:18 发布

XMM_1030

最新推荐文章于 2024-08-12 21:05:18 发布

阅读量708

点赞数

分类专栏： .net 文章标签： excel string html

本文链接：https://blog.csdn.net/XMM_1030/article/details/7477804

版权

.net 专栏收录该内容

32 篇文章 0 订阅

订阅专栏

一、方法一

public static void toFilesPl(int Model, Panel pl)
    {
        string strFileName = DateTime.Now.ToString("yyyyMMdd-hhmmss");
        System.Web.HttpContext HC = System.Web.HttpContext.Current;
        HC.Response.Clear();
        HC.Response.Buffer = true;
        HC.Response.ContentEncoding = System.Text.Encoding.UTF8;//设置输出流为简体中文

        if (Model == 1)
        {
            //---导出为Excel文件
            HC.Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(strFileName, System.Text.Encoding.UTF8) + ".xls");
            HC.Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
        }
        else
        {
            //--- 导出为Word文件
            HC.Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(strFileName, System.Text.Encoding.UTF8) + ".doc");
            HC.Response.ContentType = "application/ms-word";//设置输出文件类型为Word文件。
        }

        System.IO.StringWriter sw = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);
        pl.RenderControl(htw);

HC.Response.Write(sw.ToString());
HC.Response.End();

}

二、方法二

    public static void toFilesTb(int Model, string html)
    {
        string strFileName = DateTime.Now.ToString("yyyyMMdd-hhmmss");
        System.Web.HttpContext HC = System.Web.HttpContext.Current;
        HC.Response.Clear();
        HC.Response.Buffer = true;
        HC.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文
        if (Model == 1)
        {
            //---导出为Excel文件
            HC.Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(strFileName, System.Text.Encoding.UTF8) + ".xls");
            HC.Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
        }
        else
        {
            //--- 导出为Word文件
            HC.Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(strFileName, System.Text.Encoding.UTF8) + ".doc");
            HC.Response.ContentType = "application/ms-word";//设置输出文件类型为Word文件。
        }
        //System.IO.StringWriter sw = new System.IO.StringWriter();
        //System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);
        //dt.RenderControl(htw);
        HC.Response.Write(html);
        HC.Response.End();
    }