Forum Discussion

DCat1223's avatar
DCat1223
Frequent Contributor
9 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
    9 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
9 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
    9 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
      9 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
        9 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.