How to read each cell in a range and then type it into an app

[Petar_Soce]

Hi all

I want RPA to read each cell in a range, memorize its value then open a second app and enter each value from excel into a each typing field( one for one) in a newly opened app.

Thanks

[Dominic]

@Petar_Soce,

1. Read Excel using Read Rangeactivity and output it to datatable.
2. Use For each row to loop through datatable.
3. Inside the body of for each row activity use type into to enter the values in the app/software. You can access them with reference to column name if not with index. Example : row(“column name”) or row(“column0”)

Important Note there are many samples in forum you can refer those also we do have Uipath Academy. kindly go through those tutorials and forum for reference.

Regards,
Dominic

[pratapg (pratap)]

Hi,

can you share this task xmal files or share to my mail:gslnpatap@gmail.com

Thanks,
Pratap

[Petar_Soce]

Hi

Thank you all. I have solved my problem…I had my order in which RPA reads code mixed up so I have rearrange it and it works now.

I can send the example if someone have similar problem.

Thank you all

[kjoonx2]

Hi Petar,

Could you please send me the example. I am working on something very similar.

Thanks!

[Petar_Soce]

Hi.

This was some time ago. Really cant find what I was doing.

What you need to do is use the acivity READ RANGE which outputs DATATABLE. In it you have your RANGE values stored.
After that you open the app and use TYPE INTO on the row(box) you want to type into and to access the value from the datatable you will use row(0).item(0) If you want to type all the values it is best to use For each row loop…

[kjoonx2]

Thank you! This is very helpful

[Dorothy_lee]

Thank you so much!! it’s really helpful