Forum Discussion

yugadi's avatar
yugadi
New Member
5 years ago

Importing multiple pages tabular data from web

I am trying to import multiple pages of data that are indexed in a table in this URL http://www.nepalstock.com/main/floorsheet/index/176/?contract-no=&stock-symbol=&buyer=&seller=&_limit=500 By default, the site only shows 20 rows of data but we have an option to display 500 rows at a time. With the help of one video on power query, I was able to import this into excel. But I could do so only for the first 500 rows only. There are around 176 such pages and my aim is to edit the code in power query editor that imports all the pages into excel.

In the example video where I learned to import these data via power query,  in the advance editor, we could define a variable (StartPage as text)>= and change the start page of URL with this variable. But in my case the URL is little bit different. It doesn’t have “……&start=1&…” in the URL where I can change the variable name. Instead, it has index number that runs serially from 1 to hundreds. I would hugely appreciate if someone could guide me how I could import all of the pages.

 

2 Replies