Microsoft Office XP Web Components

Some of the powerful functionality of Microsoft Excel 2002 can be made available outside of Microsoft Excel via a collection of ActiveX controls known as Microsoft XP web components. This collection is composed of four components: a spreadsheet, chart, pivot table, and data source. Web components can be used not only in web pages (as the name implies) but also in other applications and environments, such as Microsoft Access, Visual Basic, and C++.

Let's say you need to display information on a web site or an Access form in an Excel-like interface. By incorporating the Spreadsheet component into your application, you can provide your users with features that Microsoft Excel handles extremely well: recalculation, filtering, and sorting. Or, if you want to perform these operations just in the background, you can use the Spreadsheet component as an invisible calculation engine. The Chart component will allow you to create flexible solutions that require graphing, while the PivotTable component will provide your users with data manipulation options for viewing data from different perspectives, similar to those found in the built-in Excel PivotTable feature. The fourth component, Data Source, does not have a graphical user interface. It is invisible to the user and used for managing connections to a database and binding to other web components.

Tip: Licensing Required. To personally use Microsoft Office XP web components, you must have the Microsoft Office XP web components installed and an appropriate Office XP license. If your applications utilize Office XP web components, your users do not need to have Office XP installed on their computers, but they do need to have a license for it. You can get an Office XP site license that permits intranet distribution and configure the components to allow the users to download them from your corporate intranet.

Each Office web component is identified with a ClassId, as shown below:

Component Name ClassId

Spreadsheet classid="CLSID:0002E510-0000-0000-C000-000000000046"

Chart classid="CLSID:0002E500-0000-0000-C000-000000000046"

PivotTable classid="CLSID:0002E520-0000-0000-C000-000000000046"

Data Source classid="CLSID:0002E530-0000-0000-C000-000000000046"

If used on web pages, web components require Internet Explorer 4.01 or later. For best functionality, use Internet Explorer 5 or later. To use web components in other applications, make a reference to the Microsoft Office XP Web Components Library (OWC10). This library is stored in C:\Pro-gram Files\Common Files\Microsoft Shared\Web Components\10\OWC-10.DLL. After setting up a reference to the OWC10 Library, you can open the Object Browser and take a look at numerous properties, methods, and events that you can use to manipulate various web components.

0 0

Post a comment