excellearner2012 Posted October 23, 2012 Share Posted October 23, 2012 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 Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.