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

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

propertyInherited 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

methodInherited Methods from Object: deepCopy, fromJson, hash, toDict, toJson, toMap, toString, toXml