• Examples home • Getting started • Automated encryption • Compare ASP servers • Cookies test centre • Database browser • Menuing system • Office Web Components • Searching CDs • SecureCD • Shopping cart • Slide show • Sync demo • Timed passwords • User entry control • ASP support • Database CDs • Evaluation download • Case studies • Examples • FAQ • Features • License and pricing • What they say

Office Web Components The following information has been copied from the Microsoft web site. The examples below have been adapted from OWebComp.exe, a self-extracting executable file that contains a series of scripting samples. For further information, look here : Q258187. Overview of Office Web Components (OWC) Microsoft® Office 2000 introduced the Office Web Components, a collection of COM controls designed to bring interactive spreadsheet modeling, database reporting, and data visualization to a number of control containers. The OWC library contains four principal components: Spreadsheet, Chart, PivotTable, and Data Source. These components support many of the most commonly used features found in Excel and Access: The Spreadsheet component provides a recalculation engine, a full function library, and a simple worksheet user interface. The Chart component enables you to chart data from a variety of sources. The PivotTable component allows users to sort, group, filter, outline, and manipulate data stored in either traditional or multidimensional data sources. The Data Source component provides the other components with a way to get data. Of the four OWC components, the Data Source component is the only one that does not have a user interface. Note : The OWC controls are not currently installed on this machine. Example 1 : Generate a PivotTable Image This ASP sample uses the OWC.PivotTable component to generate an GIF image. The actual PivotTable is never viewed by the client; instead, the client views an image of the PivotTable that the server generates at runtime using the ExportPicture method. ExportPicture generates a GIF file in the Windows Temporary Directory which is then shown in the browser as a  file://  URL. View source code Example 2 : Generate a Chart Image This ASP script generates a chart using the OWC.Chart component. When the chart has been set with all the desired series and formatting information, the ASP script calls the ExportPicture method to generate a temporary GIF representation of the chart in the Windows Temporary Directory, which is then shown in the browser as a  file://  URL. View source code © Copyright 2000-2007 PHD Computer Consultants Ltd