Copy data From Web Table to Excel

Hello everyone,

I would like to:

Copy a datatable from a web page

Paste it the table in a new created excel file

Name the excel file

Store the excel file on a specific path

Thanks

Hi @Youssef - If it is table from webpage then use “Data Scraping” activity that will store the output in a Data Table. Then write that Data Table into Excel using “Write Range” activity and pass the Filename as per your need.

Thanks,
AK

Hi @Youssef

You can use the data scraping wizard to get the data table in the web page to a data table variable. Then use the write range activity to write the data to an excel file.