Method Details

• size

  int size()

  Gets the number of pivot filters in the collection.

  Returns:

  the number of pivot filters

• get

  IPivotFilter get(int index)

  Gets the pivot filter at the specified index.

  Parameters:

  index - the zero-based index of the pivot filter to get

  Returns:

  the pivot filter at the specified index

• add

  IPivotFilter add(PivotFilterType type, Object value1, Object value2, PivotFilterOptions options)

  Adds a new filter to the PivotFilters collection.

  Parameters:

  type - the type of filter

  value1 - the first value for the filter (optional)

  value2 - the second value for the filter (optional)

  options - additional settings for the filter (optional)

  Returns:

  the added pivot filter

• add

  IPivotFilter add(PivotFilterType type, Object value1, Object value2)

  Adds a new filter to the PivotFilters collection.

  Parameters:

  type - the type of filter

  value1 - the first value for the filter (optional)

  value2 - the second value for the filter (optional)

  Returns:

  the added pivot filter

• add

  IPivotFilter add(PivotFilterType type, Object value1)

  Adds a new filter to the PivotFilters collection.

  Parameters:

  type - the type of filter

  value1 - the first value for the filter (optional)

  Returns:

  the added pivot filter

• add

  IPivotFilter add(PivotFilterType type)

  Adds a new filter to the PivotFilters collection.

  Parameters:

  type - the type of filter

  Returns:

  the added pivot filter