Common/NPOIExcelHelper.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using NPOI.HSSF.UserModel;
using System.Web;
using System.IO;
using System.Data;
using NPOI.SS.UserModel;
using NPOI.HSSF.Util;

namespace ZJ.GMCC.Framework.Common.Tools
{
    public class NPOIExcelHelper
    {
        public void CreateExcel(IDictionary<string, System.Data.DataTable> iDicDT, string FilePath, bool Visible)
        {
            HSSFWorkbook book = new HSSFWorkbook();

            foreach (KeyValuePair<string, System.Data.DataTable> val in iDicDT)
            {

                DataWrite2Sheet(val.Value, 0, val.Value.Rows.Count - 1, book,val.Key);
            }
            ExportToExcel(book, "数据导出.xls");
        }
        /// <summary>
        /// 把DataTable 转为Excel 内容
        /// </summary>
        /// <param name="dt"></param>
        /// <param name="startRow"></param>
        /// <param name="endRow"></param>
        /// <param name="book"></param>
        /// <param name="sheetName"></param>
        private void DataWrite2Sheet(DataTable dt, int startRow, int endRow, HSSFWorkbook book, string sheetName)
        {
            //头部样式
            CellStyle headstyle = book.CreateCellStyle();
            headstyle.Alignment = HorizontalAlignment.CENTER;
            headstyle.VerticalAlignment = VerticalAlignment.CENTER;
            Font headfont = book.CreateFont();
            headfont.Boldweight = 700;
            headstyle.SetFont(headfont);
            headstyle.FillPattern = FillPatternType.SOLID_FOREGROUND;
            headstyle.FillForegroundColor = HSSFColor.GREY_25_PERCENT.index;
            headstyle.BorderBottom = CellBorderType.THIN;
            headstyle.BorderLeft = CellBorderType.THIN;
            headstyle.BorderRight = CellBorderType.THIN;
            headstyle.BorderTop = CellBorderType.THIN;
           
            NPOI.SS.UserModel.Sheet sheet = book.CreateSheet(sheetName);
            NPOI.SS.UserModel.Row header = sheet.CreateRow(0);
            header.Height = 20 * 20;
            
            //表格内容样
            CellStyle dataStyle = book.CreateCellStyle();
            dataStyle.BorderBottom = CellBorderType.THIN;
            dataStyle.FillPattern = FillPatternType.SOLID_FOREGROUND;
            dataStyle.BorderLeft = CellBorderType.THIN;
            dataStyle.BorderRight = CellBorderType.THIN;