Page 376 - Microsoft Office Excel 2003 Programming Inside Out

Part 5: Manipulating Excel Objects
Microsoft Office Excel 2003 Programming Inside Out

Table 16-2. Key Properties and Methods of the PivotTable Object
Property/Method Description
AddDataField(Field, Caption, Method: This routine adds a data field to a PivotTable.
Function) Field is a PivotField object associated with the PivotTable.
Caption contains a value that will be used to label the
specified PivotField (optional). Function specifies the
summary function performed on the data field.
CalculatedFields Method: returns a CalculatedFields collection, which
contains the set of PivotField objects, which are
computed based on other fields in the PivotTable.
ColumnFields Property (read-only): returns either a PivotField object or a
PivotFields collection containing the fields that are
currently displayed as column fields.
ColumnGrand Property: when True, the PivotTable report displays grand
totals for each column in the PivotTable object.
DataFields Property (read-only): returns either a PivotField object or a
PivotFields collection containing the fields that are
currently displayed as data fields.
DisplayErrorString Property: when True, any cells with errors will display the
text in the ErrorString property.
DisplayNullString Property: when True, any cells with null values will display
the text in the NullString property.
ErrorString Property: contains the text that will be displayed in cells
with errors, if the DisplayErrorString property is True.
Format (format) Method: sets the PivotTable’s format to one of the
Chapter 16
formats specified in XlPivotFormatType. Valid formats are
xlPTClassic, xlPTNone, xlPTReport1 to xlPTReport10, and
xlPTTable1 to xlPTTable10.
HiddenFields Property (read-only): returns either a PivotField object or a
PivotFields collection containing the fields that are not
currently displayed as row, column, page, or data fields.
Name Property: contains the name of the PivotTable.
NullString Property: contains the text that will be displayed in cells
with null values when the DisplayNullString property
is True.
PageFields Property (read-only): returns either a PivotField object or a
PivotFields collection containing the fields that are
currently displayed as page fields.

350