Forum Discussion

surendraverma23's avatar
13 years ago

DataSink Exporting data to Excel on Same Row

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 A1. 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 A1 row.
Could you please help how to write data in new row?
  • I think that you have not correctly written the name of the worksheet in the configuration page of your datasource Excel.
  • Make sure you check the Settings of DataSource options and give the Start Row and End Row values

  • Make sure you check the Settings of DataSource options and give the Start Row and End Row values