How to copy from excel and paste into a web search box?

[Lwhite]

Rookie needs help!

I imagine this may be covered in the forum somewhere, but I am pretty new to UiPath and need some help pronto!

I have an excel spreadsheet with values in column A which I need to copy and paste into a search box on a web portal. I then need to copy and paste the text that appears on screen into column C and repeat this process, working down the rows of column A.

Could anyone help? Or point me in the right direction?

Much appreciated
Liam

[PrankurJoshi]

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.

See this sample structure -

Main.xaml (11.2 KB)

[Lwhite]

@PrankurJoshi
Thanks for the timely response. I appreciate the help.

A bit confused by the sample structure you have provided (major rookie). In the For Each Row section I have entered foreach row in “here I have typed the column name” which produces a compiling error value of type ‘string’ cannot be converted to ‘system.data.data table’

Then how do I store this value as a variable to search in browser?

Any help would be appreciated.

Thanks

[indra]

@Lwhite Follow below link and download the file you can get the solution

How to login to website by using excel input for credentials

@Hemanttt Check attached zip file SignIn.zip (29.2 KB)

[balupad14]

Hi @Lwhite,

To copy the data in the excel sheet. you can use the below activity.

BalaReva.Excel.Activities

Hi Friends, I have included some new activities in the “BalalReva.Excel.Actities”. Activities 1.Copy Data activity - It copies the data from Excel Sheet to the clipboard 2.Delete Data activity - It deletes the data in the Excel Sheet 3.Clipboard To Datatable activity - It converts the clipboard to Datatable Namespace [image] 1.Properties Copy Data activity [image] Sample File : CopyData.zip (8.1 KB) 2.Properties of Delete Data activity [image] Sample : DeleteData.zip (6.9 KB) 3.…

Regards
Balamurugan.S

[Alina_Ungurean]

Hi @Lwhite, I have the same error. Did you manage to fix it? Can you please share the xaml file? It’s much appreciated.

Thank you!

[harinathreddy.yn]

Hi Alina,

What is the issue you are facing? Can you brief it so that I will try to provide some help.

Thanks,
Hari

[Alina_Ungurean]

Hi Hari,

I am trying to copy data from an excel into a webpage, click search and then copy it back to excel.
I have created a data table variable for my database and when I try to include it in Assign I get this error:
Complier error: Option Strict on disallows implicit conversions from ‘Object’ to 'System.Data.DataTable"

[harinathreddy.yn]

Let me assume an example
1.We have an excel and the data in first column which we need to search in web.
so use the read range( workbook) activity and copy it to a data table and use for each row and inside the for each search the webpage and input for search you give it as row(0).tostring
2. I did not understand what you want to write back to Excel is it the output of the search or what ?
or you can share your XAML so that I can check what is wrong or give me full requirement I can give sample code.

coming to above screen shot the error is that word is a datatable and the row("") will give you a string data type. so you assign copy, if you want to write to data table use add data row activity.

[Alina_Ungurean]

Yes, correct I have an excel with one column of data that I need to search in a webpage and copy the output of the search back into Excel - I attach the Xaml file (it’s not complete).

Thanks!

Main (2).xaml (11.1 KB)

[indra]

@Alina_Ungurean Is it possible to share excel sheet and url

[harinred]

Hi,

Please find the below xaml and add your remaining code and run the program, let me know if you have any doubtss.
Main3.xaml (10.7 KB)

Regards,
Hari

[Alina_Ungurean]

Many thanks!!

[Alina_Ungurean]

Hello!

I need the bot to automatically read the data from Excel and paste it into the web page, search and copy output back to excel. For now I used command “type into” and I have to manually type the search word, not sure how I can make it to automatically read Excel. Can you please help?
Thanks!

Main_D.xaml (15.6 KB)

[harinred]

Can you please share the link where bot needs to search and also the excel file which has the inputs. if it is confidential you can share via message.

Thanks,
Hari

[Alina_Ungurean]

Hi Hari,

Webpage is http://dle.rae.es/?w=diccionario, it should search in the grey window with the small keyboard in the right side and press “consultar”. I attach Excel, I only need the first search result that it gets (after 1.)
Many thanks
Book4.xlsx (12.3 KB)

[harinred]

Hi Alina,

Please find the attached worflow and the result will be stored in sheet3
let me know if you don’t understand.Search.zip (42.5 KB)

[Phani_Kumar_Reddy]

Hi,
How can i take input from excel column and then search each cell in web(google) and then save back data to excel.

Eg: Let’s just say i have names of cities in column if i want coordinates of those cities
google provides coordinates directly when we type city name + coordinates
and i wasnt those coordinates gets saved back to excel

[Phani_Kumar_Reddy]

Hi,
How can i take input from excel column and then search each cell in web(google) and then save back data to excel.

Eg: Let’s just say i have names of cities in column if i want coordinates of those cities
google provides coordinates directly when we type city name + coordinates
and i want those coordinates gets saved back to excel.