Jump to content

How To Import Data From Webpage (From Ajax)


Recommended Posts

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.



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



Page2: h**p://www.dukascopy.com/tradercontest/?instrument=USD%2FCHF&side=&state=&trader=&page=2&sort_by=&sort_dir=ASC&action=forecastGrid&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,

Link to comment
Share on other sites

This thread is more than a year old. Are you sure you have something important to add to it?

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.