Skip to main content
Row

WorksheetCollection Members

A collection of worksheets in a workbook.

Properties

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.

Methods

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.
See Also