微信小程序生成Excel文件(.Net Core)

一：服务端返回字节流，小程序写文件

(1)后端代码 .Net Core 用到ExcelPackage

  public async Task<IActionResult> ExportIo([FromBody]Parameter parameter)
    {
        FactoryService factoryService = new FactoryService(_iServiceProvider);
           //获得数据
            var listData = await factoryService.GetAllDataNew(parameter);
            var result = new object();
            using (ExcelPackage excelPackage = new ExcelPackage())
            {
                ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("YuHong");
                worksheet.Cells[1, 1].Value = "生产线";
                worksheet.Cells[1, 2].Value = "生产工厂";
                worksheet.Cells[1, 3].Value = "生产时间";
                worksheet.Cells[1, 4].Value = "上传时间";
                worksheet.Cells[1, 5].Value = "12位转换码";
                worksheet.Cells[1, 6].Value = "16位防窜码";
                var rowNum = 2;
                foreach (var queryResult in listData)
                {
                    worksheet.Cells["A" + rowNum].Value = queryResult.Beltline;
                    worksheet.Cells["B" + rowNum].Value = queryResult.Factory;
                    worksheet.Cells["C" + rowNum].Value = queryResult.MakeTime;
                    worksheet.Cells["D" + rowNum].Value = queryResult.UpDate;