NameCollection
Manages a collection of defined names within a workbook or worksheet scope, providing add, remove, and lookup operations.
Definition
Namespace:Telerik.Windows.Documents.Spreadsheet.Model
Assembly:Telerik.Windows.Documents.Spreadsheet.dll
Syntax:
public class NameCollection : IEnumerable<ISpreadsheetName>, IEnumerableInheritance: objectNameCollection
Implements:
Methods
Adds a new defined name with the specified formula reference at the given cell index.
Adds a new defined name with the specified formula reference at the given cell location.
public ISpreadsheetName Add(string name, string refersTo, int rowIndex, int columnIndex, string comment = null, bool isVisible = true)The name.
refersTostringThe refers to.
rowIndexintIndex of the row.
columnIndexintIndex of the column.
commentstringThe comment.
isVisibleboolThe is visible.
Returns:Returns a strongly typed enumerator that iterates through the defined names in the collection.
public IEnumerator<ISpreadsheetName> GetEnumerator()A IEnumerator<T> that can be used to iterate through the collection.
Implements:
Removes the defined name matching the specified identifier from the collection.
Attempts to retrieve the defined name matching the specified identifier.
public bool TryGetSpreadsheetName(string name, out ISpreadsheetName spreadsheetName)The name.
spreadsheetNameISpreadsheetNameThe resulting name.
Returns:The value indicating whether the name was successfully found.
Properties
Gets the ISpreadsheetName matching the specified name, using case-insensitive lookup.
public ISpreadsheetName this[string name] { get; }The defined name.