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.
Publishing as a Web Page
Publishing a workbook or a worksheet as a web page was introduced in Excel 2000. It allows you to save all or part of a workbook in HTML format so that others can view it from a web site. You can even save the page in an interactive format that allows other Excel users to use the page to perform calculations.
You can publish web pages from Excel to a SharePoint site using the same steps as you do for any other web site:
In Excel, open the workbook to publish as a web page.
Choose File → Save as Web Page. Excel displays Figure 5-22 .
Enter the address of a document library in a SharePoint site (for example, http://wombat1/Chapter 5 Samples/Shared Documents/).
Select Add interactivity to allow other Excel users to change data on the page and perform calculations.
Enter a name for the page, and choose Save. Excel saves the workbook or worksheet as a web page in the SharePoint document library.
Tip
If you want to view additional web publishing options, in step 5, choose Publish rather than Save.
Figure 5-22. Publishing a worksheet as a SharePoint web page
It's also possible to publish the page outside a document library. For example, if you specify http://wombat1/Chapter 5 Sample/LoanCalc.htm in step 3, the page will be published at the root level of the workspace. However, it's harder to edit or delete files saved outside of document libraries.
To view the newly published ...
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.