private void GetPath(TimeSeries ts, string worksheet, int column, PathLayout pathLayout)
{
ts.Path = new DssPath();
if (pathLayout == PathLayout.StandardPath)
{
ts.Path.Apart = CellToString(workbook.Worksheets[worksheet].Cells[0, column]);
ts.Path.Bpart = CellToString(workbook.Worksheets[worksheet].Cells[1, column]);
ts.Path.Cpart = CellToString(workbook.Worksheets[worksheet].Cells[2, column]);
ts.Path.Fpart = CellToString(workbook.Worksheets[worksheet].Cells[5, column]);
}
else if (pathLayout == PathLayout.PathWithoutDPart)
{
ts.Path.Apart = CellToString(workbook.Worksheets[worksheet].Cells[0, column]);
ts.Path.Bpart = CellToString(workbook.Worksheets[worksheet].Cells[1, column]);
ts.Path.Cpart = CellToString(workbook.Worksheets[worksheet].Cells[2, column]);
ts.Path.Fpart = CellToString(workbook.Worksheets[worksheet].Cells[4, column]);
}
if (IsRegular(ts.Times.ToList()))
{
ts.Path.Epart = TimeWindow.GetInterval(ts);
}
else
{
ts.Path.Epart = "IR-Year";
}
}
private void GetPath(PairedData pd, string worksheet, int column, PathLayout pathLayout)
{
pd.Path = new DssPath();
if (pathLayout == PathLayout.StandardPath)
{
pd.Path.Apart = CellToString(workbook.Worksheets[worksheet].Cells[0, column]);
pd.Path.Bpart = CellToString(workbook.Worksheets[worksheet].Cells[1, column]);
pd.Path.Cpart = CellToString(workbook.Worksheets[worksheet].Cells[2, column]);
pd.Path.Epart = CellToString(workbook.Worksheets[worksheet].Cells[4, column]);
pd.Path.Fpart = CellToString(workbook.Worksheets[worksheet].Cells[5, column]);
}
else if (pathLayout == PathLayout.PathWithoutDPart)
{
pd.Path.Apart = CellToString(workbook.Worksheets[worksheet].Cells[0, column]);
pd.Path.Bpart = CellToString(workbook.Worksheets[worksheet].Cells[1, column]);
pd.Path.Cpart = CellToString(workbook.Worksheets[worksheet].Cells[2, column]);
pd.Path.Epart = CellToString(workbook.Worksheets[worksheet].Cells[3, column]);
pd.Path.Fpart = CellToString(workbook.Worksheets[worksheet].Cells[4, column]);
}
}
void Render(XmlWriter writer, PathLayout path)
{
RenderCore(path.Transition, writer, path.Path);
}
