Read data from excel!

Help IT Automation
1

How to read the data from Excel into a data
table in UiPath

2

You can use read range activity for this

1 Like
3

Hi! Welcome to community!

Use Read rage activity in the properties panel check the add headers and in the output panel create a variable by pressing CTRL+K. Now provide the name as dt_Input

That’s it.

Reference:

ReadRange Fo
ReadRange Fo1244×590 35.1 KB

Regards,
NaNi

2 Likes
4

HI @REITUMETSE_MATHIBELA

Welcome to uipath community

  1. Use Read Range activity → Store it as DtRead

image
image890×249 15.6 KB

  1. Use For each Row in Data Table activity

Here → CurrentRow("your Column Name").ToString it will get the column data one by one inside the loop

image

Regards
Gokul

2 Likes
5

Hi @REITUMETSE_MATHIBELA

Check out this document to create variable

Managing Variables.

6

Than you so much

1 Like