asp.net 导出excel

Install-Package EPPlus

using OfficeOpenXml;
using System.IO;
using System.Web.Mvc;

public ActionResult ExportToExcel()
{
    // 创建一个新的Excel包
    var package = new ExcelPackage();
    var worksheet = package.Workbook.Worksheets.Add("Sheet1");

    // 假设有一个数据列表
    var data = GetYourDataList(); // 这里替换为你的数据获取逻辑

    // 填充数据
    for (int row = 1; row <= data.Count; row++)
    {
        for (int col = 1; col <= data[row - 1].Count; col++)
        {
            worksheet.Cells[row, col].Value = data[row - 1][col - 1];
        }
    }

    // 设置响应头
    Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
    Response.AddHeader("content-disposition", "attachment;  filename=ExportedData.xlsx");

    // 将Excel包写入响应流
    var stream = new MemoryStream(package.GetAsByteArray());
    return File(stream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
}