Summary

The programmability story around Excel Services, part of SharePoint Server 2010, has increased dramatically versus the prior version. In addition to expanded capabilities of the Excel Web Services, there is a REST API for accessing resources in Excel workbooks using a URL and an ECMAScript or JavaScript object model (JSOM). You can use all three options within a single solution to create sophisticated web-based applications that leverage the power of Microsoft Excel.