Re: Reading OpenOffice spreadsheet in Python?

2014-05-21 Thread Skip Montanaro
On Wed, May 21, 2014 at 3:53 AM, Rustom Mody wrote: > Another possibility: Use google drive/docs spreadsheet capability. > Makes much less mess than libreoffice and will export to standard formats Correct, though it separates my spreadsheet from the Git repository, and means anyone else at work w

Re: Reading OpenOffice spreadsheet in Python?

2014-05-21 Thread Rustom Mody
On Tuesday, May 20, 2014 10:08:06 PM UTC+5:30, Skip Montanaro wrote: > 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 spreadsh

Re: Reading OpenOffice spreadsheet in Python?

2014-05-20 Thread dieter
Skip Montanaro 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

Re: Reading OpenOffice spreadsheet in Python?

2014-05-20 Thread Skip Montanaro
> Are you familiar with emacs' org mode tables? > http://orgmode.org/org.html#Tables No. Thanks for the pointer. S -- https://mail.python.org/mailman/listinfo/python-list

Re: Reading OpenOffice spreadsheet in Python?

2014-05-20 Thread Rustom Mody
On Tuesday, May 20, 2014 10:08:06 PM UTC+5:30, Skip Montanaro wrote: > 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 spreadsh

Re: Reading OpenOffice spreadsheet in Python?

2014-05-20 Thread Skip Montanaro
On Tue, May 20, 2014 at 11:49 AM, Chris Angelico 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-

Re: Reading OpenOffice spreadsheet in Python?

2014-05-20 Thread Skip Montanaro
On Tue, May 20, 2014 at 2:45 PM, Martin Manns wrote: >> 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 > > Could you please give some examples, what basic Excel capabilities you > are missing? That's

Re: Reading OpenOffice spreadsheet in Python?

2014-05-20 Thread Martin Manns
On Tue, 20 May 2014 11:38:06 -0500 Skip Montanaro wrote: > 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 Could you please give some examples, what basic Excel capabilities you are missing? > I'm op

Re: Reading OpenOffice spreadsheet in Python?

2014-05-20 Thread Chris Angelico
On Wed, May 21, 2014 at 2:38 AM, Skip Montanaro 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

Reading OpenOffice spreadsheet in Python?

2014-05-20 Thread Skip Montanaro
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 sup