Excel 2007+ Binary Workbook (xlsb) reader for Python
|PyPI|
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.
.. code:: sh
pip install pyxlsb
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.
.. code:: python
from pyxlsb import open_workbook with open_workbook('Book1.xlsb') as wb: # Do stuff with wb
The Workbook object exposes a get_sheet(idx)
method for retrieving a
Worksheet instance.
.. code:: python
with wb.get_sheet(1) as sheet: # Do stuff with sheet
with wb.get_sheet('Sheet1') as sheet: # Do stuff with sheet
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.
.. code:: python
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.
.. code:: python
from pyxlsb import convert_date print(convert_date(41235.45578))
.. |PyPI| image:: https://img.shields.io/pypi/v/pyxlsb.svg :target: https://pypi.python.org/pypi/pyxlsb