WorkbookBase.Names Property
Gets a Microsoft.Office.Interop.Excel.Names collection that represents all the names in the workbook (including all worksheet-specific names).
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
Public ReadOnly Property Names As Names
Get
public Names Names { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.Names
A Microsoft.Office.Interop.Excel.Names collection that represents all the names in the workbook (including all worksheet-specific names).
Examples
The following code example uses the Names property to create three Microsoft.Office.Interop.Excel.Name objects that refer to different ranges on worksheet Sheet1. The example then iterates through every Microsoft.Office.Interop.Excel.Name in the workbook and displays the names in column A of worksheet Sheet1.
This example is for a document-level customization.
Private Sub DisplayWorkbookNames()
Me.Names.Add("Name1", Globals.Sheet1.Range("B1", "B5"), _
True)
Me.Names.Add("Name2", Globals.Sheet1.Range("C1", "C5"), _
True)
Me.Names.Add("Name3", Globals.Sheet1.Range("D1", "D5"), _
True)
Dim i As Integer
For i = 1 To Me.Names.Count
Globals.Sheet1.Range("A" & i.ToString()).Value2 = _
Me.Names.Item(i)
Next i
End Sub
private void DisplayWorkbookNames()
{
this.Names.Add("Name1", Globals.Sheet1.Range["B1", "B5"], true, missing,
missing, missing, missing, missing, missing, missing, missing);
this.Names.Add("Name2", Globals.Sheet1.Range["C1", "C5"], true, missing,
missing, missing, missing, missing, missing, missing, missing);
this.Names.Add("Name3", Globals.Sheet1.Range["D1", "D5"], true, missing,
missing, missing, missing, missing, missing, missing, missing);
for (int i = 1; i <= this.Names.Count; i++)
{
Globals.Sheet1.Range["A" + i.ToString(), missing].Value2 =
this.Names.Item(i, missing, missing);
}
}
.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.