Message from discussion
Status of XLRD reading .xlsx (Excel 2007)
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Received: by 10.100.208.16 with SMTP id f16mr431245ang.10.1245876711859; Wed,
24 Jun 2009 13:51:51 -0700 (PDT)
Date: Wed, 24 Jun 2009 13:51:51 -0700 (PDT)
X-IP: 216.185.87.209
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.0.11)
Gecko/2009060309 Ubuntu/9.04 (jaunty) Firefox/3.0.11,gzip(gfe),gzip(gfe)
Message-ID: <03b6dd47-3ca6-47a4-b4fe-ac734740c774@33g2000vbe.googlegroups.com>
Subject: Status of XLRD reading .xlsx (Excel 2007)
From: Darryl Wallace <walla...@gmail.com>
To: python-excel <python-excel@googlegroups.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