使用EPPlus将网页表单DataGrid导出到excel

using OfficeOpenXml;
using System.Data;
using System.IO;

// 将网页表单DataGrid中的数据转换为DataTable
DataTable dataTable = new DataTable();
foreach (var column in dataGrid.Columns)
{
    dataTable.Columns.Add(column.HeaderText);
}
foreach (var row in dataGrid.Rows)
{
    DataRow dataRow = dataTable.NewRow();
    foreach (var cell in row.Cells)
    {
        dataRow[cell.Column.HeaderText] = cell.Value;
    }
    dataTable.Rows.Add(dataRow);
}

// 创建ExcelPackage对象
using (ExcelPackage excelPackage = new ExcelPackage())
{
    // 创建工作表对象
    ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("Sheet1");

    // 写入数据
    worksheet.Cells["A1"].LoadFromDataTable(dataTable, true);

    // 设置单元格样式
    worksheet.Cells[worksheet.Dimension.Address].AutoFitColumns();

    // 保存Excel文件到服务器
    string filePath = "path/to/save/excel.xlsx";
    excelPackage.SaveAs(new FileInfo(filePath));

    // 或将Excel文件作为响应发送给客户端
    // MemoryStream stream = new MemoryStream();
    // excelPackage.SaveAs(stream);
    // byte[] bytes = stream.ToArray();
    // Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
    // Response.AddHeader("Content-Disposition", "attachment; filename=excel.xlsx");
    // Response.BinaryWrite(bytes);
}