QTP: Export a single value to an existing excel sheet
I am using an excel datasheet to import variables in my application, which works fine.
What I now want to do is create an extra column in my table called "Passed". Once the details of a particular row have been used and the case has passed, I would like to record a value of Passed in the excel column. The purpose of this is so I never use that data again when I rerun the iteration.
Is there any way for me to export a "passed" status to my existing external excel file? I believe datasheet.export exports the entire sheet but I only want to update one column.