REFrame work task on data scrapping from browser save in excel to mail

Help Activities
,
1

and scroll down to get the below table.
2. Extract the table data from webpage with details of the states
3. Filter the data and get details of the states whose population is greater than 20,000,000
4. Write those states and respective capitals in one excel sheet
5. Email the result with excel file

Please develop the process in transactional flow first. Then try to upload all states details in queue and use REF for this usecase.

1 Like
2

Hi @Aakash_Gaikwad ,

Welcome to the Community !

This is a Classic case of RE Framework where the solution can be built with REF with DataTable.

  1. Convert the REF to Work with Datatable , This has to be done by updating the Transaction item in REF to DataTable . You can refer this 1. UiPath RPA Use Case : Create Card | ReFramework without Orchestrator Queue | With Excel Datatable - YouTube

  2. Extract the table data from webpage with details of the states.
    This Step would be a part if INIT State where we simply apply data Scraping , get DaTable - This Datatable would be then passed to get Transaction xaml

  3. Filter the data and get details of the states whose population is greater than 20,000,000
    This can be a Check in Process xaml file where we apply the validation logic on DataRow Item

  4. Write those states and respective capitals in one excel sheet
    Use Write cell Activity to update the status Back , This also has been covered in the video shared above

  5. Email the result with excel file
    This is just sending emails with attachment.

Sharing a Playlist where we have End to End use cases built on REF.

Thanks
Mukesh kala