Using Read Columns and Type Into Activities

Help Activities
, ,
1

Hello UiPath community!

I have been dealt a task to read from an Excel Sheet, which defines its data into columns.

My end goal : For the robot to read every column and input the values into a Google Form, and the robot knows that the first column is the header.

I want the robot to understand that the first column is the headers. And for the second, third and fourth columns to represent three individual persons.

Once that is achieved, I want to use the TypeInto activity to key this info into an eForm.
Thanks a lot!

Test Data UiPath Help.xlsx (8.2 KB)

2

@Izzat_Nasser

You can refer below post

Above post will clear you how to make as the first column as the headers

and also you can place a typeinto inside the for each row

Hope this helps you

Thanks

3

Hi,

Thanks for your answer. Actually this is not what I want.

What I want is that for example:

All the values in Column A are denoted as headers.
Then all the values from Column B onwards are data, whereby

The whole Column B represents one applicant, the whole of Column C represents one applicant, the whole of Column D represents one applicant and so on and so forth.

This is the structure for my Excel Sheet.