ASP.NET-GridView之导出excel或word

    在CS阶段我们涉及到表格的导出，再Web开发同样可以实现，而且实现形式多种多样。以下面的例子说明表格导出到excel和word

 这里用到了一个后台方法输出流形成***文件的的公共方法

DEMO

<span style="font-family:Microsoft YaHei;font-size:18px;">    /// <summary>
    /// 定义导出***文件的函数
    /// </summary>
    /// <param name="FileType"></param>
    /// <param name="FileName"></param>
    private void Export(string FileType, string FileName)
    {
        //获取或设置输出流的 HTTP 字符集-中文
        Response.Charset = "GB2312";
        //获取或设置输出流的 HTTP 字符集是什么编码的
        Response.ContentEncoding = System.Text.Encoding.UTF8;
        //追加头信息：要下载的文件名
        Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
        //输出流类型（excel或者doc）
        Response.ContentType = FileType;
        this.EnableViewState = false;
        StringWriter tw = new StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(tw);
        GridView1.RenderControl(hw);
        //按输出流类型输出
        Response.Write(tw.ToString());
        //停止输出
        Response.End();
    }</span>

表格导出EXCEL

显示效果

调用公共方法DEMO

<span style="font-family:Microsoft YaHei;font-size:18px;">/// <summary>
    /// 导出Excel
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Button1_Click(object sender, EventArgs e)
    {
        Export("application/ms-excel", "Employee information.xls");
    }</span>

表格导出WORD

显示效果

调用公共方法DEMO

<span style="font-family:Microsoft YaHei;font-size:18px;">/// <summary>
    /// 导出word
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Button2_Click(object sender, EventArgs e)
    {
        //Export("application/ms-excel", "Employee.doc");
        Export("application/ms-word", "员工信息.doc");//都可以
    }</span>

感谢您的宝贵时间······