在asp.net中将数据从网格视图导出到Excel

protected void ExportToExcel_Click(object sender, EventArgs e)
{
    // 创建一个新的Excel文档
    var workbook = new Workbook();
    var worksheet = workbook.Worksheets[0];

    // 获取网格视图中的数据
    var gridView = YourGridView; // 将YourGridView替换为你的网格视图控件ID
    var dataSource = (gridView.DataSource as DataTable).DefaultView.ToTable();

    // 将数据写入Excel工作表
    for (int i = 0; i < dataSource.Columns.Count; i++)
    {
        worksheet.Cells[0, i].Value = dataSource.Columns[i].ColumnName;
    }

    for (int i = 0; i < dataSource.Rows.Count; i++)
    {
        for (int j = 0; j < dataSource.Columns.Count; j++)
        {
            worksheet.Cells[i + 1, j].Value = dataSource.Rows[i][j].ToString();
        }
    }

    // 设置响应头，告诉浏览器下载Excel文件
    Response.Clear();
    Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
    Response.AddHeader("content-disposition", "attachment;filename=ExportedData.xlsx");

    // 将Excel文档写入响应流
    using (var memoryStream = new MemoryStream())
    {
        workbook.SaveAs(memoryStream);
        memoryStream.WriteTo(Response.OutputStream);
        Response.Flush();
        Response.End();
    }
}