NOPI的使用方法

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using DBUtility;
using System.Data;
using NPOI.SS.UserModel;
using NPOI.HSSF.UserModel;
using System.IO;

namespace WebApplication1
{
    public partial class Demo : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            DBSqlServer db = new DBSqlServer();
            DataSet ds = db.Query("select * from T_User");
            DataTable dtUser = ds.Tables[0];
            rptUserInfo.DataSource = ds.Tables[0];
            rptUserInfo.DataBind();
            HSSFWorkbook book = new HSSFWorkbook();// NPOI.HSSF.UserModel;
            string filename = "用户表.xls";
            string path = "D:\\Excel\\" + filename;
            List<string> ColumnName = new List<string>();
            for (int i = 0; i < dtUser.Columns.Count; i++)
            {
                ColumnName.Add(dtUser.Columns[i].ColumnName);
            }
            string[] ColumnArray1 = ColumnName.ToArray();
            ISheet sheet = book.CreateSheet("用户表");//创建sheet NPOI.SS.UserModel;
            IRow row = sheet.CreateRow(0);
            for (int i = 0; i < ColumnArray1.Length; i++)
            {
                row.CreateCell(i).SetCellValue(ColumnArray1[i]);
            }
            for (int i = 1; i <= dtUser.Rows.Count; i++)
            {
                IRow dr = sheet.CreateRow(i);
                for (int j = 0; j < ColumnArray1.Length; j++)
                {
                    dr.CreateCell(j).SetCellValue(dtUser.Rows[i - 1][ColumnArray1[j]].ToString());
                }
               
            }

            FileStream fs = new FileStream(path, FileMode.Create);
            book.Write(fs);
            fs.Close();
            book = null;


        }
    }
}