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