C# 使用NPOI导出Excel，首行冻结，添加筛选，填充颜色，列宽自适应

使用NuGet安装NPOI，添加以下命名空间

using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;
using NPOI.SS.Util;
using NPOI.XSSF.UserModel;

　　

添加类 ExcelExporter

 

    public static class ExcelExporter
    {
        /// <summary>
        /// DataTable导出Excel
        /// </summary>
        /// <param name="dataTable">数据源</param>
        /// <param name="fileName">保存的文件名</param>
        /// <param name="sheetName">表名</param>
        public static void ExportToExcel(this DataTable dataTable, string fileName, string sheetName = "Sheet1")
        {
            if (dataTable == null || dataTable.Rows.Count == 0)
                throw new Ex