pyxlsb 1.0.1

Install

pip install pyxlsb

Usage

The module exposes an open_workbook(name) method (similar to Xlrd and OpenPyXl) for opening XLSB files. The Workbook object representing the file is returned.

import pyxlsb
wb = pyxlsb.open_workbook('workbook.xlsb')

The Workbook object exposes a get_sheet(idx) method for retrieving a Worksheet instance.

# Using the sheet index (1-based)
sheet = wb.get_sheet(1)

# Using the sheet name
sheet = wb.get_sheet('Sheet1')

Tip: A sheets property containing the sheet names is available on the Workbook instance.

The rows() method will hand out an iterator to read the worksheet rows.

for row in sheet.rows():
  print(row)

Do note that dates will appear as floats. You must use the convert_date(date) method from the pyxlsb module to turn them into datetime instances.

print(pyxlsb.convert_date(41235.45578))