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