Class X14

Namespace

DocumentFormat.OpenXml.Linq

Assembly

DocumentFormat.OpenXml.Linq.dll

Declares XNamespace and XName fields for the xmlns:x14="http://schemas.microsoft.com/office/spreadsheetml/2009/9/main" namespace.

public static class X14

Inheritance

object

X14

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Fields

argumentDescription

Represents the x14:argumentDescription XML element.

public static readonly XName argumentDescription

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: argumentDescriptions.
• has the following XML attributes: index.
• corresponds to the following strongly-typed classes: ArgumentDescription.

argumentDescriptions

Represents the x14:argumentDescriptions XML element.

public static readonly XName argumentDescriptions

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: definedName.
• has the following child XML elements: argumentDescription.
• has the following XML attributes: count.
• corresponds to the following strongly-typed classes: ArgumentDescriptions.

axisColor

Represents the x14:axisColor XML element.

public static readonly XName axisColor

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: dataBar.
• has the following XML attributes: auto, indexed, rgb, theme, tint.
• corresponds to the following strongly-typed classes: BarAxisColor.

borderColor

Represents the x14:borderColor XML element.

public static readonly XName borderColor

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: dataBar.
• has the following XML attributes: auto, indexed, rgb, theme, tint.
• corresponds to the following strongly-typed classes: BorderColor.

cacheField

Represents the x14:cacheField XML element.

public static readonly XName cacheField

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following XML attributes: ignore.
• corresponds to the following strongly-typed classes: CacheField.

cacheHierarchy

Represents the x14:cacheHierarchy XML element.

public static readonly XName cacheHierarchy

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following child XML elements: setLevels.
• has the following XML attributes: flattenHierarchies, hierarchizeDistinct, ignore, measuresSet.
• corresponds to the following strongly-typed classes: CacheHierarchy.

calculatedMember

Represents the x14:calculatedMember XML element.

public static readonly XName calculatedMember

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following child XML elements: tupleSet.
• has the following XML attributes: displayFolder, dynamicSet, flattenHierarchies, hierarchizeDistinct, mdxLong.
• corresponds to the following strongly-typed classes: CalculatedMember.

calculatedMembers

Represents the x14:calculatedMembers XML element.

public static readonly XName calculatedMembers

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: connection.
• has the following child XML elements: calculatedMember.
• has the following XML attributes: count.
• corresponds to the following strongly-typed classes: CalculatedMembers.

cfIcon

Represents the x14:cfIcon XML element.

public static readonly XName cfIcon

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: iconSet.
• has the following XML attributes: iconId, iconSet.
• corresponds to the following strongly-typed classes: ConditionalFormattingIcon.

cfRule

Represents the x14:cfRule XML element.

public static readonly XName cfRule

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: conditionalFormatting.
• has the following child XML elements: colorScale, dataBar, dxf, extLst, iconSet, f.
• has the following XML attributes: aboveAverage, activePresent, bottom, equalAverage, id, operator, percent, priority, rank, stdDev, stopIfTrue, text, timePeriod, type.
• corresponds to the following strongly-typed classes: ConditionalFormattingRule.

cfvo

Represents the x14:cfvo XML element.

public static readonly XName cfvo

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: colorScale, dataBar, iconSet.
• has the following child XML elements: extLst, f.
• has the following XML attributes: gte, type.
• corresponds to the following strongly-typed classes: ConditionalFormattingValueObject.

color

Represents the x14:color XML element.

public static readonly XName color

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: colorScale.
• has the following XML attributes: auto, indexed, rgb, theme, tint.
• corresponds to the following strongly-typed classes: Color.

colorAxis

Represents the x14:colorAxis XML element.

public static readonly XName colorAxis

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: sparklineGroup.
• has the following XML attributes: auto, indexed, rgb, theme, tint.
• corresponds to the following strongly-typed classes: AxisColor.

colorFirst

Represents the x14:colorFirst XML element.

public static readonly XName colorFirst

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: sparklineGroup.
• has the following XML attributes: auto, indexed, rgb, theme, tint.
• corresponds to the following strongly-typed classes: FirstMarkerColor.

colorHigh

Represents the x14:colorHigh XML element.

