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