Copy-paste cell (for each) into website textbox

Help
1

Hi! I’m a newbie that needs help

I want to copy/paste cell by cell of an Excel into a textbox on a website.
You can access the textbox doing this: https://sisa.msal.gov.ar/sisa/#sisa > “Agenda Sanitaria REFES y REFEPS” > Click on REFEPS tab and there’s only one textbox.

Can anyone help me? Thanks!

2

Hi @mwzb,

Welcome to uipath!

Use excel application scope and read excel through read range activity.

This will give you excel data in for of a DataTable. Now use for each loop for data table and use Get Row Item give the index or column name to get the value or you can simply type row(“ColumnName”).ToString to get value.

Store this value in a variable, Use Open Browser activity to open the browser then use Type Into activity and hit enter to search or click search button.

Hope this helps,if it works mark it as solution.

Thanks,
Neelima.

1 Like
3

Hi @1996

This really helped me, I’m having a problem with the data type in Get Row item. It says “value of type ‘system.data.datatable’ cannot be converted to ‘system.data.datarow’”. I saved the excel range into a DataTable variable and that is what I’m giving to the Get Row item. Do you know how to solve this?

Thank you

4

Can you paste your Xaml here?

6

This file is invalid. You got to paste your XAML file.

1 Like
7

Main.xaml (22.4 KB)

8

Thank you! I see one mistake where, you need to Pass the Row instead of DataTable in the Row section. (Please find screenshot below).

Also, you can do this in 2 ways… Either you can pass the row (index) or row(column name). either ways, you can achieve your result. I have modified your Xaml and attached the 2 options here. hope it helps. Let me know if you are looking out for this.
MwzbTest.xaml (26.1 KB)
MwzbSample.xlsx (9.5 KB)

Screenshot:

image

Happy automation… Cheers :v:

1 Like
9

Thank you @Pradeep.Robot, now it’s working!

1 Like
10

Good to know! Happy Automation…

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.