|
Title: Excel DataSink Question - Writing down a column Post by: Richard Rianhard on March 28, 2008, 03:11:42 pm 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. Title: Re: Excel DataSink Question - Writing down a column Post by: omatzura on March 28, 2008, 07:48:16 pm 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 Title: Re: Excel DataSink Question - Writing down a column Post by: Richard Rianhard on March 28, 2008, 09:23:52 pm Ole,
Thanks for the reply. Do you suggest using jexcel over scriptom? Best Regards, Chuck Title: Re: Excel DataSink Question - Writing down a column Post by: omatzura on March 28, 2008, 09:31:27 pm 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 |