Chapter 18. Creating, Editing, and Managing Excel Documents with SharePoint
Introduction
MOSS 2007 makes extensive use of Microsoft Excel 2007 in organizing and presenting information to teams, departments, and organizations. The primary methods of sharing data between Excel worksheets and workgroups and SharePoint are through Excel Services and Excel Web Access.
Excel Services is defined by three components:
Excel Calculation Services (ECS) is the core of Excel Services, in some ways like the Report Center is the engine behind MOSS 2007 Business Intelligence. ECS loads worksheet and workbook data, calculates and refreshes internal and external data, and maintains connection sessions.
Excel Web Access (EWA) is a specific Web Part that allows you to access and interact with an Excel workbook from a web browser using Dynamic Hypertext Tag Markup Language (DHTML) and JavaScript. EWA can be connected to other Web Parts or Web Part Pages.
Excel Web Services (EWS) is a MOSS 2007 Web Service that offers numerous ways for a software engineer to use an Application Programming Interface (API) to develop applications based on data contained in an Excel workbook.
As a fully integrated component of MOSS 2007, you can take advantage of many SharePoint features to create, modify, and manage Excel workbooks directly from a SharePoint site.
The Excel Web Access Web Part displays spreadsheet information on a Web Part page in a format very similar to an Excel workbook. Features of the Web Part include:
Get SharePoint 2007: The Definitive Guide 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.
