Web data is not getting stored in Excel file

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

image

The issue was you didnt include the title of the search results page. SOLUTION:

  1. 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' />"

  1. set OUTPUT value of the gettext activity = str_output

  1. in your write range activity you forgot to add headers