public static readonly XName colorHigh

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: sparklineGroup.
• has the following XML attributes: auto, indexed, rgb, theme, tint.
• corresponds to the following strongly-typed classes: HighMarkerColor.

colorLast

Represents the x14:colorLast XML element.

public static readonly XName colorLast

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: sparklineGroup.
• has the following XML attributes: auto, indexed, rgb, theme, tint.
• corresponds to the following strongly-typed classes: LastMarkerColor.

colorLow

Represents the x14:colorLow XML element.

public static readonly XName colorLow

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: sparklineGroup.
• has the following XML attributes: auto, indexed, rgb, theme, tint.
• corresponds to the following strongly-typed classes: LowMarkerColor.

colorMarkers

Represents the x14:colorMarkers XML element.

public static readonly XName colorMarkers

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: sparklineGroup.
• has the following XML attributes: auto, indexed, rgb, theme, tint.
• corresponds to the following strongly-typed classes: MarkersColor.

colorNegative

Represents the x14:colorNegative XML element.

public static readonly XName colorNegative

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: sparklineGroup.
• has the following XML attributes: auto, indexed, rgb, theme, tint.
• corresponds to the following strongly-typed classes: NegativeColor.

colorScale

Represents the x14:colorScale XML element.

public static readonly XName colorScale

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: cfRule.
• has the following child XML elements: cfvo, color.
• corresponds to the following strongly-typed classes: ColorScale.

colorSeries

Represents the x14:colorSeries XML element.

public static readonly XName colorSeries

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: sparklineGroup.
• has the following XML attributes: auto, indexed, rgb, theme, tint.
• corresponds to the following strongly-typed classes: SeriesColor.

conditionalFormat

Represents the x14:conditionalFormat XML element.

public static readonly XName conditionalFormat

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: conditionalFormats.
• has the following child XML elements: extLst, pivotAreas.
• has the following XML attributes: id, priority, scope, type.
• corresponds to the following strongly-typed classes: ConditionalFormat.

conditionalFormats

Represents the x14:conditionalFormats XML element.

public static readonly XName conditionalFormats

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: pivotTableDefinition.
• has the following child XML elements: conditionalFormat.
• has the following XML attributes: count.
• corresponds to the following strongly-typed classes: ConditionalFormats.

conditionalFormatting

Represents the x14:conditionalFormatting XML element.

public static readonly XName conditionalFormatting

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: conditionalFormattings.
• has the following child XML elements: cfRule, extLst, sqref.
• has the following XML attributes: pivot.
• corresponds to the following strongly-typed classes: ConditionalFormatting.

conditionalFormattings

Represents the x14:conditionalFormattings XML element.

public static readonly XName conditionalFormattings

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following child XML elements: conditionalFormatting.
• corresponds to the following strongly-typed classes: ConditionalFormattings.

connection

Represents the x14:connection XML element.

public static readonly XName connection

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following child XML elements: calculatedMembers.
• has the following XML attributes: culture, embeddedDataId.
• corresponds to the following strongly-typed classes: Connection.

customFilter

Represents the x14:customFilter XML element.

public static readonly XName customFilter

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: customFilters.
• has the following XML attributes: operator, val.
• corresponds to the following strongly-typed classes: CustomFilter.

customFilters

Represents the x14:customFilters XML element.

public static readonly XName customFilters

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: filterColumn, filter.
• has the following child XML elements: customFilter.
• has the following XML attributes: and.
• corresponds to the following strongly-typed classes: CustomFilters.

data

Represents the x14:data XML element.

public static readonly XName data

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: slicerCacheDefinition.
• has the following child XML elements: olap, tabular.
• corresponds to the following strongly-typed classes: SlicerCacheData.

dataBar

Represents the x14:dataBar XML element.

public static readonly XName dataBar

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: cfRule.
• has the following child XML elements: axisColor, borderColor, cfvo, fillColor, negativeBorderColor, negativeFillColor.
• has the following XML attributes: axisPosition, border, direction, gradient, maxLength, minLength, negativeBarBorderColorSameAsPositive, negativeBarColorSameAsPositive, showValue.
• corresponds to the following strongly-typed classes: DataBar.

dataField

Represents the x14:dataField XML element.

