public void generateChart(List <Variable> variablesX, List <Variable> variablesY, _Worksheet sheet, DataSet dataSet)
{
int offsetY = 0;
foreach (Variable variableX in variablesX)
{
int offsetX = 0;
foreach (Variable variableY in variablesY)
{
var charts = (ChartObjects)sheet.ChartObjects();
var chartObject = charts.Add(offsetX * 450, offsetY * 250, 450, 250);
var chart = chartObject.Chart;
chart.ChartType = XlChartType.xlXYScatterLinesNoMarkers;
chart.ChartWizard(Title: "Time Series " + dataSet.getName() + " - " + variableX.name + " vs " + variableY.name, HasLegend: false);
var seriesCollection = (SeriesCollection)chart.SeriesCollection();
var series = seriesCollection.Add();
series.Values = variableY.getRange();
series.XValues = variableX.getRange();
series.MarkerStyle = XlMarkerStyle.xlMarkerStyleCircle;
offsetX++;
}
offsetY++;
}
}
public static DataSet modify(DataSet dataSet, string newRange)
{
string tmp = dataSet.Range;
int temp = tmp.IndexOf(':');
int start = tmp.IndexOf('$', temp + 1) + 1;
char[] ch = tmp.ToCharArray();
ch[start] = newRange.ToCharArray()[0];
string newtmp = new string(ch);
System.Diagnostics.Debug.WriteLine(tmp);
System.Diagnostics.Debug.WriteLine(newtmp);
Range range = dataSet.getWorksheet().Range[newtmp];
range.Select();
List <Variable> variables = createVariables(dataSet.getWorksheet(), range, dataSet.getRangeLayout(), dataSet.getVariableNamesInFirstRowOrColumn());
DataSet test = new DataSet(dataSet.getWorksheet(), range, dataSet.getName(), dataSet.getRangeLayout(), dataSet.getVariableNamesInFirstRowOrColumn(), variables);
return(test);
}
public void setVariableNamesInFirstRowOrColumn(DataSet dataSet, bool variableNamesInFirstRowOrColumn)
{
if (dataSet == null)
{
return;
}
DataSet newDataSet = DataSetFactory.create(dataSet.getWorksheet(), dataSet.getRange(), dataSet.getName(), dataSet.getRangeLayout(),
variableNamesInFirstRowOrColumn);
model.swapDataSets(dataSet, newDataSet);
}
