CellAddress

classin packageklyn.io.xlsx

public class CellAddress extends 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 `klyn 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.

Properties inherited 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.

Methods inherited from Object: fromJson, toDict, toJson, toString, toXml