Forum Discussion

manochandran's avatar
7 years ago

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

  • groovyguy's avatar
    groovyguy
    Champion Level 1

    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.