pyxlsb
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 pyxlsbUsage
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.
from pyxlsb import open_workbook
with open_workbook('Book1.xlsb') as wb:
# Do stuff with wbThe Workbook object exposes a get_sheet(idx) method for retrieving a Worksheet instance.
# 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 sheetTip: 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.
# 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.
from pyxlsb import convert_date
print(convert_date(41235.45578))
# datetime.datetime(2012, 11, 22, 10, 56, 19)1 maintainer
Metadata
1 maintainer
Release files for pyxlsb 1.0.10
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | |
|---|---|---|---|---|
| pyxlsb-1.0.10.tar.gz | 22.4 kB | Without provenance | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| pyxlsb-1.0.10-py2.py3-none-any.whl | Python 3, Python 2 | none | any | Details |
Total release size: 46.3 kB
Release files / pyxlsb-1.0.10.tar.gz
| Download URL | pyxlsb-1.0.10.tar.gz |
|---|---|
| Size | 22.4 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
8062d1ea8626d3f1980e8b1cfe91a4483747449242ecb61013bc2df85435f685
|
|
BLAKE2b-256 checksum How to use checksums |
3f13eebaeb7a40b062d1c6f7f91d09e73d30a69e33e4baa7cbe4b7658548b1cd
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.6.0 importlib_metadata/4.8.1 pkginfo/1.8.3 requests/2.28.1 requests-toolbelt/0.9.1 tqdm/4.64.0 CPython/3.10.5
|
Release files / pyxlsb-1.0.10-py2.py3-none-any.whl
| Download URL | pyxlsb-1.0.10-py2.py3-none-any.whl |
|---|---|
| Size | 23.8 kB |
| Tags | Python 2 Python 3 |
|
SHA-256 checksum How to use checksums |
87c122a9a622e35ca5e741d2e541201d28af00fb46bec492cfa9586890b120b4
|
|
BLAKE2b-256 checksum How to use checksums |
7e92345823838ae367c59b63e03aef9c331f485370f9df6d049256a61a28f06d
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.6.0 importlib_metadata/4.8.1 pkginfo/1.8.3 requests/2.28.1 requests-toolbelt/0.9.1 tqdm/4.64.0 CPython/3.10.5
|
Security for pyxlsb 1.0.10
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
