Path: csiph.com!usenet.pasdenom.info!aioe.org!news.stack.nl!newsfeed.xs4all.nl!newsfeed4a.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path: <python-python-list@m.gmane.org>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.001
X-Spam-Evidence: '*H*': 1.00; '*S*': 0.00; '(at': 0.04; 'subject:Python': 0.06; 'binary': 0.07; 'puts': 0.07; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'thus,': 0.09; '"zipfile"': 0.16; '(complex)': 0.16; 'received:80.91.229.3': 0.16; 'received:dip0.t-ipconnect.de': 0.16; 'received:plane.gmane.org': 0.16; 'received:t-ipconnect.de': 0.16; 'subject:Reading': 0.16; 'versions),': 0.16; 'xlrd': 0.16; 'files.': 0.16; "python's": 0.19; 'unlike': 0.19; 'header:User- Agent:1': 0.23; 'documented': 0.24; 'skip': 0.24; 'least': 0.26; 'world,': 0.26; 'header:X-Complaints-To:1': 0.27; 'xml': 0.29; 'work.': 0.31; 'writes:': 0.31; 'file': 0.32; 'text': 0.33; 'something': 0.35; 'there': 0.35; 'charset:us-ascii': 0.36; 'possible': 0.36; 'subject:?': 0.36; 'to:addr:python-list': 0.38; 'to:addr:python.org': 0.39; 'received:org': 0.40; 'how': 0.40; 'received:217': 0.63; 'zip': 0.64; 'market': 0.66; 'containing': 0.69; 'study': 0.69; 'converters': 0.84
X-Injected-Via-Gmane: http://gmane.org/
To: python-list@python.org
From: dieter <dieter@handshake.de>
Subject: Re: Reading OpenOffice spreadsheet in Python?
Date: Wed, 21 May 2014 08:25:00 +0200
References: <CANc-5UzTNW09cpi3fQr8squszvALgvmDKzkNOZP8GZx9DNOJfg@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Gmane-NNTP-Posting-Host: pd9e09c52.dip0.t-ipconnect.de
User-Agent: Gnus/5.1008 (Gnus v5.10.8) XEmacs/21.4.22 (linux)
Cancel-Lock: sha1:krYt6h70BGONbpLa8jJ91qDzDTE=
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.15
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups: comp.lang.python
Message-ID: <mailman.10178.1400653520.18130.python-list@python.org>
Lines: 24
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1400653520 news.xs4all.nl 2844 [2001:888:2000:d::a6]:49012
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:71839

Skip Montanaro <skip@pobox.com> writes:
> ...
> That then puts me in the market for an xlrd
> replacement. Is there something akin to xlrd for OpenDocument
> spreadsheets?

Unlike the binary "excel" format (at least for early versions),
"OpenDocument" is a well documented
file format (a zip file containing various XML files; processible
by standard XML tools). Thus, you may get at the content
via "zipfile" and Python's "xml" tools.

It might be possible to create an "xlrd" replacement based
on "zipfile" and the "xml" package -- but, of course, one
would need to study the (complex) description for the involved
XML files.

In the "Plone" world, there are text extractors/html converters
for "OpenDocument" which go this route. I do not know how
well they work.