Update Weather History in MS Excel using Webservice Function

  • 4
  • Question
  • Updated 10 months ago
I recently set up an excel spreadsheet to bring in past weather averages for each day since the beginning of the year.
I am doing this using a Webservice function with the web page link as per specified by wunderground.com, as well as my acquired API key.
The function looks like this in the spreadsheet: "=pwrWEBSERVICE("http://api.wunderground.com/api/84711...")".
However, the xml output is not importing correctly in to excel and I'm just wondering if anyone has any tips on how to solve this issue?
When I use the same function to bring in current weather conditions "=pwrWEBSERVICE("http://api.wunderground.com/api/84711.... xml")", everything works fine and I get an xml data string with all pertinent daily weather info.
Photo of beniferous

beniferous

  • 1 Post
  • 0 Reply Likes

Posted 4 years ago

  • 4
Photo of zach2811

zach2811

  • 1 Post
  • 0 Reply Likes
I am having the same issue, did you ever find a solution?
Photo of Jaime Munera

Jaime Munera

  • 2 Posts
  • 0 Reply Likes
Same here... did you make it work?
Photo of Ravi Yadav

Ravi Yadav, Official Rep

  • 82 Posts
  • 8 Reply Likes
The issue may be because of Excel's character limit. Excel has a character limit (per cell) of 32,767 characters and probably that's why it worked for conditions but isn't working for history. History's response is much larger. Not sure if that is the case here, but that's where I would look next. 
Photo of Jaime Munera

Jaime Munera

  • 2 Posts
  • 0 Reply Likes
That would do it... However... I get proper responses when the query is for today's day... anything else fails with #VALUE!
Photo of Eric

Eric

  • 2 Posts
  • 0 Reply Likes
Any tips to scrape the raw data from the weather forecast displayed as a chart?
Photo of Ravi Yadav

Ravi Yadav, Official Rep

  • 82 Posts
  • 8 Reply Likes
Eric, Wunderground's terms doesn't allow data scraping. I would suggest taking a look at the API: api.wunderground.com/api
Photo of Eric

Eric

  • 2 Posts
  • 0 Reply Likes
what about this website where they scrape the weather history rather than the forcast; is that ok? http://www.ozgrid.com/forum/showthread.php?t=156025 
Photo of Jordan Coe

Jordan Coe

  • 4 Posts
  • 0 Reply Likes
Still having the same issue. Works for today but not for past dates.
Photo of John S

John S

  • 3 Posts
  • 0 Reply Likes
Still nothing on this? Does anyone have any type of work around for pulling historic weather data into excel?