Reading In Excel

Help Studio
1

Goodday Everyone, I would like to ask how you read the data from Excel (with Multiple Sheets) into a data table in UiPath.
And How do you ensure that the data is readable and iterated over in UiPath (I used a MessageBox, but I’m not sure whether that is a way to go)?

2

Hey @givenmnisi6

The activities you should use here will be Read Range, ForEachRow.

Thanks
#nK

3

Hi @givenmnisi6

Checkout this video

You can also also use get workbook sheets activity which will get you the sheets list

Regards
Sudharsan

4

I tried following the second video, i cannot find the For Each activity that they used here.

5

Hello, probably because you are using different legacy compatibility.

try some of these:

image
image477×546 11.4 KB

6

Go to activities panel ->Filter icon ->Show modern

You will get that activity

Regards
Sudharsan

7

Screenshot (33)
I cant seem to find it here

8

Hi @givenmnisi6

Click on show classic

What activity you said you don’t see?

Regards
Sudharsan

9

For each activity that they used in the second video

10

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