Spire.XLS API

Spire.XLS namespace

AlertStyleType Enumeration

AutoFormatOptions Enumeration

AutoFormatType Enumeration

AverageType Enumeration

AxisLineIdentifierType Enumeration

AxisTextDirectionType Enumeration

AxisType Enumeration

AxisTypes Enumeration

BaseFormatType Enumeration

BookmarkHyperlink Class

BordersLineType Enumeration

BubbleSizeType Enumeration

BuiltInPropertyType Enumeration

BuiltInStyles Enumeration

CategoryType Enumeration

CellBorder Class

CellDataType Enumeration

CellFormatType Enumeration

CellRange Class

CellStyle Class

CellStyleFlag Class

CellStyleObject Class

ChartBackgroundMode Enumeration

ChartBaseUnitType Enumeration

ChartDisplayUnitType Enumeration

ChartExPositionAlignment Enumeration

ChartExSidePosition Enumeration

ChartLinePatternType Enumeration

ChartLineWeightType Enumeration

ChartMarkerType Enumeration

ChartParagraphType Enumeration

ChartPieType Enumeration

ChartPlotEmptyType Enumeration

ChartShadow Class

ChartSheet Class

ChartStyleElements Enumeration

CheckState Enumeration

ColorModel Enumeration

ColorScale Class

ColorType Enumeration

CommentHAlignType Enumeration

CommentVAlignType Enumeration

ComparisonOperatorType Enumeration

CompoundLineType Enumeration

ConditionalFormat Class

ConditionalFormats Class

ConditionalFormatScope Enumeration

ConditionalFormatType Enumeration

ConditionalFormatWrapper Class

ConditionalTopNType Enumeration

ConditionValue Class

ConditionValuePosition Enumeration

ConditionValueType Enumeration

ConnectionDataSourceType Enumeration

ConverterSetting Class

CopyRangeOptions Enumeration

CustomFontData Class

DataLabelPositionType Enumeration

DataSourceType Enumeration

DBConnection Class

DeleteOption Enumeration

DocumentProperty Class

DropLineStyleType Enumeration

EndLineCap Enumeration

ErrorBarIncludeType Enumeration

ErrorBarType Enumeration

Excel2007DataLabelPos Enumeration

Excel2016Charttype Enumeration

ExcelAddInFunction Class

ExcelCalculationMode Enumeration

ExcelChartType Enumeration

ExcelClearOptions Enumeration

ExcelColors Enumeration

ExcelComboType Enumeration

ExcelComment Class

ExcelCommentObject Class

ExcelFindOptions Enumeration

ExcelFont Class

ExcelGradient Class

ExcelHorizontalAlignment Enumeration

ExcelInterior Class

ExcelPatternType Enumeration

ExcelPicture Class

ExcelQuartileCalculation Enumeration

ExcelSaveType Enumeration

ExcelShapeType Enumeration

ExcelSheetType Enumeration

ExcelTotalsCalculation Enumeration

ExcelTreeMapLabelOption Enumeration

ExcelVersion Enumeration

ExcelVerticalAlignment Enumeration

ExpandCollapseFlags Enumeration

ExportTableOptions Class

ExternalConnection Class

ExternalLink Class

FileFormat Enumeration

FilterConditionType Enumeration

FilterDataType Enumeration

FindType Enumeration

FontCollectionIndex Enumeration

FontUnderlineType Enumeration

FontVertialAlignmentType Enumeration

GoalSeekResult Class

GradientColorType Enumeration

GradientPatternType Enumeration

GradientPresetType Enumeration

GradientStyleType Enumeration

GradientTextureType Enumeration

GradientVariantsType Enumeration

GroupByType Enumeration

HorizontalAlignType Enumeration

HPageBreak Class

HttpContentType Enumeration

HyperLink Class

HyperLinkType Enumeration

IConditionValue Interface

IconSetType Enumeration

IgnoreErrorType Enumeration

ImageFormatType Enumeration

ImageType Enumeration

ImportObjectOptions Class

InsertMoveOption Enumeration

InsertOptionsType Enumeration

IPropertyData Interface

LegendPositionType Enumeration

LegendSpacingType Enumeration

LineShapeType Enumeration

LineStyleType Enumeration

MarkerDesigner Class

MeasureUnits Enumeration

MsoPathType Enumeration

OdsPageBackground Class

OdsPageBackgroundImagePositionType Enumeration

OdsPageBackgroundImageType Enumeration

OdsPageBackgroundType Enumeration

OLEDBCommandType Enumeration

OleLinkType Enumeration

OleObjectType Enumeration

OrderBy Enumeration

