cancel
Showing results for 
Search instead for 
Did you mean: 

How to capture and iterate response values to a excel in Soapui open source

1 REPLY 1
ZDGN
Contributor

Re: How to capture and iterate response values to a excel in Soapui open source

Hi @shaikgayaz 

 

Regarding your groovy script, it seems the cell coordinates never change:

 

Label label = new Label(0, 1, holder.getNodeValue(xPath1));
sheet.addCell(label);

 

May be you should use a variable to manage either the column or row number.

 

As you can see it in the documentation, the label take column and row number as parameters:

Label(int c, int r, java.lang.String cont)
          Creates a cell which, when added to the sheet, will be presented at the specified column and row co-ordinates and will contain the specified text

 

Here is an example:

https://mkyong.com/java/jexcel-api-reading-and-writing-excel-file-in-java/

 

 

Hope this will help.

 

David.

New Here?
Join us and watch the welcome video:
Top Kudoed Authors