axasmgaxa
5 years agoOccasional Contributor
Is it possible to get Data Sink to write output to excel file horizontally and not vertically?
Hi Folks,
I have soap test that is looping through a few iterations, each time, it writes output via a datasink to an excel file.
The problem is, I would like the data to be written out to cells in a horizontal fashion, (e.g. cells A1, B1, C1) and not in a vertical fashion (e.g. A1, A2, A3) as seems to be default.
Many thank in advance for any help,
Steven.
Thanks to everyone who has responded.
I don't think it is possible via datasink. (it certainly maybe possible through Groovy, but I am not very proficient with that as of yet.)
As a work around, I reshuffled the excel sheet so it will expect the response in vertically.