asp.net 将数据导出到excel文件(NPOI)

【实例简介】

错误异常抛出框架

错误导入导出功能

【实例截图】

excel的内容如下：

【核心代码】

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using NPOIDemo;

namespace NPOIDemo
{
    public partial class Main : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }
        protected DataTable GenerateData()
        {
            DataTable data = new DataTable();
            for (int i = 0; i < 5;   i)
            {
                data.Columns.Add("Columns_"   i.ToString(), typeof(string));
            }

            for (int i = 0; i < 10;   i)
            {
                DataRow row = data.NewRow();
                row["Columns_0"] = "item0_"   i.ToString();
                row["Columns_1"] = "item1_"   i.ToString();
                row["Columns_2"] = "item2_"   i.ToString();
                row["Columns_3"] = "item3_"   i.ToString();
                row["Columns_4"] = "item4_"   i.ToString();
                data.Rows.Add(row);
            }
            return data;
        }
        protected void TestExcelWrite(string file)
        {
            try
            {
                using (ExcelHelper excelHelper = new ExcelHelper(file))
                {
                    DataTable data = GenerateData();
                    int count = excelHelper.DataTableToExcel(data, "MySheet", true);
                    if (count > 0)
                        Console.WriteLine("Number of imported data is {0} ", count);
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine("Exception: "   ex.Message);
            }
        }

        protected void DownLoad (string fileName,string filePath)
        {
            Response.ContentType = "application/x-zip-compressed";
            Response.AddHeader("Content-Disposition", "attachment;filename="   fileName);
            string filename = filePath;
            Response.TransmitFile(filename);
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            string file = @"~/temp/myTest.xlsx";
            TestExcelWrite(Server.MapPath(file));

            DownLoad("myTest.xlsx", Server.MapPath(file));
        }
    }
}