Re: Reading OpenOffice spreadsheet in Python?

2014-05-21 Thread dieter
Skip Montanaro s...@pobox.com 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

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

Re: Reading OpenOffice spreadsheet in Python?

2014-05-21 Thread Skip Montanaro
On Wed, May 21, 2014 at 3:53 AM, Rustom Mody rustompm...@gmail.com 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

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

Re: Reading OpenOffice spreadsheet in Python?

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

Re: Reading OpenOffice spreadsheet in Python?

2014-05-20 Thread Martin Manns
On Tue, 20 May 2014 11:38:06 -0500 Skip Montanaro s...@pobox.com 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

Re: Reading OpenOffice spreadsheet in Python?

2014-05-20 Thread Skip Montanaro
On Tue, May 20, 2014 at 2:45 PM, Martin Manns mma...@gmx.net 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?

Re: Reading OpenOffice spreadsheet in Python?

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

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

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