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()); }