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'] ...