Forum Discussion

satya_addepalli's avatar
2 years ago

Data Driven Test using Excel


I am using a SOAP request with a wsdl.  The data for the XML request is on an excel file. The data is split into 2 sheets.

"Sheet1" has all the authentication data (User ID, Correlation ID etc)  that is sent Soap Header.

"Sheet2" has  the actual data that should be sent to Soap Body.


How would i parameterize and use the data which is on 2 sheets of a same excel sheet in Ready API.

I am seeing  the error below,



Thanks in advance. 


1 Reply

  • when you go through the setup of the Data source, im pretty sure there is a part which asks you the worksheet that you are wanting to use