static void RunImport <T>(int tableId) where T : class
{
try {
IPowersheetImporter <T> importer = PowersheetImportFactory.Get <T>(@"Files/sheet.xlsx");
List <T> data = importer.GetAll(tableId).ToList();
foreach (var d in data)
{
System.Console.WriteLine(d.ToString());
System.Console.WriteLine();
}
}
catch (Exception ex) {
System.Console.WriteLine("Oops! {0}", ex.Message);
}
}
static void RunDump <T>(int tableId)
{
try {
IPowersheetImporter <T> importer = PowersheetImportFactory.Get <T>(@"Files/sheet.xlsx");
List <T> data = importer.GetAll(tableId).ToList();
var dumpStuff = new List <DumpClass>();
foreach (var d in data)
{
var c = new DumpClass();
}
}
catch (Exception ex) {
System.Console.WriteLine("Oops! {0}", ex.Message);
}
}
static void RunImport <T>(int tableId, int headingsRow, params string[] columns) where T : class
{
try {
IPowersheetImporter <T> importer = PowersheetImportFactory.Get <T>(@"Files/sheet.xlsx");
IPowersheetPropertyMap[] mappings = importer.GetMappings(columns).ToArray();
List <T> data = importer.Fetch(tableId, headingsRow, null, null, mappings).ToList();
foreach (var d in data)
{
System.Console.WriteLine(d.ToString());
System.Console.WriteLine();
}
}
catch (Exception ex) {
System.Console.WriteLine("Oops! {0}", ex.Message);
}
}
static void RunGrid <T>(int tableId) where T : class
{
try {
IPowersheetImporter <T> importer = PowersheetImportFactory.Get <T>(@"Files/sheet.xlsx");
object[,] grid = importer.ToGrid(tableId);
int y = (grid.GetLength(0) < 10) ? grid.GetLength(0) : 10;
int x = (grid.GetLength(1) < 10) ? grid.GetLength(1) : 10;
for (int o = 0; o < y; o++)
{
for (int i = 0; i < x; i++)
{
System.Console.Write(grid[o, i]);
}
}
}
catch (Exception ex) {
System.Console.WriteLine("Oops! {0}", ex.Message);
}
}
