Forum Discussion

shubhimu's avatar
shubhimu
Contributor
6 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...
shubhimu's avatar
shubhimu
Contributor

Hi,

 

Thanks for the reply. Actually our objective is to design a framework with minimum coding so that non technical person can also understand it easily.

 

Although using POI i am able to achieve my purpose but if we can achieve this with out coding or minimum coding then that would be of great help.

 

Thanks,

Himanshu

groovyguy's avatar
groovyguy
Champion Level 1
6 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
    6 years ago

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

    For each sheet you will need a different data source