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