How To Import Data From Webpage (From Ajax)

[excellearner2012]

How to import data from webpage (from ajax)

 

Dear Members,

 

I would like to import data from the following webpage with ajax on that page to excel. I am not the developer the following website, I am just an user and want to import data from web to excel.

 

http://www.dukascopy.com/traderconte...n=liveForecast

 

When I want to download data from page 2, the website does not generate a new web address, so I am facing a problem with inserting a link to web address for page 2,3 and likewise. But one great guy from other forum have already given the solution by giving the following links for different pages of ajax.

 

page1: h**p://www.dukascopy.com/tradercontest/?instrument=USD%2FCHF&side=&state=&trader=&page=1&sort_by=&sort_dir=ASC&action=forecastGrid&ajax=1

[/url]

 

http://www.dukascopy.com/traderconte...astGrid&ajax=1

 

Page2: h**p://www.dukascopy.com/tradercontest/?instrument=USD%2FCHF&side=&state=&trader=&page=2&sort_by=&sort_dir=ASC&action=forecastGrid&ajax=1

 

http://www.dukascopy.com/traderconte...astGrid&ajax=1

 

That is just by changing the page no to 1,2,3 and likewise. I have kept the entire web address above to show where to change the page number.

 

But when I see the webpage with the links given above for particular pages, the background color of the data, as can be seen from the original link (first link above), does not appear on the web page and in turn not in excel as well.

 

Would you please look at the above and let me know how to get the background color as well in the excel.

 

Thank you very much for all your help.

 

With kind regards,

Excelllearner2012