Forum Discussion

chemisiq's avatar
15 years ago

Groovy - Reading from Excel and write to xml.

Hi all, I'm in the middle of creating the following scenario with groovy and bumped into a problem. I have limited java knowledge and experience but I have never touch groovy before.

The operation I am trying to do is:
1. Read column 1 for an integer (n) value. [Ex: n=3]
2. Create a number of section based on the integer (n) value. [Ex: n=3]
3. Read column 2, 3, 4 and write those text into the section. [Ex: for n=1]
4. Rinse and repeat for the reset of integer (n) value. [Ex: for n=2, n=3]

Thanks a lot for helping.

1 Reply

  • Hi,

    Make use of JExcel API's. For more info visit http://jexcelapi.sourceforge.net/.
    To access the JExcel API's from the soapUI Groovy script you need to add the JExcel related jars to the path <soapUI_Installation_Path> --> bin --> ext directory and restart the soapUI.

    Hope this helps!

    Regards,
    Rohit Shingalapur