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

Help Studio
1

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

2

hey

check this example
test.xaml (10.6 KB)

regards!

3

where should i add excel file to give input to google

4

Hi @raju_alakuntla

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

5

using a read range activity

image
image798×742 19.4 KB

regards!

6

thank you

Regard

7

very useful video.
thanks a lot

Regards

8

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

Thanks

9

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

10

Hi @raju_alakuntla

  1. Use Read Range activity to read data from excel file and will give you output as DataTable and say ‘DT’
  2. Then try this expression toremove duplicates:
             newDT = DT.DefaultView.ToTable(True,"ColumnName").CopyToDataTable
  1. And then use Write Range activity to write into exel file and pass that newDT as input to it.
11

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