I’m a beginner and I’m learning from old videos, but after the update everything has changed and I can’t figure out what activities to use to add data to the excel table. In general, here’s what I want to do: 1. An employee monitors weather changes in different cities every 5 minutes (according to the directory) to the Google search engine. After that, it enters all the data into a report (Excel table) by city, indicating the date, time of inspection and temperature.
Hi @sazonov038
If you are trying to extract tabular data from the web application to fill it in the excel, you can consider using Data Scrapping.
If not, you can simply use the Get Text activity to indicate the desired data that needs to be extracted. Along with this, you can also anchor the element on which you need your bot to focus, so that even if the position changes, it will extract the value anyway.
Hope this helps,
Best Regards.
Hello, @sazonov038.
- If you want to use front end interactions, please use “Table extraction” or “Get Text” to extract data from the web browser to a Datatable, then use the datatable as an input to the “Write Range Workbook” activity to write to the desired excel
- Else, try using the available weather APIs; they are free and require no front-end UI interactions; automations will be faster, easier, and error-free.
Happy Automation 
Thanks.
1 Like
ashokkarale