How to get data without knowing EXCEL SHEET NAME

Help Studio
, ,
1

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

1 Like
2

@hj2 You can use Get Workbook Sheets Activity

4 Likes
3

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:

2 Likes
4

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

1 Like
6

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

1 Like
7

No problem. Happy to help. :grin:

8

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