Using Office Documents in a Web World

Adding Interactive Web Controls to Office Documents

Microsoft Office Web Components are a family of controls that can be used in Microsoft Internet Explorer to enable interactive browsing of Office data. Certain Office documents can be saved in interactive HTML format. The saved HTML file contains Office Web Components that are bound to the data in the document. The data can be manipulated and modified in Internet Explorer.

Spreadsheet component

The Spreadsheet Component displays data in a grid format similar to a Microsoft Excel worksheet. Values in the grid can be modified and formatted. The Property toolbox offers formatting, display, calculation, and search tools in the browser window.

Top

PivotTable component

The PivotTable Component brings the functionality of PivotTables to Internet Explorer. Multidimensional data can be manipulated and modified in the browser window by using this component.

Top

Chart component

Interactive charting is made possible with the Chart Component. A Chart component is bound to the data of a Spreadsheet or PivotTable Component. When a user modifies the bound data in Internet Explorer, the Chart component is updated to reflect the new data.

Top

Data Source component and data access pages

The Data Source Component displays relational data in Internet Explorer. Data can be grouped by fields, and then browsed in the same way it can be in an Access form. Data access pages created in Microsoft Access use the Data Source component to provide interactive database control on published HTML documents.