What's new in Excel Services for developers
Last modified: July 01, 2013
Applies to: SharePoint Server 2013
Excel Interactive View
Excel Interactive View" technology uses a simple HTML tag to create an Excel table that is based on an HTML table that is hosted on the same webpage. When you place the Excel Interactive View HTML tag above an HTML table on a hosted webpage, the tag reads the data in the HTML table and creates an Excel table in the browser that you can interact with (filter, sort) and create charts. You can also open the table as a workbook in Excel Web AppExcel Web App, or even download it to another location and open it in Excel.
For more information, see Excel Interactive View.
The Excel Services JSOM API now includes the following:
The ability to reload the embedded workbook. Now you can reset the embedded workbook to the data in the underlying workbook file.
User-created floating objects. The EwaControl object has new methods that let you add/remove floating objects that you create.
More control over viewable area of the Ewa control.
SheetChanged Event. This event raises when something changes on a sheet, such as updating cells, deleting or clearing cells, copying, cutting or pasting ranges, and undo/redo actions.
Enabling data validation. You can now validate data that is entered by a user.
Using the new OData functionality in the Excel Services REST API, you can request the tables inside an Excel workbook as OData. For example, to request Excel metadata about available resources in the SampleWorkbook.xlsx workbook using a REST call, you use the following syntax.
For more information about the REST API, see the Excel Services 2010 REST API documentation in the SharePoint Server 2010 SDK documentation.
To request metadata about available resources in the SampleWorkbook.xlsx workbook using OData, use the same REST syntax, except replace /Model with /Odata as in the following request.
From there you can use OData system query options to get specific information about tables inside the workbook.