Forum Discussion

shubhimu's avatar
shubhimu
Contributor
7 years ago

Is it possible to read multiple sheets of any workbook using the single datasource in ready api ?

Hi,   In ready api, we have provision to add data source and their we can select data source option from the drop down. Lets say i selected excel as an data source and add my excel sheet. I am able...
HimanshuTayal's avatar
HimanshuTayal
Community Hero
7 years ago

Hi shubhimu

 

You have to specify Worksheet Name and it will be same for 1 Data Source, if you want to get Data from different sheets then you need to add multiple datasource.

 

My suggestion will be write a simple groovy code of around 10 lines to read data from excel sheet.

 

look at the screenshot: