By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,345 Members | 1,790 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,345 IT Pros & Developers. It's quick & easy.

Excel file read/write?

P: n/a
As far as I know, there is pyXLWriter for writing and xlrd for reading.
Is there such thing so that one can open an Excel file into memory and
read/update any sheet/cell on the fly. One analogy to this is the
ConfigParser module.

Any info would be much appreciated.

Nov 10 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a

Podi wrote:
As far as I know, there is pyXLWriter for writing and xlrd for reading.
Most folk would seem to be using pyExcelerator rather than pyXLWriter.
It is much more up to date, it just hasn't been worked on for a year,
whereas pyXLWriter is obsolete (doesn't write latest Excel file format)
and is deliberately/officially in Norwegian Blue Parrot emulation mode.
Is there such thing so that one can open an Excel file into memory and
read/update any sheet/cell on the fly. One analogy to this is the
ConfigParser module.
There is no pure Python platform-independent facility that requires no
other software to be installed. Your choices are:

1. Python COM interface (part of
http://sourceforge.net/projects/pywin32/) with lots of users (and hence
readily available help in this newsgroup), examples, etc -- but
requires (a) Windows OS (b) Microsoft Excel

2. OpenOffice.org has a built-in Python -- 2.n where n is a small
number :-( and almost impenetrable documentation -- Sybren Stuvel has
published some examples: http://www.stuvel.eu/ooo-python
but my guess is that all the users of the OOo interface could fit in a
taxi.

3. Gnumeric is rumoured to have a similar scripting facility.

Nov 10 '06 #2

P: n/a
Thanks for the reply.
>
Most folk would seem to be using pyExcelerator rather than pyXLWriter.
It is much more up to date, it just hasn't been worked on for a year,
I will give it a shot.
1. Python COM interface (part of
http://sourceforge.net/projects/pywin32/) with lots of users (and hence
readily available help in this newsgroup), examples, etc -- but
requires (a) Windows OS (b) Microsoft Excel
I am not into COM as it is kind of anti-intuitive, at least to me.
>
2. OpenOffice.org has a built-in Python -- 2.n where n is a small
number :-( and almost impenetrable documentation -- Sybren Stuvel has
published some examples: http://www.stuvel.eu/ooo-python
but my guess is that all the users of the OOo interface could fit in a
taxi.
Hmmm..., I have 2.4.2 and would not like to down grade myself.
>
3. Gnumeric is rumoured to have a similar scripting facility.
Well, I would like to stick with the MS crowd, at least for the moment.

Cheers!
P

Nov 10 '06 #3

P: n/a

Podi wrote:
>

2. OpenOffice.org has a built-in Python -- 2.n where n is a small
number :-( and almost impenetrable documentation -- Sybren Stuvel has
published some examples: http://www.stuvel.eu/ooo-python
but my guess is that all the users of the OOo interface could fit in a
taxi.

Hmmm..., I have 2.4.2 and would not like to down grade myself.
It is a separate installation of Python, somewhere in the OOo directory
hierarchy. You would have to "down grade" yourself only when working
with OOo. In any case the documentation and the size of the user base
are showstoppers IMHO.

Cheers,
John

Nov 10 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.