May 4, 2013 11:51 PM
Microsoft states that the WEBSERVICE function may appear in the Excel for Mac function gallery, but it doesn’t work on the Mac version, because of the function’s dependencies on Windows operating system features. The STOCKS data type capability in Excel is a far superior method for this purpose.
Great guide, thanks John.
There was a time in my life when all I did was write and test web services, and here are a few notes I learned about hitting one of my web services from a browser. Looking at the WSDL for a web service from a browser. To view the WSDL document for a web service I created named UserService, I just went to the following URL in my browser. Functions Translator helps people use a localized version of Excel by helping translate from the US Excel function names, or research how to create a solution on the web with predominately English content. Easily find the equivalent localized functions and formulas in any of the supported 15 languages.
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.
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 Update
Using Webservice In Excel 2013
Webservice Excel Mac
May 4, 2013 11:51 PM