public static readonly XName dataField

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following XML attributes: pivotShowAs, sourceField, uniqueName.
• corresponds to the following strongly-typed classes: DataField.

dataValidation

Represents the x14:dataValidation XML element.

public static readonly XName dataValidation

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: dataValidations.
• has the following child XML elements: formula1, formula2, sqref.
• has the following XML attributes: allowBlank, error, errorStyle, errorTitle, imeMode, operator, prompt, promptTitle, showDropDown, showErrorMessage, showInputMessage, type.
• corresponds to the following strongly-typed classes: DataValidation.

dataValidations

Represents the x14:dataValidations XML element.

public static readonly XName dataValidations

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following child XML elements: dataValidation.
• has the following XML attributes: count, disablePrompts, xWindow, yWindow.
• corresponds to the following strongly-typed classes: DataValidations.

datastoreItem

Represents the x14:datastoreItem XML element.

public static readonly XName datastoreItem

Field Value

XName

Remarks

As an XML element, it:

• has the following child XML elements: extLst.
• has the following XML attributes: id.
• corresponds to the following strongly-typed classes: DatastoreItem.

definedName

Represents the x14:definedName XML element.

public static readonly XName definedName

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: definedNames.
• has the following child XML elements: argumentDescriptions.
• has the following XML attributes: name.
• corresponds to the following strongly-typed classes: DefinedName.

definedNames

Represents the x14:definedNames XML element.

public static readonly XName definedNames

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following child XML elements: definedName.
• corresponds to the following strongly-typed classes: DefinedNames.

dxf

Represents the x14:dxf XML element.

public static readonly XName dxf

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: cfRule.
• has the following child XML elements: alignment, border, extLst, fill, font, numFmt, protection.
• corresponds to the following strongly-typed classes: DifferentialType.

dxfs

Represents the x14:dxfs XML element.

public static readonly XName dxfs

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following child XML elements: dxf.
• has the following XML attributes: count.
• corresponds to the following strongly-typed classes: DifferentialFormats.

editValue

Represents the x14:editValue XML element.

public static readonly XName editValue

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: pivotChange, userEdit.
• has the following XML attributes: valueType.
• corresponds to the following strongly-typed classes: PivotEditValue.

extLst

Represents the x14:extLst XML elements.

public static readonly XName extLst

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: cfRule, cfvo, conditionalFormat, conditionalFormatting, datastoreItem, formControlPr, ignoredErrors, itemLst, olap, pivotChange, pivotEdit, slicer, slicerCacheDefinition, tabular.
• has the following child XML elements: ext.
• corresponds to the following strongly-typed classes: ExtensionList, SlicerCacheDefinitionExtensionList.

fillColor

Represents the x14:fillColor XML element.

public static readonly XName fillColor

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: dataBar.
• has the following XML attributes: auto, indexed, rgb, theme, tint.
• corresponds to the following strongly-typed classes: FillColor.

filter

Represents the x14:filter XML element.

public static readonly XName filter

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: filters.
• has the following XML attributes: val.
• corresponds to the following strongly-typed classes: Filter.

formControlPr

Represents the x14:formControlPr XML element.

public static readonly XName formControlPr

Field Value

XName

Remarks

As an XML element, it:

• has the following child XML elements: extLst, itemLst.
• has the following XML attributes: checked, colored, dropLines, dropStyle, dx, editVal, firstButton, fmlaGroup, fmlaLink, fmlaRange, fmlaTxbx, horiz, inc, justLastX, lockText, max, min, multiLine, multiSel, noThreeD, noThreeD2, objectType, page, passwordEdit, sel, seltype, textHAlign, textVAlign, val, verticalBar, widthMin.
• corresponds to the following strongly-typed classes: FormControlProperties.

formula1

Represents the x14:formula1 XML element.

public static readonly XName formula1

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: dataValidation.
• has the following child XML elements: f.
• corresponds to the following strongly-typed classes: DataValidationForumla1.

formula2

Represents the x14:formula2 XML element.

public static readonly XName formula2

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: dataValidation.
• has the following child XML elements: f.
• corresponds to the following strongly-typed classes: DataValidationForumla2.

header

Represents the x14:header XML element.

