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 Test4()
{
SDTExcelReader reader = new SDTExcelReader();
reader.Configuration.DataStartRow = 5;
reader.Configuration.DataStartColumn = 1;
reader.Configuration.DataNameColumn = 1;
reader.Configuration.DataDescriptionColumn = 2;
reader.Configuration.DataTypeColumn = 4;
reader.Configuration.LevelCheckColumn = 3;
reader.Configuration.LevelIdColumn = 8;
reader.Configuration.LevelParentIdColumn = 9;
reader.Configuration.LevelIdentifierKeyword = "LVL";
reader.Configuration.BaseTypeColumn = 10;
reader.Configuration.DataLengthColumn = 5;
reader.Configuration.ObjectNameRow = 2;
reader.Configuration.ObjectNameColumn = 1;
reader.Configuration.ObjectDescRow = 2;
reader.Configuration.ObjectDescColumn = 2;
reader.Configuration.DefinitionSheetName = "TransactionDefinitionSheet";
reader.Configuration.ItemIsCollectionColumn = 10;
reader.Configuration.CollectionIdentifierKeyword = "Y";
reader.Configuration.CollectionItemNameColumn = 11;
reader.ReadExcel(new string[] { GetAbsolutePathToTest("Test4_JP_SDT1.xlsx"), GetAbsolutePathToTest("Test4_JP_SDT2.xlsx") }
, GetAbsolutePathToTest("sdts_jp_4.xml"), false);
}
public void TestReadSDTCollection()
{
SDTExcelReader reader = new SDTExcelReader();
Config(reader);
reader.Configuration.DefinitionSheetName = "SDT Definition";
reader.ReadExcel(new string[] { GetAbsolutePathToTest("SDT_Test_LVL.xlsx") }
, GetAbsolutePathToTest("sdts_col.xml"), false);
}
public void TestReadJPFolder()
{
SDTExcelReader reader = new SDTExcelReader();
ConfigJPFolder(reader);
reader.Configuration.DefinitionSheetName = "SDT定義書";
reader.ReadExcel(Directory.GetFiles(GetAbsolutePathToTest(Path.Combine("JP", "SDT")), "*.xlsx")
, GetAbsolutePathToTest(Path.Combine("JP", "SDT", "sdts_jp_folder.xml")), false);;
}
public void TestReadJPFile()
{
SDTExcelReader reader = new SDTExcelReader();
ConfigJP(reader);
reader.Configuration.DefinitionSheetName = "定義シート";
reader.ReadExcel(new string[] { GetAbsolutePathToTest("SDT_Test_JP.xlsx") }
, GetAbsolutePathToTest("sdts_jp.xml"), false);
}
private static bool ReadConfiguration(SDTExcelReader reader)
{
if (!ReadBaseDataConfiguration(reader))
{
return(false);
}
reader.Configuration.ItemIsCollectionColumn = Settings.Default.ItemIsCollectionColumn;
reader.Configuration.CollectionIdentifierKeyword = Settings.Default.CollectionIdentifierKeyword;
reader.Configuration.CollectionItemNameColumn = Settings.Default.CollectionItemNameColumn;
reader.Configuration.DomainPrefixKeyword = Settings.Default.DomainPrefixKeyword;
reader.Configuration.AttributePrefixKeyword = Settings.Default.AttributePrefixKeyword;
reader.Configuration.SDTPrefixKeyword = Settings.Default.SDTPrefixKeyword;
reader.Configuration.DefaultBaseTypePrefixKeyword = Settings.Default.DefaultBaseTypePrefixKeyword;
return(true);
}
private void ConfigJPFolder(SDTExcelReader reader)
{
ConfigJP(reader);
reader.Configuration.DataStartRow = 7;
reader.Configuration.DataStartColumn = 7;
reader.Configuration.ObjectNameColumn = 7;
reader.Configuration.ObjectDescColumn = 9;
reader.Configuration.ItemIsCollectionColumn = 3;
reader.Configuration.CollectionIdentifierKeyword = "○";
reader.Configuration.LevelCheckColumn = 4;
reader.Configuration.LevelIdentifierKeyword = "○";
reader.Configuration.LevelParentIdColumn = 5;
reader.Configuration.DataNameColumn = 7;
reader.Configuration.CollectionItemNameColumn = 8;
reader.Configuration.DataTypeColumn = 9;
reader.Configuration.DataLengthColumn = 10;
reader.Configuration.BaseTypeColumn = 13;
}
private void Config(SDTExcelReader reader)
{
reader.Configuration.ObjectNameRow = 3;
reader.Configuration.ObjectNameColumn = 4;
reader.Configuration.ObjectDescColumn = 5;
reader.Configuration.ObjectDescRow = 3;
reader.Configuration.LevelCheckColumn = 3;
reader.Configuration.LevelIdentifierKeyword = "LV";
reader.Configuration.LevelParentIdColumn = 4;
reader.Configuration.LevelIdColumn = 2;
reader.Configuration.BaseTypeColumn = 7;
reader.Configuration.DataStartRow = 6;
reader.Configuration.DataNameColumn = 5;
reader.Configuration.DataDescriptionColumn = 6;
reader.Configuration.DataTypeColumn = 8;
reader.Configuration.DataLengthColumn = 9;
reader.Configuration.ItemIsCollectionColumn = 10;
reader.Configuration.CollectionIdentifierKeyword = "Y";
reader.Configuration.CollectionItemNameColumn = 11;
}
