Forum Discussion
PrathapR
Frequent Contributor
Thanks for response. Yes, I can do that If we have two files or two Data Source steps.
But In my scenario, I have one excel file in that I have multiple sheets, so in one Data Source step can we read multiple sheets from same file(I know we can achieve that by creating two Data Source steps).
Thanks!
HimanshuTayal
4 years agoCommunity Hero
PrathapR :
Yes you can do this, by parameterizing the Sheet Name but i didn't get why you want to read all sheets from single Data Source, could you please explain your usecase.
- sonya_m4 years agoSmartBear Alumni (Retired)
- PrathapR4 years agoFrequent Contributor
- sonya_m4 years agoSmartBear Alumni (Retired)
HimanshuTayal could you explain a bit more about parameterizing the Sheet Name? I think this is what PrathapR might be looking forπ
However, as far as I understand, two Data Source steps is a viable workaround here.