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