Back to Devexpress

WorksheetCollection Members

officefileapi-devexpress-dot-spreadsheet-dot-worksheetcollection-dot-underscore-members.md

latest4.5 KB
Original Source

WorksheetCollection Members

A collection of worksheets in a workbook.

Properties

NameDescription
ActiveWorksheetGets or sets the currently active worksheet within a workbook.
CountGets the number of elements contained in the ICollection. Inherited from ICollection.
IsSynchronizedGets a value indicating whether access to the ICollection is synchronized (thread safe). Inherited from ICollection.
Item[String]Gets a worksheet by its name.
SyncRootGets an object that can be used to synchronize access to the ICollection. Inherited from ICollection.

Methods

NameDescription
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

WorksheetCollection Interface

DevExpress.Spreadsheet Namespace