Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Tiny python code for parsing data from an Office Open XML Spreadsheet - xlsx
Python
branch: master

This branch is 3 commits ahead, 31 commits behind staale:master

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
xlsx
.gitignore
README.rst
setup.py

README.rst

python-xlsx

A small footprint xslx reader that understands shared strings and can process excel dates.

Usage

book = Workbook('filename or filedescriptor') #Open xlsx file
for sheet in book:
    print sheet.name
    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:

Something went wrong with that request. Please try again.