protected SpreadsheetRow createTestRow(bool useHyperLinks, int columnsCount, int rowCounter)
{
var cells = new List <SpreadsheetCell>();
for (var i = 0; i < columnsCount; i++)
{
if (useHyperLinks && i == columnsCount - 1)
{
cells.Add(new SpreadsheetHyperlinkCell(new SpreadsheetHyperLink($"http://www.google.com",
"google me!")));
}
else
{
cells.Add(new SpreadsheetCell()
{
BackgroundColor = Color.Red,
ForegroundColor = Color.Blue,
Font = _font,
Alignment = HorizontalAligment.Center,
Value = $"Cell value {rowCounter} - {i}"
});
}
}
var spreadsheetRow = new SpreadsheetRow()
{
RowCells = cells
};
return(spreadsheetRow);
}
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));
}