将DataTable转换为不包含标题单元格的Excel

using OfficeOpenXml;
using System.IO;

public void ExportDataTableToExcel(DataTable dataTable, string filePath)
{
    // 创建Excel文件
    FileInfo file = new FileInfo(filePath);
    using (ExcelPackage package = new ExcelPackage(file))
    {
        // 创建工作表
        ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("Sheet1");

        // 写入数据
        for (int i = 0; i < dataTable.Rows.Count; i++)
        {
            for (int j = 0; j < dataTable.Columns.Count; j++)
            {
                worksheet.Cells[i + 1, j + 1].Value = dataTable.Rows[i][j];
            }
        }

        // 保存Excel文件
        package.Save();
    }
}

DataTable dataTable = GetDataTable();  // 获取数据源
string filePath = "C:\\path\\to\\output\\file.xlsx";
ExportDataTableToExcel(dataTable, filePath);