PivotCache

Inheritance: java.lang.Object

public abstract class PivotCache

Represents the memory cache for some PivotTable reports.

Remarks

All data will be gathered into this cache,and the pivot table only get data from this cache,not directly access data source. If data source of some PivotTables are same, they will use a pivot cache.

Constructors

ConstructorDescription
PivotCache()

Methods

MethodDescription
dispose()Release all resource.
equals(Object arg0)
getClass()
getPivotTables()Gets all pivot tables with this pivot cache.
getSourceType()Gets the PivotTableSourceType.
hashCode()
notify()
notifyAll()
refresh()Refreshes data from the data source and calculates data for the view of all pivottables which data source is this pivot cache.
refresh(PivotTableRefreshOption option)Refreshes data from the data source and calculates data for the view of all pivottables which data source is this pivot cache.
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

PivotCache()

public PivotCache()

dispose()

public abstract void dispose()

Release all resource.

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

ParameterTypeDescription
arg0java.lang.Object

Returns: boolean

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

getPivotTables()

public PivotTable[] getPivotTables()

Gets all pivot tables with this pivot cache.

Returns: com.aspose.cells.PivotTable[] -

getSourceType()

public abstract byte getSourceType()

Gets the PivotTableSourceType.

See PivotTableSourceType.

Returns: byte

hashCode()

public native int hashCode()

Returns: int

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

refresh()

public int refresh()

Refreshes data from the data source and calculates data for the view of all pivottables which data source is this pivot cache.

Remarks

If both table1 and table2 use this cache, the two table will calculated. It’s better that you can simply call Workbook.refreshAll() to refresh all pivot tables and charts in the file.

Returns: int

refresh(PivotTableRefreshOption option)

public int refresh(PivotTableRefreshOption option)

Refreshes data from the data source and calculates data for the view of all pivottables which data source is this pivot cache.

Remarks

It’s better that you can simply call Workbook.refreshAll() to refresh all pivot tables and charts in the file.

Parameters:

ParameterTypeDescription
optionPivotTableRefreshOptionThe options for refreshing data source of pivot table.

Returns: int

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

ParameterTypeDescription
arg0long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

ParameterTypeDescription
arg0long
arg1int