AnsweredAssumed Answered

Troubleshooting excel service setcell

Question asked by on Jul 15, 2017

I was wondering if someone could please help me.

I would like to dynamically create a excel workbook and place some of the data from a SharePoint 2010 InfoPath form into a excel workbook.

I have managed to get Nintex to create the workbook by using the excel service method 'openworkbookForEditing' which opens an excel workbook already in SharePoint with session id 'sessionid'.  I then use the excel service method 'setcell' for the same sessionid, Sheet1. row 5, column 5, value "test". 

I then use 'saveworkbookcopy' and copy sessionid to the same location in SharePoint, but with a different name. 

I then use the 'closeWorkbook' for sessionid.  The newly created workbook appears, but there is not value in the required cell in either workbook.

Any advice would be gratefully received.


Thank you kindly