CellAddress
class in package klyn.io.xlsx

    public class CellAddress extends Object:

Object
└ CellAddress

One-based XLSX cell address.

The class parses and renders the common A1 notation used by Excel and by the worksheet API.

Example

    import klyn.io.xlsx

    address = CellAddress("C5")
    assert address.row == 5
    assert address.column == 3

Properties

Modifier and Type | Member | Description
--- | --- | ---
public readonly property | column `column as Int:` | One-based column index.
public readonly property | row `row as Int:` | One-based row index.

Inherited Properties
property Inherited Properties from Object: type
Constructors

Modifier and Type | Member | Description
--- | --- | ---
public | CellAddress `CellAddress(reference as String):` | Parses an A1 cell reference.
public | CellAddress `CellAddress(row as Int, column as Int):` | Creates an address from one-based row and column indexes.

Methods

Modifier and Type | Member | Description
--- | --- | ---
public static | columnIndex `columnIndex(name as String) as Int:` | Converts Excel column letters to a one-based index.
public static | columnName `columnName(column as Int) as String:` | Converts a one-based column index to Excel letters.
public static | parse `parse(reference as String) as CellAddress:` | Parses an A1 cell reference.
public override | toString `toString() as String:` | Renders the address in normalized A1 notation.

Inherited Methods
method Inherited Methods from Object: deepCopy, fromJson, toDict, toJson, toString, toXml