如何使用C#lang将gridview数据转换为asp.net中的excel表

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

public void ExportGridViewToExcel(GridView gridView, string fileName)
{
    // 创建一个新的Excel包
    var package = new ExcelPackage();

    // 创建一个Excel工作表
    var worksheet = package.Workbook.Worksheets.Add("GridViewData");

    // 将GridView数据转换为DataTable
    DataTable dataTable = new DataTable();
    foreach (DataControlField column in gridView.Columns)
    {
        dataTable.Columns.Add(column.HeaderText);
    }

    foreach (GridViewRow row in gridView.Rows)
    {
        DataRow dataRow = dataTable.NewRow();
        foreach (DataControlField column in gridView.Columns)
        {
            dataRow[column.HeaderText] = row.Cells[column.HeaderText].Text;
        }
        dataTable.Rows.Add(dataRow);
    }

    // 将DataTable数据写入Excel工作表
    worksheet.Cells["A1"].LoadFromDataTable(dataTable, true);

    // 设置工作表样式
    for (int i = 1; i <= dataTable.Columns.Count; i++)
    {
        worksheet.Column(i).AutoFit();
    }

    // 保存Excel文件
    using (var fileStream = new FileStream(fileName, FileMode.Create))
    {
        package.SaveAs(fileStream);
    }
}

ExportGridViewToExcel(GridView1, "GridViewData.xlsx");