Using Excel Services REST API in InfoPath

re: Using Excel Services REST API in InfoPath

Hilary Stoupa — Fri, 08 Mar 2019 16:21:37 GMT

I forgot the URL - and then I think the site ate my comment where I included it. docs.microsoft.com/.../excel-services-rest-api

re: Using Excel Services REST API in InfoPath

Hilary Stoupa — Fri, 08 Mar 2019 16:04:07 GMT

Hi - I haven't tried this in later versions of SharePoint. I don't have a 2016 on prem SharePoint site. Here's a link to the docs on the REST API for Excel for 2016 - You could compare URLs / functionality to the docs and see if it looks the same?

re: Using Excel Services REST API in InfoPath

emilef — Fri, 08 Mar 2019 13:55:27 GMT

Hello Hilary,

I haven't visited this site in a while, but this tutorial and the video (which you have elsewhere) were extremely helpful in getting a bunch of my work off the ground!

Anyway, my question is, as far as you are aware, does this type of data connection between InfoPath and an Excel document, such as the chart, still work with a SP 2016? My IM contacts have told me that my solution, a tool using InfoPath SP and Excel, which I won't bother describing more here, contains some features which have been deprecated in SP 2016 and the SP deployed at my workplace is being upgraded from 2010 to 2016 in the next few months.

re: Using Excel Services REST API in InfoPath

RaYvA — Wed, 12 Feb 2014 13:12:34 GMT

Hi Hilary,

Thank you for this very informative video, I implemented the form exactly like the one you demonstrated. Still had a few little glitches occasionally in the web form but that's probably my environment :)

Unfortunately, it didn't quiet meet my needs so I resorted to using SOAP instead as I needed to push ~ 10 years of financial data (60 odd parameters) into my model and then extract the corresponding ~10 years of results (~120 ranges), this also had to be done for both 'Expected' and 'Conservative' case financials (so multiply those parameters/ranges by 2!). ^_^ Yes it was a daunting task!

Magically, after unlocking that data from the existing excel spreadsheets and with the use of SharePoint content types I now automate putting all of that financial data into whatever word templates are required with no other user interaction, saving the business at least 20-30 minutes per revision of the financials documentation (and there are literally thousands of revisions per year, estimate about 3000 revisions saves 1500 hrs of work/year!)

I'm sure there are ways to clean up my InfoPath form/SOAP interaction, but I'm more than happy to put together a complete demo of this quiet complex, yet easy to implement and use, infopath/excel/word content type interaction if anyone is interested?

Cheers

re: Using Excel Services REST API in InfoPath

Hilary Stoupa — Sat, 04 Feb 2012 00:53:57 GMT

Hi - you should be able to return a cell range or a named range - but that will return the data to your secondary data source. You'll need to add rules that will take the returned data and put it in your main data source fields to your requirments.

re: Using Excel Services REST API in InfoPath

BHerz — Wed, 25 Jan 2012 17:47:16 GMT

Hi Hilary,

Thanks for the informative video on using REST API with Excel Services.

We are using InfoPath 2010 and Excel Services in SharePoint 2010 as a "calculation engine" to update Multiple InfoPath fields with the results calculated by ExcelServices. Does REST have the ability to return multiple values back to multiple InfoPath fields from one URI? Or will each field require its own REST URI and parameters to return the calculated value to each individual InfoPath field?

Bruce