On Thu, 8 Dec 2011 09:34:36 +0200
Rikus de Milander <rickmmm...@gmail.com> wrote:
> Hey,
> I am currently working on a python script to fetch data from a
> database and populate a excel sheet and draw some graphs. Currently I
> have only been able to generate a scatter graph with chart.ChartType
> = constants.xlXYScatter . Is there a way that one can set the
> position of the graph on the excel sheet or the size of the graph ?
> Is there maybe a option to draw a bar graph or line graph ?
>
> Another problem that I have is when saving the .xls workbook. When I
> use self.workbook.save(filename) [I created a object of type
> workbook] it does save but it also seems to close the application and
> remove it from the memory so then any actions after the save for eg,
> adding a worksheet does not work. Is there maybe a way to save the
> workbook without closing it ?
>
> Regards
> Rikus
Can't help with the graph as I don't use them, sorry.
But you should be able to use
self.workbook.SaveAs(filename)
this does not close excel, at least for me.
--
Rod Person http://www.rodperson.com rodper...@rodperson.com
"Silence is a fence around wisdom"
_______________________________________________
python-win32 mailing list
python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32
