xlsx-reader

Python3 library optimised for reading very large Excel XLSX files, including those with hundreds of columns as well as rows.

Simple example

from xlsxr import Workbook

workbook = Workbook(filename="myworkbook.xlsx", convert_values=True)

for sheet in workbook.sheets:
    print("Sheet ", sheet.name)
    for row in sheet.rows:
        print(row)

Conversions

By default, everything is a string, and all dates and datetimes will appear in ISO 8601 format (YYYY-mm-dd or YYYY-mm-ddTHH:MM:SS). If you supply the option convert_values to the Worksheet constructor, the library will convert numbers to ints or floats, and dates to datetime.datetime or datetime.date objects. There is no attempt to handle standalone times.

Empty cells appear as the empty string ''.

xlsxr.workbook.Workbook class

Constructor

The xlsxr.Workbook class constructor takes the following keyword arguments:

You may specify only one of filename, stream, or url.

Properties

xlsxr.sheet.Sheet class

Properties

Property | Description workbook | The parent Workbook objet name | The name of the sheet sheet_id | The internal identifier of the sheet state | The state of the sheet (normally 'visible' or 'hidden') relation_id | ?? cols | A list of metadata for each column. rows | A list of the data rows in the sheet (parsed on demand). merges | A list of merges in the sheet (parsed on demand).

Each row is a list of scalar values. The will all be strings or None unless you specified the convert_values option for the Workbook.

Merges appear as strings defining ranges, e.g. "A1:C3".

Columns

Columns are represented as dict objects with the following properties:

xlsxr.style.Style class

Properties

License

This is free and unencumbered software released into the public domain. See UNLICENSE.md for details.