Exercise 3: Using the Excel Web Viewer Web Part and the REST API to Expose Chart Data
In Exercise 3, you will use the Excel Web Viewer Web Part and REST API to display charts that are based upon the revenue data without exposing the underlying data. Excel Services provides 3 APIs with which developers can access and manipulate Excel document information.
Task 1 – Add an Excel Web Access Web Part
In this task, you will add an Excel Web Access web part to your site and connect it to an existing excel document. The web part will only display what has been published via Excel Web Services.
Task 2 – Discover the REST API
Task 3 – Test Your Solution
In this task, you will modify data within the excel application and see the changes reflected on the RevenueDetails page.