public void build_excel() { IPropertyContainer[] rows = { new MutablePropertyContainer() .WithValue(Sheet1Meta.Name, "Alex") .WithValue(Sheet1Meta.Age, 42) .WithValue(Sheet1Meta.Date, DateTime.Today.ToLocalDateTime().Date), new MutablePropertyContainer() .WithValue(Sheet1Meta.Name, "Helen") .WithValue(Sheet1Meta.Age, 17), }; var documentMetadata = new ExcelDocumentMetadata() .WithValue(ExcelMetadata.DataType, CellValues.SharedString) .WithValue(ExcelMetadata.FreezeTopRow, true) .WithValue(ExcelMetadata.ColumnWidth, 14) as ExcelDocumentMetadata; var transposed = new ExcelSheetMetadata() .WithValue(ExcelMetadata.Transpose, true) as ExcelSheetMetadata; ExcelReportBuilder .Create("build_excel.xlsx", documentMetadata) .AddReportSheet(new Sheet1Report("Sheet1"), rows) .AddReportSheet(new Sheet1Report("Sheet2").SetMetadata(transposed), rows) .SaveAndClose(); }
public Stream ReportToExcel(Entity[] entities, IReportBuilderSettings?reportBuilderSettings) { var reportRows = entities.Select(entity => EntityMeta.Instance.ToContainer(entity)); var excelStream = new MemoryStream(); ExcelReportBuilder.Create(excelStream, settings: reportBuilderSettings) .AddReportSheet(new EntityReport("Entities"), reportRows) .SaveAndClose(); return(excelStream); }
public void build_excel_with_nulls() { IPropertyContainer[] rows = { new MutablePropertyContainer(), }; var documentMetadata = new ExcelDocumentMetadata() .WithValue(ExcelMetadata.DataType, CellValues.SharedString) .WithValue(ExcelMetadata.FreezeTopRow, true) .WithValue(ExcelMetadata.ColumnWidth, 14); ExcelReportBuilder .Create("build_excel.xlsx", documentMetadata) .AddReportSheet(new Sheet1Report("Sheet1"), rows) .SaveAndClose(); }