js editor
Web development
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: 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. |