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