Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Aug 2009
    Posts
    84
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Export to Excel from webpage no longer works

    I have an assignment for my students where they download weather records to Excel from http://www.wrcc.dri.edu/cgi-bin/cliMAIN.pl?tx2244 by right clicking & choosing Export to Excel. Until I upgraded from IE 8 to IE 9 this worked just fine. It downloaded the data and imported into Excel for further analysis. It does not work with IE 9. I get



    Is there a workaround for this problem?

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,379
    Thanks
    207
    Thanked 829 Times in 762 Posts
    Sam,

    It seems that IE9 is not transferring the Web URL properly.
    Here's a workaround:
    1. Copy the URL from the Address Bar of IE
    2. Right-click the table and select Export to Excel
    3. Paste the URL into the Address Bar of the New Web Query dialog.
    4. Click on the Yellow Arrow to the left of the data you want to import.
    5. Select the Cell to import to or just click OK.
    6. Done

    Attached Images Attached Images
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  3. #3
    Star Lounger
    Join Date
    Aug 2009
    Posts
    84
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Sorry I took so long to respond. I guess I didn't have my settings correct in this forum to get an email when someone replied.

    I tried your suggestion, but it still does not work. It works for the default weather data displayed when you first go to that web page (http://www.wrcc.dri.edu/cgi-bin/cliMAIN.pl?tx2244), but the data I'm wanting to download is not the default. I have to scroll down the left side navigation bar and look for Temperature, then click the link for Average. When I do that there are no yellow arrows.

    Is this a bug in Excel or IE 9?

  4. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,379
    Thanks
    207
    Thanked 829 Times in 762 Posts
    Sam,

    This worked for me.

    1. Follow procedure above {steps 1-3}.
    2. Navigate using the links on the left side of the New Web Query dialog.
    3. Now if the Yellow arrows don't show up on the right side click the Yellow Arrow Icon to the right of the Address bar TWICE and the arrows should show up.
    4. Procede as above.

    Attached Images Attached Images
    Last edited by RetiredGeek; 2012-10-13 at 16:26.
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  5. #5
    Star Lounger
    Join Date
    Aug 2009
    Posts
    84
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks, but I couldn't get that to work either.

    I think I'll delete this assignment. It's way too complicated for my freshmen students! As an alternative I've downloaded an Excel spreadsheet that will calculate their carbon footprint based on the electricity & other fossil fuels they use. Each student has to find ways to reduce their footprint before the end of each month to get credit. Most of my students are doing well with this assignment.

  6. #6
    New Lounger
    Join Date
    Mar 2012
    Location
    California
    Posts
    4
    Thanks
    0
    Thanked 2 Times in 2 Posts
    A simple copy/paste seems to work fine, although it obviously wouldn't refresh with new data. If you're using Excel 2010 (I don't have earlier versions to test), you can simply import the table without even opening IE. From the Data tab, click on "From Web" in the "Get External Data" group, enter the URL in the address box, and click the yellow arrow next to the table. If that doesn't work, there may be a problem with Excel, not IE.

  7. The Following User Says Thank You to abilyeu For This Useful Post:

    SamStamport (2012-10-20)

Tags for this Thread

Posting Permissions

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