Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts
    is there any way to automatically pull data from the www into an excel spreadsheet?

    The source of the data: Dream Team

    [attachment=85190:Players.xls]

    The data set can expand as the season continues.

    I would be interested to see if this is possible. Thanks
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You can use a web query:
    - Copy the URL of the web page from the address bar of your browser to the clipboard.
    - In Excel, select Data | Import External Data | New Web Query...
    - Paste the URL into the Address box.
    - Scroll down to the table that you want to import.
    - Click the little arrow to the left of the table. It'll turn into a check mark.
    - Click Import.
    - Select the cell where you want the upper left corner of the table to appear.
    - Click OK.

    You can update the table by clicking the Refresh Data button on the External Data toolbar.

  3. #3

Posting Permissions

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