C# 导出DataTable到Excel

/// <summary>
/// 将DataTable数据，存储到一个Excel中（.xlsx）
/// </summary>
/// <param name="dt"></param>
/// <param name="filePath"></param>
public static void ExportExcel(DataTable dt, string filePath)
{
    // 创建工作表
    XSSFWorkbook workbook = new XSSFWorkbook();
    var sheet = workbook.CreateSheet(dt.TableName);
    // 单元格样式
    ICellStyle style = workbook.CreateCellStyle();
    style.BorderTop = NPOI.SS.UserModel.BorderStyle.Thin;
    style.BorderLeft = NPOI.SS.UserModel.BorderStyle.Thin;
    style.BorderRight = NPOI.SS.UserModel.BorderStyle.Thin;
    style.BorderBottom = NPOI.SS.UserModel.BorderStyle.Thin;
    // 创建标题行
    var rowTilte = sheet.CreateRow(0);
    // 创建标题行单元格名称
    for (int c = 0; c < dt.Columns.Count; c++)
    {
        var cellid = rowTilte.CreateCell(c);
        cellid.SetCellValue(dt.Columns[c].ColumnName);
        rowTilte.Cells[c].CellStyle = style;
    }
    // 写数据
    for (int i = 0; i < dt.Rows.Count; i++)
    {
        var rowData = sheet.CreateRow(i + 1);
        for (int c = 0; c < dt.Columns.Count; c++)
        {
            var cellid = rowData.CreateCell(c);
            cellid.SetCellValue(dt.Rows[i][c].ToString());
            rowData.Cells[c].CellStyle = style;
        }
    }
    // 列宽自动
    for (int c = 0; c < dt.Columns.Count; c++)
    {
        sheet.AutoSizeColumn(c);
    }
    // 写文件
    FileStream file = new FileStream(filePath, FileMode.CreateNew, FileAccess.Write);
    workbook.Write(file);
    file.Dispose();
}

依赖

NPOI.SS.UserModel
NPOI.XSSF.UserModel

 备注：如果要导出DataSet，只需要遍历DataSet的DataTable新建sheet即可。