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.
Using the Spreadsheet Web Part
Publishing a spreadsheet as an interactive web page is cool, but unfortunately the data on the page can't be saved. You can view the page, make some changes, and see the result, but the next person to view the page won't see your work.
To create interactive spreadsheets that can save data, create a new web part page and add a spreadsheet web part. The spreadsheet web part is included with the Office 2003 web parts download available from Microsoft. Your SharePoint administrator must install that download on your SharePoint server before you can complete the tasks in this section.
To create a page with a spreadsheet web part:
From the SharePoint site home page, choose Create → Web Part Page.
Enter a name for the new page, choose a layout, select the document library to store the page in, and click Create. SharePoint displays the new page in edit mode.
In the web part task pane, select Virtual Server Gallery. You'll see a list of the web parts installed on your server.
Drag the Office Spreadsheet web part from the task pane to a web part zone on the page. SharePoint adds the web part to the page, as shown in Figure 5-24 .
Close the web part task pane and click OK to save the changes.
Figure 5-24. Creating a web part page containing a spreadsheet
Once you've created a web part page containing a spreadsheet web part, you can edit the cells on the spreadsheet directly ...
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.