Interface IXLPivotField
- Namespace
- SlapKit.Excel.Excel
- Assembly
- SlapKit.Excel.dll
public interface IXLPivotField
- Extension Methods
-
Properties
Collapsed
bool Collapsed { get; set; }
Property Value
- bool
Compact
bool Compact { get; set; }
Property Value
- bool
CustomName
string CustomName { get; set; }
Property Value
- string
IncludeNewItemsInFilter
bool IncludeNewItemsInFilter { get; set; }
Property Value
- bool
InsertBlankLines
bool InsertBlankLines { get; set; }
Property Value
- bool
InsertPageBreaks
bool InsertPageBreaks { get; set; }
Property Value
- bool
IsInFilterList
bool IsInFilterList { get; }
Property Value
- bool
IsOnColumnAxis
bool IsOnColumnAxis { get; }
Property Value
- bool
IsOnRowAxis
bool IsOnRowAxis { get; }
Property Value
- bool
Offset
Property Value
- int
Outline
bool Outline { get; set; }
Property Value
- bool
RepeatItemLabels
bool RepeatItemLabels { get; set; }
Property Value
- bool
SelectedValues
IList<XLCellValue> SelectedValues { get; }
Property Value
- IList<XLCellValue>
ShowBlankItems
bool ShowBlankItems { get; set; }
Property Value
- bool
SortType
XLPivotSortType SortType { get; set; }
Property Value
- XLPivotSortType
SourceName
string SourceName { get; }
Property Value
- string
IXLPivotFieldStyleFormats StyleFormats { get; }
Property Value
- IXLPivotFieldStyleFormats
SubtotalCaption
string SubtotalCaption { get; set; }
Property Value
- string
Subtotals
List<XLSubtotalFunction> Subtotals { get; }
Property Value
- List<XLSubtotalFunction>
SubtotalsAtTop
bool? SubtotalsAtTop { get; set; }
Property Value
- bool?
Methods
AddSelectedValue(XLCellValue)
IXLPivotField AddSelectedValue(XLCellValue value)
Parameters
value XLCellValue
Returns
- IXLPivotField
AddSelectedValues(IEnumerable<XLCellValue>)
IXLPivotField AddSelectedValues(IEnumerable<XLCellValue> values)
Parameters
values IEnumerable<XLCellValue>
Returns
- IXLPivotField
AddSubtotal(XLSubtotalFunction)
IXLPivotField AddSubtotal(XLSubtotalFunction value)
Parameters
value XLSubtotalFunction
Returns
- IXLPivotField
SetCollapsed()
IXLPivotField SetCollapsed()
Returns
- IXLPivotField
SetCollapsed(bool)
IXLPivotField SetCollapsed(bool value)
Parameters
value bool
Returns
- IXLPivotField
SetCustomName(string)
IXLPivotField SetCustomName(string value)
Parameters
value string
Returns
- IXLPivotField
SetIncludeNewItemsInFilter()
IXLPivotField SetIncludeNewItemsInFilter()
Returns
- IXLPivotField
SetIncludeNewItemsInFilter(bool)
IXLPivotField SetIncludeNewItemsInFilter(bool value)
Parameters
value bool
Returns
- IXLPivotField
SetInsertBlankLines()
IXLPivotField SetInsertBlankLines()
Returns
- IXLPivotField
SetInsertBlankLines(bool)
IXLPivotField SetInsertBlankLines(bool value)
Parameters
value bool
Returns
- IXLPivotField
SetInsertPageBreaks()
IXLPivotField SetInsertPageBreaks()
Returns
- IXLPivotField
SetInsertPageBreaks(bool)
IXLPivotField SetInsertPageBreaks(bool value)
Parameters
value bool
Returns
- IXLPivotField
SetLayout(XLPivotLayout)
IXLPivotField SetLayout(XLPivotLayout value)
Parameters
value XLPivotLayout
Returns
- IXLPivotField
SetRepeatItemLabels()
IXLPivotField SetRepeatItemLabels()
Returns
- IXLPivotField
SetRepeatItemLabels(bool)
IXLPivotField SetRepeatItemLabels(bool value)
Parameters
value bool
Returns
- IXLPivotField
SetShowBlankItems()
IXLPivotField SetShowBlankItems()
Returns
- IXLPivotField
SetShowBlankItems(bool)
IXLPivotField SetShowBlankItems(bool value)
Parameters
value bool
Returns
- IXLPivotField
SetSort(XLPivotSortType)
IXLPivotField SetSort(XLPivotSortType value)
Parameters
value XLPivotSortType
Returns
- IXLPivotField
SetSubtotalCaption(string)
IXLPivotField SetSubtotalCaption(string value)
Parameters
value string
Returns
- IXLPivotField
SetSubtotalsAtTop()
IXLPivotField SetSubtotalsAtTop()
Returns
- IXLPivotField
SetSubtotalsAtTop(bool)
IXLPivotField SetSubtotalsAtTop(bool value)
Parameters
value bool
Returns
- IXLPivotField