How to close Excel window cleanly
Hi,
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. ...
Forum Discussion
You can use Process.Terminate()
Ex: Sys.Process("EXCEL").Terminate()
By the way, why you are running Excel using TestedApps? If you are doing this to grab values from excel then I would suggest you use DDT.ExcelDriver() method
Hi Shankar,
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.
Best Regards,
Yusuf
In order to check the formula, you have to retrieve 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 the value and verify
If not DDT then ADO might work better.
https://support.smartbear.com/testcomplete/docs/reference/program-objects/ado/index.html
Personally, I would not choose to open Excel just to read values from it. DDT has capacities that would allow that, and if sufficient, ADO works great.
hi,
my Excel-closing routine works as follows:
While Excel Process exists
get visible "XLMAIN" Windows
If #XLMAIN > 0 Then
Set ExcelApp = Xlmainwindow.Window("XLDESK").Window("EXCEL7").NativeObject.Application.Application
For Ix = ExcelApp.Workbooks.Count To 1 Step -1
' close Workbooks without saving
If ExcelApp.Workbooks(Ix).Windows(1).Visible Then ExcelApp.Workbooks(Ix).Close False
Next
ExcelApp.Quit
Set ExcelApp = Nothing
End IF
End While
