Skip to content
/ py-xlsx Public

Tiny python code for parsing data from an Office Open XML Spreadsheet - xlsx

Notifications You must be signed in to change notification settings

staale/py-xlsx

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

66 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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:

About

Tiny python code for parsing data from an Office Open XML Spreadsheet - xlsx

Resources

Stars

Watchers

Forks

Packages

No packages published

Languages