May 2005
Beginner
336 pages
10h 14m
English
Content preview from Essential SharePoint
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,
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.
Creating Web Parts from Excel
You can create custom Spreadsheet web parts from Excel 2003 using the Excel Office Web Part Add-In. Excel web parts can include data bindings, XML Maps, formatting, and complex formulas that are difficult to create from the Spreadsheet web part's browser interface.
The add-in doesn't create a new web part assembly, but rather customizes the existing Spreadsheet web part by adding a new web part description (.dwp) to the site gallery. Before you begin, download and install the components listed in Table 8-5 from http://www.microsoft.com/downloads.
Table 8-5. Downloads for Office web parts
|
Download |
Install on |
Used to |
|---|---|---|
|
Office Web Parts (ststpkpl.exe) |
Server |
Provide Spreadsheet, charting, and pivot table web parts. |
|
Office Web Components (owc11.exe) |
Clients |
Provides interactive features from web parts for Office 2003 users and read-only capability for non-Office 2003 clients. |
|
Excel Office Web Part Add-in (Spreadsheet Add-In.EXE) |
Development machine |
Create custom Spreadsheet web parts from within Excel 2003. |
Tip
The add-in is currently in beta testing. By the time a release version of the add-in is available, some of these procedures and descriptions may have changed.
Installing the add-in appends the Create Add-In menu to Excel. To create a web part from an existing spreadsheet:
Open the workbook containing the spreadsheet in Excel 2003.
Choose Create Add-In. Excel displays the dialog in Figure 8-10.
Enter the name of the SharePoint server you wish to ...
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.