public class PivotTable extends Object
Constructor and Description |
---|
PivotTable() |
Modifier and Type | Method and Description |
---|---|
String |
getAltTextDescription()
getAltTextDescription
Gets String
|
String |
getAltTextTitle()
getAltTextTitle
Gets String
|
String |
getAutoFormatType()
getAutoFormatType
Gets String
|
List<PivotField> |
getBaseFields()
getBaseFields
Gets List
|
List<PivotField> |
getColumnFields()
getColumnFields
Gets List
|
Boolean |
getColumnGrand()
getColumnGrand
Gets Boolean
|
String |
getColumnHeaderCaption()
getColumnHeaderCaption
Gets String
|
CellArea |
getColumnRange()
getColumnRange
Gets CellArea
|
Boolean |
getCustomListSort()
getCustomListSort
Gets Boolean
|
CellArea |
getDataBodyRange()
getDataBodyRange
Gets CellArea
|
PivotField |
getDataField()
getDataField
Gets PivotField
|
List<PivotField> |
getDataFields()
getDataFields
Gets List
|
List<String> |
getDataSource()
getDataSource
Gets List
|
Boolean |
getDisplayErrorString()
getDisplayErrorString
Gets Boolean
|
Boolean |
getDisplayImmediateItems()
getDisplayImmediateItems
Gets Boolean
|
Boolean |
getDisplayNullString()
getDisplayNullString
Gets Boolean
|
Boolean |
getEnableDataValueEditing()
getEnableDataValueEditing
Gets Boolean
|
Boolean |
getEnableDrilldown()
getEnableDrilldown
Gets Boolean
|
Boolean |
getEnableFieldDialog()
getEnableFieldDialog
Gets Boolean
|
Boolean |
getEnableFieldList()
getEnableFieldList
Gets Boolean
|
Boolean |
getEnableWizard()
getEnableWizard
Gets Boolean
|
String |
getErrorString()
getErrorString
Gets String
|
Boolean |
getFieldListSortAscending()
getFieldListSortAscending
Gets Boolean
|
String |
getGrandTotalName()
getGrandTotalName
Gets String
|
Boolean |
getHasBlankRows()
getHasBlankRows
Gets Boolean
|
Integer |
getIndent()
getIndent
Gets Integer
|
Boolean |
getIsAutoFormat()
getIsAutoFormat
Gets Boolean
|
Boolean |
getIsGridDropZones()
getIsGridDropZones
Gets Boolean
|
Boolean |
getIsMultipleFieldFilters()
getIsMultipleFieldFilters
Gets Boolean
|
Boolean |
getIsSelected()
getIsSelected
Gets Boolean
|
Boolean |
getItemPrintTitles()
getItemPrintTitles
Gets Boolean
|
Link |
getLink()
getLink
Gets Link
|
Boolean |
getManualUpdate()
getManualUpdate
Gets Boolean
|
Boolean |
getMergeLabels()
getMergeLabels
Gets Boolean
|
String |
getMissingItemsLimit()
getMissingItemsLimit
Gets String
|
String |
getName()
getName
Gets String
|
String |
getNullString()
getNullString
Gets String
|
String |
getPageFieldOrder()
getPageFieldOrder
Gets String
|
List<PivotField> |
getPageFields()
getPageFields
Gets List
|
Integer |
getPageFieldWrapCount()
getPageFieldWrapCount
Gets Integer
|
List<PivotFilter> |
getPivotFilters()
getPivotFilters
Gets List
|
String |
getPivotTableStyleName()
getPivotTableStyleName
Gets String
|
String |
getPivotTableStyleType()
getPivotTableStyleType
Gets String
|
Boolean |
getPreserveFormatting()
getPreserveFormatting
Gets Boolean
|
Boolean |
getPrintDrill()
getPrintDrill
Gets Boolean
|
Boolean |
getPrintTitles()
getPrintTitles
Gets Boolean
|
Boolean |
getRefreshDataFlag()
getRefreshDataFlag
Gets Boolean
|
Boolean |
getRefreshDataOnOpeningFile()
getRefreshDataOnOpeningFile
Gets Boolean
|
List<PivotField> |
getRowFields()
getRowFields
Gets List
|
Boolean |
getRowGrand()
getRowGrand
Gets Boolean
|
String |
getRowHeaderCaption()
getRowHeaderCaption
Gets String
|
CellArea |
getRowRange()
getRowRange
Gets CellArea
|
Boolean |
getSaveData()
getSaveData
Gets Boolean
|
Boolean |
getShowDataTips()
getShowDataTips
Gets Boolean
|
Boolean |
getShowDrill()
getShowDrill
Gets Boolean
|
Boolean |
getShowEmptyCol()
getShowEmptyCol
Gets Boolean
|
Boolean |
getShowEmptyRow()
getShowEmptyRow
Gets Boolean
|
Boolean |
getShowMemberPropertyTips()
getShowMemberPropertyTips
Gets Boolean
|
Boolean |
getShowPivotStyleColumnHeader()
getShowPivotStyleColumnHeader
Gets Boolean
|
Boolean |
getShowPivotStyleColumnStripes()
getShowPivotStyleColumnStripes
Gets Boolean
|
Boolean |
getShowPivotStyleLastColumn()
getShowPivotStyleLastColumn
Gets Boolean
|
Boolean |
getShowPivotStyleRowHeader()
getShowPivotStyleRowHeader
Gets Boolean
|
Boolean |
getShowPivotStyleRowStripes()
getShowPivotStyleRowStripes
Gets Boolean
|
Boolean |
getShowRowHeaderCaption()
getShowRowHeaderCaption
Gets Boolean
|
Boolean |
getShowValuesRow()
getShowValuesRow
Gets Boolean
|
Boolean |
getSubtotalHiddenPageItems()
getSubtotalHiddenPageItems
Gets Boolean
|
CellArea |
getTableRange1()
getTableRange1
Gets CellArea
|
CellArea |
getTableRange2()
getTableRange2
Gets CellArea
|
String |
getTag()
getTag
Gets String
|
void |
setAltTextDescription(String AltTextDescription)
setAltTextDescription
Sets String
|
void |
setAltTextTitle(String AltTextTitle)
setAltTextTitle
Sets String
|
void |
setAutoFormatType(String AutoFormatType)
setAutoFormatType
Sets String
|
void |
setBaseFields(List<PivotField> BaseFields)
setBaseFields
Sets List
|
void |
setColumnFields(List<PivotField> ColumnFields)
setColumnFields
Sets List
|
void |
setColumnGrand(Boolean ColumnGrand)
setColumnGrand
Sets Boolean
|
void |
setColumnHeaderCaption(String ColumnHeaderCaption)
setColumnHeaderCaption
Sets String
|
void |
setColumnRange(CellArea ColumnRange)
setColumnRange
Sets CellArea
|
void |
setCustomListSort(Boolean CustomListSort)
setCustomListSort
Sets Boolean
|
void |
setDataBodyRange(CellArea DataBodyRange)
setDataBodyRange
Sets CellArea
|
void |
setDataField(PivotField DataField)
setDataField
Sets PivotField
|
void |
setDataFields(List<PivotField> DataFields)
setDataFields
Sets List
|
void |
setDataSource(List<String> DataSource)
setDataSource
Sets List
|
void |
setDisplayErrorString(Boolean DisplayErrorString)
setDisplayErrorString
Sets Boolean
|
void |
setDisplayImmediateItems(Boolean DisplayImmediateItems)
setDisplayImmediateItems
Sets Boolean
|
void |
setDisplayNullString(Boolean DisplayNullString)
setDisplayNullString
Sets Boolean
|
void |
setEnableDataValueEditing(Boolean EnableDataValueEditing)
setEnableDataValueEditing
Sets Boolean
|
void |
setEnableDrilldown(Boolean EnableDrilldown)
setEnableDrilldown
Sets Boolean
|
void |
setEnableFieldDialog(Boolean EnableFieldDialog)
setEnableFieldDialog
Sets Boolean
|
void |
setEnableFieldList(Boolean EnableFieldList)
setEnableFieldList
Sets Boolean
|
void |
setEnableWizard(Boolean EnableWizard)
setEnableWizard
Sets Boolean
|
void |
setErrorString(String ErrorString)
setErrorString
Sets String
|
void |
setFieldListSortAscending(Boolean FieldListSortAscending)
setFieldListSortAscending
Sets Boolean
|
void |
setGrandTotalName(String GrandTotalName)
setGrandTotalName
Sets String
|
void |
setHasBlankRows(Boolean HasBlankRows)
setHasBlankRows
Sets Boolean
|
void |
setIndent(Integer Indent)
setIndent
Sets Integer
|
void |
setIsAutoFormat(Boolean IsAutoFormat)
setIsAutoFormat
Sets Boolean
|
void |
setIsGridDropZones(Boolean IsGridDropZones)
setIsGridDropZones
Sets Boolean
|
void |
setIsMultipleFieldFilters(Boolean IsMultipleFieldFilters)
setIsMultipleFieldFilters
Sets Boolean
|
void |
setIsSelected(Boolean IsSelected)
setIsSelected
Sets Boolean
|
void |
setItemPrintTitles(Boolean ItemPrintTitles)
setItemPrintTitles
Sets Boolean
|
void |
setLink(Link link)
setLink
Sets Link
|
void |
setManualUpdate(Boolean ManualUpdate)
setManualUpdate
Sets Boolean
|
void |
setMergeLabels(Boolean MergeLabels)
setMergeLabels
Sets Boolean
|
void |
setMissingItemsLimit(String MissingItemsLimit)
setMissingItemsLimit
Sets String
|
void |
setName(String Name)
setName
Sets String
|
void |
setNullString(String NullString)
setNullString
Sets String
|
void |
setPageFieldOrder(String PageFieldOrder)
setPageFieldOrder
Sets String
|
void |
setPageFields(List<PivotField> PageFields)
setPageFields
Sets List
|
void |
setPageFieldWrapCount(Integer PageFieldWrapCount)
setPageFieldWrapCount
Sets Integer
|
void |
setPivotFilters(List<PivotFilter> PivotFilters)
setPivotFilters
Sets List
|
void |
setPivotTableStyleName(String PivotTableStyleName)
setPivotTableStyleName
Sets String
|
void |
setPivotTableStyleType(String PivotTableStyleType)
setPivotTableStyleType
Sets String
|
void |
setPreserveFormatting(Boolean PreserveFormatting)
setPreserveFormatting
Sets Boolean
|
void |
setPrintDrill(Boolean PrintDrill)
setPrintDrill
Sets Boolean
|
void |
setPrintTitles(Boolean PrintTitles)
setPrintTitles
Sets Boolean
|
void |
setRefreshDataFlag(Boolean RefreshDataFlag)
setRefreshDataFlag
Sets Boolean
|
void |
setRefreshDataOnOpeningFile(Boolean RefreshDataOnOpeningFile)
setRefreshDataOnOpeningFile
Sets Boolean
|
void |
setRowFields(List<PivotField> RowFields)
setRowFields
Sets List
|
void |
setRowGrand(Boolean RowGrand)
setRowGrand
Sets Boolean
|
void |
setRowHeaderCaption(String RowHeaderCaption)
setRowHeaderCaption
Sets String
|
void |
setRowRange(CellArea RowRange)
setRowRange
Sets CellArea
|
void |
setSaveData(Boolean SaveData)
setSaveData
Sets Boolean
|
void |
setShowDataTips(Boolean ShowDataTips)
setShowDataTips
Sets Boolean
|
void |
setShowDrill(Boolean ShowDrill)
setShowDrill
Sets Boolean
|
void |
setShowEmptyCol(Boolean ShowEmptyCol)
setShowEmptyCol
Sets Boolean
|
void |
setShowEmptyRow(Boolean ShowEmptyRow)
setShowEmptyRow
Sets Boolean
|
void |
setShowMemberPropertyTips(Boolean ShowMemberPropertyTips)
setShowMemberPropertyTips
Sets Boolean
|
void |
setShowPivotStyleColumnHeader(Boolean ShowPivotStyleColumnHeader)
setShowPivotStyleColumnHeader
Sets Boolean
|
void |
setShowPivotStyleColumnStripes(Boolean ShowPivotStyleColumnStripes)
setShowPivotStyleColumnStripes
Sets Boolean
|
void |
setShowPivotStyleLastColumn(Boolean ShowPivotStyleLastColumn)
setShowPivotStyleLastColumn
Sets Boolean
|
void |
setShowPivotStyleRowHeader(Boolean ShowPivotStyleRowHeader)
setShowPivotStyleRowHeader
Sets Boolean
|
void |
setShowPivotStyleRowStripes(Boolean ShowPivotStyleRowStripes)
setShowPivotStyleRowStripes
Sets Boolean
|
void |
setShowRowHeaderCaption(Boolean ShowRowHeaderCaption)
setShowRowHeaderCaption
Sets Boolean
|
void |
setShowValuesRow(Boolean ShowValuesRow)
setShowValuesRow
Sets Boolean
|
void |
setSubtotalHiddenPageItems(Boolean SubtotalHiddenPageItems)
setSubtotalHiddenPageItems
Sets Boolean
|
void |
setTableRange1(CellArea TableRange1)
setTableRange1
Sets CellArea
|
void |
setTableRange2(CellArea TableRange2)
setTableRange2
Sets CellArea
|
void |
setTag(String Tag)
setTag
Sets String
|
String |
toString() |
public String getAltTextDescription()
public void setAltTextDescription(String AltTextDescription)
AltTextDescription
- Stringpublic String getAltTextTitle()
public void setAltTextTitle(String AltTextTitle)
AltTextTitle
- Stringpublic String getAutoFormatType()
public void setAutoFormatType(String AutoFormatType)
AutoFormatType
- Stringpublic List<PivotField> getBaseFields()
public void setBaseFields(List<PivotField> BaseFields)
BaseFields
- Listpublic List<PivotField> getColumnFields()
public void setColumnFields(List<PivotField> ColumnFields)
ColumnFields
- Listpublic Boolean getColumnGrand()
public void setColumnGrand(Boolean ColumnGrand)
ColumnGrand
- Booleanpublic String getColumnHeaderCaption()
public void setColumnHeaderCaption(String ColumnHeaderCaption)
ColumnHeaderCaption
- Stringpublic CellArea getColumnRange()
public void setColumnRange(CellArea ColumnRange)
ColumnRange
- CellAreapublic Boolean getCustomListSort()
public void setCustomListSort(Boolean CustomListSort)
CustomListSort
- Booleanpublic CellArea getDataBodyRange()
public void setDataBodyRange(CellArea DataBodyRange)
DataBodyRange
- CellAreapublic PivotField getDataField()
public void setDataField(PivotField DataField)
DataField
- PivotFieldpublic List<PivotField> getDataFields()
public void setDataFields(List<PivotField> DataFields)
DataFields
- Listpublic void setDataSource(List<String> DataSource)
DataSource
- Listpublic Boolean getDisplayErrorString()
public void setDisplayErrorString(Boolean DisplayErrorString)
DisplayErrorString
- Booleanpublic Boolean getDisplayImmediateItems()
public void setDisplayImmediateItems(Boolean DisplayImmediateItems)
DisplayImmediateItems
- Booleanpublic Boolean getDisplayNullString()
public void setDisplayNullString(Boolean DisplayNullString)
DisplayNullString
- Booleanpublic Boolean getEnableDataValueEditing()
public void setEnableDataValueEditing(Boolean EnableDataValueEditing)
EnableDataValueEditing
- Booleanpublic Boolean getEnableDrilldown()
public void setEnableDrilldown(Boolean EnableDrilldown)
EnableDrilldown
- Booleanpublic Boolean getEnableFieldDialog()
public void setEnableFieldDialog(Boolean EnableFieldDialog)
EnableFieldDialog
- Booleanpublic Boolean getEnableFieldList()
public void setEnableFieldList(Boolean EnableFieldList)
EnableFieldList
- Booleanpublic Boolean getEnableWizard()
public void setEnableWizard(Boolean EnableWizard)
EnableWizard
- Booleanpublic String getErrorString()
public void setErrorString(String ErrorString)
ErrorString
- Stringpublic Boolean getFieldListSortAscending()
public void setFieldListSortAscending(Boolean FieldListSortAscending)
FieldListSortAscending
- Booleanpublic String getGrandTotalName()
public void setGrandTotalName(String GrandTotalName)
GrandTotalName
- Stringpublic Boolean getHasBlankRows()
public void setHasBlankRows(Boolean HasBlankRows)
HasBlankRows
- Booleanpublic Integer getIndent()
public void setIndent(Integer Indent)
Indent
- Integerpublic Boolean getIsAutoFormat()
public void setIsAutoFormat(Boolean IsAutoFormat)
IsAutoFormat
- Booleanpublic Boolean getIsGridDropZones()
public void setIsGridDropZones(Boolean IsGridDropZones)
IsGridDropZones
- Booleanpublic Boolean getIsMultipleFieldFilters()
public void setIsMultipleFieldFilters(Boolean IsMultipleFieldFilters)
IsMultipleFieldFilters
- Booleanpublic Boolean getIsSelected()
public void setIsSelected(Boolean IsSelected)
IsSelected
- Booleanpublic Boolean getItemPrintTitles()
public void setItemPrintTitles(Boolean ItemPrintTitles)
ItemPrintTitles
- Booleanpublic Boolean getManualUpdate()
public void setManualUpdate(Boolean ManualUpdate)
ManualUpdate
- Booleanpublic Boolean getMergeLabels()
public void setMergeLabels(Boolean MergeLabels)
MergeLabels
- Booleanpublic String getMissingItemsLimit()
public void setMissingItemsLimit(String MissingItemsLimit)
MissingItemsLimit
- Stringpublic String getName()
public void setName(String Name)
Name
- Stringpublic String getNullString()
public void setNullString(String NullString)
NullString
- Stringpublic String getPageFieldOrder()
public void setPageFieldOrder(String PageFieldOrder)
PageFieldOrder
- Stringpublic List<PivotField> getPageFields()
public void setPageFields(List<PivotField> PageFields)
PageFields
- Listpublic Integer getPageFieldWrapCount()
public void setPageFieldWrapCount(Integer PageFieldWrapCount)
PageFieldWrapCount
- Integerpublic List<PivotFilter> getPivotFilters()
public void setPivotFilters(List<PivotFilter> PivotFilters)
PivotFilters
- Listpublic String getPivotTableStyleName()
public void setPivotTableStyleName(String PivotTableStyleName)
PivotTableStyleName
- Stringpublic String getPivotTableStyleType()
public void setPivotTableStyleType(String PivotTableStyleType)
PivotTableStyleType
- Stringpublic Boolean getPreserveFormatting()
public void setPreserveFormatting(Boolean PreserveFormatting)
PreserveFormatting
- Booleanpublic Boolean getPrintDrill()
public void setPrintDrill(Boolean PrintDrill)
PrintDrill
- Booleanpublic Boolean getPrintTitles()
public void setPrintTitles(Boolean PrintTitles)
PrintTitles
- Booleanpublic Boolean getRefreshDataFlag()
public void setRefreshDataFlag(Boolean RefreshDataFlag)
RefreshDataFlag
- Booleanpublic Boolean getRefreshDataOnOpeningFile()
public void setRefreshDataOnOpeningFile(Boolean RefreshDataOnOpeningFile)
RefreshDataOnOpeningFile
- Booleanpublic List<PivotField> getRowFields()
public void setRowFields(List<PivotField> RowFields)
RowFields
- Listpublic Boolean getRowGrand()
public void setRowGrand(Boolean RowGrand)
RowGrand
- Booleanpublic String getRowHeaderCaption()
public void setRowHeaderCaption(String RowHeaderCaption)
RowHeaderCaption
- Stringpublic CellArea getRowRange()
public void setRowRange(CellArea RowRange)
RowRange
- CellAreapublic Boolean getSaveData()
public void setSaveData(Boolean SaveData)
SaveData
- Booleanpublic Boolean getShowDataTips()
public void setShowDataTips(Boolean ShowDataTips)
ShowDataTips
- Booleanpublic Boolean getShowDrill()
public void setShowDrill(Boolean ShowDrill)
ShowDrill
- Booleanpublic Boolean getShowEmptyCol()
public void setShowEmptyCol(Boolean ShowEmptyCol)
ShowEmptyCol
- Booleanpublic Boolean getShowEmptyRow()
public void setShowEmptyRow(Boolean ShowEmptyRow)
ShowEmptyRow
- Booleanpublic Boolean getShowMemberPropertyTips()
public void setShowMemberPropertyTips(Boolean ShowMemberPropertyTips)
ShowMemberPropertyTips
- Booleanpublic Boolean getShowPivotStyleColumnHeader()
public void setShowPivotStyleColumnHeader(Boolean ShowPivotStyleColumnHeader)
ShowPivotStyleColumnHeader
- Booleanpublic Boolean getShowPivotStyleColumnStripes()
public void setShowPivotStyleColumnStripes(Boolean ShowPivotStyleColumnStripes)
ShowPivotStyleColumnStripes
- Booleanpublic Boolean getShowPivotStyleLastColumn()
public void setShowPivotStyleLastColumn(Boolean ShowPivotStyleLastColumn)
ShowPivotStyleLastColumn
- Booleanpublic Boolean getShowPivotStyleRowHeader()
public void setShowPivotStyleRowHeader(Boolean ShowPivotStyleRowHeader)
ShowPivotStyleRowHeader
- Booleanpublic Boolean getShowPivotStyleRowStripes()
public void setShowPivotStyleRowStripes(Boolean ShowPivotStyleRowStripes)
ShowPivotStyleRowStripes
- Booleanpublic Boolean getShowRowHeaderCaption()
public void setShowRowHeaderCaption(Boolean ShowRowHeaderCaption)
ShowRowHeaderCaption
- Booleanpublic Boolean getShowValuesRow()
public void setShowValuesRow(Boolean ShowValuesRow)
ShowValuesRow
- Booleanpublic Boolean getSubtotalHiddenPageItems()
public void setSubtotalHiddenPageItems(Boolean SubtotalHiddenPageItems)
SubtotalHiddenPageItems
- Booleanpublic CellArea getTableRange1()
public void setTableRange1(CellArea TableRange1)
TableRange1
- CellAreapublic CellArea getTableRange2()
public void setTableRange2(CellArea TableRange2)
TableRange2
- CellAreapublic String getTag()
public void setTag(String Tag)
Tag
- Stringpublic Link getLink()
public void setLink(Link link)
link
- LinkCopyright © 2015. All rights reserved.