Export (0) Print
Expand All
1 out of 6 rated this helpful - Rate this topic

Excel Services in SharePoint 2013

SharePoint 2013

Published: July 16, 2012

Learn about the new capabilities in Excel Services in SharePoint Server 2013 and how you can use them in your own development efforts.

SharePoint 2013 brings new technologies to Excel Services─such as ECMAScript (JavaScript, JScript) UDFs and Excel Interactive View─and new enhancements to existing technologies, such as ODATA for REST, and updates to the ECMAScript (JavaScript, JScript) Object Model (JSOM) API.

JavaScript UDFs

Excel Services already lets you create user-defined functions (UDFs) using managed code. Excel Services in SharePoint 2013 introduces a new kind of UDF—ECMAScript (JavaScript, JScript) UDFs. JavaScript UDFs run in the context of the browser: either in a Microsoft Excel workbook that is hosted in an Excel Web Access Web Part on SharePoint, or in a workbook that is embedded on a host webpage.

Excel Interactive View

Excel Interactive View is a brand new technology introduced in Excel Services 2013. Excel Interactive View uses HTML, JavaScript, and Excel Services to generate Excel table and chart views on-the-fly, in the browser, from an HTML table hosted on a web page. By using Excel Interactive View, users can harness the analytical power of Excel for use on any HTML table on any web page, in most browsers, without having Excel installed.

OData in Excel Services

SharePoint Server 2010 introduced the REST API for use in getting and setting information in Excel Workbooks stored in SharePoint document libraries. SharePoint Server 2013 adds a new way to request data from Excel Services that uses the Open Data Protocol (OData) which you can use to get information about Excel Services resources. This new service relies heavily on the existing Excel Services REST API.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.