How to run an Excel script in Testcomplete ?
Hi, I have an Excel script contains a number of keywords with their parameters values in Excel sheet and I need to run it in Testcomplete, Is it possible to run this test directly from Excel without...
Forum Discussion
Thank you for clarifiying things,
I hope I can find others who can help me, in fact, I have a script Read_Excel that reads from Excel, precises the tests to run and reports the results, (VBScript code), I just need to know how to use it ? is it just adding this script to the Script part in my project ?
And I wrote keywords in a .svb file, these keywords are used in the keyword column in the Excel script. How can I link between my Read_Excel script and these keywords ( stored in functions.svb) ?
rhsou123 wrote:
Thank you for clarifiying things,
I hope I can find others who can help me, in fact, I have a script Read_Excel that reads from Excel, precises the tests to run and reports the results, (VBScript code), I just need to know how to use it ? is it just adding this script to the Script part in my project ?
Yes... with qualifications, of course. If you add that script to TestComplete, assuming it isn't using any native objects of UFT, it should be able to read the excel file and parse out the tests... again, assuming that a) the tests are also added to TestComplete in some way and b) that they don't need additional modification. It would be cool, actually, to see what your Read_Excel script looks like... someone here might be able to help you modify it into something usable in TestComplete
And I wrote keywords in a .svb file, these keywords are used in the keyword column in the Excel script. How can I link between my Read_Excel script and these keywords ( stored in functions.svb) ?
You will need to add the functions.svb file to TestComplete as well... make sure that you then use the appropriate "USEUNIT" reference in your Read_Excel.svb file to add reference to your functions unit.
This is my Read_Excel script, I think it needs to be updated to be executed by Testcomplete(Syntax at least).
How can I add references in my Script Read_Excel.svb to my unit functions.svb ?