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 TestReadFiles() { TRNExcelReader reader = new TRNExcelReader(); Config(reader); reader.Configuration.DefinitionSheetName = "TransactionDefinitionSheet"; reader.ReadExcel(new string[] { Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "Test.xlsx"), Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "Test3.xlsx") } , Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), "trns.xml"), false); }
private void Config(TRNExcelReader reader) { reader.Configuration.ObjectNameRow = 2; reader.Configuration.ObjectNameColumn = 1; reader.Configuration.ObjectDescColumn = 2; reader.Configuration.ObjectDescRow = 2; reader.Configuration.LevelCheckColumn = 3; reader.Configuration.LevelIdentifierKeyword = "LVL"; reader.Configuration.LevelParentIdColumn = 9; reader.Configuration.LevelIdColumn = 8; reader.Configuration.BaseTypeColumn = 10; reader.Configuration.DataStartRow = 5; reader.Configuration.DataStartColumn = 1; reader.Configuration.DataNameColumn = 1; reader.Configuration.DataDescriptionColumn = 2; reader.Configuration.DataTypeColumn = 4; reader.Configuration.DataLengthColumn = 5; reader.Configuration.AttributeKeyColumn = 3; reader.Configuration.AttributeNullableColumn = 6; }
private static bool ReadConfiguration(TRNExcelReader reader) { if (!ReadBaseDataConfiguration(reader)) { return(false); } reader.Configuration.AttributeKeyColumn = Settings.Default.AttributeKeyColumn; reader.Configuration.AttributeNullableColumn = Settings.Default.AttributeNullableColumn; reader.Configuration.AttributeAutonumberColumn = Settings.Default.AttributeAutonumberColumn; reader.Configuration.AttributeTitleColumn = Settings.Default.AttributeTitleColumn; reader.Configuration.AttributeColumnTitleColumn = Settings.Default.AttributeColumnTitleColumn; reader.Configuration.AttributeContextualTitleColumn = Settings.Default.AttributeContextualTitleColumn; // Values for PK and Nullable reader.Configuration.PKValue = Settings.Default.PKValue; reader.Configuration.NullableValue = Settings.Default.NullableValue; // Formula reader.Configuration.FormulaCheckColumn = Settings.Default.FormulaCheckColumn; reader.Configuration.FormulaIdentifierKeyword = Settings.Default.FormulaIdentifierKeyword; reader.Configuration.FormulaColumn = Settings.Default.FormulaColumn; return(true); }
private void ConfigJapan(TRNExcelReader reader) { reader.Configuration.DefinitionSheetName = "トランザクション定義書"; reader.Configuration.ObjectNameRow = 3; reader.Configuration.ObjectNameColumn = 12; reader.Configuration.ObjectDescRow = 3; reader.Configuration.ObjectDescColumn = 13; reader.Configuration.DataStartRow = 6; reader.Configuration.DataStartColumn = 2; reader.Configuration.AttributeKeyColumn = 7; reader.Configuration.PKValue = "PK"; reader.Configuration.DataNameColumn = 5; reader.Configuration.DataDescriptionColumn = 6; reader.Configuration.BaseTypeColumn = 8; reader.Configuration.DataTypeColumn = 9; reader.Configuration.DataLengthColumn = 10; reader.Configuration.AttributeNullableColumn = 11; reader.Configuration.NullableValue = "Y"; reader.Configuration.LevelCheckColumn = 3; reader.Configuration.LevelIdentifierKeyword = "レベル"; reader.Configuration.LevelIdColumn = 2; reader.Configuration.LevelParentIdColumn = 4; }