public byte[] ConvertToZipFile(IEnumerable <TEntity> entities, string sheetName = "Sheet1", bool enableProfileLog = true)
{
var zipper = new ExcelZippedExporter();
zipper.TemplateFileName = TemplateFileName;
zipper.AddExport(sheetName, this, entities);
zipper.EnableProfileLog = enableProfileLog;
return(zipper.BuildZipFile());
/*
* if (string.IsNullOrEmpty(TemplateFileName)) {
* using (ExcelPackage pck = new ExcelPackage()) {
* var ws = pck.Workbook.Worksheets.Add(sheetName);
* RenderWorkSheet(entities, ws);
* return ZipPackage(pck);
* }
* } else {
* using (var fs = new FileStream(TemplateFileName, FileMode.Open, FileAccess.Read, FileShare.Read)) {
* using (ExcelPackage pck = new ExcelPackage(fs)) {
* ExcelWorksheet ws = pck.Workbook.Worksheets.First(i => i.Name == sheetName);
* RenderWorkSheet(entities, ws);
*
* var dataRange = ws.Cells["A1:" + ws.Dimension.End.Address.ToString()];
* // 刷新所有透视表
* foreach (var w in pck.Workbook.Worksheets) {
* foreach (var p in w.PivotTables) {
* p.CacheDefinition.SourceRange = dataRange;
* }
* }
*
* return ZipPackage(pck);
* }
* }
* }*/
}
public async Task <byte[]> ConvertToZipFileSync(IEnumerable <TEntity> entities, string sheetName = "Sheet1", bool enableProfileLog = true)
{
var zipper = new ExcelZippedExporter();
zipper.TemplateFileName = TemplateFileName;
zipper.AddExport(sheetName, this, entities);
zipper.EnableProfileLog = enableProfileLog;
return(await zipper.BuildZipFileSync());
}
