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: Return: none Arguments: none |
MSQueryCheck method |
Queries the registry for the existence of MS Query. Syntax: Return: none Arguments: none |
PivotOutput method |
Creates a Microsoft Excel pivot table output. Syntax: 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
Reference
Visual FoxPro Foundation Classes A-Z
Concepts
Guidelines for Using Visual FoxPro Foundation Classes