Forum Discussion

Adagio's avatar
Adagio
Frequent Contributor
7 years ago
Solved

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
    7 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

As Marsha_R, the driver does that automatically... pseudo code would be something like.

function myTest(testData){
    Log.Message(testData);

}

function runExcelDriver(){
    var driver
    driver = DDT.ExcelDriver('C:\\MyFolder\\MyWorkbook.xls', 'MySheet', true);
    while (!driver.EOF){
        myTest(driver.Value('MyColumn'));
        driver.Next();
    }
    DDT.CloseDriver(driver.Name);

}

Basically, this will go through every row in the indicated spreadsheet and execute the "myTest" function against whatever values I pass into it.  There are probably a number of different ways to achieve the same result but, generally, this demonstrates having a DDT driver loop through a sheet and execute the tests in sequence.

Marsha_R's avatar
Marsha_R
Champion Level 3
7 years ago

If one would actually click on the link I provided, one would see an actual Javascript sample already there.  :)

  • Adagio's avatar
    Adagio
    Frequent Contributor
    7 years ago

    Thanks Marsha! I did, but I ended up using the COM object which works pretty well.

     

    I have another confusion regarding this COM object. While printing the values that the object is reading, I see that It prints 'objectCOMobject' rather than the actual value of that object.

     

    In the snapshot here: 

     

      Log.Message("Row Data: " + i + " " +getUsageCode+ " ; " +getComments+ " ; " +getResonVal+ " ; " +getRefVal);

     

     

     

    Thank you

    Abhi

     

     

     

    • HKosova's avatar
      HKosova
      SmartBear Alumni (Retired)
      7 years ago
      Adagio wrote:

       

      Log.Message("Row Data: " + i + " " +getUsageCode+ " ; " +getComments+ " ; " +getResonVal+ " ; " +getRefVal);

      Hi Abhi,

       

      Are getUsageCode, getComments etc. functions? If so, you need to put () after the function names in order to call them:

      Log.Message("Row Data: " + i + " " +getUsageCode() + " ; " +getComments() + " ; " + getResonVal() + " ; " +getRefVal());

       

      Tip: If you use JavaScript (not JScript), you can use template strings to avoid string concatenation:

      Log.Message( `Row Data: ${i} ${getUsageCode()}; ${getComments()}; ${getResonVal()}; ${getRefVal()}` );
      • Adagio's avatar
        Adagio
        Frequent Contributor
        7 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