Hi,
I found the solution finally. The working solution is passing all fields data type as text to testcomplete.
Will close this thread. Thank you.
Step where entering customer id
Onscreen action for settext. Here CustomerId is the one which I am picking from excel.
Expected is this step need to enter 0000008 in edit field. But once the control comes here exception is thrown.
KeywordTests.Customer_Inquiry_DataLoop.Variables.Cust_inq["CustomerId"]
Excel is having below columns
Over the years I've been using TestComplete, I would run into this problem, and others, using Excel as a data source. I was spending a lot of time trying to compensate for what are just innate properties of Excel itself. When I switched to using .csv files for my data source, my test development got much easier.
Thank you very much for the suggestion. I tried with CSV as input file.
Once i converted my excel to CSV the fields which i formatted are text became normal cells in CSV file. Able to enter in my application but expected result is not different, because of incorrect customer id.
Is there anything i can do with the excel ?
The customer id is 8 digit. If it is starting with 00 or 000 like 00081111 in csv file it is showing as 81111. First 000's are not accepting in CSV.
Which results entering non customer id in the application.
Expectation is my csv should accept 000's in the customer id and same need to input in application.
