Write data to Excel
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-02-2010
01:59 AM
02-02-2010
01:59 AM
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
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
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-02-2010
05:48 PM
02-02-2010
05:48 PM
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.
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. ⬇️⬇️⬇️
Yuri
TestComplete Customer Care Engineer
Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-02-2010
07:39 PM
02-02-2010
07:39 PM
So this can't be done through a keyword test it needs to be done from a script?
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-02-2010
10:19 PM
02-02-2010
10:19 PM
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.
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. ⬇️⬇️⬇️
Yuri
TestComplete Customer Care Engineer
Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
