Get Sheets in Modern Excel Activities

Feedback Activities
,
1

Can we have Get Sheets activity in Excel Modern Activities. OR Way to access a sheet using index. e.g Excel.Sheet(0) ?

3

@vasanth8891

You can use for each sheet activity…which accesses each in row…and can stop execution if your required sheet is found

Or if there is only one sheet and you want to read it then can use Excel.SelectedSheet

Cheers

1 Like
5

HI,

Unfortunately, there is no GetWorksheets activity in ModernExcel… How about using classic GetWorksheets activity? It also works inside UseExcelFile as the following.

image
image1370×855 38.2 KB

Sample20230317-1L.zip (9.5 KB)

Regards,

6

Hi @vasanth8891 ,

Thank you for sharing this feed, we’re currently tracking on improving the Excel modern experience and I’ve added this insight to it. We’ll let you know here once we have any updates.

Many thanks,
Raluca

1 Like
7

Thanks. Have quick question. Can we use Excel Classic Activities inside Excel Modern containers Excel Scope ? Is it Recommended / Robust / Seamless?

8

Yes, in the meantime you can use a Classic Excel activity within a Modern scope, it shouldn’t have any impact in terms of performance.

1 Like
10

I used Excel.Sheet(Excel.SelectedSheet.Name) and it give me the first Sheet Name.