ListObject.Name Property
Gets or sets the name of the ListObject control.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
Property Name As String
string Name { get; set; }
Property Value
Type: System.String
The name of the ListObject control.
Remarks
This name is used solely as a unique identifier for the ListObjects.Item property of the ListObjects collection. This property can only be set through the object model.
By default, each ListObject control name begins with the word "List", followed by a number (no spaces). If an attempt is made to set the Name property to a name already used by another ListObject control, an exception is thrown.
Examples
The following code example creates a ListObject in the current worksheet and then uses the Name property to set the name of the ListObject to "Employees".
This example is for a document-level customization.
Private Sub ListObject_Metadata()
Dim List1 As Microsoft.Office.Tools.Excel.ListObject = _
Me.Controls.AddListObject(Me.Range("A1", "D4"), "Employees")
List1.Name = "Employees"
List1.Tag = "Employee data"
MessageBox.Show("The list name is " + List1.Name.ToString() & _
" and the tag is " & List1.Tag.ToString() + ".")
End Sub
private void ListObject_Metadata()
{
Microsoft.Office.Tools.Excel.ListObject list1 =
this.Controls.AddListObject(this.Range["A1", "D4"], "Employees");
list1.Name = "Employees";
list1.Tag = "Employee data";
MessageBox.Show("The list name is " + list1.Name.ToString() +
" and the tag is " + list1.Tag.ToString() + ".");
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.