npatkar
(Nitin Satish Patkar)
December 1, 2020, 2:13pm
1
Hi Champions,
My bot is successfully picking up data from Excel sheet and pushing it to Google. for example, “AED to SGD” Fx rate conversion. But, I am not able to download the values in Excel sheet.
I am attaching the files for your reference.
Thank you,
NitinFX Rate_2020-11-23_02 (1).xaml (13.7 KB)
Fx Rates 18.xlsx (11.2 KB)
1 Like
jack.chan
(Jack Chan)
December 2, 2020, 2:07am
3
The issue was you didnt include the title of the search results page. SOLUTION:
replace your “Get attribute” activity with “get text” and set the selector to be =
"<html app='chrome.exe' title='"+out_cell_value+" - Google Search' /><webctrl tableRow='3' tag='INPUT' type='number' title='"+out_cell_value+" - Google Search' />"
set OUTPUT value of the gettext activity = str_output
in your write range activity you forgot to add headers