skip to navigation
skip to content

pyxlsb 1.0.1

Excel 2007-2010 Binary Workbook (xlsb) parser

pyxlsb is an Excel 2007-2010 Binary Workbook (xlsb) parser for Python. The library is currently extremely limited, but functional enough for basic data extraction.

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))
 
File Type Py Version Uploaded on Size
pyxlsb-1.0.1-py2.py3-none-any.whl (md5) Python Wheel py2.py3 2017-09-27 9KB
pyxlsb-1.0.1.tar.gz (md5) Source 2017-09-27 6KB