//private void GetPairedDataTypes(PairedData pd, string worksheet) //{ // string typeI = "Independent Type"; // string typeD = "Dependent Type"; // if (HasTypes()) // { // int adjustment1 = 2; // int adjustment2 = 1; // int typeIIndex = (int)ActiveSheetInfo.PathLayout - adjustment1; // int typeDIndex = (int)ActiveSheetInfo.PathLayout - adjustment2; // int column = 1; // typeI = CellToString(workbook.Worksheets[worksheet].Cells[typeIIndex, column]); // typeD = CellToString(workbook.Worksheets[worksheet].Cells[typeDIndex, column]); // } // pd.TypeIndependent = typeI; // pd.TypeDependent = typeD; //} //private void GetPairedDataUnits(PairedData pd, string worksheet) //{ // string unitI = "Independent Unit"; // string unitD = "Dependent Unit"; // if (HasUnits()) // { // int adjustment1 = 2; // int adjustment2 = 1; // if (HasTypes()) // { // adjustment1 = 4; // adjustment2 = 3; // } // int unitIIndex = (int)ActiveSheetInfo.PathLayout - adjustment1; // int unitDIndex = (int)ActiveSheetInfo.PathLayout - adjustment2; // int column = 1; // unitI = CellToString(workbook.Worksheets[worksheet].Cells[unitIIndex, column]); // unitD = CellToString(workbook.Worksheets[worksheet].Cells[unitDIndex, column]); // } // pd.UnitsIndependent = unitI; // pd.UnitsDependent = unitD; //} private DssPath GetRandomPairedDataPath(PairedData pd, string worksheet) { return(new DssPath("import", Path.GetFileNameWithoutExtension(workbook.FullName), worksheet, "", "excel", "pairedData" + ExcelTools.RandomString(3))); }