数据导出成Excel

1、table里的数据导出成Excel   runat="server"

protected void Btn_OutEXL_Click(object sender, EventArgs e)

        {

    bind_infor();

            string strDate1 = DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss");

            Response.Charset = "GB2312";

            Response.ContentEncoding = System.Text.ASCIIEncoding.UTF8;

            Response.ContentType = "application/ms-excel";

            Response.AppendHeader("Content-Disposition", "attachment;filename=工资统计表(" + strDate1.ToString() + ").xlsx");

            StringWriter tw = new StringWriter();

            HtmlTextWriter hw = new HtmlTextWriter(tw);

            outEW.RenderControl(hw);//outEW为table的id

            Response.Write(tw.ToString());

            Response.End();

         }

2、Repeater里的数据导出成Excel

首先，设置样式：

<HeaderTemplate >表头信息</HeaderTemplate >

            <ItemTemplate>绑定信息</ItemTemplate>

        <FooterTemplate>表尾信息</FooterTemplate>

导出按钮：

<asp:Button ID="Btn_OutEXL" runat="server" Text="导出xls" 

  onclick="Btn_OutEXL_Click" style="width: 100px; height: 30px;" />

后台代码：

protected void Btn_OutEXL_Click(object sender, EventArgs e)

        {

            bind_infor();

            string strDate1 = DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss");           

            base.Response.Clear();

            base.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");

            base.Response.AddHeader("content-disposition", "attachment;filename=工资统计表(" + strDate1.ToString() + ").xlsx");

            base.Response.Charset = "gb2312";//gb2312,utf-8,UTF7

            //base.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");

            //Response.ContentType指定文件类型 可以为application/ms-excel、application/ms-word、application/ms-txt、application/ms-html 或其他浏览器可直接支持文档

            base.Response.ContentType = "application/vnd.xls";

            this.EnableViewState = false;

            //　定义一个输入流

            StringWriter writer = new StringWriter();

            HtmlTextWriter Htmlwriter = new HtmlTextWriter(writer);

            this.Repeater1.RenderControl(Htmlwriter);

            //this 表示输出本页，你也可以绑定datagrid,或其他支持obj.RenderControl()属性的控件

            base.Response.Write(writer.ToString());

            base.Response.End();

        }