EMA3D API Documentation

EMA3D API Documentation

EMA3D Scripting API

EMC Plus API V25 Documentation

DocumentFormat Namespaces

DocumentFormat.OpenXml.Spreadsheet

Alignment Class

AutoFilter Class

AutoSortScope Class

BackgroundColor Class

BookViews Class

BooleanItem Class

BooleanPropertyType Class

BorderPropertiesType Class

BorderStyleValues Enumeration

BottomBorder Class

CacheField Class

CacheFieldExtension Class

CacheFieldExtensionList Class

CacheFields Class

CacheHierarchies Class

CacheHierarchy Class

CacheHierarchyExtension Class

CacheHierarchyExtensionList Class

CacheSource Class

CacheSourceExtension Class

CacheSourceExtensionList Class

CalculatedColumnFormula Class

CalculatedItem Class

CalculatedItems Class

CalculatedMember Class

CalculatedMemberExtension Class

CalculatedMemberExtensionList Class

CalculatedMembers Class

CalculateModeValues Enumeration

CalculationCell Class

CalculationChain Class

CalculationProperties Class

CalendarValues Enumeration

CellCommentsValues Enumeration

CellFormat Class

CellFormats Class

CellFormula Class

CellFormulaValues Enumeration

CellMetadata Class

CellStyle Class

CellStyleFormats Class

CellStyles Class

CellValue Class

CellValues Enumeration

CellWatch Class

CellWatches Class

CharacterValue Class

ChartFormat Class

ChartFormats Class

Chartsheet Class

ChartSheetPageSetup Class

ChartSheetProperties Class

ChartSheetProtection Class

ChartSheetView Class

ChartSheetViews Class

ColorFilter Class

ColorScale Class

ColorType Class

ColumnBreaks Class

ColumnFields Class

ColumnHierarchiesUsage Class

ColumnHierarchyUsage Class

ColumnItems Class

CommentList Class

CommentProperties Class

CommentsValues Enumeration

CommentText Class

ConditionalFormat Class

ConditionalFormats Class

ConditionalFormatting Class

ConditionalFormattingOperatorValues Enumeration

ConditionalFormattingRule Class

ConditionalFormattingRuleExtension Class

ConditionalFormattingRuleExtensionList Class

ConditionalFormatValueObject Class

ConditionalFormatValueObjectValues Enumeration

ConditionalFormatValues Enumeration

ConformanceClass Enumeration

Connection Class

ConnectionExtension Class

ConnectionExtensionList Class

Connections Class

Consolidation Class

ControlProperties Class

CredentialsMethodValues Enumeration

CustomChartsheetView Class

CustomChartsheetViews Class

CustomFilter Class

CustomFilters Class

CustomProperties Class

CustomProperty Class

CustomSheetView Class

CustomSheetViews Class

CustomWorkbookView Class

CustomWorkbookViews Class

DatabaseProperties Class

DataBinding Class

DataConsolidate Class

DataConsolidateFunctionValues Enumeration

DataField Class

DataFieldExtension Class

DataFieldExtensionList Class

DataFields Class

DataReference Class

DataReferences Class

DataValidation Class

DataValidationErrorStyleValues Enumeration

DataValidationImeModeValues Enumeration

DataValidationOperatorValues Enumeration

DataValidations Class

DataValidationValues Enumeration

DataViewAspectValues Enumeration

DateGroupItem Class

DateTimeGroupingValues Enumeration

DateTimeItem Class

DdeLinkValue Class

DdeValues Enumeration

DefinedName Class

DefinedNames Class

DeletedField Class

DiagonalBorder Class

DialogSheet Class

DifferentialFormat Class

DifferentialFormats Class

DifferentialFormatType Class

Dimension Class

Dimensions Class

DiscreteProperties Class

DrawingHeaderFooter Class

DynamicFilter Class

DynamicFilterValues Enumeration

EmbeddedObjectProperties Class

EndBorder Class

ErrorItem Class

EvenFooter Class

EvenHeader Class

Extension Class

ExtensionList Class

ExternalBook Class

ExternalCell Class

ExternalConnectionValues Enumeration

ExternalDefinedName Class

ExternalDefinedNames Class

ExternalLink Class

ExternalReference Class

ExternalReferences Class

ExternalRow Class

ExternalSheetData Class

FieldGroup Class

FieldItem Class

FieldSortValues Enumeration

FieldsUsage Class

FieldUsage Class

FileRecoveryProperties Class

FileSharing Class

FileTypeValues Enumeration

FileVersion Class

FilterColumn Class

FilterOperatorValues Enumeration

