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.