public static readonly XName header

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: headers.
• has the following XML attributes: hierarchyName, uniqueName.
• corresponds to the following strongly-typed classes: TupleSetHeader.

headers

Represents the x14:headers XML element.

public static readonly XName headers

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: tupleSet.
• has the following child XML elements: header.
• corresponds to the following strongly-typed classes: TupleSetHeaders.

i

Represents the x14:i XML elements.

public static readonly XName i

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: items, range.
• has the following child XML elements: p.
• has the following XML attributes: c, n, nd, s, x.
• corresponds to the following strongly-typed classes: OlapSlicerCacheItem, TabularSlicerCacheItem.

iconFilter

Represents the x14:iconFilter XML element.

public static readonly XName iconFilter

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: filterColumn, filter.
• has the following XML attributes: iconId, iconSet.
• corresponds to the following strongly-typed classes: IconFilter.

iconSet

Represents the x14:iconSet XML element.

public static readonly XName iconSet

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: cfRule.
• has the following child XML elements: cfIcon, cfvo.
• has the following XML attributes: custom, iconSet, percent, reverse, showValue.
• corresponds to the following strongly-typed classes: IconSet.

id

Represents the x14:id XML element.

public static readonly XName id

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• corresponds to the following strongly-typed classes: Id.

ignoredError

Represents the x14:ignoredError XML element.

public static readonly XName ignoredError

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ignoredErrors.
• has the following child XML elements: sqref.
• has the following XML attributes: calculatedColumn, emptyCellReference, evalError, formula, formulaRange, listDataValidation, numberStoredAsText, twoDigitTextYear, unlockedFormula.
• corresponds to the following strongly-typed classes: IgnoredError.

ignoredErrors

Represents the x14:ignoredErrors XML element.

public static readonly XName ignoredErrors

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following child XML elements: extLst, ignoredError.
• corresponds to the following strongly-typed classes: IgnoredErrors.

item

Represents the x14:item XML element.

public static readonly XName item

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: itemLst.
• has the following XML attributes: val.
• corresponds to the following strongly-typed classes: ListItem.

itemLst

Represents the x14:itemLst XML element.

public static readonly XName itemLst

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: formControlPr.
• has the following child XML elements: extLst, item.
• corresponds to the following strongly-typed classes: ListItems.

items

Represents the x14:items XML element.

public static readonly XName items

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: tabular.
• has the following child XML elements: i.
• has the following XML attributes: count.
• corresponds to the following strongly-typed classes: TabularSlicerCacheItems.

level

Represents the x14:level XML element.

public static readonly XName level

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: levels.
• has the following child XML elements: ranges.
• has the following XML attributes: count, crossFilter, sortOrder, sourceCaption, uniqueName.
• corresponds to the following strongly-typed classes: OlapSlicerCacheLevelData.

levels

Represents the x14:levels XML element.

public static readonly XName levels

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: olap.
• has the following child XML elements: level.
• has the following XML attributes: count.
• corresponds to the following strongly-typed classes: OlapSlicerCacheLevelsData.

negativeBorderColor

Represents the x14:negativeBorderColor XML element.

public static readonly XName negativeBorderColor

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: dataBar.
• has the following XML attributes: auto, indexed, rgb, theme, tint.
• corresponds to the following strongly-typed classes: NegativeBorderColor.

negativeFillColor

Represents the x14:negativeFillColor XML element.

public static readonly XName negativeFillColor

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: dataBar.
• has the following XML attributes: auto, indexed, rgb, theme, tint.
• corresponds to the following strongly-typed classes: NegativeFillColor.

olap

Represents the x14:olap XML element.

public static readonly XName olap

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: data.
• has the following child XML elements: extLst, levels, selections.
• has the following XML attributes: pivotCacheId.
• corresponds to the following strongly-typed classes: OlapSlicerCache.

oleItem

Represents the x14:oleItem XML element.

public static readonly XName oleItem

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: oleItems.
• has the following child XML elements: values.
• has the following XML attributes: advise, icon, name, preferPic.
• corresponds to the following strongly-typed classes: OleItem.

p

Represents the x14:p XML element.

