Forum Discussion

Gunjan's avatar
Gunjan
New Contributor
10 years ago

How to Read (Test case) and Write (Test Result) in excel sheet using groovy script in SoapUI

Hi ,

 

I am new in soapUi, I want to generate groovy script which read data from excel sheet and write result in to excel sheet.Here is the sample of my excel sheet.Is this possible in SoapUI? I am not using SopaUI pro.

 

Following is input.xls sheet (Read test data from this excel sheet) 

 

NoThreadsStrategyTest DelayRandomLimit

 

 

Following is output.xls sheet (Write test result into this sheet)

Nominmaxavglastcnttpsbytesbpserrrat

 

 

It would be great if anyone help me!!!

 

Thanks,

Gunjan.

    • You must be posting your queries in SoapUI Open Source forum, not in SoapUI NG forum.
    • Soap UI Pro supports your requirement out-of-box. It is now also available as ReadyAPI platform.
    • You dont have to be dishartened if you are SoapUI Open source User. You can achieve this using groovy script. Refer this  post for details.

    Hope this helps.

     

  • nmrao's avatar
    nmrao
    Champion Level 3
    • You must be posting your queries in SoapUI Open Source forum, not in SoapUI NG forum.
    • Soap UI Pro supports your requirement out-of-box. It is now also available as ReadyAPI platform.
    • You dont have to be dishartened if you are SoapUI Open source User. You can achieve this using groovy script. Refer this  post for details.

    Hope this helps.