Can anyone help me to pass data from Excel by column wise

Help
1

Hi,

Can anyone help me to pass data from Excel by column wise.

Excel file data

Column 1 Value : User Name
Column 2 Value : Password
In my Excel having 10 users with userrnames & passwords.

Capture123
Capture1231013×113 5.14 KB

I need my Workflow to be like below:

Read First user in Excel
Open Chrome > My Application (Login Page)
Type Username (1st column value) in username field
Type Password (2nd column value) in password field
Click Login Button
Download Report.
Logout.
Again Read Second user in Excel.
Type Username (1st column value) in username field
Type Password (2nd column value) in password field
Click Login Button
Download Report.
Logout.
Close chrome

Please suggest me ideas to do.

Thanks in Advance!

2
  1. Open Chrome
  2. Read Excel data in a DataTable
  3. Loop in the DataTable and perform all the actions from ‘Type Username’ until ‘Logout’ in this loop.
  4. Close and kill Chrome

You can find many examples on how to loop the DataTable and get its columns, in this Forum or the UiPath documentation.

Good luck!

1 Like
4

@dntakoulas Do u have any Samples for this so that i can understand easily

5

no I do not, but searching in there produces miracles :wink:

1 Like
6

Please any one help me, still i did’t get solution. Pls pls…