@page
@model xxtsoft.Web.Entry.Pages.test2Model
@{
}
<form method="post">
    <button type="submit" asp-page-handler="down" class="btn">导出excel1</button>

    <button type="submit" asp-page-handler="down02" class="btn">导出excel2</button>
</form>

using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.RazorPages;

using MiniExcelLibs;

using System.Data;

using xxtsoft.Common;
using xxtsoft.Core.Common;

namespace xxtsoft.Web.Entry.Pages
{
    public class test2Model : PageModel
    {
        private readonly SqlSugar.ISqlSugarClient _db;
        public test2Model(SqlSugar.ISqlSugarClient db)
        {
            this._db = db;
            //_db.ChangeDatabase("1");
        }
        public void OnGet()
        {
          
        }


        public IActionResult OnPostDown()
        {
            DataTable dt = _db.Ado.GetDataTable("select * from qy_info");
            EPPlusHelper epp = new EPPlusHelper();
            return epp.outExcel(dt,"2.xlsx");
           //return Page();

        }
        public IActionResult OnPostDown02()
        {
            DataTable dt = _db.Ado.GetDataTable("select * from qy_info");          

            // 创建内存流用于存储 Excel 数据
            using var stream = new MemoryStream();

            // 使用 MiniExcel 将数据写入到内存流
            stream.SaveAs(dt);

            // 返回 Excel 文件作为文件下载响应
            return File(stream.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "3.xlsx");


           

        }
    }
}