buildingmotif.ingresses.xlsx

Classes

XLSXIngress(filename[, limit])

Reads sheets from a XLSX file and exposes them as records.

class XLSXIngress(filename: PathLike, limit: Optional[int] = - 1)

Reads sheets from a XLSX file and exposes them as records. The ‘rtype’ field of each Record gives the name of the sheet.

property records: List[Record]

The set of rows in all sheets in the XLSX file.

Returns:

A Record representing a row in a sheet. The sheetname is stored in the ‘rtype’ field. The ‘fields’ field contains key-value pairs for each row; the keys are the names of the columns and the values are the cell values at that column for the given row.

Return type:

List[Record]