xlspivotcache-ag凯发旗舰厅

com.spire.xls.core.spreadsheet.pivottables
class xlspivotcache

java.lang.object
  com.spire.xls.core.spreadsheet.xlsobject
      com.spire.xls.core.spreadsheet.pivottables.xlspivotcache

direct known subclasses:

pivotcache

public class xlspivotcache
extends xlsobject

xlspivotcache

public xlspivotcache(java.lang.object parent)

main class constructor. reservedhandle and parent properties are set.

parameters:

parent - reference to the parent object which will host this object if specified application or parent is null.

xlspivotcache

public xlspivotcache(java.lang.object parent,
                     ixlsrange datarange)

getindex

public int getindex()

gets zero-based cache index.read-only.

getsourcetype

public datasourcetype getsourcetype()

data source is one of: 1 - excel worksheet, 2 - external data, 4 - consolidation, 8 - scenario pivottable. specifies the pivot table cache source type.read-only.

getsourcerange

public ixlsrange getsourcerange()

returns the data source for the pivottable report. read-only. public spire.mergexls.core.ixlsrange sourcerange

getparent

public xlspivotcachescollection getparent()

gets parent object.

overrides:

getparent in class xlsobject

isupgradeonrefresh

public boolean isupgradeonrefresh()

specifies a boolean value that indicates whether the cache is scheduled for version upgrade.

isupgradeonrefresh

public void isupgradeonrefresh(boolean value)

specifies a boolean value that indicates whether the cache is scheduled for version upgrade.

getrefreshedby

public java.lang.string getrefreshedby()

setrefreshedby

public void setrefreshedby(java.lang.string value)

issupportsubquery

public boolean issupportsubquery()

specifies whether the cache's data source supports subqueries

issupportsubquery

public void issupportsubquery(boolean value)

specifies whether the cache's data source supports subqueries

issavedata

public boolean issavedata()

specifies a boolean value that indicates whether the pivot records are saved with the cache.

isoptimizedcache

public boolean isoptimizedcache()

specifies a boolean value that indicates whether the application will apply optimizations to the cache to reduce memory usage

isoptimizedcache

public void isoptimizedcache(boolean value)

specifies a boolean value that indicates whether the application will apply optimizations to the cache to reduce memory usage

getenablerefresh

public boolean getenablerefresh()

specifies a boolean value that indicates whether the user can refresh the cache.

setenablerefresh

public void setenablerefresh(boolean value)

specifies a boolean value that indicates whether the user can refresh the cache.

isbackgroundquery

public boolean isbackgroundquery()

specifies a boolean value that indicates whether the application should query and retrieve records asynchronously from the cache.

isbackgroundquery

public void isbackgroundquery(boolean value)

specifies a boolean value that indicates whether the application should query and retrieve records asynchronously from the cache.

getcreatedversion

public int getcreatedversion()

specifies the version of the application that created the cache. this attribute is application-dependent.

setcreatedversion

public void setcreatedversion(int value)

specifies the version of the application that created the cache. this attribute is application-dependent.

getminrefreshableversion

public int getminrefreshableversion()

specifies the earliest version of the application that is required to refresh the cache.

setminrefreshableversion

public void setminrefreshableversion(int value)

specifies the earliest version of the application that is required to refresh the cache.

getrefreshedversion

public int getrefreshedversion()

specifies the version of the application that last refreshed the cache. this attribute depends on whether the application exposes mechanisms via the user interface whereby the end-user can refresh the cache.

setrefreshedversion

public void setrefreshedversion(int value)

specifies the version of the application that last refreshed the cache. this attribute depends on whether the application exposes mechanisms via the user interface whereby the end-user can refresh the cache.

isinvaliddata

public boolean isinvaliddata()

specifies a boolean value that indicates whether the cache needs to be refreshed.

isinvaliddata

public void isinvaliddata(boolean value)

specifies a boolean value that indicates whether the cache needs to be refreshed.

getsupportadvanceddrill

public boolean getsupportadvanceddrill()

specifies whether the cache's data source supports attribute drilldown.

setsupportadvanceddrill

public void setsupportadvanceddrill(boolean value)

specifies whether the cache's data source supports attribute drilldown.

isrefreshonload

public boolean isrefreshonload()

specifies a boolean value that indicates whether the application will refresh the cache

isrefreshonload

public void isrefreshonload(boolean value)

specifies a boolean value that indicates whether the application will refresh the cache

getrefreshdate

public com.spire.ms.system.datetime getrefreshdate()

gets/sets refresh date of the cache.

setrefreshdate

public void setrefreshdate(com.spire.ms.system.datetime value)

gets/sets refresh date of the cache.

getrangename

public java.lang.string getrangename()

contains the name of the pivot cache namedrange

setrangename

public void setrangename(java.lang.string value)

contains the name of the pivot cache namedrange

hasnamedrange

public boolean hasnamedrange()

indicates whether the pivot cache has named range

inrange

public static boolean inrange(ixlsrange sourcerange,
                              xlsworksheet worksheet,
                              int index,
                              int count,
                              boolean isrow)

indicates whether specified insert row/column operation affected pivot cache in some way.

parameters:

sourcerange -

worksheet -

index -

count -

isrow -

returns: