cancel
Showing results for 
Search instead for 
Did you mean: 

Excel DataSink Question - Writing down a column

Highlighted
New Contributor

Excel DataSink Question - Writing down a column

What would be the proper way to write out data to an Excel spreadsheet down a column instead of across the row? Example: Say you have two values to write out one goes in C2 and the other goes in C3.

Thanks.
3 REPLIES 3
Super Contributor

Re: Excel DataSink Question - Writing down a column

Hi,

hmm.. I can't think of any good way to do this with the DataSink, you would just have to create a groovy script that does all the excel-creation by itself (using the included jexcel library; http://jexcelapi.sourceforge.net/)

regards,

/Ole
eviware.com
Highlighted
New Contributor

Re: Excel DataSink Question - Writing down a column

Ole,

Thanks for the reply.

Do you suggest using jexcel over scriptom?

Best Regards,
Chuck
Highlighted
Super Contributor

Re: Excel DataSink Question - Writing down a column

Hi,

hmm.. I haven't used scriptom for this purpose, but it is probably better at accessing excel files than the jexcel api (would be strange otherwise).. If you don't need to run your tests on non-windows machines and always will have excel installed togehter with soapUI then it would probably be a better choice.

Good Luck!

regards,

/Ole
eviware.com
New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors