September 2007
Beginner
822 pages
23h 3m
English
book
SharePoint 2007: The Definitive Guide
by James Pyles, Christopher M. Buechler, Bob Fox, Murray Gordon, Michael Lotter, Jason Medero, Nilesh Mehta, Joris Poelmans, Christopher Pragash, Piotr Prussak, Christopher J. Regan
Content preview from SharePoint 2007: The Definitive GuideBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
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:
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.