O'Reilly logo

Programming Excel® Services by Alvin Bruney

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required