cancel
Showing results for 
Search instead for 
Did you mean: 

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

Highlighted
Contributor

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

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!

6 REPLIES 6
Highlighted
Community Leader

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

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

 


Click "Accept as Solution" if my answer has helped,
Remember to give "Kudos" 🙂 ↓↓↓↓↓



Thanks and Regards,
Himanshu Tayal
Highlighted
Contributor

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

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

Highlighted
Community Leader

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

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

  


Click "Accept as Solution" if my answer has helped,
Remember to give "Kudos" 🙂 ↓↓↓↓↓



Thanks and Regards,
Himanshu Tayal
Highlighted
Community Manager

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

Thank you Himanshu!

@PrathapR  was your question solved? Please share 🙂

 


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
Highlighted
Contributor

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

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

 

Thanks,

Prathap

Highlighted
Community Manager

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

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


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors