Ask a Question

Write data to Excel

michelle_cox
Occasional Contributor

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 3
YMinaev
Staff

RE: Write data to Excel

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.
------
Yuri
TestComplete Customer Care Engineer

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
michelle_cox
Occasional Contributor

RE: Write data to Excel

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

RE: Write data to Excel

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.

------
Yuri
TestComplete Customer Care Engineer

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
cancel
Showing results for 
Search instead for 
Did you mean: