Gets or sets the table name.
NuGet Package: DevExpress.Spreadsheet.Core
When you create tables, default names (Table1, Table1, etc.) are automatically assigned to them. However, you can use the Name property to change a table name and make it more understandable. Note that tables have unique names in the workbook.
Table names and table column names can be used in formulas to refer to the corresponding table data ranges. This allows you to work with table data more easily. For example, the =SUM(Products[Price]) formula calculates the sum of values contained in the Price column (TableColumn.Name = “Price”) of the Products table (Table.Name = “Products”).
Syntax Rules for Names
When creating and modifying table names, follow the rules below.
- Start a name with a letter, the underscore symbol (“_”) or the backslash (“"). The remaining characters in the name can be letters, numbers, periods and underscore symbols. Note that the single letters “C”, “c”, “R”, or “r” cannot be used as names.
- A name cannot be the same as a cell reference (for example, “A1”, “$M$15”, etc.).
- A name cannot contain spaces (use underscore symbols and periods instead).
- A name cannot be an empty string.
- The length of a name cannot exceed 255 characters.
- Names are case-insensitive. For example, you are not allowed to create the Products and PRODUCTS names in one scope.
Related GitHub Examples
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Name property.
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.