5.5. Using the Spreadsheet Web PartPublishing 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:
animal 5-24. Creating a web part page containing a spreadsheetOnce you've created a web part page containing a spreadsheet web part, you can edit the cells on the spreadsheet directly in the browser. Figure 5-25 shows a Loan Calculator created on the web part page. The main difference between this version of the Loan Calculator and the one shown in Figure 5-23 is that the data can be saved with the page. There are also other differences between using the Office Spreadsheet web part and publishing a spreadsheet as a web page:
animal 5-25. Displaying a spreadsheet as a web partThe loan calculator example in Figure 5-23 is a somewhat tired example, but it does illustrate some of these differences well. In order to get it to work as a web part, I had to:
You may encounter other differences when using the Office Web Components as web parts rather than publishing as a web page.
|