Did anyone tried Modern Excel activities ? How to get the sheet by index?

Help Activities
, ,
1

I am trying to use modern Excel activities , Previosly we can get the sheet by index using workbook variable (which is mentioned in excel application scope ) like wb.getsheets(0).

But what is the method in Modern activities to achieve it?

2

@Vijay_RPA

I haven’t been able to work this out either. But a work around is using the Excel For Each Sheet activity, there you could add an index.

image

3

Yes @Che , I have seen this already and implemented it by using this only. But my question is we have a simple solution for this. Now it’s become dragging an extra activity in modern. That’s My concern :smiling_face_with_three_hearts :slight_smile:

2 Likes
4

I too have the similar requirement. Have raised a feedback request and kindly give your vote for this below topic.