public class XSSFPivotTable extends org.zkoss.poi.POIXMLDocumentPart implements org.zkoss.poi.ss.usermodel.PivotTable, Serializable
Constructor and Description |
---|
XSSFPivotTable(org.zkoss.poi.openxml4j.opc.PackagePart part,
org.zkoss.poi.openxml4j.opc.PackageRelationship rel,
List<org.zkoss.poi.ss.usermodel.PivotCache> pivotCaches) |
Modifier and Type | Method and Description |
---|---|
protected void |
commit() |
long |
getCacheId() |
List<org.zkoss.poi.ss.usermodel.PivotField> |
getColumnFields() |
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColFields |
getCTColFields() |
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTLocation |
getCTLocation() |
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTRowFields |
getCTRowFields() |
String |
getDataCaption() |
List<org.zkoss.poi.ss.usermodel.DataField> |
getDataFields() |
boolean |
getDataOnRows() |
org.zkoss.poi.ss.util.CellReference |
getFirstDataRef() |
String |
getGrandTotalCaption() |
org.zkoss.poi.ss.util.AreaReference |
getLocationRef() |
String |
getName() |
boolean |
getOutline() |
boolean |
getOutlineData() |
org.zkoss.poi.ss.usermodel.PivotCache |
getPivotCache() |
org.zkoss.poi.ss.usermodel.PivotField |
getPivotField(String name) |
List<org.zkoss.poi.ss.usermodel.PivotField> |
getPivotFields() |
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPivotTableDefinition |
getPivotTableDefinition() |
List<org.zkoss.poi.ss.usermodel.PivotField> |
getRowFields() |
String |
getRowHeaderCaption() |
org.zkoss.poi.ss.usermodel.Sheet |
getSheet() |
protected void |
onDocumentCreate() |
void |
setColumnField(org.zkoss.poi.ss.usermodel.PivotField field) |
void |
setColumnItems(List<List<org.zkoss.poi.ss.util.ItemInfo>> items) |
void |
setDataCaption(String caption) |
void |
setDataField(org.zkoss.poi.ss.usermodel.PivotField field,
String name,
org.zkoss.poi.ss.usermodel.Calculation subtotal) |
void |
setDataOnRows(boolean dataOnRows) |
void |
setFirstData(int row,
int col) |
void |
setFirstHeaderRow(int row) |
void |
setGrandTotalCaption(String caption) |
void |
setLocationRef(org.zkoss.poi.ss.util.AreaReference ref) |
void |
setName(String name) |
void |
setOutline(boolean outline) |
void |
setOutlineData(boolean outlineData) |
void |
setPivotCache(org.zkoss.poi.ss.usermodel.PivotCache pivotCache) |
void |
setRowField(org.zkoss.poi.ss.usermodel.PivotField field) |
void |
setRowHeaderCaption(String caption) |
void |
setRowItems(List<List<org.zkoss.poi.ss.util.ItemInfo>> items) |
addRelation, clearMemoryPackagePart, createRelationship, createRelationship, createRelationship, getPackagePart, getPackageRelationship, getParent, getRelationById, getRelationCounter, getRelationId, getRelations, getTargetPart, onDocumentRead, onDocumentRemove, onSave, read, rebase, removeRelation, removeRelation, toString
public XSSFPivotTable(org.zkoss.poi.openxml4j.opc.PackagePart part, org.zkoss.poi.openxml4j.opc.PackageRelationship rel, List<org.zkoss.poi.ss.usermodel.PivotCache> pivotCaches) throws IOException, org.apache.xmlbeans.XmlException
IOException
org.apache.xmlbeans.XmlException
protected void onDocumentCreate()
onDocumentCreate
in class org.zkoss.poi.POIXMLDocumentPart
protected void commit() throws IOException
commit
in class org.zkoss.poi.POIXMLDocumentPart
IOException
public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPivotTableDefinition getPivotTableDefinition()
public void setPivotCache(org.zkoss.poi.ss.usermodel.PivotCache pivotCache)
public long getCacheId()
getCacheId
in interface org.zkoss.poi.ss.usermodel.PivotTable
public List<org.zkoss.poi.ss.usermodel.PivotField> getColumnFields()
getColumnFields
in interface org.zkoss.poi.ss.usermodel.PivotTable
public void setColumnField(org.zkoss.poi.ss.usermodel.PivotField field)
setColumnField
in interface org.zkoss.poi.ss.usermodel.PivotTable
public void setDataCaption(String caption)
setDataCaption
in interface org.zkoss.poi.ss.usermodel.PivotTable
public String getDataCaption()
getDataCaption
in interface org.zkoss.poi.ss.usermodel.PivotTable
public List<org.zkoss.poi.ss.usermodel.DataField> getDataFields()
getDataFields
in interface org.zkoss.poi.ss.usermodel.PivotTable
public void setDataField(org.zkoss.poi.ss.usermodel.PivotField field, String name, org.zkoss.poi.ss.usermodel.Calculation subtotal)
setDataField
in interface org.zkoss.poi.ss.usermodel.PivotTable
public void setFirstHeaderRow(int row)
setFirstHeaderRow
in interface org.zkoss.poi.ss.usermodel.PivotTable
public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTLocation getCTLocation()
public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTColFields getCTColFields()
public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTRowFields getCTRowFields()
public void setFirstData(int row, int col)
setFirstData
in interface org.zkoss.poi.ss.usermodel.PivotTable
public void setLocationRef(org.zkoss.poi.ss.util.AreaReference ref)
setLocationRef
in interface org.zkoss.poi.ss.usermodel.PivotTable
public org.zkoss.poi.ss.util.AreaReference getLocationRef()
getLocationRef
in interface org.zkoss.poi.ss.usermodel.PivotTable
public org.zkoss.poi.ss.util.CellReference getFirstDataRef()
getFirstDataRef
in interface org.zkoss.poi.ss.usermodel.PivotTable
public void setGrandTotalCaption(String caption)
setGrandTotalCaption
in interface org.zkoss.poi.ss.usermodel.PivotTable
public String getGrandTotalCaption()
getGrandTotalCaption
in interface org.zkoss.poi.ss.usermodel.PivotTable
public void setName(String name)
setName
in interface org.zkoss.poi.ss.usermodel.PivotTable
public String getName()
getName
in interface org.zkoss.poi.ss.usermodel.PivotTable
public org.zkoss.poi.ss.usermodel.PivotCache getPivotCache()
getPivotCache
in interface org.zkoss.poi.ss.usermodel.PivotTable
public org.zkoss.poi.ss.usermodel.PivotField getPivotField(String name)
getPivotField
in interface org.zkoss.poi.ss.usermodel.PivotTable
public List<org.zkoss.poi.ss.usermodel.PivotField> getPivotFields()
getPivotFields
in interface org.zkoss.poi.ss.usermodel.PivotTable
public List<org.zkoss.poi.ss.usermodel.PivotField> getRowFields()
getRowFields
in interface org.zkoss.poi.ss.usermodel.PivotTable
public org.zkoss.poi.ss.usermodel.Sheet getSheet()
public void setColumnItems(List<List<org.zkoss.poi.ss.util.ItemInfo>> items)
setColumnItems
in interface org.zkoss.poi.ss.usermodel.PivotTable
public void setRowItems(List<List<org.zkoss.poi.ss.util.ItemInfo>> items)
setRowItems
in interface org.zkoss.poi.ss.usermodel.PivotTable
public void setRowField(org.zkoss.poi.ss.usermodel.PivotField field)
setRowField
in interface org.zkoss.poi.ss.usermodel.PivotTable
public void setDataOnRows(boolean dataOnRows)
setDataOnRows
in interface org.zkoss.poi.ss.usermodel.PivotTable
public boolean getDataOnRows()
getDataOnRows
in interface org.zkoss.poi.ss.usermodel.PivotTable
public String getRowHeaderCaption()
getRowHeaderCaption
in interface org.zkoss.poi.ss.usermodel.PivotTable
public void setRowHeaderCaption(String caption)
setRowHeaderCaption
in interface org.zkoss.poi.ss.usermodel.PivotTable
public void setOutline(boolean outline)
setOutline
in interface org.zkoss.poi.ss.usermodel.PivotTable
public boolean getOutline()
getOutline
in interface org.zkoss.poi.ss.usermodel.PivotTable
public void setOutlineData(boolean outlineData)
setOutlineData
in interface org.zkoss.poi.ss.usermodel.PivotTable
public boolean getOutlineData()
getOutlineData
in interface org.zkoss.poi.ss.usermodel.PivotTable
Copyright © 2019. All rights reserved.