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