GrapeCity.Documents.Excel.Expressions.NameNode

NameNode Class

Represents a name node in the syntax tree.

A NameNode stores the short name together with optional worksheet scope information and an optional WorkbookReference for external workbook references. Use this class to represent parsed names such as a workbook-scoped or worksheet-scoped name in a formula expression tree.

Inheritance

object

SyntaxNode

TerminalNode

NameNode

Implements

ICloneable

Namespace: GrapeCity.Documents.Excel.Expressions

Assembly: DS.Documents.Excel.dll

Syntax

public class NameNode : TerminalNode, ICloneable

Public Class NameNode
    Inherits TerminalNode
    Implements ICloneable

Examples

WorkbookReference workbookRef = WorkbookReference.FromName("BuildingSales");
NameNode nameNode = new NameNode("RawData", workbookRef, "JanIn2021", null);
nameNode.LastWorksheetName = "DecIn2021";

Constructors

Name Description

Name	Description
NameNode(string)	Creates a new `NameNode` from the specified `string`. This constructor forwards `null` for the workbook, start worksheet, and end worksheet information.
NameNode(string, WorkbookReference, string, string)	Creates a new NameNode from a range of sheets of the specified workbook.
NameNode(string, string, string)	Creates a new `NameNode` from a range of sheets. This constructor forwards `null` as the workbook reference to NameNode(string, WorkbookReference, string, string).

NameNode(string)

Creates a new NameNode from the specified string.

This constructor forwards null for the workbook, start worksheet, and end worksheet information.

NameNode(string, WorkbookReference, string, string)

Creates a new NameNode from a range of sheets of the specified workbook.

NameNode(string, string, string)

Creates a new NameNode from a range of sheets.

This constructor forwards null as the workbook reference to NameNode(string, WorkbookReference, string, string).

Properties

Name	Description
LastWorksheetName	Gets or sets the name of the last worksheet in the range. This property stores the ending worksheet name when this NameNode represents a name scoped to a range of worksheets.
Name	Gets or sets the short name.
Workbook	Gets or sets the external workbook reference. This property stores the WorkbookReference associated with this `NameNode` when the name is qualified by an external workbook.
WorksheetName	Gets or sets the worksheet of the name. This property stores the starting worksheet name for a worksheet-scoped or 3D name.