A collection of instances in a workbook.
Inheritance
object
- ICollection<NamedReference>
- IEnumerable<NamedReference>
- IEnumerable
Properties
Section titled "Properties"Count
Section titled "Count"Gets the number of named references in the collection.
public int Count { get; }this[int]
Section titled "this[int]"Gets the named reference at the specified index.
public NamedReference this[int index] { get; }Workbook
Section titled "Workbook"Gets the workbook associated with this collection.
public Workbook Workbook { get; }Methods
Section titled "Methods"Add(string, string)
Section titled "Add(string, string)"Adds a named reference with a scope of the collection's associated to the collection.
public NamedReference Add(string name, string formula)Parameters
- name:
string - formula:
string
Returns any
Add(string, string, CellReferenceMode)
Section titled "Add(string, string, CellReferenceMode)"Adds a named reference with a scope of the collection's associated to the collection.
public NamedReference Add(string name, string formula, CellReferenceMode cellReferenceMode)Parameters
- name:
string - formula:
string - cellReferenceMode:
CellReferenceMode
Returns any
Add(string, string, CellReferenceMode, Worksheet)
Section titled "Add(string, string, CellReferenceMode, Worksheet)"Adds a named reference with a scope of a worksheet to the collection.
public NamedReference Add(string name, string formula, CellReferenceMode cellReferenceMode, Worksheet worksheet)Parameters
- name:
string - formula:
string - cellReferenceMode:
CellReferenceMode - worksheet:
Worksheet
Returns any
Add(string, string, Worksheet)
Section titled "Add(string, string, Worksheet)"Adds a named reference with a scope of a worksheet to the collection.
public NamedReference Add(string name, string formula, Worksheet worksheet)Parameters
- name:
string - formula:
string - worksheet:
Worksheet
Returns any
Clear()
Section titled "Clear()"Clears all named references from the collection.
public void Clear()Returns any
Contains(NamedReference)
Section titled "Contains(NamedReference)"Determines whether a named reference is in the collection.
public bool Contains(NamedReference namedReference)Parameters
- namedReference:
NamedReference
Returns any
Find(string)
Section titled "Find(string)"Finds a named reference in the collection with a scope of the collection's associated .
public NamedReference Find(string name)Parameters
- name:
string
Returns any
Find(string, Worksheet)
Section titled "Find(string, Worksheet)"Finds a named reference in the collection with a scope of the specified worksheet.
public NamedReference Find(string name, Worksheet worksheetScope)Parameters
- name:
string - worksheetScope:
Worksheet
Returns any
FindAll(string)
Section titled "FindAll(string)"Finds all named references in the collection with the specified name.
public NamedReference[] FindAll(string name)Parameters
- name:
string
Returns any
Remove(NamedReference)
Section titled "Remove(NamedReference)"Removes the specified named reference from the collection.
public bool Remove(NamedReference namedReference)Parameters
- namedReference:
NamedReference
Returns any
RemoveAt(int)
Section titled "RemoveAt(int)"Removes the named reference at the specified index in the collection.
public void RemoveAt(int index)Parameters
- index:
int