Data scraping data

Help Activities
1

Hello world

Need help to resolve an issue that I scraped the data from the application which contains in column-2 and i have to count some fields in that column and the count number should be write in the Excel sheet how can I do that

2

Hi @murali_potnuri

  1. You can try with Data Scrapping method or Table extraction method. The output format will come as data Table

Check out the document

https://docs.uipath.com/activities/other/latest/user-guide/n-extract-data

https://docs.uipath.com/studio/standalone/2022.10/user-guide/about-data-scraping

  1. You can use Filter Data Table activity. Based on the condition you can filter the data in the result from Data Scrapping

input → Output of Data scrapping
Output → Create an variable in the output panel (DtFilter_out).

Check out the document

https://docs.uipath.com/activities/other/latest/user-guide/filter-data-table

  1. Use Write cell activity to enter the count in the excel file
DtFilter_out.Rows.count

Regards
Gokul

1 Like