Skip to main content

Lotus 1-2-3 Format

Read Lotus 1-2-3 / WK1 spreadsheet rows as flat dictionaries (experimental minimal BIFF parser).

Overview

PropertyValue
Format id123 (aliases wk1, wks)
ClassLotus123Iterable
Extensions.123, .wk1, .wks
ReadYes
WriteNo
Extranone (optional pylotus if installed)
Maturityexperimental

Record shape

One dict per spreadsheet row. When header=True (default) and row 0 contains string labels, those become column keys:

{"name": "alpha", "value": 42}

Parameters

ParameterDefaultDescription
headerTrueUse first-row labels as keys when detected

Loads the workbook into memory. Supports LABEL / INTEGER / NUMBER cells in the minimal WK1 subset.

Usage

from iterable import open_iterable

with open_iterable("sheet.wk1", format="123") as source:
for row in source:
print(row)

See also