Skip to main content
Row

SheetCollection Members

A collection of all sheets (worksheets and chart sheets) contained in a workbook.

Properties

Name Description
ActiveSheet Gets or sets the currently active sheet within a workbook.
Count Gets the number of elements contained in the ICollection. Inherited from ICollection.
IsSynchronized Gets a value indicating whether access to the ICollection is synchronized (thread safe). Inherited from ICollection.
Item[String] Provides access to an individual sheet in the collection by its name.
SyncRoot Gets an object that can be used to synchronize access to the ICollection. Inherited from ICollection.

Methods

Name Description
Contains(Sheet) Determines whether the collection contains the specified sheet.
Contains(String) Determines whether the collection contains a sheet under the specified name.
CopyTo(Array, Int32) Copies the elements of the ICollection to an Array, starting at a particular Array index. Inherited from ICollection.
GetEnumerator() Returns an enumerator that iterates through the collection. Inherited from IEnumerable<T>.
IndexOf(Sheet) Returns the index of the specified sheet in the collection.
See Also