Forum Discussion

Adagio's avatar
Adagio
Frequent Contributor
8 years ago

reading and writing to spreadsheet

Hello,   I've to use a spreadsheet to read the data from. This data would be used to run the Tests. I'm trying to write Javascript code to do that. I'm having some of the difficulties in getting th...
  • Adagio's avatar
    Adagio
    8 years ago

    Hi Helen,

     

    No, these are not functions. These are some variables which hold the values from the spreadsheet.

    I figured out the issue here. It was still being treated as an object and I was trying to read it without using any property.

    Here's what I've used.

     

     

    var getUsageCode = aqObject.GetPropertyValue(readExcel(i, 1, "Sheet1"), "Text")



     

    Thanks for your help!

    Abhi

tristaanogre's avatar
tristaanogre
Esteemed Contributor

What is the code you're using?  Are you accessing Excel directly using Sys.OleObject or are you using a DDT.ExcelDriver?  For what you're trying to do, as explained, you're reading each row in the spreadsheet and, for each row, you run the test.  That's a classic use of the DDT.ExcelDriver.