Message from discussion
Status of XLRD reading .xlsx (Excel 2007)
Received: by 10.100.141.10 with SMTP id o10mr1623836and.26.1245892574015;
Wed, 24 Jun 2009 18:16:14 -0700 (PDT)
Return-Path: <dan.p.bu...@gmail.com>
Received: from mail-yx0-f198.google.com (mail-yx0-f198.google.com [209.85.210.198])
by gmr-mx.google.com with ESMTP id 16si302137gxk.1.2009.06.24.18.16.13;
Wed, 24 Jun 2009 18:16:13 -0700 (PDT)
Received-SPF: pass (google.com: domain of dan.p.bu...@gmail.com designates 209.85.210.198 as permitted sender) client-ip=209.85.210.198;
Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of dan.p.bu...@gmail.com designates 209.85.210.198 as permitted sender) smtp.mail=dan.p.bu...@gmail.com; dkim=pass (test mode) header...@gmail.com
Received: by mail-yx0-f198.google.com with SMTP id 36so1911093yxe.13
for <python-excel@googlegroups.com>; Wed, 24 Jun 2009 18:16:13 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=gmail.com; s=gamma;
h=domainkey-signature:mime-version:received:in-reply-to:references
:date:message-id:subject:from:to:content-type
:content-transfer-encoding;
bh=Far+3vrAmKGROTmtksOKJftcv1H2K8f71z5XARw/F34=;
b=UTf9zWwiGJFdICQU/A6puENx3VCzmjHzGzqIzUs0JNHdVUYyvOfH65NIHJ6XYBIc9H
4Krvh8NNKklHRNpC+CShUoQvpvtHElaKPoomthDlfkcy7lovx774u7znUkIRGpTXGrfH
tgMW+B7/Ry4EbyLkNONlbC7SALBgx88GU3++M=
DomainKey-Signature: a=rsa-sha1; c=nofws;
d=gmail.com; s=gamma;
h=mime-version:in-reply-to:references:date:message-id:subject:from:to
:content-type:content-transfer-encoding;
b=n9rAHxnJU8KQ0lFOqih8aZCktgQnknCKZHnjv0gpq4gEu9cxDcu5oP8zIxFO9J6qwU
eL2/yLbWrkCTFkSmhcT0hwfO0L2p0ZBbnsLnCPLxtKjqJbPZx0KRXhyO4TdqNiG882Fs
6QhND4vjSWxpSOv27tl55nXGzMOXQ9gkEPyLA=
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Received: by 10.150.152.3 with SMTP id z3mr3602960ybd.112.1245892572915; Wed,
24 Jun 2009 18:16:12 -0700 (PDT)
In-Reply-To: <03b6dd47-3ca6-47a4-b4fe-ac734740c774@33g2000vbe.googlegroups.com>
References: <03b6dd47-3ca6-47a4-b4fe-ac734740c...@33g2000vbe.googlegroups.com>
Date: Thu, 25 Jun 2009 10:46:12 +0930
Message-ID: <b96bcc2f0906241816s46eaabc1m9e35a6161cd61...@mail.gmail.com>
Subject: Re: [pyxl] Status of XLRD reading .xlsx (Excel 2007)
From: Daniel Burke <dan.p.bu...@gmail.com>
To: python-excel@googlegroups.com
xlsx files are zip archives with xml files in them, you can read them
with your favorite DOM parser if you're impatient.
regards,
dan
--
"It's your privilege as an artist to inflict the pain of creativity on
yourself." --Programming Perl 3rd Edition, end of first chapter.
On Thu, Jun 25, 2009 at 6:21 AM, Darryl Wallace<walla...@gmail.com> wrote:
>
> 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. =A0I tried
> to read a simple excel 2007 (under ubuntu linux, python 2.5.4) file
> and was greeted with the following error:
> ---
>>>> book =3D xlrd.open_workbook("myexcel2007book.xlsx")
> Traceback (most recent call last):
> =A0File "<stdin>", line 1, in <module>
> =A0File "xlrd/__init__.py", line 429, in open_workbook
> =A0 =A0biff_version =3D bk.getbof(XL_WORKBOOK_GLOBALS)
> =A0File "xlrd/__init__.py", line 1545, in getbof
> =A0 =A0bof_error('Expected BOF record; found %r' % self.mem[savpos:savpos
> +8])
> =A0File "xlrd/__init__.py", line 1539, in bof_error
> =A0 =A0raise 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. =A0I was just
> interested in the status.
>
> Regards,
> Darryl
>
>
> >
>
|
