Max OSX and Excel

John Machin sjmachin at lexicon.net
Tue Aug 29 18:14:13 EDT 2006


Jorge Vargas wrote:
> On 28 Aug 2006 15:50:57 -0700, John Machin <sjmachin at lexicon.net> wrote:
> > Jorge Vargas wrote:
> > > On 8/28/06, Johanna Pfalz <Johanna.Pfalz at telus.net> wrote:
> > > > To be more specific, I'm interested in reading in certain rows and columns
> > > > from an excel spreadsheet directly without converting the information to a
> > > > text file.  I'd also like to be able to write directly to an excel
> > > > spreadsheet from python.
> >
> > AFAIK there is no Python tool that will let you "write directly to" an
> > *existing* xls file -- apart of course from running Excel on Windows
> > via COM.
> >
> > The Pyexcelerator package creates xls files.
> >
> > > ohh I found a nice tool for that a while ago but I haven't been able to test it.
> >
> > Because ....?
> >
> nothing related to it, it's just that I haven't had the time to dive into it.
> > >
> > > http://groups.google.com/group/comp.lang.python.announce/browse_thread/thread/5d0828d7762e3586
> > > http://cheeseshop.python.org/pypi/xlrd
> > > http://www.lexicon.net/sjmachin/xlrd.htm
> >
> > The "rd" in "xlrd" is an abrv8n of "read" -- it doesn't write Excel
> > spreadsheets.
> >
> oh no wonder why with my quick look at the API I didn't saw any write methods :)

Yup. The CheeseShop entry and the homepage say "to extract data from"
right up front -- no false advertising there either :-)

>
> do you have any plans of implementing wirte or at least read/write of xls docs?

pyexcelerator has already implemented "wirte".

What do you mean by "read/write of xls docs"?

Cheers,
John




More information about the Python-list mailing list