Contains the user-defined name of an object, range, or reference to another workbook, the location and name of a text file, or the built-in name of a range.
| Attribute | Description |
| Href | When Name is a subelement of the ColumnInfo element, this attribute contains the name of a text file that textual data is imported from. |
Contained In
Axis, Chart, ColumnInfo, ConsolidationReference, ExcelName, ExcelWorksheet, ExternName, Parameter, PivotField, PivotItem, PivotTable, PLPivotField, PLTotal, QueryTable, Series, TextWizardSettings, Trendline, WorksheetOptions
Remarks
The name is a text string.
For a consolidation reference, this element contains the name of the data source range.
For a series in Microsoft Excel, the name contained in the Caption and Name elements are the same. In the Chart component, the names in these elements can be different.
For the Text Import Wizard, this element contains the location and name of a text file.
For a name definition, if a built-in range name is specified, this element contains one of the following string constants that identifies the corresponding range: Consolidate_Area, Auto_Open, Auto_Close, Extract, Database, Criteria, Print_Area, Print_Titles, Recorder, Data_Form, Auto_Activate, Auto_Deactivate, or Sheet_Title.
For a named range of cells, the same name can appear more than once in a workbook; however, the name must be unique to a worksheet. You can use the name of a range of cells as the target of a hyperlink. In the HTML table containing the spreadsheet, the name is specified by the name attribute of an HTML Anchor element that contains the top-left cell of the range.
When the data comes from a PivotList component, the Name element contains the caption of the component and PivotTable report.
For a PivotTable field, field set, or total, the Name element contains a unique, non-empty string based on the caption contained in the PLCaption element. For data fields, the Name element contains the string Data (appearing in the language of the version of Microsoft Excel).
For a PivotTable item, if the PivotItem element represents a member, the Name element contains the caption of the member and the SourceName element contains the unique name. If the PivotItem represents a string filter value, the Name element contains the filter string and the SourceName element is not specified. Otherwise, the Name element contains the caption and the SourceName element contains a text version of the caption. If the value is a date or time, the string is in ISO 8601 format. The SourceName element is not specified if the caption is the same as the content of the Name element.
For all other objects, this element contains the name of the object.
See the examples in the ExcelName, ExcelWorkbook, PivotTable, QueryTable, SupBook, and WebChart element topics.