Property Getters/Setters Summary | ||
---|---|---|
method | getAltTextDescription() | |
method | setAltTextDescription(value) | |
Gets the description of the alt text | ||
method | getAltTextTitle() | |
method | setAltTextTitle(value) | |
Gets the title of the alttext | ||
method | getAutoFormatType() | |
method | setAutoFormatType(value) | |
Gets the PivotTable auto format type. The value of the property is PivotTableAutoFormatType integer constant. | ||
method | getBaseFields() | |
Returns a PivotFields object that includes all fields in the PivotTable report | ||
method | getColumnFields() | |
Returns a PivotFields object that are currently shown as column fields. | ||
method | getColumnGrand() | |
method | setColumnGrand(value) | |
Indicates whether the PivotTable report shows grand totals for columns. | ||
method | getColumnHeaderCaption() | |
method | setColumnHeaderCaption(value) | |
Gets the Column Header Caption of the PivotTable. | ||
method | getColumnRange() | |
Returns a CellArea object that represents the range that contains the column area in the PivotTable report. Read-only. | ||
method | getCustomListSort() | |
method | setCustomListSort(value) | |
Indicates whether consider built-in custom list when sort data | ||
method | getDataBodyRange() | |
Returns a CellArea object that represents the range that contains the data area in the list between the header row and the insert row. Read-only. | ||
method | getDataField() | |
Gets a PivotField object that represents all the data fields in a PivotTable. Read-only.It would be init only when there are two or more data fields in the DataPiovtFiels. It only use to add DataPivotField to the PivotTable row/column area . Default is in row area. | ||
method | getDataFields() | |
Gets a PivotField object that represents all the data fields in a PivotTable. Read-only.It would be init only when there are two or more data fields in the DataPiovtFiels. It only use to add DataPivotField to the PivotTable row/column area . Default is in row area. | ||
method | getDataSource() | |
method | setDataSource(value) | |
Gets and sets the data source of the pivot table. | ||
method | getDisplayErrorString() | |
method | setDisplayErrorString(value) | |
Indicates whether the PivotTable report displays a custom string in cells that contain errors. | ||
method | getDisplayImmediateItems() | |
method | setDisplayImmediateItems(value) | |
Indicates whether items in the row and column areas are visible when the data area of the PivotTable is empty. The default value is true. | ||
method | getDisplayNullString() | |
method | setDisplayNullString(value) | |
Indicates whether the PivotTable report displays a custom string in cells that contain null values. | ||
method | getEnableDataValueEditing() | |
method | setEnableDataValueEditing(value) | |
Specifies a boolean value that indicates whether the user is allowed to edit the cells in the data area of the pivottable. Enable cell editing in the values area | ||
method | getEnableDrilldown() | |
method | setEnableDrilldown(value) | |
Gets whether drilldown is enabled. | ||
method | getEnableFieldDialog() | |
method | setEnableFieldDialog(value) | |
Indicates whether the PivotTable Field dialog box is available when the user double-clicks the PivotTable field. | ||
method | getEnableFieldList() | |
method | setEnableFieldList(value) | |
Gets whether enable the field list for the PivotTable. | ||
method | getEnableWizard() | |
method | setEnableWizard(value) | |
Indicates whether the PivotTable Wizard is available. | ||
method | getErrorString() | |
method | setErrorString(value) | |
Gets the string displayed in cells that contain errors when the DisplayErrorString property is true.The default value is an empty string. | ||
method | getFieldListSortAscending() | |
method | setFieldListSortAscending(value) | |
Specifies a boolean value that indicates whether fields in the PivotTable are sorted in non-default order in the field list. | ||
method | getGrandTotalName() | |
method | setGrandTotalName(value) | |
Returns the text string label that is displayed in the grand total column or row heading. The default value is the string "Grand Total". | ||
method | hasBlankRows() | |
method | setHasBlankRows(value) | |
Indicates whether to add blank rows. This property only applies for the PivotTable auto format types which needs to add blank rows. | ||
method | getIndent() | |
method | setIndent(value) | |
Specifies the indentation increment for compact axis and can be used to set the Report Layout to Compact Form. | ||
method | isAutoFormat() | |
method | setAutoFormat(value) | |
Indicates whether the PivotTable report is automatically formatted. Checkbox "autoformat table "which in pivottable option for Excel 2003 Checkbox "autofit column width on update"which in pivot table Options :Layout Format for Excel 2007 | ||
method | isExcel2003Compatible() | |
method | setExcel2003Compatible(value) | |
Specifies whether the PivotTable is compatible for Excel2003 when refreshing PivotTable, if true, a string must be less than or equal to 255 characters, so if the string is greater than 255 characters, it will be truncated. if false, a string will not have the aforementioned restriction. The default value is true. | ||
method | isGridDropZones() | |
method | setGridDropZones(value) | |
Indicates whether the PivotTable report displays classic pivottable layout. (enables dragging fields in the grid) | ||
method | isMultipleFieldFilters() | |
method | setMultipleFieldFilters(value) | |
Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them. | ||
method | isSelected() | |
method | setSelected(value) | |
Indicates whether the PivotTable is selected. | ||
method | getItemPrintTitles() | |
method | setItemPrintTitles(value) | |
A bit that specifies whether pivot item captions on the row axis are repeated on each printed page for pivot fields in tabular form. | ||
method | getManualUpdate() | |
method | setManualUpdate(value) | |
Indicates whether the PivotTable report is recalculated only at the user's request. | ||
method | getMergeLabels() | |
method | setMergeLabels(value) | |
Indicates whether the specified PivotTable report's outer-row item, column item, subtotal, and grand total labels use merged cells. | ||
method | getMissingItemsLimit() | |
method | setMissingItemsLimit(value) | |
Specifies a boolean value that indicates whether the fields of a PivotTable can have multiple filters set on them. The value of the property is PivotMissingItemLimitType integer constant. | ||
method | getName() | |
method | setName(value) | |
Gets the name of the PivotTable | ||
method | getNullString() | |
method | setNullString(value) | |
Gets the string displayed in cells that contain null values when the DisplayNullString property is true.The default value is an empty string. | ||
method | getPageFieldOrder() | |
method | setPageFieldOrder(value) | |
Gets the order in which page fields are added to the PivotTable report's layout. The value of the property is PrintOrderType integer constant. | ||
method | getPageFields() | |
Returns a PivotFields object that are currently shown as page fields. | ||
method | getPageFieldWrapCount() | |
method | setPageFieldWrapCount(value) | |
Gets the number of page fields in each column or row in the PivotTable report. | ||
method | getPivotFilters() | |
Returns a PivotFilterCollection object. | ||
method | getPivotFormatConditions() | |
Gets the Format Conditions of the pivot table. | ||
method | getPivotTableStyleName() | |
method | setPivotTableStyleName(value) | |
Gets and sets the pivottable style name. | ||
method | getPivotTableStyleType() | |
method | setPivotTableStyleType(value) | |
Gets and sets the built-in pivot table style. The value of the property is PivotTableStyleType integer constant. | ||
method | getPreserveFormatting() | |
method | setPreserveFormatting(value) | |
Indicates whether formatting is preserved when the PivotTable is refreshed or recalculated. | ||
method | getPrintDrill() | |
method | setPrintDrill(value) | |
Specifies a boolean value that indicates whether drill indicators should be printed. print expand/collapse buttons when displayed on pivottable. | ||
method | getPrintTitles() | |
method | setPrintTitles(value) | |
Indicates whether the print titles for the worksheet are set based on the PivotTable report. The default value is false. | ||
method | getRefreshDataFlag() | |
method | setRefreshDataFlag(value) | |
Indicates whether Refresh Data or not. | ||
method | getRefreshDataOnOpeningFile() | |
method | setRefreshDataOnOpeningFile(value) | |
Indicates whether Refresh Data when Opening File. | ||
method | getRefreshDate() | |
Gets the date when the PivotTable was last refreshed. | ||
method | getRefreshedByWho() | |
Gets the name of the user who last refreshed the PivotTable | ||
method | getRowFields() | |
Returns a PivotFields object that are currently shown as row fields. | ||
method | getRowGrand() | |
method | setRowGrand(value) | |
Indicates whether the PivotTable report shows grand totals for rows. | ||
method | getRowHeaderCaption() | |
method | setRowHeaderCaption(value) | |
Gets the Row Header Caption of the PivotTable. | ||
method | getRowRange() | |
Returns a CellArea object that represents the range that contains the row area in the PivotTable report. Read-only. | ||
method | getSaveData() | |
method | setSaveData(value) | |
Indicates whether data for the PivotTable report is saved with the workbook. | ||
method | getShowDataTips() | |
method | setShowDataTips(value) | |
Specifies a boolean value that indicates whether tooltips should be displayed for PivotTable data cells. | ||
method | getShowDrill() | |
method | setShowDrill(value) | |
Gets whether expand/collapse buttons is shown. | ||
method | getShowEmptyCol() | |
method | setShowEmptyCol(value) | |
Specifies a boolean value that indicates whether to include empty columns in the table | ||
method | getShowEmptyRow() | |
method | setShowEmptyRow(value) | |
Specifies a boolean value that indicates whether to include empty rows in the table. | ||
method | getShowMemberPropertyTips() | |
method | setShowMemberPropertyTips(value) | |
Specifies a boolean value that indicates whether member property information should be omitted from PivotTable tooltips. | ||
method | getShowPivotStyleColumnHeader() | |
method | setShowPivotStyleColumnHeader(value) | |
Indicates whether the column header in the pivot table should have the style applied. | ||
method | getShowPivotStyleColumnStripes() | |
method | setShowPivotStyleColumnStripes(value) | |
Indicates whether column stripe formatting is applied. | ||
method | getShowPivotStyleLastColumn() | |
method | setShowPivotStyleLastColumn(value) | |
Indicates whether column stripe formatting is applied. | ||
method | getShowPivotStyleRowHeader() | |
method | setShowPivotStyleRowHeader(value) | |
Indicates whether the row header in the pivot table should have the style applied. | ||
method | getShowPivotStyleRowStripes() | |
method | setShowPivotStyleRowStripes(value) | |
Indicates whether row stripe formatting is applied. | ||
method | getShowRowHeaderCaption() | |
method | setShowRowHeaderCaption(value) | |
Indicates whether row header caption is shown in the PivotTable report Indicates whether Display field captions and filter drop downs | ||
method | getShowValuesRow() | |
method | setShowValuesRow(value) | |
Specifies a boolean value that indicates whether show values row. show the values row | ||
method | getSubtotalHiddenPageItems() | |
method | setSubtotalHiddenPageItems(value) | |
Indicates whether hidden page field items in the PivotTable report are included in row and column subtotals, block totals, and grand totals. The default value is False. | ||
method | getTableRange1() | |
Returns a CellArea object that represents the range containing the entire PivotTable report, but doesn't include page fields. Read-only. | ||
method | getTableRange2() | |
Returns a CellArea object that represents the range containing the entire PivotTable report, includes page fields. Read-only. | ||
method | getTag() | |
method | setTag(value) | |
Gets a string saved with the PivotTable report. |
Method Summary | ||
---|---|---|
method | addCalculatedField(name, formula) | |
Adds a calclulated field to pivot field and drag it to data area. | ||
method | addCalculatedField(name, formula, dragToDataArea) | |
Adds a calclulated field to pivot field. | ||
method | addFieldToArea(fieldType, pivotField) | |
Adds the field to the specific area. | ||
method | addFieldToArea(fieldType, baseFieldIndex) | |
Adds the field to the specific area. | ||
method | addFieldToArea(fieldType, fieldName) | |
Adds the field to the specific area. | ||
method | calculateData() | |
Calculates pivottable's data to cells. | ||
method | calculateRange() | |
Calculates pivottable's range. | ||
method | changeDataSource(source) | |
Set pivottable's source data. Sheet1!$A$1:$C$3 | ||
method | clearData() | |
Clear PivotTable's data and formatting | ||
method | copyStyle(pivotTable) | |
Copies named style from another pivot table. | ||
method | fields(fieldType) | |
Gets the specific fields by the field type. | ||
method | format(row, column, style) | |
Format the cell in the pivottable area | ||
method | formatAll(style) | |
Format all the cell in the pivottable area | ||
method | getCellByDisplayName(displayName) | |
Gets the Cell object by the DisplayName of PivotField | ||
method | getChildren() | |
Gets the the Children Pivot Tables which use this PivotTable data as data source. | ||
method | getHorizontalBreaks() | |
get pivot table row index list of horizontal pagebreaks | ||
method | getSource() | |
Get pivottable's source data. | ||
method | move(row, column) | |
Moves the PivotTable to a different location in the worksheet. | ||
method | move(destCellName) | |
Moves the PivotTable to a different location in the worksheet. | ||
method | refreshData() | |
Refreshes pivottable's data and setting from it's data source. | ||
method | removeField(fieldType, pivotField) | |
Remove field from specific field area | ||
method | removeField(fieldType, baseFieldIndex) | |
Removes a field from specific field area | ||
method | removeField(fieldType, fieldName) | |
Removes a field from specific field area | ||
method | setAutoGroupField(pivotField) | |
Sets auto field group by the PivotTable. | ||
method | setAutoGroupField(baseFieldIndex) | |
Sets auto field group by the PivotTable. | ||
method | setManualGroupField(pivotField, startVal, endVal, groupByList, intervalNum) | |
Sets manual field group by the PivotTable. | ||
method | setManualGroupField(pivotField, startVal, endVal, groupByList, intervalNum) | |
Sets manual field group by the PivotTable. | ||
method | setManualGroupField(baseFieldIndex, startVal, endVal, groupByList, intervalNum) | |
Sets manual field group by the PivotTable. | ||
method | setManualGroupField(baseFieldIndex, startVal, endVal, groupByList, intervalNum) | |
Sets manual field group by the PivotTable. | ||
method | setUngroup(pivotField) | |
Sets ungroup by the PivotTable | ||
method | setUngroup(baseFieldIndex) | |
Sets ungroup by the PivotTable | ||
method | showInCompactForm() | |
Layouts the PivotTable in compact form. | ||
method | showInOutlineForm() | |
Layouts the PivotTable in outline form. | ||
method | showInTabularForm() | |
Layouts the PivotTable in tabular form. | ||
method | showReportFilterPage(pageField) | |
Show all the report filter pages according to PivotField, the PivotField must be located in the PageFields. | ||
method | showReportFilterPageByIndex(posIndex) | |
Show all the report filter pages according to the position index in the PageFields | ||
method | showReportFilterPageByName(fieldName) | |
Show all the report filter pages according to PivotField's name, the PivotField must be located in the PageFields. |
Property Getters/Setters Detail |
---|
isExcel2003Compatible/setExcel2003Compatible : boolean | |
boolean isExcel2003Compatible() / setExcel2003Compatible(value) |
getRefreshedByWho : String | |
String getRefreshedByWho() |
getRefreshDate : DateTime | |
DateTime getRefreshDate() |
getPivotTableStyleName/setPivotTableStyleName : String | |
String getPivotTableStyleName() / setPivotTableStyleName(value) |
getPivotTableStyleType/setPivotTableStyleType : int | |
int getPivotTableStyleType() / setPivotTableStyleType(value) |
getColumnFields : PivotFieldCollection | |
PivotFieldCollection getColumnFields() |
getRowFields : PivotFieldCollection | |
PivotFieldCollection getRowFields() |
getPageFields : PivotFieldCollection | |
PivotFieldCollection getPageFields() |
getDataFields : PivotFieldCollection | |
PivotFieldCollection getDataFields() |
getDataField : PivotField | |
PivotField getDataField() |
getBaseFields : PivotFieldCollection | |
PivotFieldCollection getBaseFields() |
getPivotFilters : PivotFilterCollection | |
PivotFilterCollection getPivotFilters() |
getColumnRange : CellArea | |
CellArea getColumnRange() |
getRowRange : CellArea | |
CellArea getRowRange() |
getDataBodyRange : CellArea | |
CellArea getDataBodyRange() |
getTableRange1 : CellArea | |
CellArea getTableRange1() |
getTableRange2 : CellArea | |
CellArea getTableRange2() |
getColumnGrand/setColumnGrand : boolean | |
boolean getColumnGrand() / setColumnGrand(value) |
isGridDropZones/setGridDropZones : boolean | |
boolean isGridDropZones() / setGridDropZones(value) |
getRowGrand/setRowGrand : boolean | |
boolean getRowGrand() / setRowGrand(value) |
getDisplayNullString/setDisplayNullString : boolean | |
boolean getDisplayNullString() / setDisplayNullString(value) |
getNullString/setNullString : String | |
String getNullString() / setNullString(value) |
getDisplayErrorString/setDisplayErrorString : boolean | |
boolean getDisplayErrorString() / setDisplayErrorString(value) |
getErrorString/setErrorString : String | |
String getErrorString() / setErrorString(value) |
isAutoFormat/setAutoFormat : boolean | |
boolean isAutoFormat() / setAutoFormat(value) |
getAutoFormatType/setAutoFormatType : int | |
int getAutoFormatType() / setAutoFormatType(value) |
hasBlankRows/setHasBlankRows : boolean | |
boolean hasBlankRows() / setHasBlankRows(value) |
getMergeLabels/setMergeLabels : boolean | |
boolean getMergeLabels() / setMergeLabels(value) |
getPreserveFormatting/setPreserveFormatting : boolean | |
boolean getPreserveFormatting() / setPreserveFormatting(value) |
getShowDrill/setShowDrill : boolean | |
boolean getShowDrill() / setShowDrill(value) |
getEnableDrilldown/setEnableDrilldown : boolean | |
boolean getEnableDrilldown() / setEnableDrilldown(value) |
getEnableFieldDialog/setEnableFieldDialog : boolean | |
boolean getEnableFieldDialog() / setEnableFieldDialog(value) |
getEnableFieldList/setEnableFieldList : boolean | |
boolean getEnableFieldList() / setEnableFieldList(value) |
getEnableWizard/setEnableWizard : boolean | |
boolean getEnableWizard() / setEnableWizard(value) |
getSubtotalHiddenPageItems/setSubtotalHiddenPageItems : boolean | |
boolean getSubtotalHiddenPageItems() / setSubtotalHiddenPageItems(value) |
getGrandTotalName/setGrandTotalName : String | |
String getGrandTotalName() / setGrandTotalName(value) |
getManualUpdate/setManualUpdate : boolean | |
boolean getManualUpdate() / setManualUpdate(value) |
isMultipleFieldFilters/setMultipleFieldFilters : boolean | |
boolean isMultipleFieldFilters() / setMultipleFieldFilters(value) |
getMissingItemsLimit/setMissingItemsLimit : int | |
int getMissingItemsLimit() / setMissingItemsLimit(value) |
getEnableDataValueEditing/setEnableDataValueEditing : boolean | |
boolean getEnableDataValueEditing() / setEnableDataValueEditing(value) |
getShowDataTips/setShowDataTips : boolean | |
boolean getShowDataTips() / setShowDataTips(value) |
getShowMemberPropertyTips/setShowMemberPropertyTips : boolean | |
boolean getShowMemberPropertyTips() / setShowMemberPropertyTips(value) |
getShowValuesRow/setShowValuesRow : boolean | |
boolean getShowValuesRow() / setShowValuesRow(value) |
getShowEmptyCol/setShowEmptyCol : boolean | |
boolean getShowEmptyCol() / setShowEmptyCol(value) |
getShowEmptyRow/setShowEmptyRow : boolean | |
boolean getShowEmptyRow() / setShowEmptyRow(value) |
getFieldListSortAscending/setFieldListSortAscending : boolean | |
boolean getFieldListSortAscending() / setFieldListSortAscending(value) |
getPrintDrill/setPrintDrill : boolean | |
boolean getPrintDrill() / setPrintDrill(value) |
getAltTextTitle/setAltTextTitle : String | |
String getAltTextTitle() / setAltTextTitle(value) |
getAltTextDescription/setAltTextDescription : String | |
String getAltTextDescription() / setAltTextDescription(value) |
getName/setName : String | |
String getName() / setName(value) |
getColumnHeaderCaption/setColumnHeaderCaption : String | |
String getColumnHeaderCaption() / setColumnHeaderCaption(value) |
getIndent/setIndent : int | |
int getIndent() / setIndent(value) |
getRowHeaderCaption/setRowHeaderCaption : String | |
String getRowHeaderCaption() / setRowHeaderCaption(value) |
getShowRowHeaderCaption/setShowRowHeaderCaption : boolean | |
boolean getShowRowHeaderCaption() / setShowRowHeaderCaption(value) |
getCustomListSort/setCustomListSort : boolean | |
boolean getCustomListSort() / setCustomListSort(value) |
getPivotFormatConditions : PivotFormatConditionCollection | |
PivotFormatConditionCollection getPivotFormatConditions() |
getPageFieldOrder/setPageFieldOrder : int | |
int getPageFieldOrder() / setPageFieldOrder(value) |
getPageFieldWrapCount/setPageFieldWrapCount : int | |
int getPageFieldWrapCount() / setPageFieldWrapCount(value) |
getTag/setTag : String | |
String getTag() / setTag(value) |
getSaveData/setSaveData : boolean | |
boolean getSaveData() / setSaveData(value) |
getRefreshDataOnOpeningFile/setRefreshDataOnOpeningFile : boolean | |
boolean getRefreshDataOnOpeningFile() / setRefreshDataOnOpeningFile(value) |
getRefreshDataFlag/setRefreshDataFlag : boolean | |
boolean getRefreshDataFlag() / setRefreshDataFlag(value) |
getDataSource/setDataSource : String[] | |
String[] getDataSource() / setDataSource(value) |
getItemPrintTitles/setItemPrintTitles : boolean | |
boolean getItemPrintTitles() / setItemPrintTitles(value) |
getPrintTitles/setPrintTitles : boolean | |
boolean getPrintTitles() / setPrintTitles(value) |
getDisplayImmediateItems/setDisplayImmediateItems : boolean | |
boolean getDisplayImmediateItems() / setDisplayImmediateItems(value) |
isSelected/setSelected : boolean | |
boolean isSelected() / setSelected(value) |
getShowPivotStyleRowHeader/setShowPivotStyleRowHeader : boolean | |
boolean getShowPivotStyleRowHeader() / setShowPivotStyleRowHeader(value) |
getShowPivotStyleColumnHeader/setShowPivotStyleColumnHeader : boolean | |
boolean getShowPivotStyleColumnHeader() / setShowPivotStyleColumnHeader(value) |
getShowPivotStyleRowStripes/setShowPivotStyleRowStripes : boolean | |
boolean getShowPivotStyleRowStripes() / setShowPivotStyleRowStripes(value) |
getShowPivotStyleColumnStripes/setShowPivotStyleColumnStripes : boolean | |
boolean getShowPivotStyleColumnStripes() / setShowPivotStyleColumnStripes(value) |
getShowPivotStyleLastColumn/setShowPivotStyleLastColumn : boolean | |
boolean getShowPivotStyleLastColumn() / setShowPivotStyleLastColumn(value) |
Method Detail |
---|
changeDataSource | |
changeDataSource(source) |
getSource | |
String[] getSource() |
refreshData | |
refreshData() |
calculateData | |
calculateData() |
clearData | |
clearData() |
calculateRange | |
calculateRange() |
formatAll | |
formatAll(style) |
style: Style
- Style which is to formatformat | |
format(row, column, style) |
row: int
- RowIndex of the cellcolumn: int
- Column index of the cellstyle: Style
- Style which is to format the cellsetAutoGroupField | |
setAutoGroupField(baseFieldIndex) |
baseFieldIndex: int
- The row or column field index in the base fieldssetAutoGroupField | |
setAutoGroupField(pivotField) |
pivotField: PivotField
- The row or column field in the specific fieldssetManualGroupField | |
setManualGroupField(baseFieldIndex, startVal, endVal, groupByList, intervalNum) |
baseFieldIndex: int
- The row or column field index in the base fieldsstartVal: float
- Specifies the starting value for numeric grouping.endVal: float
- Specifies the ending value for numeric grouping. groupByList: ArrayList
- Specifies the grouping type list. Specified by PivotTableGroupTypeintervalNum: float
- Specifies the interval number group by numeric grouping.setManualGroupField | |
setManualGroupField(pivotField, startVal, endVal, groupByList, intervalNum) |
pivotField: PivotField
- The row or column field in the base fieldsstartVal: float
- Specifies the starting value for numeric grouping.endVal: float
- Specifies the ending value for numeric grouping. groupByList: ArrayList
- Specifies the grouping type list. Specified by PivotTableGroupTypeintervalNum: float
- Specifies the interval number group by numeric grouping.setManualGroupField | |
setManualGroupField(baseFieldIndex, startVal, endVal, groupByList, intervalNum) |
baseFieldIndex: int
- The row or column field index in the base fieldsstartVal: DateTime
- Specifies the starting value for date grouping. endVal: DateTime
- Specifies the ending value for date grouping.groupByList: ArrayList
- Specifies the grouping type list. Specified by PivotTableGroupTypeintervalNum: int
- Specifies the interval number group by in days grouping.The number of days must be positive integer of nonzerosetManualGroupField | |
setManualGroupField(pivotField, startVal, endVal, groupByList, intervalNum) |
pivotField: PivotField
- The row or column field in the base fieldsstartVal: DateTime
- Specifies the starting value for date grouping.endVal: DateTime
- Specifies the ending value for date grouping.groupByList: ArrayList
- Specifies the grouping type list. Specified by PivotTableGroupTypeintervalNum: int
- Specifies the interval number group by in days grouping.The number of days must be positive integer of nonzerosetUngroup | |
setUngroup(baseFieldIndex) |
baseFieldIndex: int
- The row or column field index in the base fieldssetUngroup | |
setUngroup(pivotField) |
pivotField: PivotField
- The row or column field in the base fieldsgetHorizontalBreaks | |
ArrayList getHorizontalBreaks() |
showInCompactForm | |
showInCompactForm() |
showInOutlineForm | |
showInOutlineForm() |
showInTabularForm | |
showInTabularForm() |
getCellByDisplayName | |
Cell getCellByDisplayName(displayName) |
displayName: String
- the DisplayName of PivotFieldgetChildren | |
PivotTable[] getChildren() |
copyStyle | |
copyStyle(pivotTable) |
pivotTable: PivotTable
- Source pivot table.showReportFilterPage | |
showReportFilterPage(pageField) |
pageField: PivotField
- The PivotField objectshowReportFilterPageByName | |
showReportFilterPageByName(fieldName) |
fieldName: String
- The name of PivotFieldshowReportFilterPageByIndex | |
showReportFilterPageByIndex(posIndex) |
posIndex: int
- The position index in the PageFieldsremoveField | |
removeField(fieldType, fieldName) |
fieldType: int
- A fieldName: String
- The name in the base fields.removeField | |
removeField(fieldType, baseFieldIndex) |
fieldType: int
- A baseFieldIndex: int
- The field index in the base fields.removeField | |
removeField(fieldType, pivotField) |
fieldType: int
- A PivotFieldType.Row |
PivotFieldType.Column |
PivotFieldType.Data |
PivotFieldType.Page |
pivotField: PivotField
- the field in the base fields.addFieldToArea | |
int addFieldToArea(fieldType, fieldName) |
fieldType: int
- A fieldName: String
- The name in the base fields.addFieldToArea | |
int addFieldToArea(fieldType, baseFieldIndex) |
fieldType: int
- A baseFieldIndex: int
- The field index in the base fields.addFieldToArea | |
int addFieldToArea(fieldType, pivotField) |
fieldType: int
- A PivotFieldType.Row |
PivotFieldType.Column |
PivotFieldType.Data |
PivotFieldType.Page |
pivotField: PivotField
- the field in the base fields.addCalculatedField | |
addCalculatedField(name, formula, dragToDataArea) |
name: String
- The name of the calculated fieldformula: String
- The formula of the calculated field.dragToDataArea: boolean
- True,drag this field to data area immediatelyaddCalculatedField | |
addCalculatedField(name, formula) |
name: String
- The name of the calculated fieldformula: String
- The formula of the calculated field.fields | |
PivotFieldCollection fields(fieldType) |
fieldType: int
- A move | |
move(row, column) |
row: int
- row index.column: int
- column index.move | |
move(destCellName) |
destCellName: String
- the dest cell name.