Displaying Workbooks in Web Parts
One of the most important functions of Excel Services is that it allows a Web Part to display a workbook. The next example will examine the scenario where a workbook is loaded in a Web Part and displayed in SharePoint.
To load a workbook in a SharePoint Web Part, open the portal and select Edit Page from the Site Actions menu. Click on Add New Web Part. Select the Excel Web Part. Click on Click Here To Open The Tool Pane to open the tool pane. You can also open the tool pane for any Web Part by clicking the Edit button in the Web Part zone and selecting Modify Shared Web Part. Enter the path to a valid workbook in the Excel Web Access tool pane. Figure 3-18 shows Excel Web Access with a loaded spreadsheet.
Figure 3-18. Excel ...
Get Programming Excel® Services 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.
