IPivotField Interface |
Represents pivot field object.
Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
The IPivotField type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
|
Axis |
Gets/sets field axis.
|
|
|
CanDragOff | |
|
|
CanDragToColumn |
User can drag field to column area.
|
|
|
CanDragToData |
True if the specified field can be dragged to the data position. The default value is True.
|
|
|
CanDragToPage |
User can drag field to page area.
|
|
|
CanDragToRow |
User can drag field to row area.
|
|
|
CustomName |
Gets/sets pivot field custom name.
|
|
|
Formula |
Specifies the formula for the calculated field
|
|
|
IsFormulaField |
Indicates whether this field is formula field
|
|
|
Name |
Returns pivot field name. Read-only.
|
|
|
NumberFormat |
Gets/sets number format.
|
|
|
RepeatItemLabels |
True if the field repeat item labels.
|
|
|
ShowBlankRow |
True if a blank row is inserted after the specified row field in a PivotTable report.
|
|
|
Subtotals |
Gets or sets type of field subtotals.
|
Methods
| Name | Description | |
|---|---|---|
|
AddLabelFilter |
Add label filter for pivot field, only for row and column field.
|
|
|
AddValueFilter |
Add value filter for pivot field, only for row and column field.
|
|
|
CreateGroup(DateTime, DateTime, PivotGroupByTypes ) |
Create group for current field.
|
|
|
CreateGroup(Double, Double, Double) |
Create group for current field.
|
|
|
CreateGroup(DateTime, DateTime, PivotGroupByTypes , Int32) |
Create group for current field.
|
See Also
