[]
        
(Showing Draft Content)

ICalculatedItems

Interface ICalculatedItems

All Superinterfaces:
Iterable<IPivotItem>

public interface ICalculatedItems extends Iterable<IPivotItem>
A collection of PivotItem objects that represent all the calculated items in the specified PivotTable report.
  • Method Details

    • getCount

      int getCount()
      Returns the number of IPivotItem in the collection.
    • get

      IPivotItem get(int index)
      Get IPivotItem item by index.
      Parameters:
      index - index of calculated item
    • get

      IPivotItem get(String itemName)
      Get IPivotItem item by name.
      Parameters:
      itemName - name of calcluated item
    • add

      IPivotItem add(String name, String formula)
      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

      void remove(String itemName)
      Remove calculated item
      Parameters:
      itemName - name of calculated item