Updating excel from the web
I am using 'Query Excel Service' to read excel data , my data can be n (1 to 5000) rows in excel .
Excel for the web (formerly Excel Web App) extends your Microsoft Excel experience to the web browser, where you can work with workbooks directly on the website where the workbook is stored.
All Office 365 customers can view and lightly edit Office files using Office for the web.
Note Workbooks that exceed 30 megabytes (MB) cannot be viewed in Excel for the web from within Microsoft Share Point Online.
For this web method call to work, put in a "m:" before the two cell Value parameters.
That is all you need for the Set Cell web method to work.
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.
This web service behaves a little differently to others you may be used to.
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.
In order to complete it though, you need to go into SOAP Editor mode.
The cell Value field, for some reason is missing the namespace behind it.
Search for updating excel from the web:
If it's convenient, could you please help with getting this worked. I don't have the administration access to the site – but need to know what to ask the support team. Is it possible to have a workflow open an Excel file and refresh pivot data? I believe this must be because the session ID is wrong.