Programming Microsoft Office 2000 Web Components

by Stearns, Dave

• ISBN13: 9780735607941
• ISBN10: 073560794X
• Edition: CD
• Format: Paperback
• Copyright: 1999-08-01
• Publisher: Microsoft Pr
• More Book Details
• Purchase Benefits

Summary

This solutions-focused guide explains how to create custom IT applications using Web components, one of the new programming capabilities offered in Office 2000. Readers are taught how to use COM controls with various Microsoft tools to publish interactive spreadsheets, charts and databases on the Web. The CD-ROM features source code for business solutions, plus Visual Basic and Visual InterDev templates.

Author Biography

Dave Stearns, a former developer in the Microsoft Information Technology group and a former program manager in the Visual Basic group, is a program manager on the Office Web Components team. He spent the last two years designing and working on features in Microsoft Office 2000, including the Office Web Components. He lives in Seattle, Washington, and is busily working on the next release of the Office Web Components.

Table of Contents

Acknowledgments	xi
Introduction	xiii
Part I Overview of the Office Web Components
Introducing the Office Web Components	3	(12)
Why Were the Office Web Components Created?	4	(2)
What Are the Office Web Components?	6	(5)
The Spreadsheet Component	7	(1)
The Chart Component	8	(1)
The PivotTable Component	9	(1)
The Data Source Component	10	(1)
Where Can You Use the Components?	11	(4)
Data Access Pages and Internet Explorer 5	12	(1)
Using the Office Web Components on a Server	12	(1)
Deployment	13	(1)
What About Netscape Navigator?	13	(2)
The Spreadsheet Component	15	(38)
The Basics of the Spreadsheet Component	15	(18)
Recalculation Engine	15	(3)
Spreadsheet Component User Interface	18	(2)
Sorting and Filtering	20	(7)
Loading Data	27	(5)
Saving Data	32	(1)
Advanced Functionality of the Spreadsheet Component	33	(8)
Property Binding and Real-Time Data	33	(2)
Function Add-Ins	35	(3)
Viewable Range and AutoFit	38	(1)
The Spreadsheet Component as a Data Source	39	(2)
Key Elements of the Programming Model	41	(12)
Working with Enumerations in Script	41	(1)
Getting Data into the Component	42	(1)
Working with Ranges	43	(2)
Formatting	45	(1)
Component-Level Appearance and Behavior	46	(2)
Sorting and Filtering	48	(1)
Protection	48	(2)
Undo	50	(1)
Useful Events	50	(1)
Retrieving Version Information	51	(2)
The Chart Component	53	(44)
The Basics of the Chart Component	53	(33)
The Nomenclature of Charting	54	(7)
Supported Chart Types	61	(10)
Loading Data	71	(11)
Chart and Axis Titles	82	(3)
Axis Labels	85	(1)
The Chart Legend	85	(1)
Advanced Functionality of the Chart Component	86	(6)
Multiple Charts in ``Chart Space''	86	(2)
Server-Side Use	88	(1)
Split Axes	89	(1)
Adjusting an Axis's Scaling	90	(1)
Homemade Chart Tips	90	(2)
Key Elements of the Programming Model	92	(5)
Creating Charts in the Chart Space	92	(1)
Changing Chart or Series Types	92	(1)
Loading the Chart with Data	93	(1)
Exporting a GIF Image	93	(1)
Working with Axes	94	(1)
Manipulating the Legend	95	(1)
Useful Events	95	(2)
The PivotTable Component	97	(50)
Overview	99	(4)
How the PivotTable Component Works with Data	103	(11)
Tabular Data Sources	103	(4)
Multidimensional (OLAP) Data Sources	107	(6)
XML	113	(1)
PivotTable Component Terminology	114	(4)
Totals	115	(1)
Fieldsets and Fields	115	(1)
Members	116	(1)
Row, Column, Filter, and Data Areas (Axes)	116	(1)
UniqueName, Name, and Caption	117	(1)
Basic Programming of the PivotTable Component	118	(16)
Getting Data into the PivotTable Component	118	(4)
Adjusting the View Layout	122	(3)
Creating New Totals for Tabular Sources	125	(1)
Sorting	125	(4)
Filtering	129	(1)
Customizing the View	130	(1)
Applying Formatting Programmatically	131	(2)
Using AutoFit	133	(1)
Advanced Programming Techniques	134	(7)
Saving and Restoring Views	134	(1)
Locking Down a View	135	(1)
Determining Selection for Drill Through	136	(3)
Showing Empty Members	139	(1)
Displaying Visual Totals	139	(1)
Showing Total Captions as Rows	140	(1)
Expanding Automatically	140	(1)
Using the PivotTable Component on a Web Server	141	(1)
Key Elements of the Programming Model	141	(6)
The Data Source Component	147	(22)
Overview	148	(2)
Security	150	(7)
Database Security	150	(3)
Cross-Domain Data Access	153	(4)
Using Remote Data Services	157	(1)
Programming the Data Source Component	158	(11)
Setting Connection Information	158	(1)
Adding a New RecordsetDef	159	(1)
Adding Calculated Fields	160	(2)
Adding Server Filters	162	(1)
Using Parameters	162	(1)
Getting Recordset Objects from the Data Source Component	163	(1)
Executing Ad Hoc Statements and Manipulating the Connection	164	(1)
Catching Data Access Errors	165	(4)
Part II Building Solutions with the Office Web Components
Dynamic and Real-Time Charting	169	(32)
About the Solution	169	(1)
Techniques Illustrated in This Solution	170	(1)
Running the Solution	171	(1)
Creating Server-Side Charts on Demand	172	(9)
Using the Chart Component on the Server	172	(2)
Generating a Server-Side Chart	174	(6)
Other Approaches to Managing Temporary Files	180	(1)
Formatting the Controls from Page Styles	181	(8)
Implementing Functions in the FormatControls.scp File	182	(7)
Reusing the FormatChartFromStyles Function	189	(1)
Building an Interactive Chart Analysis Page	189	(8)
Implementing Chart Tips	189	(3)
Zooming with a Range Slider Control	192	(5)
Charting Real-Time Data	197	(4)
Sales Analysis and Reporting System	201	(30)
About the Solution	201	(1)
Techniques Illustrated in This Solution	202	(1)
Running the Solution	202	(1)
Saving and Reloading Reports	203	(9)
Implementing a Quick Pivot User Interface	212	(3)
Automatically Generating a Title	215	(2)
Emulating Top/Bottom N Filtering	217	(4)
Implementing a Dynamic Chart View	221	(4)
Switching Connection Context	225	(2)
Formatting the Report Based on Page Styles	227	(4)
Timesheet System	231	(32)
About the Solution	231	(1)
Techniques Illustrated in This Solution	232	(1)
Running the Solution	233	(1)
The Timesheet Page	234	(6)
Configuring the Spreadsheet as a Data Entry Form	234	(2)
Binding and Formatting the Charts	236	(4)
Adding and Removing Projects in the Timesheet	240	(8)
Validating Data Entry	248	(2)
Saving and Reloading Timesheets	250	(7)
Submitting a Timesheet	257	(3)
Analyzing Work Hours	260	(1)
The Visitors Log	261	(2)
Using Spreadsheet Models Programmatically	263	(24)
About the Solution	263	(2)
Techniques Illustrated in This Solution	265	(1)
Running the Solution	266	(1)
The Mortgage Spreadsheet	266	(2)
Determining Client Browser Capabilities	268	(2)
The Mortgage Variables Form	270	(2)
Recalculating the Model on the Server	272	(4)
Generating HTML from the Spreadsheet Component	276	(8)
Returning an Interactive Spreadsheet Component	284	(3)
Real-Time Stock Portfolio	287	(22)
About the Solution	287	(1)
Techniques Illustrated in This Solution	288	(1)
Running the Solution	289	(1)
The Nuts and Bolts of Property Binding	289	(3)
The Stock Portfolio Spreadsheet	292	(2)
The Stock Ticker Control	294	(11)
Getting Stock Quote Information the Hard Way	296	(7)
Raising Property Change Notifications in Visual Basic	303	(2)
Handling Errors in the HTML Page	305	(1)
Supporting SaveSnapshot	306	(3)
Building Custom Spreadsheet Function Add-Ins	309	(32)
About the Solution	309	(1)
Techniques Illustrated in This Solution	310	(1)
Running the Solution	311	(1)
Adding a Custom Function Library to the Spreadsheet Component	312	(1)
Implementing Simple Functions	312	(3)
Doublelt---The ``Hello World'' of Custom Functions	313	(1)
Exposing Powerful VBA Functions	314	(1)
Implementing Range-Based Functions	315	(7)
The IXRangeEnum Interface	316	(1)
Getting Cell Values from IXRangeEnum	316	(1)
The Sum TopN and SumBottomN Functions	317	(5)
Implementing Complex Functions with User Interface Builders	322	(19)
The OLAPLookup Function	323	(2)
The OLAPLookup Function Wizard	325	(16)
Deploying the Components	341	(14)
Relationship to Office 2000	341	(1)
Using the Web Installer	342	(8)
Creating a Network Install Image	342	(1)
Specifying the Codebase Attribute	343	(1)
Running the Web Installer	344	(2)
Creating an Installation Page	346	(4)
Customizing Deployment Settings	350	(1)
Office Web Components Files	351	(1)
MDAC 2.1 Files and Core Office and System Files	352	(3)
Index	355