Updating excel from the web hei dating dagbladet
A bunch of XML will be returned, and the Session ID needs to be extracted from the XML by clicking on the Select Element link in the action.
Notice that at the bottom of the action configuration is the Web Service Output.
Share Point 2013 (Enterprise edition) comes with Excel Services.
One of the lesser known pieces of functionality, is the Excel Services web service.
As long as you have a credential with that name, the workflow/uda should work fine. cheers, Vadim Hi Vadim, thanks a lot for this great post! Vadim Hi Vadim, it is an Excel file with Macros - I just wanted to set a cell via workflow and use that cell as part of the Header.
If you have a different named constant, just update the UDA and republish it an the workflow. I was unable to download the UDA and import it but tried to recreat it and i'm getting this error on the second Call Web Service. Error returned from server: Hi Mike, in order to import the UDA, go to Manage User Defined Actions, click on the New or Create button and that will open the designer. That should let you import the file that is in the Downloads section on this post. It helped me a lot to configure the workflow to work with Excel. The set cell works but if you set the Header (and as far as I know it's only possible with a macro) you have to save the file as - and then my Problem starts :-) Markus Hi Vadim, Thanks for all your excellent posts! I have been struggling a long time to get exactly what you do with your UDA work with Nintex Workflow for Office 365 using the Web Request action.
I ask because I'm able to use my own Site Owner account to select the Web method and get to Open Workbook For Editing. I'm trying to create a workflow that would create a folder, an Excel document from a template and a couple of other files and then populate the cells in the Excel document with various values from various sources (including web page on the intranet). I have extracted that part, with and without the quotation marks, and have tried with the whole result string as well, but no luck.
The way to use this web service, is to first obtain a Session ID.
But I'm trying to use this in more efficient way and to update multiple cells in one call to service using method set Range. I am able to call the Open Workbook For Editing method successfully, and it returns a session ID as it is supposed to.
Unfortunately I haven't got any success here - constantly getting an error "The size of the provided array does not match the size and shape of the destination range", so seems like I couldn't set the array of values in SOAP correctly. Excel Server Api Exception: You mentioned that it might be related to the Excel Services configuration. The problem is that the next call (for testing I only do Close Workbook for now, but have tried others as well) fails with status 500 and says “Missing required soap: Body element”.
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.
Search for updating excel from the web:
The "Specify Elements" needs to be checked, and then it's possible to select the appropriate XML node.