Esempio n. 1
0
        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);
        }
Esempio n. 2
0
        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);
        }