private static ExcelReader CreateReader(ConvertCommandLine cmd) { switch (cmd.Type) { case "TRN": var trnReader = new TRNExcelReader(); if (ReadConfiguration(trnReader)) { return(trnReader); } return(null); case "SDT": var sdtReader = new SDTExcelReader(); if (ReadConfiguration(sdtReader)) { return(sdtReader); } return(null); case "GRP": var grpReader = new GRPExcelReader(); if (ReadConfiguration(grpReader)) { return(grpReader); } return(null); default: Console.WriteLine("Invalid value for Type argument"); return(null); } }
public void TestReadOneFile() { GRPExcelReader reader = new GRPExcelReader(); Config(reader); reader.Configuration.DefinitionSheetName = "GroupDefinitionSheet"; reader.ReadExcel(new string[] { Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "GRP_Test.xlsx") } , Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "groups.xml"), false); }
private static bool ReadConfiguration(GRPExcelReader reader) { if (!ReadBaseConfiguration(reader)) { return(false); } reader.Configuration.SupertypeColumn = Settings.Default.SupertypeColumn; return(true); }
private void Config(GRPExcelReader reader) { reader.Configuration.ObjectNameRow = 2; reader.Configuration.ObjectNameColumn = 1; reader.Configuration.ObjectDescColumn = 2; reader.Configuration.ObjectDescRow = 2; reader.Configuration.DataStartRow = 5; reader.Configuration.DataNameColumn = 1; reader.Configuration.DataDescriptionColumn = 2; reader.Configuration.SupertypeColumn = 3; }