GrapeCity.Documents.Excel.Expressions.ArrayNode.Elements

Elements Property

Elements

Gets or sets the array elements of this node.

The value cannot be null. Supported element types are double, string, bool, and CalcError. Numeric values such as byte, short, int, long, sbyte, ushort, uint, ulong, float, and decimal are accepted, but they are normalized to double if the node is converted to string and parsed again.

Declaration

public object[,] Elements { get; set; }

Public Property Elements As Object(,)

Examples

FormulaSyntaxTree syntaxTree = FormulaSyntaxTree.Parse("OR(A1={1,3,5})");
FunctionNode functionNode = (FunctionNode)syntaxTree.Root;
OperatorNode operatorNode = (OperatorNode)functionNode.Children[0];
ArrayNode arrayNode = (ArrayNode)operatorNode.Children[1];
object[,] elements = arrayNode.Elements;
object firstValue = elements[0, 0];