How to capture dynamic contect from a website?

Help Activities
1

Dear Experts

I have a request to capture MTM and 数量 from a website and input into a designed excel file

The problem is that the rows on the website are dynamic, we don’t know how many MTM we have to input into the excel file

May I know how to make it happen?

image
image948×186 12.5 KB

image
image382×218 2.72 KB

Thanks
Ivan

2

Hi @yangyq10

You Could use Extract Table Data Activity.

3

@yangyq10,

Extract Table Data should be able to extract this data.

1 Like
4

@yangyq10

If on single page as suggested use extract table data

If on different pages try to use for each ui element to navigate to each and then extract and add to datatable

Cheers

1 Like
5
  • Use Data Scraping (Modern: Extract Table Data)
  • Select the MTM and * columns
  • UiPath will auto-detect all dynamic rows
  • Save data to DataTable
  • Write to Excel
  • Use ‘Use Excel File’ → ‘Write Range’
  • Input the DataTable into your designed Excel