Forum Discussion

PrathapR's avatar
PrathapR
Frequent Contributor
6 years ago

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 ...
Data Source
Multiple Sheets
readyapi
HimanshuTayal's avatar
HimanshuTayal
Community Hero
6 years ago

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's avatar
sonya_m
Icon for Alumni rankAlumni
6 years ago

Thank you Himanshu!

PrathapR  was your question solved? Please share ğŸ™‚

 

  • PrathapR's avatar
    PrathapR
    Frequent Contributor
    6 years ago

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

     

    Thanks,

    Prathap

    • sonya_m's avatar
      sonya_m
      Icon for Alumni rankAlumni
      6 years ago

      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.