Forum Discussion
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 ?
- Marsha_R3 years agoChampion Level 3I think it will be easier to fix the csv. Can we try one thing? What is the problem with the customer id?
- bkrishna2133 years agoOccasional Contributor
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.
- mattb3 years agoStaff
Worst case scenario we could import a cell as a variable, and use a script to change it to a String. After that, slice the string and add 000 to the prefix.
I think there should be a better way but that's an option 🙂
Related Content
Recent Discussions
- 22 hours agojstaehlin