Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Help and How-to
Search
Search
 
Check for updates: (c) Microsoft
Microsoft Update
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Office XP Web Components: Spreadsheets
 
Applies to
Microsoft Office XP

Office Web Components is a set of ActiveX® controls installed with Office XP. However, if you previously chose not to install this set, you can download it from Office XP Tool: Web Components, on Office Online .

With a spreadsheet, you can enter and perform calculations on data or create lists of information. When you enter data into the cells of the spreadsheet, you can create formulas that perform calculations on the data just as you would create formulas in Microsoft Excel.

The following example is a spreadsheet on a Web page designed to be used as a mortgage calculator. When the user changes the values in the bordered input cells in the browser, the spreadsheet calculates the mortgage payment.

Mortgage spreadsheet

The Spreadsheet component provides formulas, totals, and sorting and filtering functionality, just as you find in Excel worksheets. Users can take advantage of Excel worksheet functions as well.

In calculations, you can use data from spreadsheet cells or other controls on the page, as well as URLs using the document object model in Microsoft Internet Explorer. You can create Web pages with spreadsheets by either publishing a worksheet using Excel, or by inserting a Spreadsheet component using the data access page Design view in Microsoft Access or Microsoft FrontPage®.

For more information about creating and using spreadsheets, see Excel Help.

advertisement