PivotTable Object

PivotTable
Multiple objects

Represents the container for a PivotTable list.

Using the PivotTable Object

You can use either the CreateObject method or the New keyword to create a PivotTable object.

The object ID for a PivotTable list on an HTML page returns a PivotTable object. The programmatic identifier for the PivotTable object is CLSID:0002E55A-0000-0000-C000-000000000046. The following example creates a PivotTable list named "PivotTable1" on an HTML page.

<object id=PivotTable1 classid=CLSID:0002E55A-0000-0000-C000-000000000046></object>

Properties | ActiveData Property | ActiveObject Property | ActiveView Property | AllowCustomOrdering Property | AllowDetails Property | AllowFiltering Property | AllowGrouping Property | AllowPropertyToolbox Property | AutoFit Property | BackColor Property | BuildNumber Property | Commands Property | CommandText Property | Connection Property | ConnectionString Property | Constants Property | DataMember Property | DataSource Property | DataSourceName Property | DisplayAlerts Property | DisplayDesignTimeUI Property | DisplayExpandIndicator Property | DisplayFieldList Property | DisplayOfficeLogo Property | DisplayPropertyToolbox Property | DisplayScreenTips Property | DisplayToolbar Property | EditMode Property | HasDetails Property | Height Property | HTMLData Property | Hwnd Property | IsDirty Property | Left Property | MajorVersion Property | MaxHeight Property | MaxWidth Property | MinorVersion Property | Parent Property | ProviderType Property | RevisionNumber Property | RightToLeft Property | Selection Property | SelectionType Property | Toolbar Property | Top Property | UserMode Property | Version Property | ViewOnlyMode Property | Width Property | XMLData Property

Methods | Copy Method | EndEdit Method | Export Method | ExportPicture Method | Refresh Method | Select Method | ShowAbout Method | ShowContextMenu Method | ShowHelp Method | StartEdit Method

Events | BeforeContextMenu Event | BeforeKeyDown Event | BeforeKeyPress Event | BeforeKeyUp Event | BeforeQuery Event | BeforeScreenTip Event | Click Event | CommandBeforeExecute Event | CommandChecked Event | CommandEnabled Event | CommandExecute Event | CommandTipText Event | DataChange Event | DblClick Event | EndEdit Event | KeyDown Event | KeyPress Event | KeyUp Event | MouseDown Event | MouseMove Event | MouseUp Event | MouseWheel Event | OnConnect Event | OnDisconnect Event | PivotTableChange Event | Query Event | SelectionChange Event | StartEdit Event | ViewChange Event

Parent Objects

Child Objects | OCCommands Object | PivotData Object | PivotView Object