Professional ASP Programming Guide for Office Web Component: With Office 2000 and Office XP

by Qimao Zhang

Overview

Professional OWC programming with Office 2000 and Office XP.

This book is the definite guide for professional programming with Office Web Components (OWC). The book contains detailed and ready-to-go code samples that have been fully tested in the real working environment. Both Office 2000 and Office XP web developers will find that this book is a complete and useful reference. The book covers all aspects of Chart component, PivotTable component, and Spreadsheet component with complete code samples. In addition, the book includes up-to-date code source such as Office XP Web Component Toolpack. Professional ASP Programming Guide is written for programmers and web developers who want to create powerful, dynamic, visually arresting, and information enriched web sites.

Product Details

ISBN-13:	9780595198467
Publisher:	iUniverse, Incorporated
Publication date:	09/01/2001
Pages:	328
Product dimensions:	6.24(w) x 9.10(h) x 0.83(d)

Table of Contents

Chapter 0	Good Programming Practice	1
	Write Self-Documenting Code	1
	Always Use "Option Explicit"	4
	Provide Useful Comments	5
	Robust Programming	7
	Review before Release	9
	Code Reuse and Efficiency	11
Chapter 1	Introduction to Office Web Components	15
	Installation	16
	Types of OWC Components	16
	The Chart Component	18
	The Spreadsheet Component	20
	The PivotTable Component	21
	The Data Source Component	22
	What's New in Office XP OWC	23
Chapter 2	Introduction to Chart Component	40
	Chart Types	40
	Chart Elements	44
	The Chart Area	45
	The Plot Area	46
	Chart Titles	47
	Legend	48
	Series	49
	Values	50
	Axes	50
	Gridlines	51
	Error Bars	52
	Trendline	53
	Data labels	55
Chapter 3	Programming Chart Component	58
	Pie Chart	59
	Line Chart	70
	Area Chart	84
	Column Chart & Bar Chart	87
	Gantt Chart	98
	XY Scatter Chart	106
	Stock Chart	118
	Doughnut Chart	126
	Radar Chart	128
	Bubble Chart	131
	Polar Chart	133
	Combination Chart	135
	Create Multiple Charts in the Same Chart Space	141
Chapter 4	Advanced Charting Techniques	146
	Split Axis	147
	Add Data Labels	149
	Create Chart Methods	151
	Create chart as an object	151
	Create Chart as Bitmap Image	153
	Cleanup Methods	155
	Create Chart using XML Data	156
Chapter 5	Introduction to PivotTable Component	163
	Data Sources	164
	Tabular Data Source Sample	166
	PivotTable Component Properties and Methods	177
Chapter 6	Advanced Techniques for PivotTable Component	182
	AutoFit	183
	Auto-expansion	184
	Export Pivot Table as an Image	184
	Display Empty Members	185
	Display Total for All Members	186
	Sorting and Filtering	186
	Behaviors	188
	DHTML Behavior Usage	189
	Cell Coloring	192
	Drillthrough	200
	Actions	210
	Printing	216
Chapter 7	Introduction to Spreadsheet Component	219
	Populating the Spreadsheet Component	220
	Properties, Methods, and Events	225
	Office XP Code Sample	233
Chapter 8	Advanced Techniques for Spreadsheet Component	238
	Programming Spreadsheet Component in VB	239
	Build Spreadsheet XML	244
	Bugs	250
Chapter 9	Date Source Component	253
	Introduction	254
	Data Source component Objects	257
	Data Source component events	264
	The Layout of a Data Access Page	270
Chapter 10	Office XP Web Component Toolpack	274
	Download	276
	Installation	278
	Uninstall or Reinstall	284
Appendix A	Active Server Pages Object Model	287
Appendix B	VB Script Reference	293
	Index	307