Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (pypi.python.org).
Help us improve Python packaging - Donate today!

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:

Release History

Release History

This version
History Node

0.4.1

History Node

0.4

History Node

0.3

History Node

0.2

Download Files

Download Files

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

File Name & Checksum SHA256 Checksum Help Version File Type Upload Date
py-xlsx-0.4.1.tar.gz (7.6 kB) Copy SHA256 Checksum SHA256 Source Jun 8, 2014

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting