GrapeCity.Documents.Excel.Expressions.TableItemNode.-ctor

TableItemNode Constructor

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.

Declaration

public TableItemNode(string tableName, TableItemType itemType, string columnName)

Public Sub New(tableName As String, itemType As TableItemType, columnName As String)

Parameters

Type	Name	Description
string	tableName	The name of the table.
TableItemType	itemType	The table item type represented by the structured reference.
string	columnName	The name of the referenced column.

Examples

GrapeCity.Documents.Excel.Expressions.TableItemNode tableItem = new GrapeCity.Documents.Excel.Expressions.TableItemNode("DeptSales", TableItemType.Headers, "Amount");
FormulaSyntaxTree syntaxTree = new FormulaSyntaxTree();
syntaxTree.Root = tableItem;
string formulaText = syntaxTree.ToString();

TableItemNode(string, TableItemType, string, string)

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

Declaration

public TableItemNode(string tableName, TableItemType itemType, string columnFrom, string columnTo)

Public Sub New(tableName As String, itemType As TableItemType, columnFrom As String, columnTo As String)

Parameters

Type	Name	Description
string	tableName	The name of the table.
TableItemType	itemType	The part of the table.
string	columnFrom	The start column.
string	columnTo	The end column.

Examples

GrapeCity.Documents.Excel.Expressions.TableItemNode tableItem = new GrapeCity.Documents.Excel.Expressions.TableItemNode(
    "DeptSales",
    GrapeCity.Documents.Excel.Expressions.TableItemType.Data,
    "Amount",
    "Discount"
);
FormulaSyntaxTree syntaxTree = new FormulaSyntaxTree();
syntaxTree.Root = tableItem;
string formulaText = syntaxTree.ToString();