keyword test data driven loop dropping leading zero

I got around several of those sort of issues by making all my fields in Excel of format Text, even if  the content is a date or an integer or whatever.  

I encountered a similar problem in the past also and found the solution to be the same: force the test data to text so TestComplete will interpret it as a string. But also, my understanding is that setting Excel pages or columns to be of type text still does not guarantee that TestComplete will interpret a cell value as a string. The only way to force this reliably is to precede the value in the cell with a ' (single quote). So Kyle could force the test data to text this way instead of using .csv file if Excel is preferable.

This is deffinetely TestComplete not reading the .xls correctly.



I was able to work around it by changing the file layout to .csv.

I don't see an option to quote responses so here goes...



Marsha - I did try changing the data type to text and there were a couple issues with it.  The first and worst was that the script would then throw an error "type mismatch" and stop execution.  Second being I had to generate the file which was several thousand lines long.  If I used date or num I can drag down to populate vs. typing every value in.





Donald - do you mean prepopulate the cell in excel with the single quote or in the test script?



Tanya - that help artice has good examples for including that in script based tests, anyhwere I can find an example of integrating it into a keyword driven test?