Interface IXLPivotTable
public interface IXLPivotTable- Extension Methods
Properties
AllowMultipleFilters
bool AllowMultipleFilters { get; set; }Property Value
AutofitColumns
bool AutofitColumns { get; set; }Property Value
ClassicPivotTableLayout
bool ClassicPivotTableLayout { get; set; }Property Value
ColumnHeaderCaption
string ColumnHeaderCaption { get; set; }Property Value
ColumnLabels
IXLPivotFields ColumnLabels { get; }Property Value
Description
string Description { get; set; }Property Value
DisplayCaptionsAndDropdowns
bool DisplayCaptionsAndDropdowns { get; set; }Property Value
DisplayItemLabels
bool DisplayItemLabels { get; set; }Property Value
EmptyCellReplacement
string EmptyCellReplacement { get; set; }Property Value
EnableCellEditing
bool EnableCellEditing { get; set; }Property Value
EnableShowDetails
bool EnableShowDetails { get; set; }Property Value
ErrorValueReplacement
string ErrorValueReplacement { get; set; }Property Value
FilterAreaOrder
XLFilterAreaOrder FilterAreaOrder { get; set; }Property Value
FilterFieldsPageWrap
int FilterFieldsPageWrap { get; set; }Property Value
FilteredItemsInSubtotals
bool FilteredItemsInSubtotals { get; set; }Property Value
InsertBlankLines
bool InsertBlankLines { set; }Property Value
Layout
XLPivotLayout Layout { set; }Property Value
MergeAndCenterWithLabels
bool MergeAndCenterWithLabels { get; set; }Property Value
Name
string Name { get; set; }Property Value
PivotCache
The cache of data for the pivot table. The pivot table is created from cached data, not up-to-date data in a worksheet.
IXLPivotCache PivotCache { get; set; }Property Value
PreserveCellFormatting
bool PreserveCellFormatting { get; set; }Property Value
PrintExpandCollapsedButtons
bool PrintExpandCollapsedButtons { get; set; }Property Value
PrintTitles
bool PrintTitles { get; set; }Property Value
RepeatRowLabels
bool RepeatRowLabels { get; set; }Property Value
ReportFilters
IXLPivotFields ReportFilters { get; }Property Value
RowHeaderCaption
string RowHeaderCaption { get; set; }Property Value
RowLabelIndent
int RowLabelIndent { get; set; }Property Value
RowLabels
IXLPivotFields RowLabels { get; }Property Value
ShowColumnHeaders
bool ShowColumnHeaders { get; set; }Property Value
ShowColumnStripes
bool ShowColumnStripes { get; set; }Property Value
ShowContextualTooltips
bool ShowContextualTooltips { get; set; }Property Value
ShowEmptyItemsOnColumns
bool ShowEmptyItemsOnColumns { get; set; }Property Value
ShowEmptyItemsOnRows
bool ShowEmptyItemsOnRows { get; set; }Property Value
ShowExpandCollapseButtons
bool ShowExpandCollapseButtons { get; set; }Property Value
ShowGrandTotalsColumns
bool ShowGrandTotalsColumns { get; set; }Property Value
ShowGrandTotalsRows
bool ShowGrandTotalsRows { get; set; }Property Value
ShowPropertiesInTooltips
bool ShowPropertiesInTooltips { get; set; }Property Value
ShowRowHeaders
bool ShowRowHeaders { get; set; }Property Value
ShowRowStripes
bool ShowRowStripes { get; set; }Property Value
ShowValuesRow
bool ShowValuesRow { get; set; }Property Value
SortFieldsAtoZ
bool SortFieldsAtoZ { get; set; }Property Value
StyleFormats
IXLPivotTableStyleFormats StyleFormats { get; }Property Value
Subtotals
XLPivotSubtotals Subtotals { get; set; }Property Value
TargetCell
IXLCell TargetCell { get; set; }Property Value
Theme
XLPivotTableTheme Theme { get; set; }Property Value
Title
string Title { get; set; }Property Value
UseCustomListsForSorting
bool UseCustomListsForSorting { get; set; }Property Value
Values
IXLPivotValues Values { get; }Property Value
Worksheet
IXLWorksheet Worksheet { get; }Property Value
Methods
CopyTo(IXLCell)
IXLPivotTable CopyTo(IXLCell targetCell)Parameters
targetCellIXLCell
Returns
SetAllowMultipleFilters()
IXLPivotTable SetAllowMultipleFilters()Returns
SetAllowMultipleFilters(bool)
IXLPivotTable SetAllowMultipleFilters(bool value)Parameters
valuebool
Returns
SetAutofitColumns()
IXLPivotTable SetAutofitColumns()Returns
SetAutofitColumns(bool)
IXLPivotTable SetAutofitColumns(bool value)Parameters
valuebool
Returns
SetClassicPivotTableLayout()
IXLPivotTable SetClassicPivotTableLayout()Returns
SetClassicPivotTableLayout(bool)
IXLPivotTable SetClassicPivotTableLayout(bool value)Parameters
valuebool
Returns
SetColumnHeaderCaption(string)
IXLPivotTable SetColumnHeaderCaption(string value)Parameters
valuestring
Returns
SetDescription(string)
IXLPivotTable SetDescription(string value)Parameters
valuestring
Returns
SetDisplayCaptionsAndDropdowns()
IXLPivotTable SetDisplayCaptionsAndDropdowns()Returns
SetDisplayCaptionsAndDropdowns(bool)
IXLPivotTable SetDisplayCaptionsAndDropdowns(bool value)Parameters
valuebool
Returns
SetDisplayItemLabels()
IXLPivotTable SetDisplayItemLabels()Returns
SetDisplayItemLabels(bool)
IXLPivotTable SetDisplayItemLabels(bool value)Parameters
valuebool
Returns
SetEmptyCellReplacement(string)
IXLPivotTable SetEmptyCellReplacement(string value)Parameters
valuestring
Returns
SetEnableCellEditing()
IXLPivotTable SetEnableCellEditing()Returns
SetEnableCellEditing(bool)
IXLPivotTable SetEnableCellEditing(bool value)Parameters
valuebool
Returns
SetEnableShowDetails()
IXLPivotTable SetEnableShowDetails()Returns
SetEnableShowDetails(bool)
IXLPivotTable SetEnableShowDetails(bool value)Parameters
valuebool
Returns
SetErrorValueReplacement(string)
IXLPivotTable SetErrorValueReplacement(string value)Parameters
valuestring
Returns
SetFilterAreaOrder(XLFilterAreaOrder)
IXLPivotTable SetFilterAreaOrder(XLFilterAreaOrder value)Parameters
valueXLFilterAreaOrder
Returns
SetFilterFieldsPageWrap(int)
IXLPivotTable SetFilterFieldsPageWrap(int value)Parameters
valueint
Returns
SetFilteredItemsInSubtotals()
IXLPivotTable SetFilteredItemsInSubtotals()Returns
SetFilteredItemsInSubtotals(bool)
IXLPivotTable SetFilteredItemsInSubtotals(bool value)Parameters
valuebool
Returns
SetInsertBlankLines()
IXLPivotTable SetInsertBlankLines()Returns
SetInsertBlankLines(bool)
IXLPivotTable SetInsertBlankLines(bool value)Parameters
valuebool
Returns
SetLayout(XLPivotLayout)
IXLPivotTable SetLayout(XLPivotLayout value)Parameters
valueXLPivotLayout
Returns
SetMergeAndCenterWithLabels()
IXLPivotTable SetMergeAndCenterWithLabels()Returns
SetMergeAndCenterWithLabels(bool)
IXLPivotTable SetMergeAndCenterWithLabels(bool value)Parameters
valuebool
Returns
SetName(string)
IXLPivotTable SetName(string value)Parameters
valuestring
Returns
SetPreserveCellFormatting()
IXLPivotTable SetPreserveCellFormatting()Returns
SetPreserveCellFormatting(bool)
IXLPivotTable SetPreserveCellFormatting(bool value)Parameters
valuebool
Returns
SetPrintExpandCollapsedButtons()
IXLPivotTable SetPrintExpandCollapsedButtons()Returns
SetPrintExpandCollapsedButtons(bool)
IXLPivotTable SetPrintExpandCollapsedButtons(bool value)Parameters
valuebool
Returns
SetPrintTitles()
IXLPivotTable SetPrintTitles()Returns
SetPrintTitles(bool)
IXLPivotTable SetPrintTitles(bool value)Parameters
valuebool
Returns
SetRepeatRowLabels()
IXLPivotTable SetRepeatRowLabels()Returns
SetRepeatRowLabels(bool)
IXLPivotTable SetRepeatRowLabels(bool value)Parameters
valuebool
Returns
SetRowHeaderCaption(string)
IXLPivotTable SetRowHeaderCaption(string value)Parameters
valuestring
Returns
SetRowLabelIndent(int)
IXLPivotTable SetRowLabelIndent(int value)Parameters
valueint
Returns
SetShowColumnHeaders()
IXLPivotTable SetShowColumnHeaders()Returns
SetShowColumnHeaders(bool)
IXLPivotTable SetShowColumnHeaders(bool value)Parameters
valuebool
Returns
SetShowColumnStripes()
IXLPivotTable SetShowColumnStripes()Returns
SetShowColumnStripes(bool)
IXLPivotTable SetShowColumnStripes(bool value)Parameters
valuebool
Returns
SetShowContextualTooltips()
IXLPivotTable SetShowContextualTooltips()Returns
SetShowContextualTooltips(bool)
IXLPivotTable SetShowContextualTooltips(bool value)Parameters
valuebool
Returns
SetShowEmptyItemsOnColumns()
IXLPivotTable SetShowEmptyItemsOnColumns()Returns
SetShowEmptyItemsOnColumns(bool)
IXLPivotTable SetShowEmptyItemsOnColumns(bool value)Parameters
valuebool
Returns
SetShowEmptyItemsOnRows()
IXLPivotTable SetShowEmptyItemsOnRows()Returns
SetShowEmptyItemsOnRows(bool)
IXLPivotTable SetShowEmptyItemsOnRows(bool value)Parameters
valuebool
Returns
SetShowExpandCollapseButtons()
IXLPivotTable SetShowExpandCollapseButtons()Returns
SetShowExpandCollapseButtons(bool)
IXLPivotTable SetShowExpandCollapseButtons(bool value)Parameters
valuebool
Returns
SetShowGrandTotalsColumns()
IXLPivotTable SetShowGrandTotalsColumns()Returns
SetShowGrandTotalsColumns(bool)
IXLPivotTable SetShowGrandTotalsColumns(bool value)Parameters
valuebool
Returns
SetShowGrandTotalsRows()
IXLPivotTable SetShowGrandTotalsRows()Returns
SetShowGrandTotalsRows(bool)
IXLPivotTable SetShowGrandTotalsRows(bool value)Parameters
valuebool
Returns
SetShowPropertiesInTooltips()
IXLPivotTable SetShowPropertiesInTooltips()Returns
SetShowPropertiesInTooltips(bool)
IXLPivotTable SetShowPropertiesInTooltips(bool value)Parameters
valuebool
Returns
SetShowRowHeaders()
IXLPivotTable SetShowRowHeaders()Returns
SetShowRowHeaders(bool)
IXLPivotTable SetShowRowHeaders(bool value)Parameters
valuebool
Returns
SetShowRowStripes()
IXLPivotTable SetShowRowStripes()Returns
SetShowRowStripes(bool)
IXLPivotTable SetShowRowStripes(bool value)Parameters
valuebool
Returns
SetShowValuesRow()
IXLPivotTable SetShowValuesRow()Returns
SetShowValuesRow(bool)
IXLPivotTable SetShowValuesRow(bool value)Parameters
valuebool
Returns
SetSortFieldsAtoZ()
IXLPivotTable SetSortFieldsAtoZ()Returns
SetSortFieldsAtoZ(bool)
IXLPivotTable SetSortFieldsAtoZ(bool value)Parameters
valuebool
Returns
SetSubtotals(XLPivotSubtotals)
IXLPivotTable SetSubtotals(XLPivotSubtotals value)Parameters
valueXLPivotSubtotals
Returns
SetTitle(string)
IXLPivotTable SetTitle(string value)Parameters
valuestring
Returns
SetUseCustomListsForSorting()
IXLPivotTable SetUseCustomListsForSorting()Returns
SetUseCustomListsForSorting(bool)
IXLPivotTable SetUseCustomListsForSorting(bool value)Parameters
valuebool