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