Requires Excel 2013 or greater. These are new functions in Excel.
You can import .XML data straight from the web into Excel with the WEBSERVICE( ) and FILTERXML( ) functions.
In this video we will get real-time updates from Weather.gov. Data source: http://w1.weather.gov/xml/current_obs/
We will then build a dynamic input source to display current weather conditions for locations across Ohio (the heart of Excel!).
It’s crazy to think that even the most artistic websites (mine included, of course) are built on code. If you’re running Chrome, you can peek at the insides of any website using Ctrl + U. Here, for example, is the insides of the weather report in Akron, Ohio:
I paste the insides of this tree below:
Check out the header of this code: it’s written in XML. Here’s an in-depth introduction to XML, but almost everything you need to know is in the name: Extensible Markup Language.