WorksheetCollection
Overview
WorksheetCollection is a class in Aspose.Cells FOSS for Java.
Inherits from: Iterable<Worksheet>.
Represents a collection of worksheets in a workbook.
This class provides 9 methods for working with WorksheetCollection objects in Java programs.
Available methods include: add, get, getActiveSheetIndex, getActiveSheetName, getCount, iterator, removeAt, setActiveSheetIndex, setActiveSheetName.
All exported members are accessible to any Java application after installing the Aspose.Cells FOSS for Java package.
Properties: activeSheetIndex, activeSheetName, count.
Description
WorksheetCollection is a class in the Aspose.Cells FOSS library for Java that exposes 12 methods and 3 properties for programmatic use. It extends Iterable<Worksheet>, inheriting shared functionality from its parent type.
Core capabilities include: string; sets the active sheet index; sets the active sheet name. These operations enable developers to integrate worksheetcollection functionality directly into Java applications.
The class also provides the count property (returns the count), the activeSheetIndex property (returns the active sheet index), the activeSheetName property (returns the active sheet name).
Properties
| Name | Type | Access | Description |
|---|---|---|---|
count | int | Read | Returns the count. |
activeSheetIndex | int | Read | Returns the active sheet index. |
activeSheetName | String | Read | Returns the active sheet name. |
Methods
| Signature | Description |
|---|---|
get(index: int) → Worksheet | Returns the requested item. |
get(name: String) → Worksheet | Returns the requested item. |
getCount() → int | Returns the count. |
getActiveSheetIndex() → int | Returns the active sheet index. |
setActiveSheetIndex(value: int) | Sets the active sheet index. |
getActiveSheetName() → String | Returns the active sheet name. |
setActiveSheetName(value: String) | Sets the active sheet name. |
add() → int | Adds a new item to the current collection. |
add(sheetName: String) → int | Adds a new item to the current collection. |
removeAt(sheetName: String) | Removes at. |
removeAt(index: int) | Removes at. |
iterator() → Iterator<Worksheet> | Returns an iterator over the current collection. |
