ParameterValue.ArrayValue Property

Gets the parameter as an array of cell values.

Namespace: DevExpress.Spreadsheet.Functions

Assembly: DevExpress.Spreadsheet.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public CellValue[, ] ArrayValue { get; }

VB.NET

Public ReadOnly Property ArrayValue As CellValue(,)

Property Value

Type	Description
CellValue[,]	A two-dimensional array of CellValue objects.

Remarks

If the parameter is not an array, returns null.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ArrayValue property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

winforms-spreadsheet-use-formula-engine/CS/FormulaEngineTest/Form1.cs#L125

{
    res += String.Format("{0} ", result.ArrayValue[i, j]);
}

how-to-use-excel-add-ins-in-winforms-spreadsheet/CS/SpreadsheetAddIn/Form1.cs#L140

else if (parameter.IsArray)
    return ConvertArrayParameter(parameter.ArrayValue);
else

VB.NET

winforms-spreadsheet-use-formula-engine/VB/FormulaEngineTest/Form1.vb#L113

For j As Integer = 0 To colLength - 1
    res &= String.Format("{0} ", result.ArrayValue(i, j))
Next j

how-to-use-excel-add-ins-in-winforms-spreadsheet/VB/SpreadsheetAddIn/Form1.vb#L153

ElseIf parameter.IsArray Then
    Return ConvertArrayParameter(parameter.ArrayValue)
Else