Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #71814

Re: Reading OpenOffice spreadsheet in Python?

Show key headers only | View raw

On Wed, May 21, 2014 at 2:38 AM, Skip Montanaro <skip@pobox.com> wrote:
> 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.

Okay, I won't suggest Windows INI files, but I'll still suggest taking
a step back and figuring out exactly what you're trying to accomplish.
Can you separate out the real data from the formula-derived info, put
the former into a git-managed file, and the latter into something you
regenerate by script (maybe off a makefile)? Organize your source file
in such a way that adding a new config file or new parameter is easy.
The beauty of a spreadsheet is that a cell could be *either* a formula
*or* actual data, completely indistinguishably (note, some may argue
that this is also a major weakness of spreadsheets); I would guess you
most likely don't need that flexibility, and can easily separate
"source" and "calculated". You could make your file format CSV or tab
delimited, and then use LibreOffice to edit it, if that makes the most
sense.

Something to consider, since I can't specifically advise on OO/LO
readers/writers. :)

ChrisA

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

Thread

Re: Reading OpenOffice spreadsheet in Python? Chris Angelico <rosuav@gmail.com> - 2014-05-21 02:49 +1000

csiph-web