.net core 使用post请求导出Excel

项目中导出功能需要根据页面中勾选的guid去导出excel，原本使用的get请求就不够用了
需要转为post请求，特此记录一下
前端

exportForSupplier() {
    //exportFile("/pmat/api/app/materials-for-supplier/export-tobe-settled-material-list", this.materialSearchData);
    this.materialSearchData.materialIds = null;
    
    this.$services.materials.materialsForSupplier.exportTobeSettledMaterialList(this.materialSearchData).then((res) => {
    	//这里我后端方法返回的是Byte[] 前端拿到的却已经转成了base64
        // 将 Base64 字符串解码为二进制数据
        var byteCharacters = atob(res);
        var byteNumbers = new Array(byteCharacters.length);
        for (var i = 0; i < byteCharacters.length; i++) {
            byteNumbers[i] = byteCharacters.charCodeAt(i);
        }

        // 将二进制数据转换为 Uint8Array
        var byteArray = new Uint8Array(byteNumbers);

        // 使用二进制数据创建 Blob 对象
        var blob = new Blob([byteArray], { type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" });
        const url = window.URL.createObjectURL(blob);
        const a = document.createElement('a');
        a.href = url;
        a.download = 'exported-file.xlsx'; // 可以自定义文件名
        document.body.appendChild(a);
        a.click();
        a.remove();
        
    });
}

后端

 public async Task<byte[]> ExportTobeSettledMaterialListAsync(GetMaterialsForSupplierInput input)
 {
     input.SkipCount = 0;
     input.MaxResultCount = Int32.MaxValue;

     var exportList = (await GetMyTodoMaterialListAsync(input) as CustomPagedResultDto<MaterialDto>)!;
		if (input.PostMaterialIds.Any())
		{
			exportList.Items = exportList.Items.Where(s => input.PostMaterialIds.Contains(s.Id)).ToList();
		}
		// 2、获取模板，往模板中插入数据
		string templateFile = Path.Combine(_hostingEnvironment.ContentRootPath, "Templates", "MaterialMyTodoForSupplierTemplate.xlsx");
     var ms = new MemoryStream();
     using (var stream = File.OpenRead(templateFile))
     {
         XSSFWorkbook xssWorkbook = new XSSFWorkbook(stream);
         var sheet = xssWorkbook.GetSheetAt(0);

         int rowIndex = 3;
         // 从A4开始
         foreach (var material in exportList.Items)
         {
             rowIndex += 1;

             // 2.1、采购订单号、物料号、收货日期、数量
             ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"A{rowIndex}", rowIndex, material.SA, DataTypeEnum.String);
             ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"B{rowIndex}", rowIndex, material.MaterialNumber, DataTypeEnum.String);
             ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"C{rowIndex}", rowIndex, material.ReceivingTime.ToString("yyyy-MM-dd"), DataTypeEnum.String);
             ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"D{rowIndex}", rowIndex, material.Factory, DataTypeEnum.String);
             ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"E{rowIndex}", rowIndex, material.ArrivalQuantity.ToFixed(0).ToString(), DataTypeEnum.Integer);
                                                                           
             // 2.2、A价（未税单价、VW Confirm、不含税金额、增值税额）
             ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"F{rowIndex}", rowIndex, material.MaterialUntaxedUnitPriceStr, DataTypeEnum.Decimal, 5);
             ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"G{rowIndex}", rowIndex, material.CFFConfirmMaterialUnitPrice?.ToAmountFormat(5), DataTypeEnum.Decimal, 5);
             ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"H{rowIndex}", rowIndex, material.AmountWithoutVatForAPrice.ToAmountFormat(), DataTypeEnum.Decimal);
             ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"I{rowIndex}", rowIndex, material.VatAmountForAPrice.ToAmountFormat(), DataTypeEnum.Decimal);

             // 2.3、包装费（未税单价、VW Confirm、不含税金额、增值税额）
             ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"J{rowIndex}", rowIndex, material.PackingUntaxedUnitPrice.ToAmountFormat(5), DataTypeEnum.Decimal, 5);
             ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"K{rowIndex}", rowIndex, material.TLPConfirmPackingUnitPrice?.ToAmountFormat(5), DataTypeEnum.Decimal, 5);
             ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"L{rowIndex}", rowIndex, material.AmountWithoutVatForPacking.ToAmountFormat(), DataTypeEnum.Decimal);
             ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"M{rowIndex}", rowIndex, material.VatAmountForPacking.ToAmountFormat(), DataTypeEnum.Decimal);
             // 2.4、送货单号（DeliveryNote）
             ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"N{rowIndex}", rowIndex, material.DeliveryNote, DataTypeEnum.String);
         }

         // 2.7、合计
         var totalItem = exportList.TotalItem;
         var lastRowIndex = rowIndex + 1;
         ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"A{lastRowIndex}", lastRowIndex, _localizer["Table:Total"], DataTypeEnum.String);
         ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"E{lastRowIndex}", lastRowIndex, totalItem.ArrivalQuantity.ToFixed(0).ToString(), DataTypeEnum.String);
         ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"H{lastRowIndex}", lastRowIndex, totalItem.AmountWithoutVatForAPrice.ToAmountFormat(), DataTypeEnum.Decimal);
         ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"I{lastRowIndex}", lastRowIndex, totalItem.VatAmountForAPrice.ToAmountFormat(), DataTypeEnum.Decimal);
         ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"L{lastRowIndex}", lastRowIndex, totalItem.AmountWithoutVatForPacking.ToAmountFormat(), DataTypeEnum.Decimal);
         ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"M{lastRowIndex}", lastRowIndex, totalItem.VatAmountForPacking.ToAmountFormat(), DataTypeEnum.Decimal);


         // 空值单元格的实线
         ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"B{lastRowIndex}", lastRowIndex, "", DataTypeEnum.String);
         ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"C{lastRowIndex}", lastRowIndex, "", DataTypeEnum.String);
         ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"D{lastRowIndex}", lastRowIndex, "", DataTypeEnum.String);
         ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"F{lastRowIndex}", lastRowIndex, "", DataTypeEnum.String);
         ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"G{lastRowIndex}", lastRowIndex, "", DataTypeEnum.String);
         ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"J{lastRowIndex}", lastRowIndex, "", DataTypeEnum.String);
         ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"K{lastRowIndex}", lastRowIndex, "", DataTypeEnum.String);
         ExcelHelper.Value.SetCellData(xssWorkbook, sheet.SheetName, $"N{lastRowIndex}", lastRowIndex, "", DataTypeEnum.String);

         ExcelHelper.Value.AutoSizeColumns(sheet);

         xssWorkbook.Write(ms, true);
     }
     ms.Position = 0;


     var fileName = $"Export_MyTodoList_{DateTime.Now.ToString("yyyyMMddHHmmss")}.xlsx";
     byte[] data = ms.ToArray();

     //return new RemoteStreamContent(ms, fileName, FileHelper.GetMimeType(fileName));
     return data;
 }