WorkbookWorksheets
class in package klyn.io.xlsx

    public class WorkbookWorksheets extends Object implements IList<Worksheet>:

Object
└ WorkbookWorksheets
All Implemented Interfaces: IList

Workbook worksheet collection.

The collection preserves worksheet order and also exposes name-based lookup, which keeps code close to common spreadsheet APIs.

@example ```klyn import klyn.io.xlsx

workbook = Workbook("report.xlsx", WorkbookMode.CREATE) sheet = workbook.addWorksheet("Data") assert workbook.worksheets["Data"] == sheet workbook.close()

Properties

Modifier and Type | Member | Description
--- | --- | ---
public override readonly property | size `size as ULong:` | Number of worksheets.

Properties inherited from Object: type
Properties inherited from IList: size
Constructors

Modifier and Type | Member | Description
--- | --- | ---
public | WorkbookWorksheets `WorkbookWorksheets():` | Creates an empty worksheet collection.

Methods

Modifier and Type | Member | Description
--- | --- | ---
public override | count `count(item as Worksheet) as ULong:` | Counts worksheet references equal to `item`.
public override | join `join(separator as String) as String:` | Joins worksheet names.

Methods inherited from Object: fromJson, toDict, toJson, toString, toXml
Methods inherited from IList: count, join
Operators

Modifier and Type | Member | Description
--- | --- | ---
public override | operator in(item as Worksheet) as Boolean: | Returns true when a worksheet reference exists in this collection.
public | operator[](name as String) as Worksheet: | Returns a worksheet by name.
public override | operator[](index as Int) as Worksheet: | Returns a worksheet by zero-based index.

Operators inherited from IList: operator in(item as T) as Boolean, operator[](index as Int) as T