Forum Discussion

Richard_Rianhar's avatar
Richard_Rianhar
New Contributor
17 years ago

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

Sort By
  • omatzura's avatar
    omatzura
    Super Contributor
    17 years ago
    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
  • Richard_Rianhar's avatar
    Richard_Rianhar
    New Contributor
    17 years ago
    Ole,

    Thanks for the reply.

    Do you suggest using jexcel over scriptom?

    Best Regards,
    Chuck
  • omatzura's avatar
    omatzura
    Super Contributor
    17 years ago
    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