Get worksheet in New Version

Help Studio
, ,
1

Hi,

How i get “Get WorkBooks Sheets” in New UiPath Version

Navnit

2

Hi @Navnit_Ghadigaonkar

If you didn’t have this activity in the ACTIVITY Panel?

Enable the the classic option in the filter.

image

Install the Excel activity from the MANAGE packages.

Regards
Gokul

3

Thanks Sir for your guidance

but same activity in need in New version “Modern Design Acitivity”

4

Hi @Navnit_Ghadigaonkar ,

As of now there is no distinct activity to get the sheets in the modern activities, you would’ve to use the classic activity to do so.

Regards,

5

Perhaps consider the next closest equivalent in Modern Excel activities “For each Excel sheet”

image

6

Hi @Navnit_Ghadigaonkar ,

An Alternate method would be to use For Each Excel Sheet activity.
image

In this case as well, we would need to append the values to a list or an array.
image

7

In this case you can try with For Each Excel sheet activity

Here is the docs : https://docs.uipath.com/activities/other/latest/user-guide/for-each-sheet-x

Regards
Gokul