Status of XLRD reading .xlsx (Excel 2007) - python-excel

Message from discussion Status of XLRD reading .xlsx (Excel 2007)

Darryl Wallace

More options Jun 25, 6:51 am

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

Date: Wed, 24 Jun 2009 13:51:51 -0700 (PDT)

Local: Thurs, Jun 25 2009 6:51 am

Subject: Status of XLRD reading .xlsx (Excel 2007)

  Reply to author
  |
  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

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

Reply to author Forward