Showing results for 
Search instead for 
Did you mean: 

TestCase with Excel DataSource - TestCase Ends Prematurely

Occasional Contributor

TestCase with Excel DataSource - TestCase Ends Prematurely

Hi.  I have a great SoapUI NG TestCase written.  It takes data from an Excel spreadsheet via a DataSource step, updates the request and checks the response.  The only problem I have is that not all of the rows of data in the Excel spreadsheet are processed.  For example the current project I am testing has 215 rows of data in the Excel spreadsheet.  I ran my SoapUI NG TestCase and it finished after processing row 142.  I reran it and they all ran.  There are no empty rows in the spreadsheet.  I am not seeing any errors in soapUI NG.  The TestCase is finishing like normal.  To get all of the rows processed I rerun the TestCase.  This is something that is occurring several times a day.  It never stops on the same row.  Why does this happen?  Has anyone else seen this?

Thank you,


Community Manager

Re: TestCase with Excel DataSource - TestCase Ends Prematurely

Hi Angie,


From my understanding, the behavior you describe is strange. I would recommend that you contact our Ready! API Customer Care Team and provide them with your Excel file - they will analyze it and try to reproduce the behavior in their test lab. You can contact them here:


Tanya Gorbunova
SmartBear Community Manager

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️

Re: TestCase with Excel DataSource - TestCase Ends Prematurely

If you are familiar with groovy and jxl, you could try using jxl libraries to achieve this.You get more flexibility of handling data if done that way and none of the rows gets missed.


New Here?
Join us and watch the welcome video:
Script Wanted
Let's start July with new challenges!

Create a script to change request body before sending it to the server for the TechCorner tag!

Scripts created in June:
- A script to generate a request body based on data from Datasource
- A script to go through all response nodes and check the value of the required field
- A Dispatching script to get responses based on the values in Request Body
- A script to add a new tag and assign it to all TestCases in a TestSuite
Top Kudoed Authors