如何使用asp.net创建和下载excel文档

using OfficeOpenXml;
using System.IO;

public class ExcelHelper
{
    public static byte[] CreateExcelFile()
    {
        using var package = new ExcelPackage();
        var worksheet = package.Workbook.Worksheets.Add("Sheet1");

        // 在此处添加您的数据
        worksheet.Cells["A1"].Value = "Hello";
        worksheet.Cells["B1"].Value = "World!";

        // 保存Excel文件为字节数组
        using var memoryStream = new MemoryStream();
        package.SaveAs(memoryStream);
        return memoryStream.ToArray();
    }
}

using System.IO;
using System.IO.Compression;
using Microsoft.AspNetCore.Mvc;

public class HomeController : Controller
{
    public IActionResult DownloadExcel()
    {
        var fileContents = ExcelHelper.CreateExcelFile();

        return File(fileContents, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "MyExcelFile.xlsx");
    }
}

<a asp-action="DownloadExcel">下载Excel文件</a>