使用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