How to close Excel window cleanly

Question

Hi,&nbsp;
&nbsp;
I need to close Excel application opened using TestApps["EXCEL"]["Run"] method.
I have tried closing the excel using the TestedApp["Close"]() method but it only closes the Excel window.
The "EXCEL.EXE" process keeps running in the background.
&nbsp;
Could anyone show me how can I close Excel so that the background process also gets terminated just like how it works when we manually close an open Excel window.
&nbsp;
I have used TestedApp["Terminate"](); method but it causes issues in further iterations where I need to wor on Excel.
&nbsp;
&nbsp;
Thanks,
Yusuf Malak

vthomeschoolmom · Answer

If not DDT then ADO might work better.
&nbsp;
https://support.smartbear.com/testcomplete/docs/reference/program-objects/ado/index.html
&nbsp;
Personally, I would not choose to open Excel just to read values from it.&nbsp; DDT has capacities that would allow that, and if sufficient, ADO works great.&nbsp;

shankar_r · Answer

You can use Process.Terminate()
Ex: Sys.Process("EXCEL").Terminate()
&nbsp;
By the way, why you are running Excel using TestedApps?&nbsp; If you are doing this to grab values from excel then I would suggest you use DDT.ExcelDriver() method

shankar_r · Answer

In order to check the formula, you have to retrieve&nbsp;the value from excel validate whether the value is being calculated correctly.
If this statement is true in your case then you can very well use DDT.ExcelDriver() to retrieve&nbsp;the value and verify

yusufm87 · Answer

Hi Shankar,
&nbsp;
Thank you for you solution. But as I mentioned in my message that using ["Terminate"]() causes application to misbehave, I cannot use it under the circumstance.
In our test cases we are verifying various fields in Excel and checking if the formulas work. We are not retrieving any test data from excel.
&nbsp;
&nbsp;
Best Regards,
Yusuf

manfred_f · Answer

hi,
my Excel-closing routine works as follows:
&nbsp;
While Excel Process exists
&nbsp;&nbsp; get visible "XLMAIN" Windows
&nbsp;&nbsp; If #XLMAIN &gt; 0 Then
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set ExcelApp = Xlmainwindow.Window("XLDESK").Window("EXCEL7").NativeObject.Application.Application
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; For Ix = ExcelApp.Workbooks.Count To 1 Step -1
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ' close Workbooks without saving
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If ExcelApp.Workbooks(Ix).Windows(1).Visible Then ExcelApp.Workbooks(Ix).Close False
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Next
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ExcelApp.Quit
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Set ExcelApp = Nothing

&nbsp;&nbsp; End IF
End While

Forum Discussion

How to close Excel window cleanly

Related Content

Script To Automatically Close 'Active' Window

Closing browser windows if Open

Closing Window with Unexpected Window Handler is aborting entire test run

Opening the current active "EDGE" browser window and using that object instead of closing browser

closing chrome using sys.waitbrowser, close and/or terminate

Recent Discussions

Unexpected dialog is not handled by event handler

External table is not in expected format

Video recording of Text Execution

how to run custom scripts after project suite Run is completed

Testing a Citrix application via Citrix Viewer and the IQ module