CellWatchCollection

CellWatchCollection class

Represents the collection of cells on this worksheet being watched in the ‘watch window’.

public class CellWatchCollection : CollectionBase<CellWatch>

Constructors

Name Description
CellWatchCollection() The default constructor.

Properties

Name Description
Capacity { get; set; }
Count { get; }
Item { get; } Gets and sets CellWatch by index. (2 indexers)
Item { get; set; }

Methods

Name Description
Add(string) Adds
Add(int, int) Adds CellWatch with row and column.
BinarySearch(CellWatch)
BinarySearch(CellWatch, IComparer<CellWatch>)
BinarySearch(int, int, CellWatch, IComparer<CellWatch>)
Clear()
Contains(CellWatch)
CopyTo(CellWatch[])
CopyTo(CellWatch[], int)
CopyTo(int, CellWatch[], int, int)
Exists(Predicate<CellWatch>)
Find(Predicate<CellWatch>)
FindAll(Predicate<CellWatch>)
FindIndex(Predicate<CellWatch>)
FindIndex(int, Predicate<CellWatch>)
FindIndex(int, int, Predicate<CellWatch>)
FindLast(Predicate<CellWatch>)
FindLastIndex(Predicate<CellWatch>)
FindLastIndex(int, Predicate<CellWatch>)
FindLastIndex(int, int, Predicate<CellWatch>)
GetEnumerator()
IndexOf(CellWatch)
IndexOf(CellWatch, int)
IndexOf(CellWatch, int, int)
LastIndexOf(CellWatch)
LastIndexOf(CellWatch, int)
LastIndexOf(CellWatch, int, int)
RemoveAt(int)

Examples


[C#]

//Instantiating a Workbook object
Workbook workbook = new Workbook();
// Get the first Worksheet.
Worksheet sheet = workbook.Worksheets[0];
// Add Cell Watch Item into the watch window
sheet.CellWatches.Add("B2");

 [Visual Basic]

'Instantiating a Workbook object
Dim workbook As Workbook = New Workbook()
'Get the first Worksheet.
Dim sheet as Worksheet = workbook.Worksheets(0);
'Add Cell Watch Item into the watch window
sheet.CellWatches.Add("B2")

See Also