Forum Discussion

Taz's avatar
Taz
Contributor
2 years ago

How to iterate throw Excel data in a groovy script?

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 ro...
Assertions
Data-Driven Testing
Function Tests
Scripting
nmrao's avatar
nmrao
Champion Level 3
2 years ago

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's avatar
    Taz
    Contributor
    2 years ago

    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.