How to fetch details from excel sheet and enter those values in an application?

Help Studio
, ,
1

Hi community,

Please help me with below use case on how to build logic.

image
image1222×262 11.8 KB

I need to fetch the Action type Value from the excel and update in the web application as shown in respective fields.

image
image1114×247 10.9 KB

Note: No. of rows in the excel sheet is dynamic.

Please help me with logic building.

2

@Vaishnav_Tej Hi, Please follow these steps.
0) put assign activity and make int value which is row1 for application

  1. read excel file from B2 cell and store in DT
  2. put for each over datatable.
  3. inside loop make dynamic selector by adding row variable for each filed and give respective value.
  4. inside loop put increment for row.
3

You should do the free training on the UiPath Academy web site. It will teach you the basic things you need to know to do simple processes like this.