Forum Discussion

michelle_cox's avatar
michelle_cox
Occasional Contributor
15 years ago

Write data to Excel

Hi



I am recording my Keyword tests and have set them up to be data driven by an excel spreadsheet. I have successfully been able to use data from the spreadsheet as input values in my tested application. Is it possible for me to retriev data from my tested application and write it back in to the spreadsheet.



I.e I want to take the value of the 'Total' field in my tested app and write it to the 'Actual Total' column in my spreadsheet.



Thanks

3 Replies

Sort By
  • YMinaev's avatar
    YMinaev
    Staff
    15 years ago
    Hi,



    You need to call a script routine which will invoke Excel via COM and write the needed value to the target sheet. An example of such a routine is posted here.
  • michelle_cox's avatar
    michelle_cox
    Occasional Contributor
    15 years ago
    So this can't be done through a keyword test it needs to be done from a script?
  • YMinaev's avatar
    YMinaev
    Staff
    15 years ago
    Hi,



    Yes, this should be done from script. As I said in my previous message, you need to create a script routine and call it from your keyword test.