Search code examples
pythonmoduleopenxmlxmlreaderxlsx

Python .xlsx (Office OpenXML) reader as simple as csv module?


I know some Python xlsx readers are emerging, but from what I've seen they don't seem nearly as intuitive as the built-in csv module.

What I want is a module that can do something like this:

reader = xlsx.reader(open('/path/to/file'))

for sheet in reader:
    print 'In %s we have the following employees:' % (sheet.name)
    for row in sheet:
        print '%s, %s years old' % (row['Employee'], row['Age'])

Is there such a reader?


Solution

  • xlrd has xlsx handling for basic data extraction, using the same APIs as for xls, in alpha test at the moment. Send me private e-mail if interested.