Table.Name Property

Gets or sets the table name.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

• C#
• VB.NET

string Name { get; set; }

Property Name As String

Property Value

A String value that specifies the name of the table.

|

Remarks

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.

Note

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.

• C#
• VB.NET

spreadsheet-document-api-use-worksheet-table-as-data-source/CS/SpreadsheetDocumentServerAsDataSourceExample/Form1.cs#L29

options.DataSourceColumnTypeDetector = new MyColumnDetector();
string dsName = wb.Worksheets[0].Tables[0].Name;

spreadsheet-document-api-use-worksheet-table-as-data-source/VB/SpreadsheetDocumentServerAsDataSourceExample/Form1.vb#L23

options.DataSourceColumnTypeDetector = New MyColumnDetector()
Dim dsName As String = wb.Worksheets(0).Tables(0).Name

See Also

Spreadsheet Tables

Table Interface

Table Members

DevExpress.Spreadsheet Namespace