Interface ICalculatedItems
- All Superinterfaces:
Iterable<IPivotItem>
A collection of PivotItem objects that represent all the calculated items in the specified PivotTable report.
-
Method Summary
Creates a new calculated item.
Get IPivotItem item by index.
Get IPivotItem item by name.
int
Returns the number of IPivotItem in the collection.
void
-
Method Details
-
getCount
int getCount()
Returns the number of IPivotItem in the collection.
-
get
Get IPivotItem item by index.
- Parameters:
index
- index of calculated item
-
get
Get IPivotItem item by name.
- Parameters:
itemName
- name of calcluated item
-
add
Creates a new calculated item. Returns a PivotItem object.
- Parameters:
name
- The name of the calculated item.
formula
- The formula for the calculated item.
- Returns:
- IPivotItem
-
remove
Remove calculated item
- Parameters:
itemName
- name of calculated item