none
javascript web page to excel RRS feed

  • Question

  • Dear All

    I have excel database of about 100 hyperlinks of webpages like this:

    http://3d-televize.heureka.cz/panasonic-tx-48as640e/porovnat-ceny/#offers

    http://led-televize.heureka.cz/panasonic-tx-42as600e/porovnat-ceny/#offers

    ...

    All ones represent different products but have the same structure.

    I need to have content of these pages in excel. The main purpose is to get the shop and the price.

    So for example:

    SHOP           PRICE

    Mall.cz         15989

    Exasoft.cz    16990

    ...

    I tried web queries but not working on this kind of web page. (error acccured: This Web query returned no data.  To change the query, click OK, click the arrow on the name box in the forumula bar, click the name of the external data range for the Web query, right-click the selection, and then click Edit Query.)

    I went through many scrapers tools (eg. outwit, data miner) but could not find the one manage to solve this issue.

    I am rather basic in VBA but it could be the only solution.

    Is there a way to extract data from those hyperlinks each one in separate sheet to get the needed data?

    Or maybe there is easier way to gather information about Price and Shop for each product and placed it in excel?

    Gordonik

    Thursday, October 23, 2014 8:15 AM