Forum Discussion

bkrishna213's avatar
bkrishna213
Occasional Contributor
4 years ago
Solved

Exception in Keyword testing with Data Base Table variable

Hello,   I am trying to compare excel data with desktop application. Passing inputs from my local excel. Created variable in project level and assigned related excel cells. Test complete is throwi...
data-driven testing
keyword tests
test run
  • bkrishna213's avatar
    bkrishna213
    4 years ago

    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.

Marsha_R's avatar
Marsha_R
Icon for Champion Level 3 rankChampion Level 3
4 years ago

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.

bkrishna213's avatar
bkrishna213
Occasional Contributor
4 years ago

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 ?