How to resolve the error while opening an excel workbook?
I am trying to open an excel workbook using the below lines of code. It throws an error saying, function Test(){ var Excel; Excel = Sys.OleObject("Excel.Application"); Excel.Visible = true; Excel.Workbooks.Open("D:\\test1.xls"); } "Sorry, we couldn't find D:\test1.xls. Is it possible it was moved, renamed or deleted?" I don't know what's wrong with this simple lines of code. I am using TestComplete 12 and have MS Excel 2016 64 bit installed. Is it causing the problem? Please help!
Read and Write in Excel sheets using VBScripts
I am creating a framework using Excel Sheets for a Desktop application. I am new to TestComplete. I have seen the syntax from Help in Testcomplete. But still I am not able to bring up a solution. For example I have 5 testcases to be executed. I have created an excel with 2 sheets namely Sheet1 and Sheet2 with 4 testcases with headings in Sheet1 as TestCases and Status. In sheet2, i have createdTestcase ID,TestCase,Expected Result,Actual Result,Status,Screenshots,Start Time,End Time,Time Taken. In sheet1, if the status column value is 1 then the Testcase will be executed. If it is 0 then it will not be executed. In sheet2, the actual result should be PASS or FAIL. PASS should be in green color and FAIL should be in RED color. And if both the actual and expected are same then PASS should be mentioned in Status column. And how to add screenshot path for the respective Testcase? Also, I would like to know how to fetch the start time and end time and compare both of them and calculate the total time taken. I need a sample code to fetch details from the excel sheet and to write the same results in that excel sheet. I know it is difficult for me at this stage, but I need your help guys. Awaiting for the answers soon. I have attached the excel sheet for reference.
TestComplete 11.0 - Memory Issue
Environment Details: Windows 7, 64 Bit, 8 GB RAM TestComplete 11.0 Project Details: Used NameMapping Approach Defined All object references in one script file as Global Variables. There are 3000+ Variables. Reading and Writing Data from Excels Problem: When i open my project. RAM usage is 320-340 MB When i run any of my test function RAM usage will increase to 450-500 MB If i keep on running test functions RAM usage will increase to 800+ MB This is making my test execution go slow and crashing application under test. Anybody faced this kind of issue ? Why RAM usage will be increasing every time ? Is there any memory leakage ? Why after execution RAM usage is not coming to normal ?
TestComplete data driven loops not working for second row of an xls file
Hi Does anyone know of any simple misktakes that could stop a data-driven loop from and xls file stop working for a web page? My data loop successfully takes the data from the first row of a spreadsheet (to set up new users in a web app), but fails to find the data in the second row. When watching the script on the second iteration I can see that TestComplete goes to the correct field to enter the new username, but nothing happens ans it continues without erroring. Alternatively, does anyone know whoe to debug a data-driven loop to see if I can understand what is happening in the background. Many thanks, Dom.