FirstFooter Class

FirstHeader Class

FontCharSet Class

FontFamily Class

FontFamilyNumbering Class

FontScheme Class

FontSchemeValues Enumeration

ForegroundColor Class

FormatActionValues Enumeration

FormulaExpressionValues Enumeration

FromMarker Class

FunctionGroup Class

FunctionGroups Class

FutureMetadata Class

FutureMetadataBlock Class

GradientFill Class

GradientStop Class

GradientValues Enumeration

GroupByValues Enumeration

GroupItems Class

GroupLevel Class

GroupLevels Class

GroupMember Class

GroupMembers Class

GrowShrinkValues Enumeration

HeaderFooter Class

HierarchyUsageType Class

HorizontalAlignmentValues Enumeration

HorizontalBorder Class

HtmlFormattingValues Enumeration

Hyperlink Class

Hyperlinks Class

IconFilter Class

IconSetValues Enumeration

IgnoredError Class

IgnoredErrors Class

IndexedColors Class

InlineString Class

InputCells Class

InternationalPropertyType Class

ItemValues Enumeration

LeftBorder Class

LegacyDrawing Class

LegacyDrawingHeaderFooter Class

LegacyDrawingType Class

MarkerType Class

MdxFunctionValues Enumeration

MdxKPIPropertyValues Enumeration

MdxMemberProp Class

MdxMetadata Class

MdxSetOrderValues Enumeration

MeasureDimensionMap Class

MeasureGroup Class

MeasureGroups Class

MemberProperties Class

MemberPropertiesMap Class

MemberProperty Class

MemberPropertyIndex Class

MergeCell Class

MergeCells Class

MetadataBlock Class

MetadataBlocksType Class

MetadataRecord Class

MetadataStrings Class

MetadataType Class

MetadataTypes Class

MissingItem Class

MissingTable Class

MruColors Class

NameIndex Class

NewDifferentialFormat Class

NumberingFormat Class

NumberingFormats Class

NumberItem Class

ObjectAnchor Class

ObjectDisplayValues Enumeration

OddFooter Class

OddHeader Class

OlapProperties Class

OldDifferentialFormat Class

OldFormula Class

OleObject Class

OleObjects Class

OleUpdateValues Enumeration

OrientationValues Enumeration

OutlineProperties Class

PageBreakType Class

PageField Class

PageFields Class

PageMargins Class

PageOrderValues Enumeration

PageSetup Class

PageSetupProperties Class

PaneStateValues Enumeration

PaneValues Enumeration

Parameter Class

Parameters Class

ParameterValues Enumeration

PatternFill Class

PatternValues Enumeration

PhoneticAlignmentValues Enumeration

PhoneticProperties Class

PhoneticRun Class

PhoneticValues Enumeration

PivotArea Class

PivotAreaReference Class

PivotAreaReferences Class

PivotAreas Class

PivotAreaValues Enumeration

PivotCache Class

PivotCacheDefinition Class

PivotCacheDefinitionExtension Class

PivotCacheDefinitionExtensionList Class

PivotCacheRecord Class

PivotCacheRecords Class

PivotCaches Class

PivotField Class

PivotFieldExtension Class

PivotFieldExtensionList Class

PivotFields Class

PivotFilter Class

PivotFilterExtension Class

PivotFilterExtensionList Class

PivotFilters Class

PivotFilterValues Enumeration

PivotHierarchies Class

PivotHierarchy Class

PivotHierarchyExtension Class

PivotHierarchyExtensionList Class

PivotSelection Class

PivotTableAxisValues Enumeration

PivotTableDefinition Class

PivotTableDefinitionExtension Class

PivotTableDefinitionExtensionList Class

PivotTableStyle Class

PrintErrorValues Enumeration

PrintOptions Class

ProtectedRange Class

ProtectedRanges Class

Protection Class

QualifierValues Enumeration

QueryCache Class

QueryTable Class

QueryTableDeletedFields Class

QueryTableExtension Class

QueryTableExtensionList Class

QueryTableField Class

QueryTableFields Class

QueryTableRefresh Class

RangeProperties Class

RangeSets Class

ReferenceModeValues Enumeration

ReviewedList Class

RevisionActionValues Enumeration

RevisionAutoFormat Class

RevisionCellChange Class

RevisionComment Class

RevisionConflict Class

RevisionCustomView Class

RevisionDefinedName Class

RevisionFormat Class

RevisionInsertSheet Class

RevisionMove Class

RevisionQueryTable Class

RevisionRowColumn Class

Revisions Class

RevisionSheetName Class

