How to get data without knowing EXCEL SHEET NAME

Can I set to load the data of the first sheet unconditionally?
I want to work without knowing the sheet name.

1 Like

@hj2 You can use Get Workbook Sheets Activity


Hey man. You can use the get workbook sheets activity inside an excel scope. This activity will return the list of sheets as a string and you can then pass this information to the read range activity.

I hope this helps :slight_smile:


Hi @hj2 use Get Workbook Sheet and pass index has 0 which will give u first worksheet name.

1 Like

@supermanPunch @bobby @Tushar_Karkera
Thank you :slight_smile:
I solved it.

1 Like

No problem. Happy to help. :grin:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.