CalculationData.GetParamValueInArrayMode
CalculationData.GetParamValueInArrayMode method
Gets the value(s) of the parameter at given index. If the parameter is some kind of expression that needs to be calculated, then it will be calculated in array mode.
public object[][] GetParamValueInArrayMode(int index, int maxRowCount, int maxColumnCount)
| Parameter | Type | Description |
|---|---|---|
| index | Int32 | The index of the parameter(0 based) |
| maxRowCount | Int32 | The row count limit for the returned array. If it is non-positive or greater than the actual row count, then actual row count will be used. |
| maxColumnCount | Int32 | The column count limit for the returned array. If it is non-positive or greater than the actual row count, then actual column count will be used. |
Return Value
An array which contains all items represented by the specified parameter.
Remarks
For an expression that needs to be calculated, taking A:A+B:B as an example: In value mode it will be calculated to a single value according to current cell base. But in array mode, all values of A1+B1,A2+B2,A3+B3,… will be calculated and used to construct the returned array. And for such kind of situation, it is better to specify the limit for the row/column count (such as according to MaxDataRow and MaxDataColumn), otherwise the returned large array may increase memory cost with large amount of useless data.
See Also
- class CalculationData
- namespace Aspose.Cells
- assembly Aspose.Cells