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