Forum Discussion

veronica_glynn's avatar
veronica_glynn
Contributor
12 years ago

Setting up Excel driver and using variables

Hi! I am running into some difficulties setting up my new scripts with variables contained in my Excel worksheet. I am converting my Keyword tests into Scripts and need to pass in my values contained ...
Philip_Baird's avatar
Philip_Baird
Community Hero
12 years ago

Hi Veronica


 


From your example, you seem to be iterating through the Drivers recordset but not actually setting anything from the Driver.


 


You will need to use the DDT::CurrentDriver::Value() method to access each field and assign it as appropriate, as such:


 


Sub CurDriverExample


  


  ' Creates a driver


  Call DDT.ExcelDriver("C:\MyFile.xls", "Sheet1")


   


  ' Iterates through records


  While Not DDT.CurrentDriver.EOF()


 


  ' Gets a value from the storage and posts it to the log


  ' Instead of logging, set the value of a Project Variable to be DDT.CurrentDriver.Value(0)

  ' Something like Project.Variables.questionTitle = DDT.CurrentDriver.Value(0)


    Log.Message(DDT.CurrentDriver.Value(0))


    DDT.CurrentDriver.Next()


  WEnd


   


  ' Closes the driver


  DDT.CloseDriver(DDT.CurrentDriver.Name)


  


End Sub


 


Full details of the Excel Driver can be found here




Hope this helps.


 


Regards,


Phil Baird