Tiny python code for parsing data from Microsoft's Office Open XML Spreadsheet format
A small footprint xlsx reader that understands shared strings and can process excel dates.
No external requirements. Supports Python versions 2.6+ and 3.2+.
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'] ...
To my knowledge there are other python alternatives:
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
py-xlsx-0.4.1.tar.gz (7.6 kB view hashes)