public static readonly XName p

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: i, selection.
• has the following XML attributes: n.
• corresponds to the following strongly-typed classes: OlapSlicerCacheItemParent.

pivotArea

Represents the x14:pivotArea XML element.

public static readonly XName pivotArea

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: pivotEdit.
• has the following child XML elements: extLst, references.
• has the following XML attributes: axis, cacheIndex, collapsedLevelsAreSubtotals, dataOnly, field, fieldPosition, grandCol, grandRow, labelOnly, offset, outline, type.
• corresponds to the following strongly-typed classes: PivotArea.

pivotAreas

Represents the x14:pivotAreas XML element.

public static readonly XName pivotAreas

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: conditionalFormat.
• has the following child XML elements: pivotArea.
• has the following XML attributes: count.
• corresponds to the following strongly-typed classes: PivotAreas.

pivotCacheDefinition

Represents the x14:pivotCacheDefinition XML element.

public static readonly XName pivotCacheDefinition

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following XML attributes: pivotCacheId, slicerData, supportAddCalcMems, supportSubqueryCalcMem, supportSubqueryNonVisual.
• corresponds to the following strongly-typed classes: PivotCacheDefinition.

pivotCaches

Represents the x14:pivotCaches XML element.

public static readonly XName pivotCaches

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following child XML elements: pivotCache.
• corresponds to the following strongly-typed classes: PivotCaches.

pivotChange

Represents the x14:pivotChange XML element.

public static readonly XName pivotChange

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: pivotChanges.
• has the following child XML elements: editValue, extLst, tupleItems.
• has the following XML attributes: allocationMethod, weightExpression.
• corresponds to the following strongly-typed classes: PivotChange.

pivotChanges

Represents the x14:pivotChanges XML element.

public static readonly XName pivotChanges

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: pivotTableDefinition.
• has the following child XML elements: pivotChange.
• corresponds to the following strongly-typed classes: PivotChanges.

pivotEdit

Represents the x14:pivotEdit XML element.

public static readonly XName pivotEdit

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: pivotEdits.
• has the following child XML elements: extLst, pivotArea, tupleItems, userEdit.
• corresponds to the following strongly-typed classes: PivotEdit.

pivotEdits

Represents the x14:pivotEdits XML element.

public static readonly XName pivotEdits

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: pivotTableDefinition.
• has the following child XML elements: pivotEdit.
• corresponds to the following strongly-typed classes: PivotEdits.

pivotField

Represents the x14:pivotField XML element.

public static readonly XName pivotField

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following XML attributes: fillDownLabels, ignore.
• corresponds to the following strongly-typed classes: PivotField.

pivotHierarchy

Represents the x14:pivotHierarchy XML element.

public static readonly XName pivotHierarchy

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following XML attributes: ignore.
• corresponds to the following strongly-typed classes: PivotHierarchy.

pivotTable

Represents the x14:pivotTable XML element.

public static readonly XName pivotTable

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: pivotTables, slicerCachePivotTables.
• has the following XML attributes: name, tabId.
• corresponds to the following strongly-typed classes: SlicerCachePivotTable.

pivotTableDefinition

Represents the x14:pivotTableDefinition XML element.

public static readonly XName pivotTableDefinition

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following child XML elements: conditionalFormats, pivotChanges, pivotEdits.
• has the following XML attributes: allocationMethod, altText, altTextSummary, autoApply, calculatedMembersInFilters, enableEdit, fillDownLabelsDefault, hideValuesRow, visualTotalsForSets, weightExpression.
• corresponds to the following strongly-typed classes: PivotTableDefinition.

pivotTables

Represents the x14:pivotTables XML element.

public static readonly XName pivotTables

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: slicerCacheDefinition.
• has the following child XML elements: pivotTable.
• corresponds to the following strongly-typed classes: SlicerCachePivotTables.

protectedRange

Represents the x14:protectedRange XML element.

public static readonly XName protectedRange

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: protectedRanges.
• has the following child XML elements: sqref.
• has the following XML attributes: algorithmName, hashValue, name, password, saltValue, securityDescriptor, spinCount.
• corresponds to the following strongly-typed classes: ProtectedRange.

protectedRanges

Represents the x14:protectedRanges XML element.

