More information on it can be found here : this is an ASMX web service, it can be called from Nintex Workflow using the Call Web Service action.This web service behaves a little differently to others you may be used to.
The "Specify Elements" needs to be checked, and then it's possible to select the appropriate XML node.
This XML browser gives you an easy way to get to the data in the XML that is needed, without having to know XPath: The Open Workflow For Editing Result is the node that contains the Session ID that will be needed for any future calls to update this Excel file.
We are opening a session, checking for errors, updating a cell, checking for errors and finally closing the session.
Although in the screenshot, I'm doing something naughty, in that I'm not labeling my actions, in the downloaded UDA file below, they have been labeled and should make it easier for you to understand what it is doing.
Share Point 2013 (Enterprise edition) comes with Excel Services.
One of the lesser known pieces of functionality, is the Excel Services web service.
You can't just call a method to update a cell in your spreadsheet.
The way to use this web service, is to first obtain a Session ID.
I have learned this trick while doing analysis on a pivot table today.
In this online lesson on pivot tables, I will teach you how to group dates in pivot tables to analyze the data by month, week, quarter or hour of day.
In order to complete it though, you need to go into SOAP Editor mode.