public static void DataTableToExcel(List<DataTable> dataTables, string filePath)

        {

            if (dataTables == null || !dataTables.Any())

                throw new Exception("dataTables不能为null");

            bool isOldThan2007 = Path.GetExtension(filePath)?.ToLower() == ".xls";

            IWorkbook book = dataTables.ToWorkbook(isOldThan2007);

            using (FileStream fs = new FileStream(filePath, FileMode.Create, FileAccess.Write))

            {

                book.Write(fs);

            }

        }

        public static IWorkbook ToWorkbook(this List<DataTable> dataTables, bool isOldThan2007)

        {

            IWorkbook book = isOldThan2007 ? new HSSFWorkbook() : (IWorkbook)new XSSFWorkbook();

            foreach (var dataTable in dataTables)

            {

                if (dataTable == null)

                    continue;

                ISheet sheet = book.CreateSheet(dataTable.TableName);

                IRow headerRow = sheet.CreateRow();

                foreach (DataColumn column in dataTable.Columns)

                {

                    headerRow.CreateCell(column.Ordinal).SetCellValue(column.ColumnName);

                }

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

                {

                    DataRow row = dataTable.Rows[i];

                    IRow dataRow = sheet.CreateRow(i + );

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

                    {

                        dataRow.CreateCell(j).SetCellValue(row[j]?.ToString());

                    }

                }

            }

            return book;

        }