How to iterate throw Excel data in a groovy script?

[Taz]

I created a data source with Excel and want to use it in a groovy script.  Using "Get Data" I can get individual properties but it appears to only pick out individual data properties from the last row.  I would like to get the whole sheet as an object, either of rows and columns or a list of objects.  How can this be best achieved?

[nmrao]

If you are using data driven tests, it is possible to iterate the data source records without scripting. Please see the following documentation

https://support.smartbear.com/readyapi/docs/testing/data-driven/concepts.html

https://support.smartbear.com/readyapi/docs/testing/data-driven/index.html

Video here

https://www.youtube.com/watch?v=AFtyMUiD-5s

Here another resource if you wanted only groovy way:

https://www.evoketechnologies.com/data-driven-testing-using-soap-ui-groovy/

[Taz]

Thank you for the reply.  I was aware of the data-driven concepts but they didn´t address the issue of me wanting to use the Excel Data within a groovy script.  From your answer I guess the only way is to use a third party component like SoapUI.  I will look into this.  

[nmrao]

One can use groovy in ReadyAPI. Note that SoapUI is also from Smartbear, but free.

[SarahS]

Hi @Taz,

Understanding that your goal here is to use the entire data set in a script. One approach I can think of would be to read in each row of data and perhaps pass this into an array. The syntax for referencing a row is as follows:
${DataSouceTestStep#DataSourceProperty::RowNumber}

You can use a property/variable as the RowNumber to iterate through the data set.

Documentation for this is here if you want to get more details.
https://support.smartbear.com/readyapi/docs/functional/steps/data-source.html