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

Groups > comp.lang.python > #71832 > unrolled thread

Re: Reading OpenOffice spreadsheet in Python?

Back to article view | Back to comp.lang.python

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.

Contents

  Re: Reading OpenOffice spreadsheet in Python? Skip Montanaro <skip@pobox.com> - 2014-05-20 17:16 -0500

#71832 — Re: Reading OpenOffice spreadsheet in Python?

On Tue, May 20, 2014 at 11:49 AM, Chris Angelico <rosuav@gmail.com> wrote:
> 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)?

Actually, I'm sympathetic to INI files. I like the simplicity. The
ultimate config files are output in XML though (ugh). Somewhere along
the way, I want to avoid typing repetitive information into files.
Today, I use a template file, read the spreadsheet with xlrd and
generate the XML cruft with Cheetah. I could retain Excel (or Open
Document or pyspread or some other spreadsheet) and then export to CSV
files. That would solve the issue as well. Though it would be an extra
step I'd have to do manually (because I can rely on xlrd), it would
still leave me with the input-to-config-file data in tabular form.

I'll figure something out. Something else that occurs to me as I write
this is that Excel files tend to acquire all sorts of cruft, right? Or
is that just Word files? Perhaps I can make things better by
copying/pasting the existing spreadsheet data into a fresh spreadsheet
that hasn't been updated repeatedly?

Skip

[toc] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web