cancel
Showing results for 
Search instead for 
Did you mean: 

Reading Data from Excel using Groovy script

manochandran
Visitor

Reading Data from Excel using Groovy script

Hi Team,

 

      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. 

 

 

Thanks,

Mano

1 REPLY 1
msiadak
Community Hero

Re: Reading Data from Excel using Groovy script

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. 




---

Click the Accept as Solution button if my answer has helped, and remember to give kudos where appropriate too!
New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors