Static
$tStatic
nextGets the number of sheets in the collection. The number of sheets in the collection.
Creates a new [[Sheet]] and adds it to the collection.
If the workbook originally had no sheets, the newly added sheet will become the selected sheet of the workbook. This can be changed after more sheets are added by setting the [[WindowOptions.selectedSheet]] of the Workbook.
[[ArgumentNullException]] 'name' is null or empty.
[[ArgumentException]] 'name' contains the invalid characters: ':', '', '/', '?', '*', '[', or ']'.
[[ArgumentException]] 'name' exceeds 31 characters in length.
[[ArgumentException]] 'name' is being used as the name of another sheet (sheet names are case-insensitively compared).
The name to give the new Sheet.
An enumeration indicating the type of sheet to create
Determines whether a sheet is in the collection.
The sheet to locate in the collection.
Gets the index of the specified sheet in the collection.
[[Sheet.sheetIndex]]
The sheet of which to get the index.
Gets the sheet at the specified index. The sheet at the specified index.
[[ArgumentOutOfRangeException]] 'index' is less than zero or 'index' is greater than or equal to [[count]].
The zero-based index of the sheet to get.
Gets the sheet with the specified name.
Sheet names are compared case-insensitively.
The sheet with the specified name.[[InvalidOperationException]] A sheet with the specified name does not exist in the collection.
[[Sheet.name]]
The name of the sheet to get.
Removes the sheet at the specified index from the collection.
If there are any [[NamedReference]] instances in the [[Workbook.namedReferences]] collection with the worksheet to remove as their scope, they will be removed from the [[Workbook]].
[[ArgumentOutOfRangeException]] 'index' is less than zero or 'index' is greater than or equal to [[count]].
The index of the sheet to remove from the collection.
Removes the specified sheet from the collection.
If there are any [[NamedReference]] instances in the [[Workbook.namedReferences]] collection with the worksheet to remove as their scope, they will be removed from the [[Workbook]].
The sheet to remove from the collection.
Static
compareStatic
compareStatic
equalsStatic
equalsStatic
getStatic
getStatic
getStatic
referenceStatic
static
A collection of sheets in a workbook.
See