Write data to Excel

[michelle_cox]

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

[YMinaev]

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]

So this can't be done through a keyword test it needs to be done from a script?

[YMinaev]

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.