C#利用NPOI匯出Excel類(簡單版)

標籤：style   blog   http   color   io   os   ar   for   sp   

代碼：

using System.Data;using System.IO;using NPOI.HSSF.UserModel;using NPOI.SS.UserModel;namespace ahwildlife.Utils{    /// <summary>    /// Excel工具類    /// 利用NPOI產生Excel    /// </summary>    public class ExcelUtil    {        #region 產生Excel        /// <summary>        /// 產生Excel        /// </summary>        public static void CreateExcel(DataTable dt, string path)        {            HSSFWorkbook workbook = new HSSFWorkbook();            ISheet sheet = string.IsNullOrEmpty(dt.TableName) ? workbook.CreateSheet("Sheet1") : workbook.CreateSheet(dt.TableName);//建立工作表            #region 標題            IRow row = sheet.CreateRow(0);//在工作表中添加一行            for (int i = 0; i < dt.Columns.Count; i++)            {                ICell cell = row.CreateCell(i);//在行中添加一列                cell.SetCellValue(dt.Columns[i].ColumnName);//設定列的內容                 }            #endregion            #region 填充資料            for (int i = 1; i <= dt.Rows.Count; i++)//遍曆DataTable行            {                DataRow dataRow = dt.Rows[i - 1];                row = sheet.CreateRow(i);//在工作表中添加一行                for (int j = 0; j < dt.Columns.Count; j++)//遍曆DataTable列                {                    ICell cell = row.CreateCell(j);//在行中添加一列                    cell.SetCellValue(dataRow[j].ToString());//設定列的內容                     }            }            #endregion            #region 輸出到Excel            MemoryStream ms = new MemoryStream();            workbook.Write(ms);            using (FileStream fs = new FileStream(path, FileMode.Create, FileAccess.Write))            {                byte[] bArr = ms.ToArray();                fs.Write(bArr, 0, bArr.Length);                fs.Flush();            }            #endregion        }        #endregion    }}

View Code

 

C#利用NPOI匯出Excel類(簡單版)