public DataSet(_Worksheet worksheet, Range range, string name, RangeLayout rangeLayout, bool variableNamesInFirstRowOrColumn, List <Variable> variables) { this.worksheet = worksheet; this.range = range; this.name = name; this.rangeLayout = rangeLayout; this.variableNamesInFirstRowOrColumn = variableNamesInFirstRowOrColumn; this.variables = new BindingList <Variable>(variables); }
public void setRangeLayoutFor(DataSet dataSet, RangeLayout rangeLayout) { if (dataSet == null) { return; } DataSet newDataSet = DataSetFactory.create(dataSet.getWorksheet(), dataSet.getRange(), dataSet.getName(), rangeLayout, dataSet.getVariableNamesInFirstRowOrColumn()); model.swapDataSets(dataSet, newDataSet); }
public dynamic[] getValuesArray(RangeLayout rangeLayout) { var valuesList = new List <dynamic>(); if (rangeLayout == RangeLayout.COLUMNS) { for (int row = 0; row < range.Rows.Count; row++) { var value = ((Range)worksheet.Cells[range.Row + row, range.Column]).Value2; valuesList.Add(value); } } else { for (int column = 0; column < range.Columns.Count; column++) { var value = ((Range)worksheet.Cells[range.Row, range.Column + column]).Value2; valuesList.Add(value); } } return(valuesList.ToArray()); }
public static DataSet create(_Worksheet worksheet, Range range, string name, RangeLayout rangeLayout, bool variableNamesInFirstRowOrColumn) { List <Variable> variables = createVariables(worksheet, range, rangeLayout, variableNamesInFirstRowOrColumn); return(new DataSet(worksheet, range, name, rangeLayout, variableNamesInFirstRowOrColumn, variables)); }
//test public static List <Variable> createVariables(_Worksheet worksheet, Range range, RangeLayout rangeLayout, bool variableNamesInFirstRowOrColumn) { return(rangeLayout == COLUMNS? createColumnVariables(worksheet, range, variableNamesInFirstRowOrColumn) : createRowVariables(worksheet, range, variableNamesInFirstRowOrColumn)); }