Forum Discussion

PrathapR's avatar
PrathapR
Frequent Contributor
5 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
PrathapR's avatar
PrathapR
Frequent Contributor

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's avatar
HimanshuTayal
Community Hero
5 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
    SmartBear Alumni (Retired)
    5 years ago

    Thank you Himanshu!

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

     

    • PrathapR's avatar
      PrathapR
      Frequent Contributor
      5 years ago

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

       

      Thanks,

      Prathap

      • sonya_m's avatar
        sonya_m
        SmartBear Alumni (Retired)
        5 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.