NPOI-WebForm_Excel导入与导出

本文面对的是第一次 接触NPOI的童鞋

不必为了一些琐碎的事情搞的心情烦躁

废话不多说先上 Demo 的全家福

接下来直接上代码

 public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                //导出Excel
                ExportByWeb("ExportDemo.xlsx");
            }
            RepeaterTable.DataSource = GetDtTable();
            RepeaterTable.DataBind();
        }

        public static MemoryStream ExcelStream()
        {
            DataTable dtTable = GetDtTable();
            return ExcelHelper.ExportDT(dtTable, "HeaderText");

        }

        private static DataTable GetDtTable()
        {
            string path = HttpContext.Current.Request.MapPath("~/App_Data/excel2007.xlsx");
            //调用ZK的ExcelHelper
            DataTable dtTable = ExcelHelper.ImportExceltoDt(path);
            return dtTable;
        }

        public static void ExportByWeb(string strFileName)
        {
            HttpContext curContext = HttpContext.Current;

            // 设置编码和附件格式
            curContext.Response.ContentType = "application/vnd.ms-excel";
            curContext.Response.ContentEncoding = Encoding.UTF8;
            curContext.Response.Charset = "";
            curContext.Response.AppendHeader("Content-Disposition",
                "attachment;filename=" + HttpUtility.UrlEncode(strFileName, Encoding.UTF8));

            curContext.Response.BinaryWrite(ExcelStream().GetBuffer());
            curContext.Response.End();
        }
    }

代码很简单，很容易看懂O(∩_∩)O~

前台绑定数据的代码

<h2>
        欢迎使用 NPOI
    </h2>
    <asp:Repeater ID="RepeaterTable" runat="server">
        <HeaderTemplate>
            <table border="1" cellpadding="10" cellspacing="0">
                <tr>
                    <td>
                        ID
                    </td>
                    <td>
                        品牌
                    </td>
                    <td>
                        型号
                    </td>
                </tr>
        </HeaderTemplate>
        <ItemTemplate>
            <tr>
                <td>
                    <%# DataBinder.Eval(Container.DataItem,"ID") %>
                </td>
                <td>
                    <%# DataBinder.Eval(Container.DataItem,"品牌") %>
                </td>
                <td>
                    <%# DataBinder.Eval(Container.DataItem,"型号") %>
                </td>
            </tr>
        </ItemTemplate>
        <FooterTemplate>
            </table>
        </FooterTemplate>
    </asp:Repeater>
    <p>
        <form action="/" method="post">
        <input type="submit" name="name" value="导出" />
        </form>
    </p>

执行结果：

代码的下载地址

http://files.cnblogs.com/zhaozhengyan/ExcelDemoFor2.0.1.rar