+ Reply to Thread
Results 1 to 5 of 5

Extracting Data from Webpage

  1. #1
    Registered User
    Join Date
    12-17-2011
    Location
    Hatfield
    MS-Off Ver
    Excel 2010
    Posts
    3

    Extracting Data from Webpage

    Hi all,

    I am Kevin and am new to this site. I have few questions about Excel and was hoping to find some answers here.

    I am having a problem with improting data from a website (weather commerce). The website contains weather information for various destinations and to view information for each destination, I have to choose a destination from a drop down menu and tick on the sub destinations to view weather information for each sub destination.

    I tried importing the information using a web query but I can not import the data. Is this because the website uses drop down menus to populate information and is there a way in which I can import this data to excel?

    Thank you in advance for all help.

    Kev

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Extracting Data from Webpage

    what site is it? perhaps there is a page of the whole data
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    12-17-2011
    Location
    Hatfield
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Extracting Data from Webpage

    Quote Originally Posted by martindwilson View Post
    what site is it? perhaps there is a page of the whole data
    Its a website for weather prediction like Met Office. My company has subscribed to them and as we have a lot of sites to monitor I thought it was easy to build a spreadsheet and use web query to update them. The site can only be accessed by using a username and password.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,395

    Re: Extracting Data from Webpage

    Hi Kevin and welcome to the forum,

    Excel Web Queries look for an HTML TABLE of data on the web page. If you are looking at a site that doesn't display what you want as a table then Web Queries don't work. The little yellow arrows show where the web tables are on the page. See:
    http://www.techrepublic.com/article/...ueries/6115870 for how Web Queries work.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  5. #5
    Registered User
    Join Date
    12-17-2011
    Location
    Hatfield
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Extracting Data from Webpage

    Quote Originally Posted by MarvinP View Post
    Hi Kevin and welcome to the forum,

    Excel Web Queries look for an HTML TABLE of data on the web page. If you are looking at a site that doesn't display what you want as a table then Web Queries don't work. The little yellow arrows show where the web tables are on the page. See:
    http://www.techrepublic.com/article/...ueries/6115870 for how Web Queries work.
    Thank you for confirming this

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1