Forum Discussion

duepayer's avatar
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:

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.

2 Replies

  • Can anybody help i am running into the same issue.

    The Datasink is updating to the excel file instead of inserting into a new row

    Thanks in advance
  • Hi,

    since this is a Pro-related question please post this in the soapUI Pro forum board so we can answer there

    Thanks!

    /Ole
    SmartBear Software