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.

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.

WorksheetCollection

Overview

Properties

Methods

See Also