編輯

共用方式為


XlPivotCellType Enum

Definition

Specifies the PivotTable entity the cell corresponds to.

public enum class XlPivotCellType
public enum XlPivotCellType
Public Enum XlPivotCellType
Inheritance
XlPivotCellType

Fields

Name Value Description
xlPivotCellValue 0

Any cell in the data area (except a blank row).

xlPivotCellPivotItem 1

A cell in the row or column area which is not a subtotal, grand total, custom subtotal, or blank line.

xlPivotCellSubtotal 2

A cell in the row or column area which is a subtotal.

xlPivotCellGrandTotal 3

A cell in a row or column area which is a grand total.

xlPivotCellDataField 4

A data field label (not the Data button).

xlPivotCellPivotField 5

The button for a field (not the Data button).

xlPivotCellPageFieldItem 6

The cell that shows the selected item of a Page field.

xlPivotCellCustomSubtotal 7

A cell in the row or column area that is a custom subtotal.

xlPivotCellDataPivotField 8

The Data button.

xlPivotCellBlankCell 9

A structural blank cell in the PivotTable.

Applies to