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. =0A=
=0AI found the tools here http://www.python-excel.org/,=A0 and http://sourc=
eforge.net/projects/pyexcelerator/. I have been trying to use the former, s=
ince the latter seems to be devoid of documentation (not even any docstring=
s).=0A=0A=0AMy first thought was to copy the template, open the copy, modif=
y it and save the modifications. But it looks like if I open an existing sp=
readsheet it must be read only. So I tried to=A0 open the template, copy it=
 to a new spreadsheet and write the new spreadsheet, but I can't seem to co=
py the images, and it looks like copying the formatting is going to be diff=
icult.=0A=0ACan anyone give me any tips or advice?=0A=0AThanks in advance,=
=0A=0A=A0=A0 -EdK=0A=0AEd Keith=0A=0Ae_d_k@yahoo.com=0A=0A=0A=0ABlog: edkei=
th.blogspot.com=0A=0A=0A      

On Dec 20, 9:56=A0pm, Ed Keith <e_...@yahoo.com> wrote:
> I have a user supplied 'template' Excel spreadsheet. I need to create a n=
ew excel spreadsheet based on the supplied template, with data filled in.
>
> I found the tools herehttp://www.python-excel.org/,=A0andhttp://sourcefor=
ge.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 s=
ave the modifications. But it looks like if I open an existing spreadsheet =
it must be read only. So I tried to=A0 open the template, copy it to a new =
spreadsheet and write the new spreadsheet, but I can't seem to copy the ima=
ges, and it looks like copying the formatting is going to be difficult.
>
> Can anyone give me any tips or advice?
>
> Thanks in advance,
>
> =A0=A0 -EdK
>
> Ed Keith
>
> e_...@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

On Dec 21, 8:56=A0am, Ed Keith <e_...@yahoo.com> wrote:
> I have a user supplied 'template' Excel spreadsheet. I need to create a n=
ew excel spreadsheet based on the supplied template, with data filled in.
>
> I found the tools herehttp://www.python-excel.org/,=A0andhttp://sourcefor=
ge.net/projects/pyexcelerator/. I have been trying to use the former, since=
 the latter seems to be devoid of documentation (not even any docstrings).

pyExcelerator is abandonware. Use xlwt instead; it's a bug-fixed/
maintained/enhanced fork of pyExcelerator

Read the tutorial that you'll find mentioned on http://www.python-excel.org

Join the google group that's also mentioned there; look at past
questions, ask some more, ...