I have data in excel (one row with 10 columns) and am using DataSource step to read the data. However, I would like to read the data and pass it as a request through Groovy script.
Let me know the groovy script to read the data from excel and pass it as a request.
Readying an Excel file from groovy is not a trivial matter. There's a number of resources out there, but I do not recommend this way if you are not proficient in groovy.
Have you considered using a Data Source test step that uses that Excel sheet? That would allow you to easily read the spreadsheet and use the data in requests.