python-xlsx
A small footprint xlsx reader that understands shared strings and can process excel dates.
Requirements
No external requirements. Supports Python versions 2.6+ and 3.2+.
Usage
book = Workbook('filename or filedescriptor') #Open xlsx file
for sheet in book:
print sheet.name
# for larger workbooks, use sheet.rowsIter() instead of
# sheet.rows().iteritems()
for row, cells in sheet.rows().iteritems(): # or sheet.cols()
print row # prints row number
for cell in cells:
print cell.id, cell.value, cell.formula
# or you can access the sheets by their name:
some_sheet = book['some sheet name']
...
Alternatives
To my knowledge there are other python alternatives:
Metadata
Release files for py-xlsx 0.4.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| py-xlsx-0.4.1.tar.gz | 7.6 kB | Details |
Release files / py-xlsx-0.4.1.tar.gz
| Download URL | py-xlsx-0.4.1.tar.gz |
|---|---|
| Size | 7.6 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
d8fb5d02b9324b9b6b6cb3304fc9f9d543df18d1b2596c93ebfb26a7ed18ddc4
|
|
BLAKE2b-256 checksum How to use checksums |
fada0dbdb984cbc0f2f8721d3029de6ad64c11207938d835c7f5bf9e293390e0
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |