Re: Reading OpenOffice spreadsheet in Python?

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> (permalink)
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

Show key headers only | View raw

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.

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Re: Reading OpenOffice spreadsheet in Python? dieter <dieter@handshake.de> - 2014-05-21 08:25 +0200

csiph-web