kenm: If you open the DataSink, there's an option to "Append to existing file" which will provide the functionality and behavior you are looking for.
Thx for the reply,
I'm afraid that option isn't there for excel data sink. I've had to take an ugly workaround where I've two data sinks to a txt file (one for the headers and one for the content I want from data generator), I think have a data generator using that csv file as an input and then export that to Excel. It's an ugly workaround for something I'd hope would have been available in the product by default?
kenm: You can always write up what you want as a feature request. ReadyAPI Feature Request
Thanks guys,
Unfortunately excel is mandatory for my requirements. I ended up having to workaround leveraging groovy script to output headers to csv, data generator then appending to csv, then in turn use that CSV as a data source which in turn we'll utilize for a second data sink into excel.
A bit of an ugly long winded workaround but hope it helps someone.
