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

Gregory Piñero gregpinero at gmail.com
Tue Jul 11 14:27:41 EDT 2006


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)



More information about the Python-list mailing list