DataTable导出到excel word

using  System;
using  System.Data;
using  System.Configuration;
using  System.Web;
using  System.Web.Security;
using  System.Web.UI;
using  System.Web.UI.WebControls;
using  System.Web.UI.WebControls.WebParts;
using  System.Web.UI.HtmlControls;
using  System.IO;

public   partial   class  _Default : System.Web.UI.Page 
... {
    private DataTable dt;
    protected void Page_Load(object sender, EventArgs e)
    ...{
        if (!IsPostBack)
            BindGrid();
    }

    private void InitDataTable()
    ...{
        dt = new DataTable();
        dt.Columns.Add(new DataColumn("id", Type.GetType("System.Int32")));
        dt.Columns.Add(new DataColumn("name",Type.GetType("System.String")));
        for (int i = 1; i <= 20; i++)
        ...{
            DataRow dr = dt.NewRow();
            dr[0] = i;
            dr[1] = "姓名" + i.ToString();
            dt.Rows.Add(dr);
        }
    }

    private void BindGrid()
    ...{
        InitDataTable();
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }

    private void OutFile(FileName filename,FileType filetype)
    ...{
        Response.ClearContent();
        Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile." + filename);
        Response.ContentType = "application/ms-" + filetype;
        StringWriter sw = new StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);
        BindGrid();
        DataGrid g = new DataGrid();
        g.DataSource = dt;
        g.DataBind();
        g.RenderControl(htw);
        Response.Write(sw.ToString());
        Response.End();
    }

    enum FileName ...{ xls, doc };
    enum FileType ...{ excel, word };

    protected void but_Command(object sender, CommandEventArgs e)
    ...{
        if(e.CommandName=="excel")
            OutFile(FileName.xls, FileType.excel);
        else if(e.CommandName=="word")
            OutFile(FileName.doc, FileType.word);
    }
}

 

<% ... @ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" EnableEventValidation="false"  %>

<! DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd" >
< html  xmlns ="http://www.w3.org/1999/xhtml" >
< head  runat ="server" >
     < title > Untitled Page </ title >
</ head >
< body >
     < form  id ="form1"  runat ="server" >
         < div >
             &nbsp;&nbsp;
             < asp:GridView  ID ="GridView1"  runat ="server"  AllowPaging ="True"  AllowSorting ="True"
                 Width ="509px" >
                 < Columns >
                     < asp:CommandField  ShowSelectButton ="True"   />
                 </ Columns >
             </ asp:GridView >
                     < asp:Button  ID ="btnExcel"  runat ="server"  CommandName ="excel"
                        Text ="导出到Excel"  OnCommand ="but_Command"   />
                     < asp:Button  ID ="btnWord"  runat ="server"  CommandName ="word"  OnCommand ="but_Command"
                        Text ="导出到Word"   />
         </ div >
     </ form >
</ body >
</ html >