Forum Discussion
tristaanogre
13 years agoEsteemed Contributor
DB Table type project variables are read-only. You cannot write values to them via the Project.Variables object.
Out of curiousity, what is the purpose of writing values to the same spreadsheet? Are you going to be using those values in a later test or are you using these values in an off-line validation of the results? There may be a different way of achieving the same result.
You can access Excel sheets directly using the Excel.Application object if you need to do so. This will allow you to access the cells in read/write mode. You can find some sample code to do so at http://smartbear.com/support/viewarticle/20878/. Similar code can be adapted to loop through rows in in Excel the same way and then combine the two.
Out of curiousity, what is the purpose of writing values to the same spreadsheet? Are you going to be using those values in a later test or are you using these values in an off-line validation of the results? There may be a different way of achieving the same result.
You can access Excel sheets directly using the Excel.Application object if you need to do so. This will allow you to access the cells in read/write mode. You can find some sample code to do so at http://smartbear.com/support/viewarticle/20878/. Similar code can be adapted to loop through rows in in Excel the same way and then combine the two.
Related Content
Recent Discussions
- 3 days agoMW_Didata