private static void ReadENwisParmsExcelToSql(string inputExcelFile, StringBuilder sb) { if (!File.Exists(inputExcelFile)) { throw new ArgumentException("Input excel file '" + inputExcelFile + "' does not exist!"); } object misValue = Missing.Value; var xlApp = new Excel.Application(); var xlWorkBook = xlApp.Workbooks.Open(inputExcelFile, 0, true, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); var cachedMetadataTables = new MetadataParamTables(); if (xlWorkBook != null) { cachedMetadataTables.Load(xlWorkBook); xlWorkBook.Close(true, misValue, misValue); xlApp.Quit(); } ReleaseObject(xlWorkBook); ReleaseObject(xlApp); Console.WriteLine("[Debug] MetadataTables is loadded."); Console.WriteLine("[Debug] ParamTable: {0}", cachedMetadataTables.ParamTable); Console.WriteLine("[Debug] UnitsTable: {0}", cachedMetadataTables.UnitsTable); Console.WriteLine("[Debug] UnitsGroupTable: {0}", cachedMetadataTables.UnitsGroupTable); ReadDataIntoSQL(cachedMetadataTables, sb); }
private static void ReadDataIntoSQL(MetadataParamTables cachedMetadataParamTables, StringBuilder sb) { sb.AppendLine(@"USE $(DBName)"); sb.AppendLine(@"DECLARE @CNT INT;"); sb.AppendLine(); //first go through UnitsGroup ReadUnitsGroup(cachedMetadataParamTables.UnitsGroupTable, sb); //Then go through Units ReadUnits(cachedMetadataParamTables.UnitsTable, sb); //Last go through Parameters ReadParameters(cachedMetadataParamTables.ParamTable, sb); }