The STOCKS data type capability in Excel is a far superior method for this purpose.
Excel 2013 or above (we will be using WEBSERVICE and FILTERXML functions in Excel) How to get the API Key from Google Maps or Bing Maps: The API key process is somewhat technical and can be confusing. Plus for Google Maps API, you need to provide your credit card details (according to Google, you will not be billed automatically though). The Excel WEBSERVICE function, ENCODEURL function, and FILTERXML function work nicely together to make the task of working with web services straightforward within Excel 2013. This functionality is made available in Excel 2010, Excel 2007, and Excel 2003 in the Excel PowerUps Premium Suite add-in for Excel. This can be downloaded for free.
May 4, 2013 11:51 PM
Tip: If you have Excel 365 there’s a much easier way see Exchange Rate support in Excel 365. There are many places on the web which supply exchange rate information in a computer readable format. Excel can grab that data and put it into cells for the worksheet. For this article, we set some limitations: No VBA code or addons. The add-in will work on any version of Microsoft Excel from Excel 2007 to fully installed Office 365. As long as you have Excel installed on a Windows machine, this add-in will work fine. It works with Microsoft® Excel® 2007, 2010, 2013, 2016, Office 365, Office 2019. Works on Surface Pro 4 and Hybrid laptops.
Excel Webservice Xml
Great guide, thanks John.
Just a note, in case anyone has the same issue. At first I couldn't get this to work. I tried logging out and back in (still no joy), then restarting the mac (still no joy).
Try doing both of those first. However, if, like me, you still can't get the local host site to load, try the following: You should find a file at /Library/WebServer/Documents/index.html.en . This contains the text 'It works!' referred to in the post. What I did was duplicate that file in the same folder and changed the duplicate's name to 'index.html', leaving the original in situ.
Both local and user sites then loaded. After which, I was able to delete the duplicated file and everything now works without issue. Just to be clear, leave the original file index.html.en where it is, untouched and unharmed throughout this step.
Web Service In Excel For Mac Os
Not sure why I had to take this mysterious detour - probably something local to my machine, but if you're having trouble after following the guide above, see if it helps.
Excel Webservice Function Example
May 4, 2013 11:51 PM