NPOIExcel

public class NPOIExcel

    {

        private string _title;

        private string _sheetName;

        private string _filePath;

        /// <summary>

        /// 导出到Excel

        /// </summary>

        /// <param name="table"></param>

        /// <returns></returns>

        public bool ToExcel(DataTable table)

        {

            FileStream fs = new FileStream(this._filePath, FileMode.OpenOrCreate, FileAccess.ReadWrite);

            IWorkbook workBook = new HSSFWorkbook();

            this._sheetName = this._sheetName.IsEmpty() ? "sheet1" : this._sheetName;

            ISheet sheet = workBook.CreateSheet(this._sheetName);

            //处理表格标题

            IRow row = sheet.CreateRow();

            row.CreateCell().SetCellValue(this._title);

            sheet.AddMergedRegion(new CellRangeAddress(, , , table.Columns.Count - ));

            row.Height = ;

            ICellStyle cellStyle = workBook.CreateCellStyle();

            IFont font = workBook.CreateFont();

            font.FontName = "微软雅黑";

            font.FontHeightInPoints = ;

            cellStyle.SetFont(font);

            cellStyle.VerticalAlignment = VerticalAlignment.Center;

            cellStyle.Alignment = HorizontalAlignment.Center;

            row.Cells[].CellStyle = cellStyle;

            //处理表格列头

            row = sheet.CreateRow();

            for (int i = ; i < table.Columns.Count; i++)

            {

                row.CreateCell(i).SetCellValue(table.Columns[i].ColumnName);

                row.Height = ;

                sheet.AutoSizeColumn(i);

            }

            //处理数据内容

            for (int i = ; i < table.Rows.Count; i++)

            {

                row = sheet.CreateRow( + i);

                row.Height = ;

                for (int j = ; j < table.Columns.Count; j++)

                {

                    row.CreateCell(j).SetCellValue(table.Rows[i][j].ToString());

                    sheet.SetColumnWidth(j,  * );

                }

            }

            //写入数据流

            workBook.Write(fs);

            fs.Flush();

            fs.Close();

            return true;

        }

        /// <summary>

        /// 导出到Excel

        /// </summary>

        /// <param name="table"></param>

        /// <param name="title"></param>

        /// <param name="sheetName"></param>

        /// <returns></returns>

        public bool ToExcel(DataTable table, string title, string sheetName, string filePath)

        {

            this._title = title;

            this._sheetName = sheetName;

            this._filePath = filePath;

            return ToExcel(table);

        }

    }