GrapeCity.Documents.Excel.Expressions.TableItemNode

TableItemNode Class

Represents a table item in the syntax tree.

A table item describes a structured reference to a table, including the table name, the referenced table part, and the source column or column range. Use this class to build or inspect syntax nodes for references such as headers, data, totals, or specific table columns.

Inheritance

object

SyntaxNode

TerminalNode

TableItemNode

Implements

ICloneable

Namespace: GrapeCity.Documents.Excel.Expressions

Assembly: DS.Documents.Excel.dll

Syntax

public class TableItemNode : TerminalNode, ICloneable

Public Class TableItemNode
    Inherits TerminalNode
    Implements ICloneable

Examples

FormulaSyntaxTree syntaxTree = FormulaSyntaxTree.Parse("DeptSales[[#Headers],[#Data],[ComPct]]");
TableItemNode tableItem = (TableItemNode)syntaxTree.Root;
string tableName = tableItem.TableName;
TableItemType itemType = tableItem.ItemType;
string columnName = tableItem.ColumnFrom;

Constructors

Name Description

Name	Description
TableItemNode(string, TableItemType, string)	Creates a new `TableItemNode` that represents a table structured reference for a single column. Use this constructor to specify the table name, the referenced table item type, and the referenced column name for the structured reference.
TableItemNode(string, TableItemType, string, string)	Creates a new TableItemNode from range of columns of a table.

TableItemNode(string, TableItemType, string)

Creates a new TableItemNode that represents a table structured reference for a single column.

Use this constructor to specify the table name, the referenced table item type, and the referenced column name for the structured reference.

TableItemNode(string, TableItemType, string, string)

Creates a new TableItemNode from range of columns of a table.

Properties

Name	Description
ColumnFrom	Gets or sets the start column of the table item. This property returns the first column name in the structured reference represented by this `TableItemNode`. For a single-column table item, it returns that column name. For a column range, it returns the start column of the range.
ColumnTo	Gets or sets the end column of the table column range. For a `TableItemNode` that represents a range of columns, this property returns the last column name in that range. If the node represents a single column reference, this property returns `null`.
ItemType	Gets or sets the referenced part of the table. The returned item type indicates which section of the table this `TableItemNode` represents in a structured reference, such as headers, data, or totals.
TableName	Gets or sets the name of the table. Use this property to retrieve the table name stored in the current TableItemNode.