92 lines
2.4 KiB
Plaintext
92 lines
2.4 KiB
Plaintext
Metadata-Version: 2.1
|
|
Name: pyxlsb
|
|
Version: 1.0.10
|
|
Summary: Excel 2007-2010 Binary Workbook (xlsb) parser
|
|
Home-page: https://github.com/willtrnr/pyxlsb
|
|
Author: William Turner
|
|
Author-email: willtur.will@gmail.com
|
|
License: LGPLv3+
|
|
Platform: UNKNOWN
|
|
Classifier: Development Status :: 5 - Production/Stable
|
|
Classifier: License :: OSI Approved :: GNU Lesser General Public License v3 or later (LGPLv3+)
|
|
Classifier: Programming Language :: Python :: 2
|
|
Classifier: Programming Language :: Python :: 2.7
|
|
Classifier: Programming Language :: Python :: 3
|
|
Classifier: Programming Language :: Python :: 3.5
|
|
Classifier: Programming Language :: Python :: 3.6
|
|
Classifier: Programming Language :: Python :: 3.7
|
|
Classifier: Programming Language :: Python :: 3.8
|
|
Classifier: Programming Language :: Python :: 3.9
|
|
License-File: COPYING
|
|
License-File: COPYING.LESSER
|
|
|
|
pyxlsb
|
|
======
|
|
|
|
|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.
|
|
|
|
Install
|
|
-------
|
|
|
|
.. code:: sh
|
|
|
|
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.
|
|
|
|
.. 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
|
|
|
|
# Using the sheet index (1-based)
|
|
with wb.get_sheet(1) as sheet:
|
|
# Do stuff with sheet
|
|
|
|
# Using the sheet name
|
|
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
|
|
|
|
# You can use .rows(sparse=True) to skip empty rows
|
|
for row in sheet.rows():
|
|
print(row)
|
|
# [Cell(r=0, c=0, v='TEXT'), Cell(r=0, c=1, v=42.1337)]
|
|
|
|
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))
|
|
# datetime.datetime(2012, 11, 22, 10, 56, 19)
|
|
|
|
.. |PyPI| image:: https://img.shields.io/pypi/v/pyxlsb.svg
|
|
:target: https://pypi.python.org/pypi/pyxlsb
|
|
|
|
|