public static readonly XName protectedRanges

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following child XML elements: protectedRange.
• corresponds to the following strongly-typed classes: ProtectedRanges.

range

Represents the x14:range XML element.

public static readonly XName range

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ranges.
• has the following child XML elements: i.
• has the following XML attributes: startItem.
• corresponds to the following strongly-typed classes: OlapSlicerCacheRange.

ranges

Represents the x14:ranges XML element.

public static readonly XName ranges

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: level.
• has the following child XML elements: range.
• corresponds to the following strongly-typed classes: OlapSlicerCacheRanges.

row

Represents the x14:row XML element.

public static readonly XName row

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: rows.
• has the following child XML elements: rowItem.
• corresponds to the following strongly-typed classes: TupleSetRow.

rowItem

Represents the x14:rowItem XML element.

public static readonly XName rowItem

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: row.
• has the following XML attributes: d, u.
• corresponds to the following strongly-typed classes: TupleSetRowItem.

rows

Represents the x14:rows XML element.

public static readonly XName rows

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: tupleSet.
• has the following child XML elements: row.
• corresponds to the following strongly-typed classes: TupleSetRows.

selection

Represents the x14:selection XML element.

public static readonly XName selection

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: selections.
• has the following child XML elements: p.
• has the following XML attributes: n.
• corresponds to the following strongly-typed classes: OlapSlicerCacheSelection.

selections

Represents the x14:selections XML element.

public static readonly XName selections

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: olap.
• has the following child XML elements: selection.
• has the following XML attributes: count.
• corresponds to the following strongly-typed classes: OlapSlicerCacheSelections.

setLevel

Represents the x14:setLevel XML element.

public static readonly XName setLevel

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: setLevels.
• has the following XML attributes: hierarchy.
• corresponds to the following strongly-typed classes: SetLevel.

setLevels

Represents the x14:setLevels XML element.

public static readonly XName setLevels

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: cacheHierarchy.
• has the following child XML elements: setLevel.
• has the following XML attributes: count.
• corresponds to the following strongly-typed classes: SetLevels.

slicer

Represents the x14:slicer XML elements.

public static readonly XName slicer

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: slicerList, slicers.
• has the following child XML elements: extLst.
• has the following XML attributes: cache, caption, columnCount, level, lockedPosition, name, id, rowHeight, showCaption, startItem, style.
• corresponds to the following strongly-typed classes: Slicer, SlicerRef.

slicerCache

Represents the x14:slicerCache XML element.

public static readonly XName slicerCache

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: slicerCaches, slicerCaches.
• has the following XML attributes: id.
• corresponds to the following strongly-typed classes: SlicerCache.

slicerCacheDefinition

Represents the x14:slicerCacheDefinition XML element.

public static readonly XName slicerCacheDefinition

Field Value

XName

Remarks

As an XML element, it:

• has the following child XML elements: data, extLst, pivotTables.
• has the following XML attributes: name, sourceName.
• corresponds to the following strongly-typed classes: SlicerCacheDefinition.

slicerCaches

Represents the x14:slicerCaches XML element.

public static readonly XName slicerCaches

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following child XML elements: slicerCache.
• corresponds to the following strongly-typed classes: SlicerCaches.

slicerList

Represents the x14:slicerList XML element.

public static readonly XName slicerList

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following child XML elements: slicer.
• corresponds to the following strongly-typed classes: SlicerList.

slicerStyle

Represents the x14:slicerStyle XML element.

public static readonly XName slicerStyle

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: slicerStyles.
• has the following child XML elements: slicerStyleElements.
• has the following XML attributes: name.
• corresponds to the following strongly-typed classes: SlicerStyle.

slicerStyleElement

Represents the x14:slicerStyleElement XML element.

public static readonly XName slicerStyleElement

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: slicerStyleElements.
• has the following XML attributes: dxfId_, type.
• corresponds to the following strongly-typed classes: SlicerStyleElement.

slicerStyleElements

Represents the x14:slicerStyleElements XML element.

public static readonly XName slicerStyleElements

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: slicerStyle.
• has the following child XML elements: slicerStyleElement.
• corresponds to the following strongly-typed classes: SlicerStyleElements.

slicerStyles