OrderType Enumeration

PageBreakExtentType Enumeration

PageBreakType Enumeration

PageColRow Structure

PageImagePaintedEventArgs Class

PageImagePaintedHandler Delegate

PageOrientationType Enumeration

PageSetup Class

PagesOrderType Enumeration

PaperSizeType Enumeration

PathFillMode Enumeration

PivotAutoFomatTypes Enumeration

PivotBuiltInStyles Enumeration

PivotCache Class

PivotDataType Enumeration

PivotField Class

PivotFieldFormatType Enumeration

PivotFieldSortType Enumeration

PivotGroupByTypes Enumeration

PivotItemType Enumeration

PivotLabelFilterType Enumeration

PivotPageAreaFieldsOrderType Enumeration

PivotTable Class

PivotTableElement Enumeration

PivotTableFields Class

PivotTableLayoutType Enumeration

PivotValueFilterType Enumeration

PresetTextEffect Enumeration

PrintCommentType Enumeration

PrintErrorsType Enumeration

PrintingPageType Enumeration

PropertyType Enumeration

PrstGeomShapeType Enumeration

QueryTableXls Class

ReadingOrderType Enumeration

RectangleShapeType Enumeration

RectangleStyleType Enumeration

ReferRangeArea Class

RenameStrategy Enumeration

ResizeBehaveType Enumeration

RichTextObject Class

SaveShapeTypeOption Class

SelectionType Enumeration

ShapeArrowLengthType Enumeration

ShapeArrowStyleType Enumeration

ShapeArrowWidthType Enumeration

ShapeDashLineStyleType Enumeration

ShapeFillType Enumeration

ShapeGlow Class

ShapeLayerChangeType Enumeration

ShapeLineStyleType Enumeration

ShapeReflection Class

SheetProtectionType Enumeration

SlicerCacheCrossFilterType Enumeration

SortComparsionType Enumeration

SortedWayType Enumeration

SortOrientationType Enumeration

Sparkline Class

SparklineCollection Class

SparklineEmptyCells Enumeration

SparklineGroup Class

SparklineGroupCollection Class

SparklineType Enumeration

SpartlineVerticalAxisType Enumeration

SplitType Enumeration

StyleEntryModifierEnum Enumeration

SubtotalTypes Enumeration

TableBuiltInStyles Enumeration

TextDirection Enumeration

TextRotationType Enumeration

TextSaveOptions Class

TextVerticalValue Enumeration

ThemeColorType Enumeration

TickLabelPositionType Enumeration

TickMarkType Enumeration

TopBottomType Enumeration

TopFormatType Enumeration

TrendLineType Enumeration

UnknownVariableAction Enumeration

Validation Class

ValidationComparisonOperator Enumeration

VariableTypeAction Enumeration

VerticalAlignType Enumeration

ViewMode Enumeration

VPageBreak Class

WebQueryConnection Class

Worksheet Class

WorksheetCopyType Enumeration

WorksheetVisibility Enumeration

XlsConditionValue Class

XlsDocumentProperty Class

XlsSlicer Class

XlsSlicerCache Class

XlsSlicerCacheItem Class

XlsSlicerCacheItemCollection Class

XlsSlicerCollection Class

XLSXBorderJoinType Enumeration

XLSXChartBevelType Enumeration

XLSXChartLightingType Enumeration

XLSXChartMaterialType Enumeration

XLSXChartPrespectiveType Enumeration

XLSXChartShadowInnerType Enumeration

XLSXChartShadowOuterType Enumeration

XLSXPivotItemType Enumeration

XmlOpenType Enumeration

Click or drag to resize

PivotItemType Enumeration

Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)

Syntax

public enum PivotItemType

Public Enumeration PivotItemType

public enum class PivotItemType

type PivotItemType

Members

	Member name	Value	Description
	Average	0	Represents the Average
	Blank	1	Represent the Blank line in the pivot Table
	Count	2	Represent the count aggregate functions
	CountA	3	Represent the count number aggregate functions
	Data	4	Represent the data
	Default	5	Represent the default type of Pivot Table. (total aggregate is default)
	GrandTotal	6	Represent the grand total
	Max	7	Represent the maximum aggregate function
	Min	8	Represent the minimum aggregate function
	Product	9	Represent the product functions
	StdDev	10	Represents the "standard deviation" aggregate function.
	StdDevP	11	Represents the "standard deviation population" aggregate function.
	Sum	12	Represents the "sum" aggregate value.
	Var	13	Represents the "variance" aggregate value.
	VarP	14	Represents the "variance population" aggregate value.

See Also

Reference

Spire.Xls Namespace