[python-win32] Excel graphs and saving excel workbook .xls
rodperson at rodperson.com
Thu Dec 8 13:30:22 CET 2011
On Thu, 8 Dec 2011 09:34:36 +0200
Rikus de Milander <rickmmmbra at gmail.com> wrote:
> 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 ?
Can't help with the graph as I don't use them, sorry.
But you should be able to use
this does not close excel, at least for me.
Rod Person http://www.rodperson.com rodperson at rodperson.com
"Silence is a fence around wisdom"
More information about the python-win32