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