Read data from excel!

[REITUMETSE_MATHIBELA]

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

[Sam_Abraham (Sam Thomas Abraham)]

You can use read range activity for this

[THIRU_NANI (NaNi)]

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:

Regards,
NaNi

[Gokul001 (Gokul Balaji)]

HI @REITUMETSE_MATHIBELA

Welcome to uipath community

1. Use Read Range activity → Store it as DtRead

2. 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

Regards
Gokul

[Gokul001 (Gokul Balaji)]

Hi @REITUMETSE_MATHIBELA

Check out this document to create variable

Managing Variables.

[REITUMETSE_MATHIBELA]

Than you so much