public void CreateEmptyFile() { using (var excel = new SpreadsheetBook()) { var file = AppContext.BaseDirectory + "\\" + nameof(CreateEmptyFile) + ".xlsx"; excel.Create(file); } }
public void CreateFileAndWriteOneCell() { var file = AppContext.BaseDirectory + "\\" + nameof(CreateFileAndWriteOneCell) + ".xlsx"; using (var excel = new SpreadsheetBook()) { excel.Create(file); var sheet = excel[0]; var cellA1 = sheet.AddCell("D", 3); cellA1.Write($"Row: 3 - Cell: D"); } }
public void CreateFileInMemoryAndSaveInDisk() { var file = AppContext.BaseDirectory + "\\" + nameof(CreateFileInMemoryAndSaveInDisk) + ".xlsx"; using (var excel = new SpreadsheetBook()) { excel.Create(); var sheet = excel[0]; var cellA1 = sheet.AddCell("A", 1); var cellB3 = sheet.AddCell("B", 3); cellA1.Write("Row: 1 - Cell:A1"); cellB3.Write("Row: 3 - Cell:B3"); excel.SaveAs(file); } }
public void CreateFileAndWriteTextInA1AndB3() { var file = AppContext.BaseDirectory + "\\" + nameof(CreateFileAndWriteTextInA1AndB3) + ".xlsx"; using (var excel = new SpreadsheetBook()) { excel.Create(file); var sheet = excel[0]; var cellA1 = sheet.AddCell("A", 1); var cellB3 = sheet.AddCell("B", 3); cellA1.Write("Row: 1 - Cell:A1"); cellB3.Write("Row: 3 - Cell:B3"); } }
public void CreateFileAndWriteFirstLineInFirstSheet() { var file = AppContext.BaseDirectory + "\\" + nameof(CreateFileAndWriteFirstLineInFirstSheet) + ".xlsx"; using (var excel = new SpreadsheetBook()) { excel.Create(file); var sheet = excel[0]; for (byte cIndex = 1; cIndex <= 26; cIndex++) { var cell = sheet.AddCell(cIndex, 1); cell.Write($"Row: 1 - Cell:{cIndex}"); } } }
public void CreateFileWith100RowsAnd20CellsInForAllSheets() { var file = AppContext.BaseDirectory + "\\" + nameof(CreateFileWith100RowsAnd20CellsInForAllSheets) + ".xlsx"; using (var excel = new SpreadsheetBook()) { excel.Create(file); // excel.AddWorksheet("FirstPlan"); foreach (var planilha in excel) { for (uint rowIndex = 1; rowIndex < 101; rowIndex++) { for (byte cIndex = 1; cIndex <= 26; cIndex++) { var cell = planilha.AddCell(cIndex, rowIndex); cell.Write($"Row:{rowIndex} - Cell:{cIndex}"); } } } } }
public SpreadsheetTest() { _workBook = new SpreadsheetBook(); _workBook.Create($"{AppContext.BaseDirectory}\\{nameof(SpreadsheetTest)}{DateTime.Now:dd_MM_yyy-HH_mm_fffff}.xlsx", nameof(SpreadsheetTest)); }