| Category | Automation |
| Default Catalog | Visual FoxPro Catalog\Foundation Classes\Automation |
| Class | pivottable |
| Base Class | Custom |
| Class Library | pivtable.vcx |
| Parent Class | automation |
| Sample | ...\Samples\Vfp98\Solution\Ffc\Automate.scx |
Remarks
This Custom class uses the PivotTable Wizard engine to generate an Excel Pivot Table from FoxPro data.
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. |