Skip to main content

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)

Source distribution for py-xlsx 0.4.1
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

Release history Release notifications | RSS feed

This release

0.4.1 This release

1 release file

0.4

1 release file

0.3

1 release file

0.2

1 release file

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page