private void FastExcelMergeDemo(FileInfo inputFile)
{
Console.WriteLine();
Console.WriteLine("DEMO UPDATE 1");
Stopwatch stopwatch = new Stopwatch();
using (FastExcel.FastExcel fastExcel = new FastExcel.FastExcel(inputFile))
{
Worksheet worksheet = new Worksheet();
List <Row> rows = new List <Row>();
for (int rowNumber = 1; rowNumber < NumberOfRecords; rowNumber += 50)
{
List <Cell> cells = new List <Cell>();
for (int columnNumber = 1; columnNumber < 12; columnNumber += 2)
{
cells.Add(new Cell(columnNumber, rowNumber));
}
cells.Add(new Cell(13, "Updated Row"));
rows.Add(new Row(rowNumber, cells));
}
worksheet.Rows = rows;
stopwatch.Start();
Console.WriteLine("Updating data every 50th row...");
fastExcel.Update(worksheet, "sheet1");
}
Console.WriteLine(string.Format("Updating data took {0} seconds", stopwatch.Elapsed.TotalSeconds));
}
private void FastExcelMergeDemo(FileInfo inputFile)
{
Console.WriteLine();
Console.WriteLine("DEMO UPDATE 1");
Stopwatch stopwatch = new Stopwatch();
using (FastExcel.FastExcel fastExcel = new FastExcel.FastExcel(inputFile))
{
Worksheet worksheet = new Worksheet();
List<Row> rows = new List<Row>();
for (int rowNumber = 1; rowNumber < NumberOfRecords; rowNumber += 50)
{
List<Cell> cells = new List<Cell>();
for (int columnNumber = 1; columnNumber < 12; columnNumber += 2)
{
cells.Add(new Cell(columnNumber, rowNumber));
}
cells.Add(new Cell(13, "Updated Row"));
rows.Add(new Row(rowNumber, cells));
}
worksheet.Rows = rows;
stopwatch.Start();
Console.WriteLine("Updating data every 50th row...");
fastExcel.Update(worksheet, "sheet1");
}
Console.WriteLine(string.Format("Updating data took {0} seconds", stopwatch.Elapsed.TotalSeconds));
}
