pyExcelerator - Can I read and modify an existing Excel-WorkBook?

[rbsharp at gmx.de]

Hello,
I agree that it would be nice to use one package to read and modify an
Excel Sheet. I have only had to do either one or the other, read a
sheet and use the data for something else, or export data to an
Excel-Sheet. Perhaps you might like to look at xlrd:

http://www.lexicon.net/sjmachin/xlrd.htm

It works fines as far as reading Excel is concerned.

Greetings,

Richard Sharp

Gregory Piñero wrote:
> No, by it I meant pyExcelerator :-)
>
> On 7/11/06, Larry Bates <larry.bates at websafe.com> wrote:
> > If by "it" you mean Excel's COM interface, it most certainly will.
> > With COM you call all the same functions/methods that Microsoft
> > calls to open, save, and manipulate the spreadsheet.
> >
> > Here are a few links that might help:
> >
> > http://mathieu.fenniak.net/plotting-in-excel-through-pythoncom/
> > http://www.markcarter.me.uk/computing/python/excel.html
> > http://mathieu.fenniak.net/plotting-in-excel-through-pythoncom/
> >
> > Hope info helps.
> >
> > -Larry
> >
> > Gregory Piñero wrote:
> > > I'm pretty sure it doesn't support reading an existing document.  That
> > > would be useful.
> > >
> > > On 7/11/06, Larry Bates <larry.bates at websafe.com> wrote:
> > >> Marco Aschwanden wrote:
> > >> >
> > >> > Hi
> > >> >
> > >> > I would like to
> > >> >   1. import an existing Excel-sheet (a template)
> > >> >   2. and add some data to it
> > >> >   3. and save it under a different name afterwards.
> > >> >
> > >> > To me it seems, that pyExcelerator does not support the reading for
> > >> > modification of an Excel-sheet. It allows only the "parse_xls" but I
> > >> > would like to keep the "formatting" in the template.
> > >> >
> > >> > Did I miss a "load", "read" or "open" function in pyExcelerator that
> > >> > would hand me back a WorkBook?
> > >> >
> > >> > Greetings,
> > >> > Marco
> > >> >
> > >> >
> > >> If you are on Windows, you may find using COM interface to
> > >> actual Excel application easier.
> > >>
> > >> -Larry Bates
> > >> --
> > >> http://mail.python.org/mailman/listinfo/python-list
> > >>
> > >
> > >
> >
> >
>
>
> --
> Gregory Piñero
> Chief Innovation Officer
> Blended Technologies
> (www.blendedtechnologies.com)