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