Forum Discussion

shubhimu's avatar
shubhimu
Contributor
8 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...
groovyguy's avatar
groovyguy
Community Hero
8 years ago

While you cannot do this with a single Data Source, you can use multiple ones and if you set it up right, a Data Source Loop can ensure you are refreshing each one on a new pass. 

sanj's avatar
sanj
Super Contributor
8 years ago

You can do the following to select your appropriate excel sheet:

For each sheet you will need a different data source