Hi,
When you create an excel datasource you are prompted to select a worksheet so I don't think reading multiple worksheets using a single DataSource step is feasible without coding.
But why do you want to do it using a single datasource step anyways?
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
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.
You can do the following to select your appropriate excel sheet:
For each sheet you will need a different data source
