How to shut-down Excel from Python

[Elias Alhanatis]

Hello to everybody!

I have created an app which calculates some statistical data.
I use the following function to get Excel to print a page with the data.

Code: ( text )

def Create_Analysis_Page(Name,Job,Phone,Month,Analysin g_Dict,preview=False):
xlApp = Dispatch ("Excel.Application")
xlWb = xlApp.Workbooks.Open ("C:\\Python25\\Misthos.xlsx")
xlSht = xlWb.Worksheets (1)

xlSht.Cells(1,2).Value=str(Name)
xlSht.Cells(2,2).Value=str(Job)
xlSht.Cells(3,2).Value=int(Phone)
xlSht.Cells(5,2).Value=str(Month)

try:
for i in range (9,40):
xlSht.Cells(i,2).Value=Analysing_Dict[i-8][0]
xlSht.Cells(i,3).Value=Analysing_Dict[i-8][1]
xlSht.Cells(i,4).Value=Analysing_Dict[i-8][2]
except:
pass

xlSht.Cells(41,4).Value=Analysing_Dict["Totals"][0]
xlSht.Cells(42,4).Value=Analysing_Dict["Totals"][1]
xlSht.Cells(43,4).Value=Analysing_Dict["Totals"][2]

#Preview or not....
if preview:
xlApp.Visible=1

#Print The Sheet...
xlSht.PrintOut()

xlApp.Workbooks.Close()

xlApp.Quit()



My problem is in the last few lines , because when Excel shuts down , it pops up a "Save Changes" dialog , which is never the case in my app. How can i bypass this?


Thank you in advance!!!

Elias

[ubentook]

xlWb.Close SaveChanges:=False

Hello to everybody!
I have created an app which calculates some statistical data.
I use the following function to get Excel to print a page with the data.
Code: ( text )

def Create_Analysis_Page(Name,Job,Phone,Month,Analysin g_Dict,preview=False):
xlApp = Dispatch ("Excel.Application")
xlWb = xlApp.Workbooks.Open ("C:\\Python25\\Misthos.xlsx")
xlSht = xlWb.Worksheets (1)

xlSht.Cells(1,2).Value=str(Name)
xlSht.Cells(2,2).Value=str(Job)
xlSht.Cells(3,2).Value=int(Phone)
xlSht.Cells(5,2).Value=str(Month)

try:
for i in range (9,40):
xlSht.Cells(i,2).Value=Analysing_Dict[i-8][0]
xlSht.Cells(i,3).Value=Analysing_Dict[i-8][1]
xlSht.Cells(i,4).Value=Analysing_Dict[i-8][2]
except:
pass

xlSht.Cells(41,4).Value=Analysing_Dict["Totals"][0]
xlSht.Cells(42,4).Value=Analysing_Dict["Totals"][1]
xlSht.Cells(43,4).Value=Analysing_Dict["Totals"][2]

#Preview or not....
if preview:
xlApp.Visible=1

#Print The Sheet...
xlSht.PrintOut()

xlApp.Workbooks.Close()

xlApp.Quit()



My problem is in the last few lines , because when Excel shuts down , it pops up a "Save Changes" dialog , which is never the case in my app. How can i bypass this?
Thank you in advance!!!

Elias

[Elias Alhanatis]

Thanks a lot friend!!!!
Short , and to the point!!!!

Elias

[dittytwo]

Hi there

I want the opposite
and i am having a blonde day

i can't save it
Excel.Saved = 1 obviously only works if you have opened the document
however for the life of me today i can't figure out how to save it once i have created it as it pops up a save dialogue box

cheers
D2

[dittytwo]

Hi there

I want the opposite
and i am having a blonde day

i can't save it
Excel.Saved = 1 obviously only works if you have opened the document
however for the life of me today i can't figure out how to save it once i have created it as it pops up a save dialogue box

cheers
D2

total blonde moment
com_objectName.SaveAs(Filename)

oh dear...

D2