<form method="post">
    <button type="submit" asp-page-handler="down" class="btn">虚拟文件下载</button>
    <button type="submit" asp-page-handler="down01" class="btn">文件流的方式下载01</button>
    <button type="submit" asp-page-handler="down02" class="btn">远程文件下载02</button>


    <button type="submit" asp-page-handler="down03" class="btn">导入excel</button>
</form>

using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.RazorPages;
using System;
using System.Data;
using System.IO;
using System.Net.Mime;
using xxtsoft.Common;


namespace xxtsoft.Pages
{
    public class officeModel : PageModel
    {
        //public DataTable dt = new DataTable();
       
        public void OnGet()
        {

            //string f = FileHelper.absoluteWebPath("upLoadfiels/01.xlsx");    

            //dt = OfficeHelper.InputEPPlusByExcelToDT(f);

            DataSet ds = CommHelper.GetDs("rw", "*", "", "id desc");
            string[] nameStrs = { "id", "bm", "xm", "rw", "zrr", "kssj", "jssj", "bz", "cdt" };
            string msg = "";
            bool b = OfficeHelper.DTExportEPPlusExcel(ds.Tables[0], "wwwroot/upLoadfiels", "test.xlsx", nameStrs, ref msg);

            //ViewData["msg"] = b;
            //CommHelper.DownloadFile(addrUrl);

        }

        /// <summary>
        /// 虚拟文件地址输出下载        
        /// </summary>
        /// <returns></returns>
        //public IActionResult OnPostDown()
        //{
        //    //string f = "upLoadfiels/xls/";
        //    //string n = "test.xlsx";
        //    //DataSet ds = CommHelper.GetDs("tst", "*", "", "");
        //    //string[] nameStrs = { "序号", "姓名" };
        //    //string msg = "";
        //    //bool b = OfficeHelper.DTExportEPPlusExcel(ds.Tables[0], "wwwroot/" + f, n, nameStrs, ref msg);

        //    //if (b)
        //    //{

        //    //    return File(f + n, "application/octet-stream", Path.GetFileName(f + n));
        //    //}
        //    //else
        //    //{
        //    //    return NotFound();

        //    //}

        //    //var addrUrl = "/upLoadfiels/xls/test.xlsx";
        //    //return File(addrUrl, "application/octet-stream", Path.GetFileName(addrUrl));
        //}
        /// <summary>
        /// 文件流的方式输出
        /// </summary>
        /// <returns></returns>
        //public IActionResult OnPostDown01()
        //{
        //    var addrUrl = @"C:\奇迹再造\xxtsoft\wwwroot\upLoadfiels\xls\test1.xlsx";
        //    var stream = System.IO.File.OpenRead(addrUrl);
        //    return File(stream, "application/octet-stream", Path.GetFileName(addrUrl));
        //}

        /// <summary>
        /// 通过HttpClient获取另外站点的文件流，再输出        
        /// </summary>
        /// <returns></returns>
        //public async Task<IActionResult> OnPostDown02()
        //{
        //    var path = "https://oa.eduw.cn/upLoadfiels/logo.png";
        //    HttpClient client = new HttpClient();
        //    client.BaseAddress = new Uri(path);
        //    var stream = await client.GetStreamAsync(path);
        //    return File(stream, "application/octet-stream", Path.GetFileName(path));
        //}
        //public void OnPostDown03()
        //{

        //    string f = "wwwroot/upLoadfiels/xls/test.xlsx";

        //    FileInfo fileExcel = new FileInfo(f);

        //    DataTable? dt1 = OfficeHelper.InputEPPlusByExcelToDT(fileExcel);
        //    this.dt = dt1;
        //}

    }


}