DataSink overwriting the same line on Excel

[testhrishi]

I have Datasink process overwritting on the same row for my Excel document for the proces which I am getting to loop 5 times using conditional goto.

 In the logs I can see the all 3 steps inside my tests case are getting executed as expected, in which the last step is the datasink where I am writing the captured properties in a excel file.

Wonder what I need to do so that sink will write on new row each time the step gets executed?

[lakshmiarun]

Hi,

Thank you for posting in our forum.

Make sure you check a couple of things listed below:

1. You have the Datasource loop

2. Datasink teststep is above the Datasource loop.

Please take a look at the screenshot below:

https://www.screencast.com/t/AAivn27jZA

Best,

Lakshmi

[testhrishi]

I think DataSink should work without any datasource loop. I am reading anydata from anyhere, so why do I need a data source loop?

[MikeGatward]

If you want to loop then datasource loop is the way to go

Sounds like your method is treating these as single tests hence it will just overwrite. Datasource loop will ensure each row is written separately

and make sure you're excel is not open when to run the tests otherwise nothing will be written

[testhrishi]

The way I read it, Datasource shall be use to read data and Datasink shall be use to write/dump data. If I just need to dump data, datasink shall work but looks like thats not the case for excel.

 Worked fine for notepad

[lakshmiarun]

Hi,

That is how excel works. After looping through a value excel sheet shuts down and opens up only for the next loop. This is tool independent.

Best,

Lakshmi