Reading OpenOffice spreadsheet in Python?

Date	2014-05-20 11:38 -0500
Subject	Reading OpenOffice spreadsheet in Python?
From	Skip Montanaro <skip@pobox.com>
Newsgroups	comp.lang.python
Message-ID	<mailman.10158.1400603888.18130.python-list@python.org> (permalink)

Show all headers | 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