在Windows10中将ASP.Net网格视图导出到excel

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

    // 添加一个工作表
    var worksheet = workbook.Worksheets.Add("Sheet1");

    // 获取网格视图的数据源
    var dataSource = GridView1.DataSource as DataTable;

    // 将数据填充到工作表中
    worksheet.InsertDataTable(dataSource, true, 1, 1);

    // 设置响应头，告诉浏览器下载Excel文件
    Response.Clear();
    Response.ContentType = "application/vnd.ms-excel";
    Response.AddHeader("Content-Disposition", "attachment;filename=GridViewData.xls");

    // 将Excel文档写入响应流
    workbook.Save(Response.OutputStream, SaveFormat.Excel97To2003);

    // 结束响应
    Response.End();
}