Excel Services & Rest Overview

The Excel services is essentially a SOAP web service which can be accessed via: http://sharepointsite/_vti_bin/Excelservices.asmx

Excel forms have fields that are bound to cells in a workbook. The form can then be filled out and populates the spreadsheet.

Common events utilized are:

              Sheet.DataEntered()

              Workbook.DataEntered()

 Workbook.BeforeTyping()

Common method utilized is:

             Workbook.Reload(call back)

REST allows for information to be accessed via OData as long as regions named as tables are in the spreadsheet

REST can be used with published spreadsheets (.xlsx)

Formatted URL example:

http://sharepointsite/_vti_bin/ExcelRest.aspx/NameofExcelFile.xslx/Odata/TableName

View Video: