WorksheetCollection Members

A collection of worksheets in a workbook.

Name	Description
ActiveWorksheet	Gets or sets the currently active worksheet 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]	Gets a worksheet by its name.
SyncRoot	Gets an object that can be used to synchronize access to the ICollection. Inherited from ICollection.

Name	Description
Add()	Creates a new worksheet and appends it to the end of the collection.
Add(String)	Creates a new worksheet under the specified name and appends it to the end of the collection.
Contains(Worksheet)	Determines whether the collection contains the specified worksheet.
Contains(String)	Determines whether the collection contains a worksheet 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(Worksheet)	Returns the zero-based index of the specified worksheet in the collection.
Insert(Int32, String)	Creates a new worksheet under the specified name and appends it to the collection at the specified position.
Insert(Int32)	Creates a new worksheet and appends it to the collection at the specified position.
Remove(Worksheet)	Removes the specified worksheet from the collection.
RemoveAt(Int32)	Removes the worksheet at the specified position from the collection.

Properties