一:服务端返回字节流,小程序写文件
(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 &