public override void Execute() { var columnsCount = 10; var workBook = new SpreadsheetWorkbook(); var worksheet = new SpreadsheetWorksheet("Test22"); var table = new SpreadsheetTable("GridTable"); for (var i = 0; i < 10; i++) { table.Columns.Add(new SpreadsheetTableColumn() { Name = $"Column{i}" }); } var rowCounter = 0; var enumerator = Enumerable.Range(0, RowsToStream) // normally you would have some other IEnumerable that you would transform into spreadsheetrows // the key to use the least amount of memory as possible it to just pass it along without calling .ToList on the transformed data .Select(x => { return(createTestRow(false, columnsCount, x)); }) .GetEnumerator(); table.ActivateStreamingMode(enumerator); worksheet.AddTable(table); workBook.AddWorksheet(worksheet); workBook.Save(OutputFile); }
public void NonStreaming_LargeTable_FileCreated() { var newExcel = new SpreadsheetWorkbook(); var columnsCount = 10; var worksheet = new SpreadsheetWorksheet("Test22"); for (int i = 0; i < 100000; i++) { var cells = new List <SpreadsheetCell>(); for (var j = 0; j < columnsCount; j++) { cells.Add(new SpreadsheetCell() { BackgroundColor = Color.Red, ForegroundColor = Color.Blue, Font = _font, Alignment = HorizontalAligment.Center, Value = $"Ovo je test {i} - {j}" }); } var row = new SpreadsheetRow() { RowCells = cells }; worksheet.AddRow(row); } newExcel.AddWorksheet(worksheet); newExcel.Save(STR_TestOutputPath); Assert.IsTrue(File.Exists(STR_TestOutputPath)); }
public override void Execute() { var columnsCount = 10; var workBook = new SpreadsheetWorkbook(); var worksheet = new SpreadsheetWorksheet("Test22"); var table = new SpreadsheetTable("GridTable"); for (var i = 0; i < 10; i++) { table.Columns.Add(new SpreadsheetTableColumn() { Name = $"Column{i}" }); } table.ActivateStreamingMode(); var rowCounter = 0; table.TableRowRequested += (s, args) => { var spreadsheetRow = createTestRow(true, columnsCount, rowCounter); args.Row = spreadsheetRow; rowCounter++; args.Finished = rowCounter == RowsToStream; }; worksheet.AddTable(table); workBook.AddWorksheet(worksheet); workBook.Save(OutputFile); }
public override void Execute() { var workBook = new SpreadsheetWorkbook(); var sheet = new SpreadsheetWorksheet("Sheet1"); workBook.AddWorksheet(sheet); var table = new SpreadsheetTable("Table1"); table.Columns = new List <SpreadsheetTableColumn>() { new SpreadsheetTableColumn() { Name = "Column A" }, new SpreadsheetTableColumn() { Name = "Column B" } }; table.Rows = new List <SpreadsheetRow>() { new SpreadsheetRow() { RowCells = new List <SpreadsheetCell>() { new SpreadsheetCell() { Value = "Test" }, new SpreadsheetHyperlinkCell(new SpreadsheetHyperLink("https://www.google.com", "Google me!")) } }, new SpreadsheetRow() { RowCells = new List <SpreadsheetCell>() { new SpreadsheetCell() { Value = "Test2 " }, new SpreadsheetHyperlinkCell(new SpreadsheetHyperLink("https://www.google.com", "Google me!")) } } }; sheet.AddTable(table); workBook.Save(OutputFile); }
private static SpreadsheetWorkbook setupLargeWorkbook(Action <SpreadsheetRow> afterRowCreated, int rowsToStream = 800000, bool useHyperLinks = false, bool useEnumerator = false) { var columnsCount = 10; var newExcel = new SpreadsheetWorkbook(); var worksheet = new SpreadsheetWorksheet("Test22"); var table = new SpreadsheetTable("GridTable"); for (var i = 0; i < 10; i++) { table.Columns.Add(new SpreadsheetTableColumn() { Name = $"Column{i}" }); } if (!useEnumerator) { table.ActivateStreamingMode(); var rowCounter = 0; table.TableRowRequested += (s, args) => { var spreadsheetRow = createTestRow(useHyperLinks, columnsCount, rowCounter); args.Row = spreadsheetRow; rowCounter++; afterRowCreated?.Invoke(args.Row); args.Finished = rowCounter == rowsToStream; }; } else { var enumerator = Enumerable.Range(0, rowsToStream).Select(x => { var row = createTestRow(useHyperLinks, columnsCount, x); afterRowCreated?.Invoke(row); return(row); }) .GetEnumerator(); table.ActivateStreamingMode(enumerator); } worksheet.AddTable(table); newExcel.AddWorksheet(worksheet); return(newExcel); }
public override void Execute() { var workBook = new SpreadsheetWorkbook(); var sheet = new SpreadsheetWorksheet("Sheet1"); workBook.AddWorksheet(sheet); sheet.AddRow(new SpreadsheetRow() { RowCells = new List <SpreadsheetCell>() { new SpreadsheetCell() { Value = "Hello World!" } } }); workBook.Save(OutputFile); }
public void Test1() { var newExcel = new SpreadsheetWorkbook(); var worksheet = new SpreadsheetWorksheet("Test22"); worksheet.AddRow(new SpreadsheetRow() { RowCells = new System.Collections.Generic.List <SpreadsheetCell>() { new SpreadsheetCell() { Value = "test" } } }); newExcel.AddWorksheet(worksheet); newExcel.Save("c:\\temp\\test.xlsx"); }
public void Save_SingleCell_FileCreated() { var newExcel = new SpreadsheetWorkbook(); var worksheet = new SpreadsheetWorksheet("Test22"); worksheet.AddRow(new SpreadsheetRow() { RowCells = new System.Collections.Generic.List <SpreadsheetCell>() { new SpreadsheetCell() { Value = "test" } } }); newExcel.AddWorksheet(worksheet); newExcel.Save(STR_TestOutputPath); Assert.IsTrue(File.Exists(STR_TestOutputPath)); }