Figure D

Use the Object Browser to look up properties, methods, and events of the Spreadsheet, Chart, PivotTable, and Data Source web components.

Object Browser

tfFM

|owcio

il

J N IJÜ

I Spreadsheet

~3M

F

aearun ricyuiLS I

| Library | Class

J Member

jU\ OWC10 M Spreadsheet hrj

! Classes

I Members of'Spreadsheet'

0 SchemaRowsource

d

ef

ActiveCeil

M

^ SchemaRowsources

iff

ActiveSheet

\

Section

S1

ActiveWindow

0 Sheets

iff

ActiveWorkbook

[Ml Spreadsheet S

ef

Al 1 owP ro p e rtvTo o 1 b ox

SublistRelationships

Application

ijSi SublistSchemaRelationsh

Auto Fit

0 TitleBar

m

Build

Window

eff

BuildNumber

^ Windows

iff

Calculation

Workbook

CalcuiationVersion

0 Workbooks

eff

CanUndo

© Worksheet

üf?

Caption

IS Worksheets

d

ef

Cells

1 Class Spreadsheet

ä

Member of OWCIO

Microsoft Office Spreadsheet 10.0

d

You can find a lot of useful information on the OWC10 object model and many code samples in the online help files located in the folder C:\Program Files\Common Files\Microsoft Shared\Web Components\10\1033. Consider this appendix as a quick, hands-on introduction to scripting web components from a web page.

0 0

Post a comment