How to set text one by one from excel sheet to google search engine

raju_alakuntla · March 23, 2022, 4:26am

i have some names in excel sheet and want to search in google one by one automatically

fernando_zuluaga · March 23, 2022, 4:37am

hey

check this example
test.xaml (10.6 KB)

regards!

raju_alakuntla · March 23, 2022, 4:43am

where should i add excel file to give input to google

nikhil.girish · March 23, 2022, 4:43am

kindly refer the video

also high level approach

read the excel using read range and later use for each row to iterate each row and do your needful activities

Thanks

fernando_zuluaga · March 23, 2022, 4:44am

using a read range activity

regards!

raju_alakuntla · March 23, 2022, 5:02am

thank you

Regard

raju_alakuntla · March 23, 2022, 5:03am

very useful video.
thanks a lot

Regards

nikhil.girish · March 23, 2022, 5:14am

Kindly close the topic and mark as solution so it will be benefitted to others
@raju_alakuntla

Thanks

raju_alakuntla · March 23, 2022, 5:49am

can you please help me to skip repeated names in web search?

nikhil.girish · March 23, 2022, 6:13am

Use Read Range activity to read data from excel file and will give you output as DataTable and say ‘DT’
Then try this expression toremove duplicates:

             newDT = DT.DefaultView.ToTable(True,"ColumnName").CopyToDataTable

And then use Write Range activity to write into exel file and pass that newDT as input to it.

system · March 26, 2022, 6:14am

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