Go to Google Groups Home    python-excel
Status of XLRD reading .xlsx (Excel 2007)

Darryl Wallace <walla...@gmail.com>

I know this has been asked in the past, but is support for
reading .xlsx (Excel 2007) format closer to being complete?

The reason I ask is because the included README.html mentions that
support is scheduled for v0.7.1 which is the current version.  I tried
to read a simple excel 2007 (under ubuntu linux, python 2.5.4) file
and was greeted with the following error:
---

>>> book = xlrd.open_workbook("myexcel2007book.xlsx")

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "xlrd/__init__.py", line 429, in open_workbook
    biff_version = bk.getbof(XL_WORKBOOK_GLOBALS)
  File "xlrd/__init__.py", line 1545, in getbof
    bof_error('Expected BOF record; found %r' % self.mem[savpos:savpos
+8])
  File "xlrd/__init__.py", line 1539, in bof_error
    raise XLRDError('Unsupported format, or corrupt file: ' + msg)
xlrd.biffh.XLRDError: Unsupported format, or corrupt file: Expected
BOF record; found 'PK\x03\x04\x14\x00\x06\x00'
---
So my guess is that it's not ready and that's fine.  I was just
interested in the status.

Regards,
Darryl