Hi
I want to import data from a website into excel (or database) and currently I do it using ID but it takes about 1minutes to get 100 records and the website ommits some IDs so it seems it is generating more IDs then I can download.
The best solution would be to filter data on web page and download all results but the website uses javascript to go to another page which so far I couldn't make it work with excel. I've tried putting & and hidden parameters but it didn't work.
I currently download it using id like this
but I would to use this link
Unfortunatelly I cannot find any parameters to go to page 2,3,4
The only way apart from click the page number was to paste Javascript:__do PostBack('srpPa ger','2') to the web address.
So I'm looking for something that would allow me to loop through all pages.
Many thanks in advance
Emil
I want to import data from a website into excel (or database) and currently I do it using ID but it takes about 1minutes to get 100 records and the website ommits some IDs so it seems it is generating more IDs then I can download.
The best solution would be to filter data on web page and download all results but the website uses javascript to go to another page which so far I couldn't make it work with excel. I've tried putting & and hidden parameters but it didn't work.
I currently download it using id like this
but I would to use this link
Unfortunatelly I cannot find any parameters to go to page 2,3,4
The only way apart from click the page number was to paste Javascript:__do PostBack('srpPa ger','2') to the web address.
So I'm looking for something that would allow me to loop through all pages.
Many thanks in advance
Emil