Forum Discussion
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.
- Manfred_F6 years agoRegular Contributor
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
Related Content
- 7 years agotechgirlbb
Recent Discussions
- 18 minutes agoSvetaG