On Sep 11, 12:59 pm, "Hamilton, William " <[EMAIL PROTECTED]> wrote:
> > From: Chris
>
> > I have a python script that is driving Excel and using the win32com
> > module. However, upon program completion there's still an Excel.exe
> > process running in the background that I must terminate through Task
> > Manager. Reading up on other threads indicate that maybe I still have
> > some Excel objects referenced within my code. Is this why the process
> > doesn't terminate?
>
> > The related (I hope) parts of my code is here.
>
> > x1App = Dispatch("Excel.Application")
> > Book1 = x1App.Workbooks.Open(ExcelLogPath+"\\outputLog-template.xls")
> > x1App.Visible = 1
> > for sheets in Book1.Worksheets:
> > if sheets.Name == file_name:
> > sheetExists = True
> > if sheetExists != True:
> > activeSheet =
> > Book1.Worksheets.Add(After=Book1.Worksheets(1))
> > activeSheet.Name = file_name
> > testNum[file_name] = 0
> > Book1.Worksheets(file_name).Select()
> > Book1.ActiveSheet.Cells(1+(testNum[file_name]*20),1).Value = "Original
> > File Name"
> > Book1.ActiveSheet.Cells(2+(testNum[file_name]*20),1).Value =
> > file_name
> > Book1.ActiveSheet.Pictures().Insert(output).Select()
> > Book1.SaveAs(Filename=path)
> > x1App.ActiveWorkbook.Close(SaveChanges=0)
> > x1App.Quit()
> > del x1App
> > del Book1
> > del activeSheet
>
> > What am I missing?
>
> In my Excel projects, I terminate it with:
>
> xlBook.Close()
> xlApp.Quit()
>
> I haven't had a problem with Excel staying open after the program ends.
>
> (On a tangent, I want to find the person who thought it was a good idea
> to use the same symbol in a font for 1, l, and I and do some unpleasant
> things.)
>
> --
> -Bill Hamilton
That doesn't really fix the problem as I'm pretty sure its identical
code for
x1App.ActiveWorkbook.Close(SaveChanges=0)
I think where my problem lies is within my for each loop where I
search to see if the worksheet with the name already exists
for sheets in Book1.Worksheets:
if sheets.Name == file_name:
sheetExists = True
Since I'm assuming that it creates objects for each of the sheets and
I don't delete them...
--
http://mail.python.org/mailman/listinfo/python-list
