Publishing to Excel Services

This example provides a walk-through of exporting a SharePoint list to an Excel 2010 spreadsheet, and then publishing that content using Excel Services. This replicates the example offered in the previous section titled “The Excel Services Service Application,” where a manager asks his employees to update a SharePoint list with sales data, and then he exports this to Excel 2010, edits it, and then publishes back to SharePoint 2010 using Excel Services. The home page for the site is then edited to include an Excel Web Access web part that links to the published content.

This example helps to clarify the full process of publishing using Excel Services and then exposing the data using the Excel Web Access web part, ...

Get Microsoft SharePoint 2010 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.