public interface PivotTable
Modifier and Type | Method and Description |
---|---|
long |
getCacheId()
Returns the cache id of the PivotTable.
|
java.util.List<PivotField> |
getColumnFields()
Returns all column fields.
|
java.lang.String |
getDataCaption()
Returns the data caption.
|
java.util.List<DataField> |
getDataFields()
Returns all data fields.
|
boolean |
getDataOnRows()
Returns whether data on rows or not.
|
CellReference |
getFirstDataRef()
Returns the first data
CellReference |
java.lang.String |
getGrandTotalCaption()
Returns the grand total caption.
|
AreaReference |
getLocationRef()
Returns the location range of the PivotTable.
|
java.lang.String |
getName()
Returns the name of the PivotTable.
|
boolean |
getOutline() |
boolean |
getOutlineData() |
PivotCache |
getPivotCache()
Returns the
PivotCache of the PivotTable. |
PivotField |
getPivotField(java.lang.String name)
Returns the
PivotField . |
java.util.List<PivotField> |
getPivotFields()
Returns all fields of the PivotTable.
|
java.util.List<PivotField> |
getRowFields()
Returns all row fields.
|
java.lang.String |
getRowHeaderCaption()
Returns the row header caption.
|
void |
setColumnField(PivotField field)
Sets column type of a pivot field.
|
void |
setColumnItems(java.util.List<java.util.List<ItemInfo>> items)
Serts column items
|
void |
setDataCaption(java.lang.String caption)
Sets the data caption.
|
void |
setDataField(PivotField field,
java.lang.String name,
Calculation subtotal)
Sets data field
|
void |
setDataOnRows(boolean dataOnRows)
Sets data on rows
|
void |
setFirstData(int row,
int col)
Sets the first data row/column index.
|
void |
setFirstHeaderRow(int row)
Sets the first header row.
|
void |
setGrandTotalCaption(java.lang.String caption)
Sets the grand total caption.
|
void |
setLocationRef(AreaReference ref)
Sets the location range of the PivotTable.
|
void |
setName(java.lang.String name)
Sets the name of PivotTable.
|
void |
setOutline(boolean outline) |
void |
setOutlineData(boolean outlineData) |
void |
setRowField(PivotField field)
Sets row type of a pivot field.
|
void |
setRowHeaderCaption(java.lang.String caption)
Sets the row header caption.
|
void |
setRowItems(java.util.List<java.util.List<ItemInfo>> items)
Sets row items.
|
void setName(java.lang.String name)
name
- java.lang.String getName()
long getCacheId()
void setGrandTotalCaption(java.lang.String caption)
caption
- java.lang.String getGrandTotalCaption()
void setDataCaption(java.lang.String caption)
caption
- java.lang.String getDataCaption()
void setRowHeaderCaption(java.lang.String caption)
caption
- java.lang.String getRowHeaderCaption()
void setFirstHeaderRow(int row)
row
- void setFirstData(int row, int col)
row
- col
- CellReference getFirstDataRef()
CellReference
void setLocationRef(AreaReference ref)
ref
- AreaReference getLocationRef()
PivotCache getPivotCache()
PivotCache
of the PivotTable.PivotField getPivotField(java.lang.String name)
PivotField
.name
- java.util.List<PivotField> getPivotFields()
void setRowField(PivotField field)
field
- java.util.List<PivotField> getRowFields()
void setRowItems(java.util.List<java.util.List<ItemInfo>> items)
items
- void setColumnField(PivotField field)
field
- java.util.List<PivotField> getColumnFields()
void setColumnItems(java.util.List<java.util.List<ItemInfo>> items)
items
- void setDataField(PivotField field, java.lang.String name, Calculation subtotal)
field
- name
- subtotal
- java.util.List<DataField> getDataFields()
void setDataOnRows(boolean dataOnRows)
dataOnRows
- boolean getDataOnRows()
void setOutline(boolean outline)
boolean getOutline()
void setOutlineData(boolean outlineData)
boolean getOutlineData()
Copyright © 2005-2010 Potix Corporation. All Rights Reserved.