Reading OpenOffice spreadsheet in Python?

Path	csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!feeder4.news.weretis.net!rt.uk.eu.org!newsfeed.xs4all.nl!newsfeed1.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path	<skip.montanaro@gmail.com>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.002
X-Spam-Evidence	'H': 1.00; 'S': 0.00; 'parameters': 0.04; 'subject:Python': 0.06; 'column': 0.07; 'puts': 0.07; 'pypi': 0.07; 'file)': 0.09; 'latter': 0.09; 'window.': 0.09; 'windows': 0.15; 'from:addr:pobox.com': 0.16; 'from:addr:skip': 0.16; 'inability': 0.16; 'modules,': 0.16; 'simplest': 0.16; 'subject:Reading': 0.16; 'throw': 0.16; 'xlrd': 0.16; 'files.': 0.16; 'sender:addr:gmail.com': 0.17; 'properly': 0.19; 'config': 0.24; 'skip': 0.24; 'options': 0.25; 'define': 0.26; 'permission': 0.26; 'excel': 0.26; 'message-id:@mail.gmail.com': 0.30; "i'm": 0.30; '(new': 0.31; 'parameters.': 0.31; 'open': 0.33; 'mac': 0.33; 'basic': 0.35; 'something': 0.35; 'but': 0.35; 'received:google.com': 0.35; 'google': 0.35; 'there': 0.35; 'really': 0.36; 'format.': 0.36; 'subject:?': 0.36; 'so,': 0.37; 'stable': 0.38; 'to:addr:python-list': 0.38; 'issue': 0.38; 'weight': 0.39; 'sure': 0.39; 'to:addr:python.org': 0.39; 'how': 0.40; 'read': 0.60; 'upgrading': 0.60; 'new': 0.61; 'high': 0.63; 'market': 0.66; 'saving': 0.69; 'spreadsheet': 0.84
DKIM-Signature	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:sender:date:message-id:subject:from:to:content-type; bh=H8Lnyl4WmcWhVBdpCzXvrhNIUHkfXxsGy1M+mfZHleg=; b=yjpDMEUTzTqrAgxiOhYxwuBRbsNZiGgP8rGCX8bwXyxSDA+RwOnkCmiyg1R/rMm0tc MyelB7fpspkaY+RUE6roghdbA4YlCCYd35uNGCCE2CGw8x/FRVSpsiR6OegfCrBn/sCJ 7fhBp5POtmgle46OsSc2AiWioKZUl3HElMSn57phJeSXzD23O4p6I1lW8pFecUcLodXN +SyLlJEenF/ayDRohmXc9vgnsA3PKQW5jmdOfVYfANxBVcdQYwxR0YlAcJVbhuPAGTsm gao/dikuigEAkbvEvq4mOqOfkguFvS2iLYg4wgsbwFR4F86ve6J+g0pOPMg6GOHG38Yw 5gVQ==
MIME-Version	1.0
X-Received	by 10.50.122.67 with SMTP id lq3mr6691938igb.8.1400603886507; Tue, 20 May 2014 09:38:06 -0700 (PDT)
Sender	skip.montanaro@gmail.com
Date	Tue, 20 May 2014 11:38:06 -0500
X-Google-Sender-Auth	FgSS7kVQH5jzlrA8xGyonN1mPck
Subject	Reading OpenOffice spreadsheet in Python?
From	Skip Montanaro <skip@pobox.com>
To	Python <python-list@python.org>
Content-Type	text/plain; charset=UTF-8
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.10158.1400603888.18130.python-list@python.org> (permalink)
Lines	28
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1400603888 news.xs4all.nl 2947 [2001:888:2000:d::a6]:33466
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:71812

Show key headers only | View raw

I don't have Windows and since upgrading my Mac to Mavericks I no
longer have Excel of any flavor. I have a few Excel spreadsheets in
which I store parameters from which I generate other config files. I
read those spreadsheets using xlrd.

I am so fed up with LibreOffice's inability to properly support really
basic Excel capabilities, I'm about ready to throw my computer out the
window. So, I'm looking for alternatives. Before someone suggests
config parser/Windows INI files... A spreadsheet format is kinda handy
in this case because I do use a few formulas to define some of the
parameters. Adding a new row (new config file) or column (new
parameter) is a breeze. The simplest solution would seem to be to
submit to LibreOffice's terror and just start saving my spreadsheets
in OpenDocument format. That then puts me in the market for an xlrd
replacement. Is there something akin to xlrd for OpenDocument
spreadsheets? I see a couple possibilities in PyPI (exodf, odfpy), but
none which have a really high weight (suggesting they are "category
killers").

I'm open to other options as well. I see a number of Google
spreadsheet modules, and there is pyspread. The former has the
permission issue (besides, where I work everything goes into Git), and
I'm not sure how full-featured or stable the latter is (but, will
investigate).

Thx,

Skip

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

Thread

Reading OpenOffice spreadsheet in Python? Skip Montanaro <skip@pobox.com> - 2014-05-20 11:38 -0500
  Re: Reading OpenOffice spreadsheet in Python? Martin Manns <mmanns@gmx.net> - 2014-05-20 21:45 +0200
    Re: Reading OpenOffice spreadsheet in Python? Skip Montanaro <skip@pobox.com> - 2014-05-20 17:08 -0500
  Re: Reading OpenOffice spreadsheet in Python? Rustom Mody <rustompmody@gmail.com> - 2014-05-20 18:19 -0700
    Re: Reading OpenOffice spreadsheet in Python? Skip Montanaro <skip@pobox.com> - 2014-05-20 20:33 -0500
  Re: Reading OpenOffice spreadsheet in Python? Rustom Mody <rustompmody@gmail.com> - 2014-05-21 01:53 -0700
    Re: Reading OpenOffice spreadsheet in Python? Skip Montanaro <skip@pobox.com> - 2014-05-21 09:24 -0500

csiph-web