Forum Discussion

DCat1223's avatar
DCat1223
Frequent Contributor
9 years ago
Solved

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

     

DCat1223's avatar
DCat1223
Frequent Contributor

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. 

    • DCat1223's avatar
      DCat1223
      Frequent Contributor
      9 years ago

      Another thing I find interesting is the HSA Weekly column header is formatted General, and the rest of the column is Currency, yet when I plug that column into the Code Snippet it returns the "-" in my message box as I would expect.  The Com Transit Month Limit is formatted exactly the same waya as the HSA Weekly column, and that returns the "Decline" as I would expect.  There is just something about the DCRA Annual Amt field I guess. 

      • joseph_michaud's avatar
        joseph_michaud
        Moderator
        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