Static $tStatic nextGets the number of worksheets in the collection. The number of worksheets in the collection.
Creates a new Worksheet and adds it to the collection.
If the workbook originally had no worksheets, the newly added worksheet will become the selected worksheet of the workbook. This can be changed after more worksheets are added by setting the WindowOptions.selectedWorksheet 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 worksheet (worksheet names are case-insensitively compared).
The Worksheet created with the specified name.
The name to give the new Worksheet.
Clears all worksheets from the collection.
If there are any NamedReference instances in the Workbook.namedReferences collection with a worksheet for a scope, they will be removed from the Workbook.
Determines whether a worksheet with the specified name exists in the collection.
True if a worksheet with the specified name is found; False otherwise.
The name of the worksheet to search for. The name is compared case-insensitively.
Gets the worksheet at the specified index. The worksheet 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 worksheet to get.
Gets the worksheet with the specified name.
Worksheet names are compared case-insensitively.
The worksheet with the specified name.InvalidOperationException A worksheet with the specified name does not exist in the collection.
The name of the worksheet to get.
Removes the worksheet 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 worksheet to remove from the collection.
Removes the specified worksheet 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.
True if the worksheet was successfully removed from the collection; False if the worksheet did not exist in the collection.
The worksheet to remove from the collection.
Static compareStatic compareStatic equalsStatic equalsStatic getStatic getStatic getStatic reference
A collection of worksheets in a workbook.
See