Exercise 1: Create Reports using Excel Services
In this exercise you will access an Excel Workbook using the Excel Services REST interface. The results of these REST requests will be integrated into a Word template document using the Open XML SDK and archived in a document repository.
Task 1 – Create the Report Generation web part
In this task, you will create the web part that initiates report generation. You will define the web part’s UI and put the code in place to start the process of building the report.
Task 2 – Use Excel Services REST interface to retrieve the data
In this task, you will add the Excel Services REST requests to the web part to provide the appropriate data to the report generation code.
Task 3 – Configure the report site web parts
In this task, you will place the new web part on the site’s main page and configure the site for use.
Exercise 1 Verification
In order to verify that you have correctly performed all steps of exercise 1, proceed as follows:
Test the Web Part
Test the GenerateReport web part by generating reports for several states.