Modifying an existing excel spreadsheet

Jon Clements joncle at googlemail.com
Tue Dec 21 10:37:30 EST 2010


On Dec 20, 9:56 pm, Ed Keith <e_... at yahoo.com> wrote:
> I have a user supplied 'template' Excel spreadsheet. I need to create a new excel spreadsheet based on the supplied template, with data filled in.
>
> I found the tools herehttp://www.python-excel.org/, andhttp://sourceforge.net/projects/pyexcelerator/. I have been trying to use the former, since the latter seems to be devoid of documentation (not even any docstrings).
>
> My first thought was to copy the template, open the copy, modify it and save the modifications. But it looks like if I open an existing spreadsheet it must be read only. So I tried to  open the template, copy it to a new spreadsheet and write the new spreadsheet, but I can't seem to copy the images, and it looks like copying the formatting is going to be difficult.
>
> Can anyone give me any tips or advice?
>
> Thanks in advance,
>
>    -EdK
>
> Ed Keith
>
> e_... at yahoo.com
>
> Blog: edkeith.blogspot.com

Have you tried: http://groups.google.com/group/python-excel
 and searching the archives for "template"? Similar questions have
come up before there.

hth

Jon



More information about the Python-list mailing list