Skip to main content
A newer version of this page is available. .
.NET Framework 4.5.2+
Row

WorksheetCollection Methods

A collection of worksheets in a workbook.
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