Reading Data From Excel sheet

google "groovy read exel file" will give you entry point.

Another idea, Wy are you using Excel file ? Try OpenOffice or CSV file.

PHL.

Thank you for replying !

I am using excel sheet which has Large number of test data for me.
That's why I am using the the excel sheet.

But as you suggested I will also try to fetch that data from CSV.
But my priority will be Excel sheet only.

I also have to put the result in Excel sheet.

I know that there is a commercial product : a java library that allows you to read and write excel file. You can add it in soapui and use it.

The entry point is http://www.teamdev.com/jexcel/index.jsf.

PHL.

Thanks for suggestion

that's a nice stuff
I would really use it.

but as of now I don't want to go for any commercial product. that is why I am asking for a midway solution.

I have read that there is a groovy script for fetching data from excel.
I have tried also. But it still not working.