Introduction
The Office Web Components (OWC) are COM controls that provide developers a means for analyzing and reporting data
It mainly consists of 4 components
Spreadsheet component
Chart component
PivotTable® component
Data Source control
OWC Features Specific to the Web Environment
Height and width tags
AutoFit property provides automatic resizing to fit controls to their contents, which eliminates the need for internal scroll bars
Supports the same color table as Internet Explorer
Chart Component
Microsoft Office Web Components to build graphs on the fly both in GUI applications and Web applications and introduce a class that you can use to simplify using those components for easy graphing of data.
Graphing can add dramatic visual impact to your applications. For many application that use complex data graphing is an indispensable tool for providing a consolidated view of the data.
The Chart component is comparable to a small version of Excel charting, supporting most of the art types in Excel as well as a Polar art type.
Basic Features
Supports nearly 60 graph/chart types like Column, Bar, Pie, Line, Stock, Area, Doughnut and their variants etc
Multiple charts can exist in a single “chart space” Category and Value axes,Series,Data label,Legend
Combination Charts
Each series has its own type of data
Types that can be used in a combination chart are Column, Line, and Area etc
Using a secondary value axis
Secondary value axis added via the Chart object model will have the same scaling as the primary value axis
oTo achieve separate scaling for value axes, publish chart interactively from Excel
Manipulating a chart
Emphasize an object in the Chart Use the Selection Change Event
Zooming on Chart Data Manipulate the Axes and Scaling objects
Create a Chart with Hotspots Use the RangeFromPoint method to manipulate the points to be considered
Office Web Components (OWC) Chart/Graphs Types
The names of the Chats/graphs are as follows
ColumnClusteredChart,
ColumnStackedChart ,
ColumnStacked100Chart,
BarClusteredChar,
BarStackedChart ,
BarStacked100Chart,
LineChart,
LineMarkersChart,
LineStackedChart,
LineStackedMarkers,
LineStacked100,
LineStacked100Markers,
SmoothLine,
SmoothLineMarkers,
SmoothLineStacked,
SmoothLineStackedMarkers,
SmoothLineStacked100,
SmoothLineStacked100Markers
Pie,
PieExploded,
PieStacked ScatterMarkers,
ScatterSmoothLineMarkers
ScatterSmoothLine,
ScatterLineMarkers,
ScatterLine,
ScatterLineFilled,
Bubble,
BubbleLine,
Area,
AreaStacked,
AreaStacked100,
Doughnut,
DoughnutExploded,
RadarLine,
RadarLineMarkers,
RadarLineFilled,
RadarSmoothLine,
RadarSmoothLineMarkers,
StockHLC,
StockOHLC,
PolarMarkers,
PolarLine,
PolarLineMarkers,
PolarSmoothLine,
PolarSmoothLineMarkers,
Column3D,
ColumnClustered3D,
ColumnStacked3D,
ColumnStacked1003D,
Combo3DChart
Bar3D,
BarClustered3D,
BarStacked3D,
BarStacked1003D,
Line3D,
LineOverlapped3D,
LineStacked3D,
LineStacked1003D,
Pie3D,
PieExploded3D,
Area3D,
AreaOverlapped3D,
AreaStacked3D etc,
Benefits
Around 60 varieties of charts/graphs can be drawn like line, Pie, column, Stock etc and their variants.
3D charts/graphs are possible.
No third party component is required use Microsoft Office and adds web components reference to the project.
Cost efficient as it comes with MSOffice.
Saving Reports
XMLData Property
Export method
Export Picture Method
Use to create locked-down reports that are non-interactive
Use for displaying report Gifs in unsupported browsers like Navigator
The OWC can coexist with versions of Office prior to 2000 and onwards
Automatic download from the browser CODEBASE tag
Requires an Office 2000 License and onwards
System Requirements:
Windows® 95/98, Windows NT® 4.0, or
Windows 2000 onwards
Interactive use of components requires Internet Explorer 4.01 or greater
OWC Support
The OWC support on various containers are tabulated as follows
Container Test Coverage
Microsoft Internet Explorer 5.0 Full
Microsoft Internet Explorer 4.01 Full
Microsoft Internet Explorer 3.x Not supported
Microsoft Visual Basic 6.0 Full
Microsoft Visual Basic 5.0 Basic
Microsoft Visual InterDev® Basic
Microsoft Access Forms Basic
Microsoft Office User Forms Basic
Microsoft FrontPage 99 Full
Microsoft FrontPage 98 Basic
Microsoft Access 2000 Data Access Page Designer Full
Microsoft Script Editor Full
Microsoft Word 2000 Basic
Microsoft Excel 2000 Basic
Microsoft PowerPoint® 2000 Basic
Microsoft Outlook® 2000 Basic
Microsoft Visual C++/MFC Projects None
Microsoft Visual J++ None
Resources for the OWC
Books
• The O.W.C Black Book 2nd Edition - Alvin Bruney 2007
• Professional ASP Programming Guide for Office Web Components: With Office 2000 and Office XP - Qimao Zhang 2001
• Programming Microsoft Office 2000 Web Components
Microsoft Press, Author: Dave Stearns
ISBN:0-7356-0794-X
• Inside Microsoft Visual Basic, Scripting Edition
Microsoft Press, Author: Scott Hillier
ISBN:ISBN 1-57231-444-3
• Professional Active Server Pages 2.0
WROX Press, Authors: Francis, Fedorov, Harrison, Homer, Murphy, Sussman, Smith and Wood
ISBN:1-861001-26-6
|
| Author: Deepika Haridas 23 Jul 2009 | Member Level: Diamond Points : 1 |
Hi,
Format your Article as per the guidelines provided.
--
Thanks & Regards,
Deepika
Editor
|