Interface IPivotItem
public interface IPivotItem
Represents an item in a PivotTable field. The items are the individual data entries in a field category. The PivotItem object is a member of the PivotItems collection. The PivotItems collection contains all the items in a PivotField.
Method Summary
All Methods Instance Methods Abstract Methods
Gets the formula of calculated item.
Gets the name of the object.
int
Gets the Position of the item in its field if the item is currently showing.
boolean
Gets if the outline is expanded for the specified range (so that the detail of the column or row is visible).
Returns the specified object’s name as it appears in the original source data for the specified PivotTable report.
boolean
Determines whether the object is visible.
void
Sets the formula of calculated item.
void
Sets the name of the object.
void
Sets the Position of the item in its field if the item is currently showing.
void
Sets whether the outline is expanded for the specified range (so that the detail of the column or row is visible).
void
Determines whether the object is visible.
Method Details
getName
Gets the name of the object.
setName
Sets the name of the object.
getPosition
int getPosition ()
Gets the Position of the item in its field if the item is currently showing.
setPosition
void setPosition (int value)
Sets the Position of the item in its field if the item is currently showing.
getShowDetail
boolean getShowDetail ()
Gets if the outline is expanded for the specified range (so that the detail of the column or row is visible).
Returns:
the value indicates if the pivot item is expanded.
setShowDetail
void setShowDetail (boolean value)
Sets whether the outline is expanded for the specified range (so that the detail of the column or row is visible).
Parameters:
value
- indicates if the pivot item is expanded.
getSourceName
Returns the specified object’s name as it appears in the original source data for the specified PivotTable report. This might be different from the current item name if the user renamed the item after creating the PivotTable report .
getVisible
boolean getVisible ()
Determines whether the object is visible.
setVisible
void setVisible (boolean value)
Determines whether the object is visible.