程序包 com.grapecity.documents.excel

接口 IPivotTables

所有超级接口:

Iterable<IPivotTable>

public interface IPivotTables
extends Iterable<IPivotTable>

Represents a collection of all the PivotTable objects on the specified worksheet.

方法概要

修饰符和类型	方法	说明
IPivotTable	add(IPivotCache PivotCache, IRange TableDestination)	Adds a new PivotTable report.
IPivotTable	add(IPivotCache PivotCache, IRange TableDestination, String TableName)	Adds a new PivotTable report.
IPivotTable	get(int index)	Returns a single object from a collection.
IPivotTable	get(String name)	Returns a single object from a collection.
int	getCount()	Returns the number of objects in the collection.

从接口继承的方法 java.lang.Iterable

forEach, iterator, spliterator

方法详细资料

getCount

int getCount()

Returns the number of objects in the collection.

add

IPivotTable add(IPivotCache PivotCache,
 IRange TableDestination)

Adds a new PivotTable report.

参数:

PivotCache - The PivotTable cache on which the new PivotTable report is based.The cache provides data for the report.

TableDestination - The cell in the upper-left corner of the PivotTable report'sdestination range (the range on the worksheet where the resulting report will be placed). You must specify a destination range on the worksheet that contains the PivotTables object specified by expression.

返回:

PivotTable object

add

IPivotTable add(IPivotCache PivotCache,
 IRange TableDestination,
 String TableName)

Adds a new PivotTable report.

参数:

PivotCache - The PivotTable cache on which the new PivotTable report is based.The cache provides data for the report.

TableDestination - The cell in the upper-left corner of the PivotTable report'sdestination range (the range on the worksheet where the resulting report will be placed). You must specify a destination range on the worksheet that contains the PivotTables object specified by expression.

TableName - The name of the new PivotTable report.

返回:

PivotTable object

get

IPivotTable get(int index)

Returns a single object from a collection.

参数:

index - The index number for the object.

get

IPivotTable get(String name)

Returns a single object from a collection.

参数:

name - The name for the object.