ipivottable-ag凯发旗舰厅

com.spire.xls.core
interface ipivottable

all known implementing classes:

pivottable, xlspivottable

public interface ipivottable

represents pivot table object.

getname

java.lang.string getname()

gets pivot table name. read-only.

returns:

getpivotfields

pivottablefields getpivotfields()

gets collection of pivot fields. read-only.

returns:

getdatafields

pivotdatafields getdatafields()

gets collection of pivot table data fields. read-only.

returns:

isrowgrand

boolean isrowgrand()

gets/sets value indicating whether the pivottable contains row with grand totals for columns (same as rowgrand in vba).

returns:

iscolumngrand

boolean iscolumngrand()

gets/sets value indicating whether the pivottable contains column with grand totals for rows (same as columngrand in vba).

returns:

getshowdrillindicators

boolean getshowdrillindicators()

the showdrillindicators property is used for toggling the display of drill indicators in the pivottable.

returns:

getdisplayfieldcaptions

boolean getdisplayfieldcaptions()

gets/sets value controlling whether or not filter buttons and pivotfield captions for rows and columns are displayed in the grid.

returns:

getrepeatitemsoneachprintedpage

boolean getrepeatitemsoneachprintedpage()

true if row, column, and item labels appear on the first row of each page when the specified pivottable report is printed. false if labels are printed only on the first page. the default value is true.

returns:

getbuiltinstyle

pivotbuiltinstyles getbuiltinstyle()

gets/sets built-in pivot style.

returns:

getshowrowgrand

boolean getshowrowgrand()

gets/sets value indicating whether the pivottable contains grand totals for rows.

returns:

getshowcolumngrand

boolean getshowcolumngrand()

gets/sets value indicating whether the pivottable contains grand totals for columns.

returns:

getcacheindex

int getcacheindex()

gets index of the pivot cache.read-only.

returns:

getlocation

cellrange getlocation()

returns pivot table location.

returns:

getoptions

ipivottableoptions getoptions()

represents the pivot table options.read-only

returns:

getrowsperpage

int getrowsperpage()

specifies the number of rows per page for this pivottable that the filter area will occupy.read-only.

returns:

getcolumnsperpage

int getcolumnsperpage()

specifies the number of columns per page for this pivottable that the filter area will occupy.

returns:

getcalculatedfields

ipivotcalculatedfields getcalculatedfields()

returns the collection of calculated fields of the specified pivot table.read-only.

returns:

getpagefields

ipivotfields getpagefields()

returns the collection of page field for the specified pivot table,read-only.

returns:

getrowfields

ipivotfields getrowfields()

returns the collection of row field for the specified pivot table.read-only.

returns:

getcolumnfields

ipivotfields getcolumnfields()

returns the collection of column field for the specified pivot table.read-only.

returns:

getshowdatafieldinrow

boolean getshowdatafieldinrow()

gets/sets value indicating whether the pivottable data fields are shown in rows.

returns:

clear

void clear()

this method clears all the fields, deletes all filtering and sorting applied to the pivottable.

clearrowfieldfilter

void clearrowfieldfilter(java.lang.string fieldname)

clear the row field filter.

parameters:

fieldname - the row field name.

clearcolumnfieldfilter

void clearcolumnfieldfilter(java.lang.string fieldname)

clear the column field filter.

parameters:

fieldname - the column field name.

clearfilter

void clearfilter(java.lang.string fieldname)

clear the row and column field filter depends on field name.

parameters:

fieldname - the row and column field name.