Represents the x14:slicerStyles XML element.

public static readonly XName slicerStyles

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following child XML elements: slicerStyle.
• has the following XML attributes: defaultSlicerStyle.
• corresponds to the following strongly-typed classes: SlicerStyles.

slicers

Represents the x14:slicers XML element.

public static readonly XName slicers

Field Value

XName

Remarks

As an XML element, it:

• has the following child XML elements: slicer.
• corresponds to the following strongly-typed classes: Slicers.

sortCondition

Represents the x14:sortCondition XML element.

public static readonly XName sortCondition

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: sortState.
• has the following XML attributes: customList, descending, dxfId_, iconId, iconSet, ref, sortBy.
• corresponds to the following strongly-typed classes: SortCondition.

sourceConnection

Represents the x14:sourceConnection XML element.

public static readonly XName sourceConnection

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following XML attributes: name.
• corresponds to the following strongly-typed classes: SourceConnection.

sparkline

Represents the x14:sparkline XML element.

public static readonly XName sparkline

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: sparklines.
• has the following child XML elements: f, sqref.
• corresponds to the following strongly-typed classes: Sparkline.

sparklineGroup

Represents the x14:sparklineGroup XML element.

public static readonly XName sparklineGroup

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: sparklineGroups.
• has the following child XML elements: colorAxis, colorFirst, colorHigh, colorLast, colorLow, colorMarkers, colorNegative, colorSeries, sparklines, f.
• has the following XML attributes: dateAxis, displayEmptyCellsAs, displayHidden, displayXAxis, first, high, last, lineWeight, low, manualMax, manualMin, markers, maxAxisType, minAxisType, negative, rightToLeft, type.
• corresponds to the following strongly-typed classes: SparklineGroup.

sparklineGroups

Represents the x14:sparklineGroups XML element.

public static readonly XName sparklineGroups

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following child XML elements: sparklineGroup.
• corresponds to the following strongly-typed classes: SparklineGroups.

sparklines

Represents the x14:sparklines XML element.

public static readonly XName sparklines

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: sparklineGroup.
• has the following child XML elements: sparkline.
• corresponds to the following strongly-typed classes: Sparklines.

table

Represents the x14:table XML element.

public static readonly XName table

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following XML attributes: altText, altTextSummary.
• corresponds to the following strongly-typed classes: Table.

tabular

Represents the x14:tabular XML element.

public static readonly XName tabular

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: data.
• has the following child XML elements: extLst, items.
• has the following XML attributes: crossFilter, customListSort, pivotCacheId, showMissing, sortOrder.
• corresponds to the following strongly-typed classes: TabularSlicerCache.

tupleItem

Represents the x14:tupleItem XML element.

public static readonly XName tupleItem

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: tupleItems.
• corresponds to the following strongly-typed classes: Xstring.

tupleItems

Represents the x14:tupleItems XML element.

public static readonly XName tupleItems

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: pivotChange, pivotEdit.
• has the following child XML elements: tupleItem.
• corresponds to the following strongly-typed classes: TupleItems.

tupleSet

Represents the x14:tupleSet XML element.

public static readonly XName tupleSet

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: calculatedMember.
• has the following child XML elements: headers, rows.
• has the following XML attributes: columnCount, rowCount.
• corresponds to the following strongly-typed classes: TupleSet.

userEdit

Represents the x14:userEdit XML element.

public static readonly XName userEdit

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: pivotEdit.
• has the following child XML elements: editValue, f.
• corresponds to the following strongly-typed classes: PivotUserEdit.

values

Represents the x14:values XML element.

public static readonly XName values

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: oleItem.
• has the following child XML elements: value.
• has the following XML attributes: cols, rows.
• corresponds to the following strongly-typed classes: DdeValues.

workbookPr

Represents the x14:workbookPr XML element.

public static readonly XName workbookPr

Field Value

XName

Remarks

As an XML element, it:

• has the following parent XML elements: ext.
• has the following XML attributes: accuracyVersion, defaultImageDpi, discardImageEditData.
• corresponds to the following strongly-typed classes: WorkbookProperties.

x14

Defines the XML namespace associated with the x14 prefix.

public static readonly XNamespace x14

Field Value

XNamespace