Skip to main content
Join the official 2019 Python Developers SurveyStart the survey!

Tiny python code for parsing data from Microsoft's Office Open XML Spreadsheet format

Project description

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:

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for py-xlsx, version 0.4.1
Filename, size File type Python version Upload date Hashes
Filename, size py-xlsx-0.4.1.tar.gz (7.6 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page