Share via


Pivot Table Foundation Class

This Custom class uses the PivotTable Wizard engine to generate an Excel pivot table from FoxPro data.

Category

Automation

Default Catalog

Visual FoxPro Catalog\Foundation Classes\Automation

Class

pivottable

Base Class

Custom

Class Library

pivtable.vcx

Parent Class

automation

Sample

...\Samples\Solution\Ffc\Automate.scx

Remarks

To use, drop the class on a project or form or, from the Component Gallery Item shortcut menu, select Add to Project or Add to Form. When you add the class to a form in a data environment, Visual FoxPro opens a builder so you can specify the cPivFldCol, cPivFldRow, cPivFldPage, cPivFldData, lHasColumnTotals, and lHasRowTotals values. When you drop the class on a project, you can choose between adding the class or creating a subclass.

See Guidelines for Using Visual FoxPro Foundation Classes for more information on using foundation classes.

Properties, Events, Methods

Description

CheckState property

Specifies whether to test the state of Microsoft Excel through an error routine.

Default: .F.

cOutfile property

Specifies the name of the output file.

Default: ""

cPivFldCol property

Specifies the name of the field that identifies each pivot table column.

Default: ""

cPivFldData property

Specifies the name of the field reported as pivot table data.

Default: ""

cPivFldPage property

Specifies the name of the field that determines the pivot table pages.

Default: ""

cPivFldRow property

Specifies the name of the field whose values identify each pivot table row.

Default: ""

lHasColumnTotals property

Specifies whether to total columns.

Default: .F.

lHasRowTotals property

Specifies whether to total rows.

Default: .F.

nAction property

Specifies the output action to perform. Output action:

1 = Microsoft Excel worksheet

Default: 1

GetXLPath method

Queries the registry for the existence of Microsoft Excel.

Syntax: GetXLPath( )

Return: none

Arguments: none

MSQueryCheck method

Queries the registry for the existence of MS Query.

Syntax: MSQueryCheck( )

Return: none

Arguments: none

PivotOutput method

Creates a Microsoft Excel pivot table output.

Syntax: PivotOutput( )

Return: none

Arguments: none

aFldList[1,1] property

Internal to the class.

cFormName property

Internal to the class.

cFormSCX property

Internal to the class.

CheckFldLen method

Internal to the class.

GetDOSName method

Internal to the class.

lHasMSQry32 property

Internal to the class.

lHasNoTask property

Internal to the class.

lIsNumeric property

Internal to the class.

SkipError property

Internal to the class.

See Also

Concepts

Guidelines for Using Visual FoxPro Foundation Classes

Reference

Visual FoxPro Foundation Classes A-Z

Other Resources

Foundation Class Samples