Forum Discussion

DCat1223's avatar
DCat1223
Frequent Contributor
10 years ago

Help with an error message when executing a keyword test.

Good afternoon, and thank you for taking the time to read this. I am having trouble with a keyword test. The piece giving me trouble is referencing a value in a spreadsheet in a column called “DCRA...
  • joseph_michaud's avatar
    joseph_michaud
    10 years ago

    The DB provider chooses whether a column is considered as data or text.  Changing the format of the data only changes the  view of the data, not the underlying value. What happens if you write a little test to read the values for a column one at a time and log them?

     

    For more information, check this article Using Excel Files as Data Storages and this Forum article Trouble getting desired excel data

     

cunderw's avatar
cunderw
Community Hero
10 years ago

When using excel make sure ALL cells of your column have the same type/format. This is a common error when working with Excel Sheets. Testcomplete does not recogize different data types/formats in the same column.

  • DCat1223's avatar
    DCat1223
    Frequent Contributor
    10 years ago

    Thanks for the quick reply.  All cells (including the heading) are formatted as Currency.  Just to be sure, I selected the whole column, changed it to Text, then back to Currency.  I also tried formatting to Text and running it.  Still the same error.  Any other thoughts?   

    • cunderw's avatar
      cunderw
      Community Hero
      10 years ago

      You have decline right above the first number, which means you have numbers and text, they should all be text. 

      • DCat1223's avatar
        DCat1223
        Frequent Contributor
        10 years ago

        You are correct, there is text in that first cell.  The cell, however is formatted as Currency.  See the attached screenshot.  Likewise, when I changed the whole column to Text, I still receive the same error message.