Handling Excel in TestComplete

Question

Dears&nbsp;&nbsp;I m new to&nbsp; test complete and also for Automation , I have below queries&nbsp; Please do needful&nbsp;I have External Workbooks for my script , Under One Book&nbsp; i have a sheet with Column As Test case Name and Flag as Y or N , and in my second sheet&nbsp; i have input parameter for my test cases when i choose yes from my sheet,&nbsp; it will check the parameter from other workbook sheet and run my function,&nbsp; i have scripted the code using Pandas and OpenPyXL Python Lib, but when i run this code using Test Complete , Whole Test complete Crashed . is there any way handle this scenario using Test complete

rraghvani · Answer

I suggest you see&nbsp;Python - Specifics of Usage.&nbsp;The online help shows examples of how to read Excel files and process the data. Which may be useful for what you want to do.

Forum Discussion

Handling Excel in TestComplete

Related Content

Handling Inconsistent popups

Is Excel 2016 compatible with TestComplete 12?

When testing Excel on Windows, sometimes TestComplete hangs before even launching Excel

Excel Compare using TestComplete ( Python Scripting)

how to handle empty field in excel sheet in data driven testing using groovy script

Recent Discussions

RuntimeErrors after upgrading to 15.68.8.7

Access outlook email to click on button inside the email

csv file comparison

Python: I have to close and reopen TestComplete after each run or I get a NoneType error

Different log for each group from execution plan