public void Range_InsertLargeAmountOfData_MultiColumn_50000Cells()
{
WriterProcessor writer = new WriterProcessor();
List <string> listColumn = new List <string>();
listColumn.Add("A");
// gap
listColumn.Add("C");
listColumn.Add("D");
// More gap
listColumn.Add("G");
listColumn.Add("H");
List <Range> listRange = new List <Range>();
foreach (string column in listColumn)
{
Range range = new Range(column);
for (uint i = 1; i < 10000; i++)
{
range.addCellCore(new CellCore(i, "insert InsertMultiColumn [" + column + "] line [" + i.ToString() + "]"));
}
listRange.Add(range);
}
writer.UpdateListOfRange("FichierInOrig.xlsx", "Sheet2", listRange);
}
public void Range_InsertLargeAmountOfData_SameColumn_10000Cells()
{
WriterProcessor writer = new WriterProcessor();
Range range = new Range("A");
for (uint i = 1; i < 10000; i++)
{
range.addCellCore(new CellCore(i, "insert InsertLargeAmountOfData : " + i.ToString()));
}
writer.UpdateRange("FichierInOrig.xlsx", "Sheet2", range);
}
public ModeRunnerAbstract()
{
this.writer = new WriterProcessor();
}
