dotnetcore / dotnetcore/Magicodes.IE

.Net Core使用模板导出Excel,不会自动刷新第二个sheet的透视表

Open
#436 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C#
Stars
2.2k
Forks
495
PR merge metrics
No merged PRs in 30d

Description

### Expected behaviour
如何做才能在第一个sheet填充数据之后自动刷新第二个sheet的透视表?

### Actual behaviour
var tplPath = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot/TestFiles", "ExportTemplatesTest", "SellinReportWeeklyTemplate.xlsx");

//创建Excel导出对象
IExportFileByTemplate exporter = new ExcelExporter();
//根据模板导出
var a = await exporter.ExportBytesByTemplate(res.Data, tplPath);

###excel

[SellinReportWeeklyTemplate.xlsx](https://github.com/dotnetcore/Magicodes.IE/files/9386173/SellinReportWeeklyTemplate.xlsx)

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.