private DssPath GetRandomTimeSeriesPath(TimeSeries ts, string worksheet)
{
if (IsRegular(ts.Times.ToList()))
{
var temp = ts;
temp.Path = new DssPath("import", Path.GetFileNameWithoutExtension(workbook.FullName), worksheet,
"", "", "regularTimeSeries" + ExcelTools.RandomString(3));
temp.Path.Epart = TimeWindow.GetInterval(temp);
return(temp.Path);
}
else
{
return(new DssPath("import", Path.GetFileNameWithoutExtension(workbook.FullName), worksheet,
"", "IR-Year", "irregularTimeSeries" + ExcelTools.RandomString(3)));
}
}
public void CreateWorkbook(string filename)
{
workbook = workbookSet.Workbooks.Add();
if (filename == "" || filename == null)
{
workbook.FullName = "dss_excel" + ExcelTools.RandomString(10) + ".xlsx";
}
else if (filename.EndsWith(".xls") || filename.EndsWith(".xlsx"))
{
workbook.FullName = filename;
}
else
{
workbook.FullName = Path.GetDirectoryName(filename) + "\\" +
Path.GetFileNameWithoutExtension(filename) + ".xlsx";
}
}
//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)));
}