RichDataPivotCacheGuid Class

RightBorder Class

RowBreaks Class

RowColumnActionValues Enumeration

RowFields Class

RowHierarchiesUsage Class

RowHierarchyUsage Class

RuleValues Enumeration

RunProperties Class

RunPropertyCharSet Class

Scenarios Class

ScopeValues Enumeration

Selection Class

ServerFormat Class

ServerFormats Class

SharedItems Class

SharedStringItem Class

SharedStringTable Class

SheetCalculationProperties Class

SheetData Class

SheetDataSet Class

SheetDimension Class

SheetFormatProperties Class

SheetIdMap Class

SheetName Class

SheetNames Class

SheetProperties Class

SheetProtection Class

SheetStateValues Enumeration

SheetView Class

SheetViews Class

SheetViewValues Enumeration

ShowDataAsValues Enumeration

SingleXmlCell Class

SingleXmlCells Class

SlicerCacheDefinitionExtension Class

SortByTuple Class

SortByValues Enumeration

SortCondition Class

SortMethodValues Enumeration

SortState Class

SortValues Enumeration

SourceValues Enumeration

StartBorder Class

StringItem Class

Stylesheet Class

StylesheetExtension Class

StylesheetExtensionList Class

TableColumn Class

TableColumns Class

TableExtension Class

TableExtensionList Class

TableFormulaType Class

TablePart Class

TableParts Class

TableStyle Class

TableStyleElement Class

TableStyleInfo Class

TableStyles Class

TableStyleValues Enumeration

TableValues Enumeration

TargetScreenSizeValues Enumeration

TextField Class

TextFields Class

TextHorizontalAlignmentValues Enumeration

TextProperties Class

TextVerticalAlignmentValues Enumeration

TimePeriodValues Enumeration

TopBorder Class

TopicReferences Class

TotalsRowFormula Class

TotalsRowFunctionValues Enumeration

TupleCache Class

TuplesType Class

Underline Class

UnderlineValues Enumeration

UpdateLinksBehaviorValues Enumeration

ValueMetadata Class

VerticalAlignmentRunValues Enumeration

VerticalAlignmentValues Enumeration

VerticalBorder Class

VerticalTextAlignment Class

VisibilityValues Enumeration

VolatileDependencyValues Enumeration

VolatileType Class

VolatileTypes Class

VolatileValues Enumeration

WebPublishing Class

WebPublishItem Class

WebPublishItems Class

WebPublishObject Class

WebPublishObjects Class

WebQueryProperties Class

WebSourceValues Enumeration

WorkbookExtension Class

WorkbookExtensionList Class

WorkbookProperties Class

WorkbookProtection Class

WorkbookView Class

Worksheet Class

WorksheetExtension Class

WorksheetExtensionList Class

WorksheetSource Class

XmlCellProperties Class

XmlColumnProperties Class

XmlDataValues Enumeration

XmlProperties Class

XstringType Class

Click or drag to resize

ItemValues Enumeration

PivotItem Type

Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll) Version: 2.20.0+Branch.release-v2.20.0.Sha.a873d3fbff9bffe179fea62486da950adf5be65d.a873d3fbff9bffe179fea62486da950adf5be65d

Syntax

public enum ItemValues

Public Enumeration ItemValues

public enum class ItemValues

type ItemValues

Members

Member name	Value	Description
Data	0	Data. When the item is serialized out as xml, its value is "data".
Default	1	Default. When the item is serialized out as xml, its value is "default".
Sum	2	Sum. When the item is serialized out as xml, its value is "sum".
CountA	3	CountA. When the item is serialized out as xml, its value is "countA".
Average	4	Average. When the item is serialized out as xml, its value is "avg".
Maximum	5	Max. When the item is serialized out as xml, its value is "max".
Minimum	6	Min. When the item is serialized out as xml, its value is "min".
Product	7	Product. When the item is serialized out as xml, its value is "product".
Count	8	Count. When the item is serialized out as xml, its value is "count".
StandardDeviation	9	stdDev. When the item is serialized out as xml, its value is "stdDev".
StandardDeviationP	10	StdDevP. When the item is serialized out as xml, its value is "stdDevP".
Variance	11	Var. When the item is serialized out as xml, its value is "var".
VarianceP	12	VarP. When the item is serialized out as xml, its value is "varP".
Grand	13	Grand Total Item. When the item is serialized out as xml, its value is "grand".
Blank	14	Blank Pivot Item. When the item is serialized out as xml, its value is "blank".

See Also

Reference

DocumentFormat.OpenXml.Spreadsheet Namespace