Extracting Data from a web table that contains multiple pages

[THARAN123]

Hi All,

Look forward to your assistance in extracting data from a web table that contains multiple pages.

Link for the web page is https://www.cse.lk/pages/trade-summary/trade-summary.component.html

Thank in advance.

[PhilipTreacy · Accepted solution]

Hi @THARAN123 

Loks like the data on that page is loaded with JavaScript.  Power Query can't read tables loaded like this.  The data has to be on the page you load in order for PQ to get it.

You could try a VBA solution or using Power Automate

Web Scraping - Filling in Forms

Regards

Phil

[THARAN123]

Hi @PhilipTreacy 

Thank you for the prompt reply and the same is very much appreciated.

I will try the VBA solution.

Thanks again.