i have some names in excel sheet and want to search in google one by one automatically
where should i add excel file to give input to google
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
thank you
Regard
very useful video.
thanks a lot
Regards
Kindly close the topic and mark as solution so it will be benefitted to others
@raju_alakuntla
Thanks
can you please help me to skip repeated names in web search?
- 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.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.