How to load properties from different sheets (Same Excel File) in Data Source step

[PrathapR]

Hi All,

I'm trying to load properties from different sheets(Same File)  in data source step but it's automatically changing sheet name for all properties, when we change for one. 

Is that as designed or do we have any other way to do that?

Thanks!

[HimanshuTayal]

@PrathapR :

Could you please elaborate more your use case, as what i have understand is you want to fetch data from 2 Excel sheet in same WorkBook.

If it is your scenario then to fetch data from different sheets, you need to add different DataSource Step because each DataSource represents 1 DataSheet, so for fetching data from multiple sheets, you need to add multiple DataSource Step.

[PrathapR]

@HimanshuTayal 

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]

@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_m]

Thank you Himanshu!

@PrathapR  was your question solved? Please share 🙂

[PrathapR]

No @sonya_m , it didn't resolve, I'm using 2 data source steps.

Thanks,

Prathap

[sonya_m]

@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.