15 years ago
DataSink Exporting data to Excel on Same Row
Hello all,
I'm running some SOAP tests and would like to export responses from several calls to an excel file via DataSink. I've set some properties that are pulling values from several Responses using Property Transfers. I've also set the File and Out File to the same TestSink.xls file, typed in the name for the Worksheet and set it Start at Cell A2. I ran my test case several times and noticed that instead of breaking to the next line in my excel file each time I run my test it overwrites the contents of the A2 row. On the Testing Data Sinks page it states the following in regards to Excel DataSink functionality:
Seems pretty straightforward so what am I doing wrong?
Please help/advise.
I'm running some SOAP tests and would like to export responses from several calls to an excel file via DataSink. I've set some properties that are pulling values from several Responses using Property Transfers. I've also set the File and Out File to the same TestSink.xls file, typed in the name for the Worksheet and set it Start at Cell A2. I ran my test case several times and noticed that instead of breaking to the next line in my excel file each time I run my test it overwrites the contents of the A2 row. On the Testing Data Sinks page it states the following in regards to Excel DataSink functionality:
Excel – writes the property value to cells in a specified or empty Excel sheet, a new row is started each time the DataSink is run during a single execution of the containing TestCase (see the example in the DataSink Tutorial).
Seems pretty straightforward so what am I doing wrong?
Please help/advise.