Forum Discussion
It would help if we could see the code you are attempting to execute. Since you're using Office 2016, now, probably the excel spreadsheets need to be opened using a different driver.
On screen i use Data-driven loop, excel is still open. Pop up dialog with excel is open... etc.
- tristaanogre8 years agoEsteemed Contributor
Close Excel and the pop-up dialog before running your test and try again. IIRC, the Keyword operation version of the Excel DDT loop uses the ACE driver to Excel. In the past, I've had problems with that driver if the excel document is actually open when I try to run the tests.
- David918 years agoFrequent Contributor
Once this is done, and at another Data driven crash it. :/ Same error.
- tristaanogre8 years agoEsteemed Contributor
Are you opening up the same file in another DDT loop? One thing I'm NOT sure of is whether or not DDT driver loops in Keyword tests properly "close" once the loop is done. In Script code, I'd call a DDT.CloseDriver() method after every loop once I'm done with the file. This closes the connection to the file and frees up the driver. In Keyword tests, I can't find an analog to do so which means that it's possible that, within a single Keyword test, you can't use the same file twice. HKosova, do you know if DDT Excel drivers instantiated in a Keyword test using the Data Driven Loop operation "close" the connection when the loop is done?
Related Content
Recent Discussions
- 3 minutes agoMW_Didata
- 12 hours agod_gfleetwood92