public void ShouldReadHeaders() { ExcelStreamReader.Execute(fileName, reader => reader.ForEachSheet(sheet => { sheet.ForEachRow((schema, row) => { Console.WriteLine("New Row"); for (int i = 0; i < schema.Columns.Count; i++) { Console.WriteLine(row[i]); } }); }) ); }
public void ShouldReadAllRows() { ExcelStreamReader.Execute(fileName, reader => reader.ForEachSheet(sheet => { var schema = sheet.GetSchema(); foreach (var row in sheet.GetRows()) { Console.WriteLine("New Row"); for (int i = 0; i < schema.Columns.Count; i++) { Console.WriteLine(row[i]); } } }) ); }
public void ImportAllRows() { var ddlManager = new DDLManager(); var bulkdInsertManager = new BulkInsertManager(); String connString = GetConnectionString(); Console.WriteLine("Start time" + DateTime.Now); ExcelStreamReader.Execute(fileName, reader => reader.ForEachSheet(sheet => { var schema = sheet.GetSchema(); ddlManager.CreateTable(schema.TableName, schema, connString); bulkdInsertManager.BulkInsertTo(schema, schema.TableName, sheet, connString); }) ); Console.WriteLine("End time" + DateTime.Now); }
public static void Execute(string fileName, Action <ExcelStreamReader> action) { var reader = new ExcelStreamReader(fileName); action(reader); }
public static void Execute(string fileName, Action<ExcelStreamReader> action) { var reader = new ExcelStreamReader(fileName); action(reader); }