Class X

Namespace: DocumentFormat.OpenXml.Linq

Assembly: DocumentFormat.OpenXml.Linq.dll

Declares XNamespace and XName fields for the xmlns:x="http://schemas.openxmlformats.org/spreadsheetml/2006/main" namespace.

public static class X

Inheritance: object

X

Inherited Members: object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Fields

DataBinding

Represents the x:DataBinding XML element.

public static readonly XName DataBinding

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: Map_.
has the following XML attributes: ConnectionID_, DataBindingLoadMode, DataBindingName, FileBinding, FileBindingName.
corresponds to the following strongly-typed classes: DataBinding.

MapInfo

Represents the x:MapInfo XML element.

public static readonly XName MapInfo

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: Map_, Schema.
has the following XML attributes: SelectionNamespaces.
corresponds to the following strongly-typed classes: MapInfo.

Map_

Represents the x:Map XML element.

public static readonly XName Map_

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: MapInfo.
has the following child XML elements: DataBinding.
has the following XML attributes: Append, AutoFit, ID_, Name_, PreserveFormat, PreserveSortAFLayout, RootElement, SchemaID, ShowImportExportValidationErrors.
corresponds to the following strongly-typed classes: Map.

Schema

Represents the x:Schema XML element.

public static readonly XName Schema

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: MapInfo.
has the following XML attributes: ID_, Namespace, SchemaRef.
corresponds to the following strongly-typed classes: Schema.

alignment

Represents the x:alignment XML element.

public static readonly XName alignment

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: dxf, ndxf, odxf, xf, dxf, dxf.
has the following XML attributes: horizontal, indent, justifyLastLine, mergeCell, readingOrder, relativeIndent, shrinkToFit, textRotation, vertical, wrapText.
corresponds to the following strongly-typed classes: Alignment.

anchor

Represents the x:anchor XML element.

public static readonly XName anchor

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: commentPr, controlPr, objectPr.
has the following child XML elements: from, to.
has the following XML attributes: moveWithCells, sizeWithCells, z_order.
corresponds to the following strongly-typed classes: ObjectAnchor.

author

Represents the x:author XML element.

public static readonly XName author

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: authors.
has the following XML attributes: space.
corresponds to the following strongly-typed classes: Author.

authors

Represents the x:authors XML element.

public static readonly XName authors

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: comments.
has the following child XML elements: author.
corresponds to the following strongly-typed classes: Authors.

autoFilter

Represents the x:autoFilter XML element.

public static readonly XName autoFilter

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: customSheetView, filter, table, worksheet, macrosheet.
has the following child XML elements: extLst, filterColumn, sortState.
has the following XML attributes: ref.
corresponds to the following strongly-typed classes: AutoFilter.

autoSortScope

Represents the x:autoSortScope XML element.

public static readonly XName autoSortScope

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotField.
has the following child XML elements: pivotArea.
corresponds to the following strongly-typed classes: AutoSortScope.

b

Represents the x:b XML elements.

public static readonly XName b

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: font, groupItems, r, rPr, sharedItems.
has the following child XML elements: x_.
has the following XML attributes: c, cp, f, u, v, val.
corresponds to the following strongly-typed classes: Bold, BooleanItem.

bgColor

Represents the x:bgColor XML element.

public static readonly XName bgColor

Field Value

XName

Remarks

As an XML element, it:

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

bk

Represents the x:bk XML elements.

public static readonly XName bk

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: cellMetadata, futureMetadata, valueMetadata.
has the following child XML elements: extLst, rc.
corresponds to the following strongly-typed classes: FutureMetadataBlock, MetadataBlock.

bookViews

Represents the x:bookViews XML element.

public static readonly XName bookViews

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: workbook.
has the following child XML elements: workbookView.
corresponds to the following strongly-typed classes: BookViews.

border

Represents the x:border XML element.

public static readonly XName border

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: borders, dxf, ndxf, odxf, dxf, dxf.
has the following child XML elements: bottom, diagonal, end, horizontal, left, right, start, top, vertical.
has the following XML attributes: diagonalDown, diagonalUp, outline.
corresponds to the following strongly-typed classes: Border.

borders

Represents the x:borders XML element.

public static readonly XName borders

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: styleSheet.
has the following child XML elements: border.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: Borders.

bottom

Represents the x:bottom XML element.

public static readonly XName bottom

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: border.
has the following child XML elements: color.
has the following XML attributes: style.
corresponds to the following strongly-typed classes: BottomBorder.

brk

Represents the x:brk XML element.

public static readonly XName brk

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: colBreaks, rowBreaks.
has the following XML attributes: id, man, max, min, pt.
corresponds to the following strongly-typed classes: Break.

c

Represents the x:c XML elements.

public static readonly XName c

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: calcChain, row.
has the following child XML elements: extLst, f, is, v.
has the following XML attributes: a, cm, i, l, ph, r, s, t, vm.
corresponds to the following strongly-typed classes: CalculationCell, Cell.

cacheField

Represents the x:cacheField XML element.

public static readonly XName cacheField

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: cacheFields.
has the following child XML elements: extLst, fieldGroup, mpMap, sharedItems.
has the following XML attributes: caption, databaseField, formula, hierarchy, level, mappingCount, memberPropertyField, name, numFmtId, propertyName, serverField, sqlType, uniqueList.
corresponds to the following strongly-typed classes: CacheField.

cacheFields

Represents the x:cacheFields XML element.

public static readonly XName cacheFields

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotCacheDefinition.
has the following child XML elements: cacheField.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: CacheFields.

cacheHierarchies

Represents the x:cacheHierarchies XML element.

public static readonly XName cacheHierarchies

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotCacheDefinition.
has the following child XML elements: cacheHierarchy.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: CacheHierarchies.

cacheHierarchy

Represents the x:cacheHierarchy XML element.

public static readonly XName cacheHierarchy

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: cacheHierarchies.
has the following child XML elements: extLst, fieldsUsage, groupLevels.
has the following XML attributes: allCaption, allUniqueName, attribute, caption, count, defaultMemberUniqueName, dimensionUniqueName, displayFolder, hidden, iconSet, keyAttribute, measure, measureGroup, measures, memberValueDatatype, oneField, parentSet, set, time, unbalanced, unbalancedGroup, uniqueName.
corresponds to the following strongly-typed classes: CacheHierarchy.

cacheSource

Represents the x:cacheSource XML element.

public static readonly XName cacheSource

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotCacheDefinition.
has the following child XML elements: consolidation, extLst, worksheetSource.
has the following XML attributes: connectionId, type.
corresponds to the following strongly-typed classes: CacheSource.

calcChain

Represents the x:calcChain XML element.

public static readonly XName calcChain

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: c, extLst.
corresponds to the following strongly-typed classes: CalculationChain.

calcPr

Represents the x:calcPr XML element.

public static readonly XName calcPr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: workbook.
has the following XML attributes: calcCompleted, calcId, calcMode_, calcOnSave, concurrentCalc, concurrentManualCount, forceFullCalc, fullCalcOnLoad, fullPrecision, iterate, iterateCount, iterateDelta, refMode.
corresponds to the following strongly-typed classes: CalculationProperties.

calculatedColumnFormula

Represents the x:calculatedColumnFormula XML element.

public static readonly XName calculatedColumnFormula

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: tableColumn.
has the following XML attributes: array, space.
corresponds to the following strongly-typed classes: CalculatedColumnFormula.

calculatedItem

Represents the x:calculatedItem XML element.

public static readonly XName calculatedItem

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: calculatedItems.
has the following child XML elements: extLst, pivotArea.
has the following XML attributes: field, formula.
corresponds to the following strongly-typed classes: CalculatedItem.

calculatedItems

Represents the x:calculatedItems XML element.

public static readonly XName calculatedItems

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotCacheDefinition.
has the following child XML elements: calculatedItem.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: CalculatedItems.

calculatedMember

Represents the x:calculatedMember XML element.

public static readonly XName calculatedMember

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: calculatedMembers, calculatedMembers.
has the following child XML elements: extLst.
has the following XML attributes: hierarchy, mdx, memberName, name, parent, set, solveOrder.
corresponds to the following strongly-typed classes: CalculatedMember.

calculatedMembers

Represents the x:calculatedMembers XML element.

public static readonly XName calculatedMembers

Field Value

XName

Remarks

As an XML element, it:

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

cell

Represents the x:cell XML element.

public static readonly XName cell

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: row.
has the following child XML elements: v.
has the following XML attributes: r, t, vm.
corresponds to the following strongly-typed classes: ExternalCell.

cellMetadata

Represents the x:cellMetadata XML element.

public static readonly XName cellMetadata

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: metadata.
has the following child XML elements: bk.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: CellMetadata.

cellStyle

Represents the x:cellStyle XML element.

public static readonly XName cellStyle

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: cellStyles.
has the following child XML elements: extLst.
has the following XML attributes: builtinId, customBuiltin, hidden, iLevel, name, xfId.
corresponds to the following strongly-typed classes: CellStyle.

cellStyleXfs

Represents the x:cellStyleXfs XML element.

public static readonly XName cellStyleXfs

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: styleSheet.
has the following child XML elements: xf.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: CellStyleFormats.

cellStyles

Represents the x:cellStyles XML element.

public static readonly XName cellStyles

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: styleSheet.
has the following child XML elements: cellStyle.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: CellStyles.

cellWatch

Represents the x:cellWatch XML element.

public static readonly XName cellWatch

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: cellWatches.
has the following XML attributes: r.
corresponds to the following strongly-typed classes: CellWatch.

cellWatches

Represents the x:cellWatches XML element.

public static readonly XName cellWatches

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: worksheet.
has the following child XML elements: cellWatch.
corresponds to the following strongly-typed classes: CellWatches.

cellXfs

Represents the x:cellXfs XML element.

public static readonly XName cellXfs

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: styleSheet.
has the following child XML elements: xf.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: CellFormats.

cfRule

Represents the x: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, extLst, formula, iconSet.
has the following XML attributes: aboveAverage, bottom, dxfId_, equalAverage, operator, percent, priority, rank, stdDev, stopIfTrue, text, timePeriod, type.
corresponds to the following strongly-typed classes: ConditionalFormattingRule.

cfvo

Represents the x: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.
has the following XML attributes: gte, type, val.
corresponds to the following strongly-typed classes: ConditionalFormatValueObject.

charset

Represents the x:charset XML elements.

public static readonly XName charset

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: font, rPr.
has the following XML attributes: val.
corresponds to the following strongly-typed classes: FontCharSet, RunPropertyCharSet.

chartFormat

Represents the x:chartFormat XML element.

public static readonly XName chartFormat

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: chartFormats.
has the following child XML elements: pivotArea.
has the following XML attributes: chart, format, series.
corresponds to the following strongly-typed classes: ChartFormat.

chartFormats

Represents the x:chartFormats XML element.

public static readonly XName chartFormats

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotTableDefinition.
has the following child XML elements: chartFormat.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: ChartFormats.

chartsheet

Represents the x:chartsheet XML element.

public static readonly XName chartsheet

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: customSheetViews, drawing, drawingHF, extLst, headerFooter, legacyDrawing, legacyDrawingHF, pageMargins, pageSetup, picture, sheetPr, sheetProtection, sheetViews, webPublishItems.
corresponds to the following strongly-typed classes: Chartsheet.

col

Represents the x:col XML element.

public static readonly XName col

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: cols.
has the following XML attributes: bestFit, collapsed, customWidth, hidden, max, min, outlineLevel, phonetic, style, width.
corresponds to the following strongly-typed classes: Column.

colBreaks

Represents the x:colBreaks XML element.

public static readonly XName colBreaks

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: customSheetView, worksheet, macrosheet.
has the following child XML elements: brk.
has the following XML attributes: count, manualBreakCount.
corresponds to the following strongly-typed classes: ColumnBreaks.

colFields

Represents the x:colFields XML element.

public static readonly XName colFields

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotTableDefinition.
has the following child XML elements: field.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: ColumnFields.

colHierarchiesUsage

Represents the x:colHierarchiesUsage XML element.

public static readonly XName colHierarchiesUsage

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotTableDefinition.
has the following child XML elements: colHierarchyUsage.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: ColumnHierarchiesUsage.

colHierarchyUsage

Represents the x:colHierarchyUsage XML element.

public static readonly XName colHierarchyUsage

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: colHierarchiesUsage.
has the following XML attributes: hierarchyUsage.
corresponds to the following strongly-typed classes: ColumnHierarchyUsage.

colItems

Represents the x:colItems XML element.

public static readonly XName colItems

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotTableDefinition.
has the following child XML elements: i.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: ColumnItems.

color

Represents the x:color XML element.

public static readonly XName color

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: bottom, colorScale, dataBar, diagonal, end, font, horizontal, left, mruColors, right, rPr, start, stop, top, vertical.
has the following XML attributes: auto, indexed, rgb, theme, tint.
corresponds to the following strongly-typed classes: Color.

colorFilter

Represents the x:colorFilter XML element.

public static readonly XName colorFilter

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: filterColumn, filter.
has the following XML attributes: cellColor, dxfId_.
corresponds to the following strongly-typed classes: ColorFilter.

colorScale

Represents the x: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.

colors

Represents the x:colors XML element.

public static readonly XName colors

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: styleSheet.
has the following child XML elements: indexedColors, mruColors.
corresponds to the following strongly-typed classes: Colors.

cols

Represents the x:cols XML element.

public static readonly XName cols

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: worksheet, macrosheet.
has the following child XML elements: col.
corresponds to the following strongly-typed classes: Columns.

comment

Represents the x:comment XML element.

public static readonly XName comment

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: commentList.
has the following child XML elements: commentPr, text.
has the following XML attributes: authorId, guid, ref, shapeId.
corresponds to the following strongly-typed classes: Comment.

commentList

Represents the x:commentList XML element.

public static readonly XName commentList

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: comments.
has the following child XML elements: comment.
corresponds to the following strongly-typed classes: CommentList.

commentPr

Represents the x:commentPr XML element.

public static readonly XName commentPr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: comment.
has the following child XML elements: anchor.
has the following XML attributes: altText, autoFill, autoLine, autoScale, colHidden, defaultSize, disabled, justLastX, locked, lockText, print, rowHidden, textHAlign, textVAlign, uiObject.
corresponds to the following strongly-typed classes: CommentProperties.

comments

Represents the x:comments XML element.

public static readonly XName comments

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: authors, commentList, extLst.
corresponds to the following strongly-typed classes: Comments.

condense

Represents the x:condense XML element.

public static readonly XName condense

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: font, rPr.
has the following XML attributes: val.
corresponds to the following strongly-typed classes: Condense.

conditionalFormat

Represents the x: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: priority, scope, type.
corresponds to the following strongly-typed classes: ConditionalFormat.

conditionalFormats

Represents the x: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 x:conditionalFormatting XML element.

public static readonly XName conditionalFormatting

Field Value

XName

Remarks

As an XML element, it:

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

connection

Represents the x:connection XML element.

public static readonly XName connection

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: connections.
has the following child XML elements: dbPr, extLst, olapPr, parameters, textPr, webPr.
has the following XML attributes: background, credentials, deleted, description, id, interval, keepAlive, minRefreshableVersion, name, new, odcFile, onlyUseConnectionFile, reconnectionMethod, refreshedVersion, refreshOnLoad, saveData, savePassword, singleSignOnId, sourceFile, type.
corresponds to the following strongly-typed classes: Connection.

connections

Represents the x:connections XML element.

public static readonly XName connections

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: connection.
corresponds to the following strongly-typed classes: Connections.

consolidation

Represents the x:consolidation XML element.

public static readonly XName consolidation

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: cacheSource.
has the following child XML elements: pages, rangeSets.
has the following XML attributes: autoPage.
corresponds to the following strongly-typed classes: Consolidation.

control

Represents the x:control XML element.

public static readonly XName control

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: controls.
has the following child XML elements: controlPr.
has the following XML attributes: name, id, shapeId.
corresponds to the following strongly-typed classes: Control.

controlPr

Represents the x:controlPr XML element.

public static readonly XName controlPr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: control.
has the following child XML elements: anchor.
has the following XML attributes: altText, autoFill, autoLine, autoPict, cf, defaultSize, disabled, linkedCell, listFillRange, locked, macro, print, id, recalcAlways, uiObject.
corresponds to the following strongly-typed classes: ControlProperties.

controls

Represents the x:controls XML element.

public static readonly XName controls

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: dialogsheet, worksheet.
has the following child XML elements: control.
corresponds to the following strongly-typed classes: Controls.

customFilter

Represents the x: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 x: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.

customPr

Represents the x:customPr XML element.

public static readonly XName customPr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: customProperties.
has the following XML attributes: name, id.
corresponds to the following strongly-typed classes: CustomProperty.

customProperties

Represents the x:customProperties XML element.

public static readonly XName customProperties

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: worksheet, macrosheet.
has the following child XML elements: customPr.
corresponds to the following strongly-typed classes: CustomProperties.

customSheetView

Represents the x:customSheetView XML elements.

public static readonly XName customSheetView

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: customSheetViews.
has the following child XML elements: autoFilter, colBreaks, extLst, headerFooter, pageMargins, pageSetup, pane, printOptions, rowBreaks, selection.
has the following XML attributes: colorId, filter, filterUnique, fitToPage, guid, hiddenColumns, hiddenRows, outlineSymbols, printArea, scale, showAutoFilter, showFormulas, showGridLines, showPageBreaks, showRowCol, showRuler, state, topLeftCell, view, zeroValues, zoomToFit.
corresponds to the following strongly-typed classes: CustomChartsheetView, CustomSheetView.

customSheetViews

Represents the x:customSheetViews XML elements.

public static readonly XName customSheetViews

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: chartsheet, dialogsheet, worksheet, macrosheet.
has the following child XML elements: customSheetView.
corresponds to the following strongly-typed classes: CustomChartsheetViews, CustomSheetViews.

customWorkbookView

Represents the x:customWorkbookView XML element.

public static readonly XName customWorkbookView

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: customWorkbookViews.
has the following child XML elements: extLst.
has the following XML attributes: activeSheetId, autoUpdate, changesSavedWin, guid, includeHiddenRowCol, includePrintSettings, maximized, mergeInterval, minimized, name, onlySync, personalView, showComments, showFormulaBar, showHorizontalScroll, showObjects, showSheetTabs, showStatusbar, showVerticalScroll, tabRatio, windowHeight, windowWidth, xWindow, yWindow.
corresponds to the following strongly-typed classes: CustomWorkbookView.

customWorkbookViews

Represents the x:customWorkbookViews XML element.

public static readonly XName customWorkbookViews

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: workbook.
has the following child XML elements: customWorkbookView.
corresponds to the following strongly-typed classes: CustomWorkbookViews.

d

Represents the x:d XML element.

public static readonly XName d

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: groupItems, r, sharedItems.
has the following child XML elements: x_.
has the following XML attributes: c, cp, f, u, v.
corresponds to the following strongly-typed classes: DateTimeItem.

dataBar

Represents the x: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: cfvo, color.
has the following XML attributes: maxLength, minLength, showValue.
corresponds to the following strongly-typed classes: DataBar.

dataConsolidate

Represents the x:dataConsolidate XML element.

public static readonly XName dataConsolidate

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: worksheet, macrosheet.
has the following child XML elements: dataRefs.
has the following XML attributes: function, leftLabels, link, startLabels, topLabels.
corresponds to the following strongly-typed classes: DataConsolidate.

dataField

Represents the x:dataField XML element.

public static readonly XName dataField

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: dataFields.
has the following child XML elements: extLst.
has the following XML attributes: baseField, baseItem, fld, name, numFmtId, showDataAs, subtotal.
corresponds to the following strongly-typed classes: DataField.

dataFields

Represents the x:dataFields XML element.

public static readonly XName dataFields

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotTableDefinition.
has the following child XML elements: dataField.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: DataFields.

dataRef

Represents the x:dataRef XML element.

public static readonly XName dataRef

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: dataRefs.
has the following XML attributes: name, id, ref, sheet.
corresponds to the following strongly-typed classes: DataReference.

dataRefs

Represents the x:dataRefs XML element.

public static readonly XName dataRefs

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: dataConsolidate.
has the following child XML elements: dataRef.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: DataReferences.

dataValidation

Represents the x: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, list.
has the following XML attributes: allowBlank, error, errorStyle, errorTitle, imeMode, operator, prompt, promptTitle, showDropDown, showErrorMessage, showInputMessage, sqref, type.
corresponds to the following strongly-typed classes: DataValidation.

dataValidations

Represents the x:dataValidations XML element.

public static readonly XName dataValidations

Field Value

XName

Remarks

As an XML element, it:

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

dateGroupItem

Represents the x:dateGroupItem XML element.

public static readonly XName dateGroupItem

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: filters.
has the following XML attributes: dateTimeGrouping, day, hour, minute, month, second, year.
corresponds to the following strongly-typed classes: DateGroupItem.

dbPr

Represents the x:dbPr XML element.

public static readonly XName dbPr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: connection.
has the following XML attributes: command, commandType, connection, serverCommand.
corresponds to the following strongly-typed classes: DatabaseProperties.

ddeItem

Represents the x:ddeItem XML element.

public static readonly XName ddeItem

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: ddeItems.
has the following child XML elements: values.
has the following XML attributes: advise, name, ole, preferPic.
corresponds to the following strongly-typed classes: DdeItem.

ddeItems

Represents the x:ddeItems XML element.

public static readonly XName ddeItems

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: ddeLink.
has the following child XML elements: ddeItem.
corresponds to the following strongly-typed classes: DdeItems.

ddeLink

Represents the x:ddeLink XML element.

public static readonly XName ddeLink

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: externalLink.
has the following child XML elements: ddeItems.
has the following XML attributes: ddeService, ddeTopic.
corresponds to the following strongly-typed classes: DdeLink.

definedName

Represents the x:definedName XML elements.

public static readonly XName definedName

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: definedNames.
has the following XML attributes: comment, customMenu, description, function, functionGroupId, help, hidden, localSheetId, name, publishToServer, refersTo, sheetId, shortcutKey, statusBar, vbProcedure, workbookParameter, xlm.
corresponds to the following strongly-typed classes: DefinedName, ExternalDefinedName.

definedNames

Represents the x:definedNames XML elements.

public static readonly XName definedNames

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: externalBook, workbook.
has the following child XML elements: definedName.
corresponds to the following strongly-typed classes: DefinedNames, ExternalDefinedNames.

deletedField

Represents the x:deletedField XML element.

public static readonly XName deletedField

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: queryTableDeletedFields.
has the following XML attributes: name.
corresponds to the following strongly-typed classes: DeletedField.

diagonal

Represents the x:diagonal XML element.

public static readonly XName diagonal

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: border.
has the following child XML elements: color.
has the following XML attributes: style.
corresponds to the following strongly-typed classes: DiagonalBorder.

dialogsheet

Represents the x:dialogsheet XML element.

public static readonly XName dialogsheet

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: controls, customSheetViews, drawing, drawingHF, extLst, headerFooter, legacyDrawing, legacyDrawingHF, oleObjects, pageMargins, pageSetup, printOptions, sheetFormatPr, sheetPr, sheetProtection, sheetViews.
corresponds to the following strongly-typed classes: DialogSheet.

dimension

Represents the x:dimension XML elements.

public static readonly XName dimension

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: dimensions, worksheet, macrosheet.
has the following XML attributes: caption, measure, name, ref, uniqueName.
corresponds to the following strongly-typed classes: Dimension, SheetDimension.

dimensions

Represents the x:dimensions XML element.

public static readonly XName dimensions

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotCacheDefinition.
has the following child XML elements: dimension.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: Dimensions.

discretePr

Represents the x:discretePr XML element.

public static readonly XName discretePr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: fieldGroup.
has the following child XML elements: x_.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: DiscreteProperties.

drawing

Represents the x:drawing XML element.

public static readonly XName drawing

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: chartsheet, dialogsheet, worksheet, macrosheet.
has the following XML attributes: id.
corresponds to the following strongly-typed classes: Drawing.

drawingHF

Represents the x:drawingHF XML element.

public static readonly XName drawingHF

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: chartsheet, dialogsheet, worksheet, macrosheet.
has the following XML attributes: cfe, cff, cfo, che, chf, cho, lfe, lff, lfo, lhe, lhf, lho, id, rfe, rff, rfo, rhe, rhf, rho.
corresponds to the following strongly-typed classes: DrawingHeaderFooter.

dxf

Represents the x:dxf XML element.

public static readonly XName dxf

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: dxfs, rfmt, dxfs, dxfs, dxfs.
has the following child XML elements: alignment, border, extLst, fill, font, numFmt, protection.
corresponds to the following strongly-typed classes: DifferentialFormat.

dxfs

Represents the x:dxfs XML element.

public static readonly XName dxfs

Field Value

XName

Remarks

As an XML element, it:

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

dynamicFilter

Represents the x:dynamicFilter XML element.

public static readonly XName dynamicFilter

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: filterColumn, filter.
has the following XML attributes: maxVal, maxValIso, type, val, valIso.
corresponds to the following strongly-typed classes: DynamicFilter.

e

Represents the x:e XML element.

public static readonly XName e

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: entries, groupItems, r, sharedItems.
has the following child XML elements: tpls, x_.
has the following XML attributes: b, bc, c, cp, f, fc, i, in, st, u, un, v.
corresponds to the following strongly-typed classes: ErrorItem.

end

Represents the x:end XML element.

public static readonly XName end

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: border.
has the following child XML elements: color.
has the following XML attributes: style.
corresponds to the following strongly-typed classes: EndBorder.

entries

Represents the x:entries XML element.

public static readonly XName entries

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: tupleCache.
has the following child XML elements: e, m, n, s.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: Entries.

evenFooter

Represents the x:evenFooter XML element.

public static readonly XName evenFooter

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: headerFooter.
has the following XML attributes: space.
corresponds to the following strongly-typed classes: EvenFooter.

evenHeader

Represents the x:evenHeader XML element.

public static readonly XName evenHeader

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: headerFooter.
has the following XML attributes: space.
corresponds to the following strongly-typed classes: EvenHeader.

ext

Represents the x:ext XML elements.

public static readonly XName ext

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: extLst, extLst, extLst, extLst, extLst, extLst, extLst, extLst.
has the following child XML elements: cacheField, cacheHierarchy, calculatedMember, conditionalFormattings, connection, dataField, dataValidations, definedNames, dxfs, id, ignoredErrors, pivotCacheDefinition, pivotCaches, pivotField, pivotHierarchy, pivotTableDefinition, protectedRanges, slicerCaches, slicerList, slicerStyles, sourceConnection, sparklineGroups, table, workbookPr, cachedUniqueNames, cacheHierarchy, calculatedMember, connection, dataField, dataModel, dxfs, movingPeriodState, pivotCacheDecoupled, pivotCacheIdVersion, pivotCaches, pivotFilter, pivotTableData, pivotTableReferences, pivotTableUISettings, queryTable, slicerCacheHideItemsWithNoData, slicerCachePivotTables, slicerCaches, tableSlicerCache, timelineCachePivotCaches, timelineCacheRefs, timelinePivotCacheDefinition, timelineRefs, timelineStyles, webExtensions, workbookPr.
has the following XML attributes: uri.
corresponds to the following strongly-typed classes: CacheFieldExtension, CacheHierarchyExtension, CacheSourceExtension, CalculatedMemberExtension, ConditionalFormattingRuleExtension, ConnectionExtension, DataFieldExtension, Extension, PivotCacheDefinitionExtension, PivotFieldExtension, PivotFilterExtension, PivotHierarchyExtension, PivotTableDefinitionExtension, QueryTableExtension, SlicerCacheDefinitionExtension, StylesheetExtension, TableExtension, WorkbookExtension, WorksheetExtension.

extLst

Represents the x:extLst XML elements.

public static readonly XName extLst

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: autoFilter, bk, c, cacheField, cacheHierarchy, cacheSource, calcChain, calculatedItem, calculatedMember, cellStyle, cfRule, cfvo, chartsheet, comments, conditionalFormat, conditionalFormatting, connection, customSheetView, customWorkbookView, dataField, dialogsheet, dxf, externalLink, filter, filterColumn, format, futureMetadata, groupLevel, header, ignoredErrors, metadata, nc, ndxf, oc, odxf, pageField, pivotArea, pivotCacheDefinition, pivotCacheRecords, pivotField, pivotHierarchy, pivotTableDefinition, queryTable, queryTableField, queryTableRefresh, rcc, rdn, reference, rfmt, row, rsnm, sheetView, sheetViews, singleXmlCell, sortState, sst, styleSheet, table, tableColumn, tupleCache, userInfo, volTypes, workbook, workbookView, worksheet, xf, xmlCellPr, xmlColumnPr, xmlPr, dxf, pivotArea, macrosheet, dxf, filter.
has the following child XML elements: ext.
corresponds to the following strongly-typed classes: CacheFieldExtensionList, CacheHierarchyExtensionList, CacheSourceExtensionList, CalculatedMemberExtensionList, ConditionalFormattingRuleExtensionList, ConnectionExtensionList, DataFieldExtensionList, ExtensionList, PivotCacheDefinitionExtensionList, PivotFieldExtensionList, PivotFilterExtensionList, PivotHierarchyExtensionList, PivotTableDefinitionExtensionList, QueryTableExtensionList, StylesheetExtensionList, TableExtensionList, WorkbookExtensionList, WorksheetExtensionList.

extend

Represents the x:extend XML element.

public static readonly XName extend

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: font, rPr.
has the following XML attributes: val.
corresponds to the following strongly-typed classes: Extend.

externalBook

Represents the x:externalBook XML element.

public static readonly XName externalBook

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: externalLink.
has the following child XML elements: definedNames, sheetDataSet, sheetNames.
has the following XML attributes: id.
corresponds to the following strongly-typed classes: ExternalBook.

externalLink

Represents the x:externalLink XML element.

public static readonly XName externalLink

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: ddeLink, externalBook, extLst, oleLink.
corresponds to the following strongly-typed classes: ExternalLink.

externalReference

Represents the x:externalReference XML element.

public static readonly XName externalReference

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: externalReferences.
has the following XML attributes: id.
corresponds to the following strongly-typed classes: ExternalReference.

externalReferences

Represents the x:externalReferences XML element.

public static readonly XName externalReferences

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: workbook.
has the following child XML elements: externalReference.
corresponds to the following strongly-typed classes: ExternalReferences.

f

Represents the x:f XML element.

public static readonly XName f

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: c, nc, oc.
has the following XML attributes: aca, bx, ca, del1, del2, dt2D, dtr, r1, r2, ref, si, t, space.
corresponds to the following strongly-typed classes: CellFormula.

family

Represents the x:family XML elements.

public static readonly XName family

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: font, rPr.
has the following XML attributes: val.
corresponds to the following strongly-typed classes: FontFamily, FontFamilyNumbering.

fgColor

Represents the x:fgColor XML element.

public static readonly XName fgColor

Field Value

XName

Remarks

As an XML element, it:

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

field

Represents the x:field XML element.

public static readonly XName field

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: colFields, rowFields.
has the following XML attributes: x.
corresponds to the following strongly-typed classes: Field.

fieldGroup

Represents the x:fieldGroup XML element.

public static readonly XName fieldGroup

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: cacheField.
has the following child XML elements: discretePr, groupItems, rangePr.
has the following XML attributes: base, par.
corresponds to the following strongly-typed classes: FieldGroup.

fieldUsage

Represents the x:fieldUsage XML element.

public static readonly XName fieldUsage

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: fieldsUsage.
has the following XML attributes: x.
corresponds to the following strongly-typed classes: FieldUsage.

fieldsUsage

Represents the x:fieldsUsage XML element.

public static readonly XName fieldsUsage

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: cacheHierarchy.
has the following child XML elements: fieldUsage.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: FieldsUsage.

fileRecoveryPr

Represents the x:fileRecoveryPr XML element.

public static readonly XName fileRecoveryPr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: workbook.
has the following XML attributes: autoRecover, crashSave, dataExtractLoad, repairLoad.
corresponds to the following strongly-typed classes: FileRecoveryProperties.

fileSharing

Represents the x:fileSharing XML element.

public static readonly XName fileSharing

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: workbook.
has the following XML attributes: algorithmName, hashValue, readOnlyRecommended, reservationPassword, saltValue, spinCount, userName.
corresponds to the following strongly-typed classes: FileSharing.

fileVersion

Represents the x:fileVersion XML element.

public static readonly XName fileVersion

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: workbook.
has the following XML attributes: appName, codeName, lastEdited, lowestEdited, rupBuild.
corresponds to the following strongly-typed classes: FileVersion.

fill

Represents the x:fill XML element.

public static readonly XName fill

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: dxf, fills, ndxf, odxf, dxf, dxf.
has the following child XML elements: gradientFill, patternFill.
corresponds to the following strongly-typed classes: Fill.

fills

Represents the x:fills XML element.

public static readonly XName fills

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: styleSheet.
has the following child XML elements: fill.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: Fills.

filter

Represents the x:filter XML elements.

public static readonly XName filter

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: filters.
has the following child XML elements: autoFilter, extLst.
has the following XML attributes: description, evalOrder, fld, id, iMeasureFld, iMeasureHier, mpFld, name, stringValue1, stringValue2, type, val.
corresponds to the following strongly-typed classes: Filter, PivotFilter.

filterColumn

Represents the x:filterColumn XML element.

public static readonly XName filterColumn

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: autoFilter.
has the following child XML elements: colorFilter, customFilters, dynamicFilter, extLst, filters, iconFilter, top10, customFilters, iconFilter.
has the following XML attributes: colId, hiddenButton, showButton.
corresponds to the following strongly-typed classes: FilterColumn.

filters

Represents the x:filters XML elements.

public static readonly XName filters

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: filterColumn, pivotTableDefinition, filter.
has the following child XML elements: dateGroupItem, filter, filter.
has the following XML attributes: blank, calendarType, count.
corresponds to the following strongly-typed classes: Filters, PivotFilters.

firstFooter

Represents the x:firstFooter XML element.

public static readonly XName firstFooter

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: headerFooter.
has the following XML attributes: space.
corresponds to the following strongly-typed classes: FirstFooter.

firstHeader

Represents the x:firstHeader XML element.

public static readonly XName firstHeader

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: headerFooter.
has the following XML attributes: space.
corresponds to the following strongly-typed classes: FirstHeader.

font

Represents the x:font XML element.

public static readonly XName font

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: dxf, fonts, ndxf, odxf, dxf, dxf.
has the following child XML elements: b, charset, color, condense, extend, family, i, name, outline, scheme, shadow, strike, sz, u, vertAlign.
corresponds to the following strongly-typed classes: Font.

fonts

Represents the x:fonts XML element.

public static readonly XName fonts

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: styleSheet.
has the following child XML elements: font.
has the following XML attributes: count, knownFonts.
corresponds to the following strongly-typed classes: Fonts.

format

Represents the x:format XML element.

public static readonly XName format

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: formats.
has the following child XML elements: extLst, pivotArea.
has the following XML attributes: action, dxfId_.
corresponds to the following strongly-typed classes: Format.

formats

Represents the x:formats XML element.

public static readonly XName formats

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotTableDefinition.
has the following child XML elements: format.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: Formats.

formula

Represents the x:formula XML element.

public static readonly XName formula

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: cfRule, rdn.
has the following XML attributes: space.
corresponds to the following strongly-typed classes: Formula.

formula1

Represents the x: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 XML attributes: space.
corresponds to the following strongly-typed classes: Formula1.

formula2

Represents the x: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 XML attributes: space.
corresponds to the following strongly-typed classes: Formula2.

from

Represents the x:from XML element.

public static readonly XName from

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: anchor.
has the following child XML elements: col, colOff, row, rowOff.
corresponds to the following strongly-typed classes: FromMarker.

functionGroup

Represents the x:functionGroup XML element.

public static readonly XName functionGroup

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: functionGroups.
has the following XML attributes: name.
corresponds to the following strongly-typed classes: FunctionGroup.

functionGroups

Represents the x:functionGroups XML element.

public static readonly XName functionGroups

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: workbook.
has the following child XML elements: functionGroup.
has the following XML attributes: builtInGroupCount.
corresponds to the following strongly-typed classes: FunctionGroups.

futureMetadata

Represents the x:futureMetadata XML element.

public static readonly XName futureMetadata

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: metadata.
has the following child XML elements: bk, extLst.
has the following XML attributes: count, name.
corresponds to the following strongly-typed classes: FutureMetadata.

gradientFill

Represents the x:gradientFill XML element.

public static readonly XName gradientFill

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: fill.
has the following child XML elements: stop.
has the following XML attributes: bottom, degree, left, right, top, type.
corresponds to the following strongly-typed classes: GradientFill.

group

Represents the x:group XML element.

public static readonly XName group

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: groups.
has the following child XML elements: groupMembers.
has the following XML attributes: caption, id, name, uniqueName, uniqueParent.
corresponds to the following strongly-typed classes: Group.

groupItems

Represents the x:groupItems XML element.

public static readonly XName groupItems

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: fieldGroup.
has the following child XML elements: b, d, e, m, n, s.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: GroupItems.

groupLevel

Represents the x:groupLevel XML element.

public static readonly XName groupLevel

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: groupLevels.
has the following child XML elements: extLst, groups.
has the following XML attributes: caption, customRollUp, uniqueName, user.
corresponds to the following strongly-typed classes: GroupLevel.

groupLevels

Represents the x:groupLevels XML element.

public static readonly XName groupLevels

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: cacheHierarchy.
has the following child XML elements: groupLevel.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: GroupLevels.

groupMember

Represents the x:groupMember XML element.

public static readonly XName groupMember

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: groupMembers.
has the following XML attributes: group, uniqueName.
corresponds to the following strongly-typed classes: GroupMember.

groupMembers

Represents the x:groupMembers XML element.

public static readonly XName groupMembers

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: group.
has the following child XML elements: groupMember.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: GroupMembers.

groups

Represents the x:groups XML element.

public static readonly XName groups

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: groupLevel.
has the following child XML elements: group.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: Groups.

header

Represents the x: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 child XML elements: extLst, reviewedList, sheetIdMap.
has the following XML attributes: dateTime, guid, maxRId, maxSheetId, minRId, id, userName.
corresponds to the following strongly-typed classes: Header.

headerFooter

Represents the x:headerFooter XML element.

public static readonly XName headerFooter

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: chartsheet, customSheetView, dialogsheet, worksheet, macrosheet.
has the following child XML elements: evenFooter, evenHeader, firstFooter, firstHeader, oddFooter, oddHeader.
has the following XML attributes: alignWithMargins, differentFirst, differentOddEven, scaleWithDoc.
corresponds to the following strongly-typed classes: HeaderFooter.

headers

Represents the x:headers XML element.

public static readonly XName headers

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: header.
has the following XML attributes: diskRevisions, exclusive, guid, history, keepChangeHistory, lastGuid, preserveHistory, protected, revisionId, shared, trackRevisions, version.
corresponds to the following strongly-typed classes: Headers.

horizontal

Represents the x:horizontal XML element.

public static readonly XName horizontal

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: border.
has the following child XML elements: color.
has the following XML attributes: style.
corresponds to the following strongly-typed classes: HorizontalBorder.

hyperlink

Represents the x:hyperlink XML element.

public static readonly XName hyperlink

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: hyperlinks.
has the following XML attributes: display, location, id, ref, tooltip.
corresponds to the following strongly-typed classes: Hyperlink.

hyperlinks

Represents the x:hyperlinks XML element.

public static readonly XName hyperlinks

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: worksheet.
has the following child XML elements: hyperlink.
corresponds to the following strongly-typed classes: Hyperlinks.

i

Represents the x:i XML elements.

public static readonly XName i

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: colItems, font, rowItems, rPr.
has the following child XML elements: x_.
has the following XML attributes: i, r, t, val.
corresponds to the following strongly-typed classes: Italic, RowItem.

iconFilter

Represents the x: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 x: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: cfvo.
has the following XML attributes: iconSet, percent, reverse, showValue.
corresponds to the following strongly-typed classes: IconSet.

ignoredError

Represents the x: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 XML attributes: calculatedColumn, emptyCellReference, evalError, formula, formulaRange, listDataValidation, numberStoredAsText, sqref, twoDigitTextYear, unlockedFormula.
corresponds to the following strongly-typed classes: IgnoredError.

ignoredErrors

Represents the x:ignoredErrors XML element.

public static readonly XName ignoredErrors

Field Value

XName

Remarks

As an XML element, it:

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

indexedColors

Represents the x:indexedColors XML element.

public static readonly XName indexedColors

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: colors.
has the following child XML elements: rgbColor.
corresponds to the following strongly-typed classes: IndexedColors.

inputCells

Represents the x:inputCells XML element.

public static readonly XName inputCells

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: scenario.
has the following XML attributes: deleted, numFmtId, r, undone, val.
corresponds to the following strongly-typed classes: InputCells.

is

Represents the x:is XML element.

public static readonly XName @is

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: c, nc, oc.
has the following child XML elements: phoneticPr, r, rPh, t.
corresponds to the following strongly-typed classes: InlineString.

item

Represents the x:item XML element.

public static readonly XName item

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: items.
has the following XML attributes: c, d, e, f, h, m, n, s, sd, t, x.
corresponds to the following strongly-typed classes: Item.

items

Represents the x:items XML element.

public static readonly XName items

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotField.
has the following child XML elements: item.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: Items.

k

Represents the x:k XML element.

public static readonly XName k

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: mdx.
has the following XML attributes: n, np, p.
corresponds to the following strongly-typed classes: MdxKpi.

kpi

Represents the x:kpi XML element.

public static readonly XName kpi

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: kpis.
has the following XML attributes: caption, displayFolder, goal, measureGroup, parent, status, trend, uniqueName, value, weight.
corresponds to the following strongly-typed classes: Kpi.

kpis

Represents the x:kpis XML element.

public static readonly XName kpis

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotCacheDefinition.
has the following child XML elements: kpi.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: Kpis.

left

Represents the x:left XML element.

public static readonly XName left

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: border.
has the following child XML elements: color.
has the following XML attributes: style.
corresponds to the following strongly-typed classes: LeftBorder.

legacyDrawing

Represents the x:legacyDrawing XML element.

public static readonly XName legacyDrawing

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: chartsheet, dialogsheet, worksheet, macrosheet.
has the following XML attributes: id.
corresponds to the following strongly-typed classes: LegacyDrawing.

legacyDrawingHF

Represents the x:legacyDrawingHF XML element.

public static readonly XName legacyDrawingHF

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: chartsheet, dialogsheet, worksheet, macrosheet.
has the following XML attributes: id.
corresponds to the following strongly-typed classes: LegacyDrawingHeaderFooter.

location

Represents the x:location XML element.

public static readonly XName location

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotTableDefinition.
has the following XML attributes: colPageCount, firstDataCol, firstDataRow, firstHeaderRow, ref, rowPageCount.
corresponds to the following strongly-typed classes: Location.

m

Represents the x:m XML elements.

public static readonly XName m

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: entries, groupItems, r, sharedItems, tables.
has the following child XML elements: tpls, x_.
has the following XML attributes: b, bc, c, cp, f, fc, i, in, st, u, un.
corresponds to the following strongly-typed classes: MissingItem, MissingTable.

main

Represents the x:main XML element.

public static readonly XName main

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: volType.
has the following child XML elements: tp.
has the following XML attributes: first.
corresponds to the following strongly-typed classes: Main.

map

Represents the x:map XML element.

public static readonly XName map

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: maps.
has the following XML attributes: dimension, measureGroup.
corresponds to the following strongly-typed classes: MeasureDimensionMap.

maps

Represents the x:maps XML element.

public static readonly XName maps

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotCacheDefinition.
has the following child XML elements: map.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: Maps.

mdx

Represents the x:mdx XML element.

public static readonly XName mdx

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: mdxMetadata.
has the following child XML elements: k, ms, p, t.
has the following XML attributes: f, n.
corresponds to the following strongly-typed classes: Mdx.

mdxMetadata

Represents the x:mdxMetadata XML element.

public static readonly XName mdxMetadata

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: metadata.
has the following child XML elements: mdx.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: MdxMetadata.

measureGroup

Represents the x:measureGroup XML element.

public static readonly XName measureGroup

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: measureGroups.
has the following XML attributes: caption, name.
corresponds to the following strongly-typed classes: MeasureGroup.

measureGroups

Represents the x:measureGroups XML element.

public static readonly XName measureGroups

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotCacheDefinition.
has the following child XML elements: measureGroup.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: MeasureGroups.

member

Represents the x:member XML element.

public static readonly XName member

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: members.
has the following XML attributes: name.
corresponds to the following strongly-typed classes: Member.

members

Represents the x:members XML element.

public static readonly XName members

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotHierarchy.
has the following child XML elements: member.
has the following XML attributes: count, level.
corresponds to the following strongly-typed classes: Members.

mergeCell

Represents the x:mergeCell XML element.

public static readonly XName mergeCell

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: mergeCells.
has the following XML attributes: ref.
corresponds to the following strongly-typed classes: MergeCell.

mergeCells

Represents the x:mergeCells XML element.

public static readonly XName mergeCells

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: worksheet.
has the following child XML elements: mergeCell.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: MergeCells.

metadata

Represents the x:metadata XML element.

public static readonly XName metadata

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: cellMetadata, extLst, futureMetadata, mdxMetadata, metadataStrings, metadataTypes, valueMetadata.
corresponds to the following strongly-typed classes: Metadata.

metadataStrings

Represents the x:metadataStrings XML element.

public static readonly XName metadataStrings

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: metadata.
has the following child XML elements: s.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: MetadataStrings.

metadataType

Represents the x:metadataType XML element.

public static readonly XName metadataType

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: metadataTypes.
has the following XML attributes: adjust, assign, cellMeta, clearAll, clearComments, clearContents, clearFormats, coerce, copy, delete, edit, ghostCol, ghostRow, merge, minSupportedVersion, name, pasteAll, pasteBorders, pasteColWidths, pasteComments, pasteDataValidation, pasteFormats, pasteFormulas, pasteNumberFormats, pasteValues, rowColShift, splitAll, splitFirst.
corresponds to the following strongly-typed classes: MetadataType.

metadataTypes

Represents the x:metadataTypes XML element.

public static readonly XName metadataTypes

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: metadata.
has the following child XML elements: metadataType.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: MetadataTypes.

mp

Represents the x:mp XML element.

public static readonly XName mp

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: mps.
has the following XML attributes: field, level, name, nameLen, pLen, pPos, showAsCaption, showCell, showTip.
corresponds to the following strongly-typed classes: MemberProperty.

mpMap

Represents the x:mpMap XML element.

public static readonly XName mpMap

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: cacheField.
has the following XML attributes: v.
corresponds to the following strongly-typed classes: MemberPropertiesMap.

mps

Represents the x:mps XML element.

public static readonly XName mps

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotHierarchy.
has the following child XML elements: mp.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: MemberProperties.

mruColors

Represents the x:mruColors XML element.

public static readonly XName mruColors

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: colors.
has the following child XML elements: color.
corresponds to the following strongly-typed classes: MruColors.

ms

Represents the x:ms XML element.

public static readonly XName ms

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: mdx.
has the following child XML elements: n.
has the following XML attributes: c, ns, o.
corresponds to the following strongly-typed classes: MdxSet.

n

Represents the x:n XML elements.

public static readonly XName n

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: entries, groupItems, ms, r, sharedItems, t.
has the following child XML elements: tpls, x_.
has the following XML attributes: b, bc, c, cp, f, fc, i, in, s, st, u, un, v, x.
corresponds to the following strongly-typed classes: NameIndex, NumberItem.

name

Represents the x:name XML element.

public static readonly XName name

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: font.
has the following XML attributes: val.
corresponds to the following strongly-typed classes: FontName.

nc

Represents the x:nc XML element.

public static readonly XName nc

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: rcc.
has the following child XML elements: extLst, f, is, v.
has the following XML attributes: cm, ph, r, s, t, vm.
corresponds to the following strongly-typed classes: NewCell.

ndxf

Represents the x:ndxf XML element.

public static readonly XName ndxf

Field Value

XName

Remarks

As an XML element, it:

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

numFmt

Represents the x:numFmt XML element.

public static readonly XName numFmt

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: dxf, ndxf, numFmts, odxf, dxf, dxf.
has the following XML attributes: formatCode, numFmtId.
corresponds to the following strongly-typed classes: NumberingFormat.

numFmts

Represents the x:numFmts XML element.

public static readonly XName numFmts

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: styleSheet.
has the following child XML elements: numFmt.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: NumberingFormats.

objectPr

Represents the x:objectPr XML element.

public static readonly XName objectPr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: oleObject.
has the following child XML elements: anchor.
has the following XML attributes: altText, autoFill, autoLine, autoPict, dde, defaultSize, disabled, locked, macro, print, id, uiObject.
corresponds to the following strongly-typed classes: EmbeddedObjectProperties.

oc

Represents the x:oc XML element.

public static readonly XName oc

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: rcc.
has the following child XML elements: extLst, f, is, v.
has the following XML attributes: cm, ph, r, s, t, vm.
corresponds to the following strongly-typed classes: OldCell.

oddFooter

Represents the x:oddFooter XML element.

public static readonly XName oddFooter

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: headerFooter.
has the following XML attributes: space.
corresponds to the following strongly-typed classes: OddFooter.

oddHeader

Represents the x:oddHeader XML element.

public static readonly XName oddHeader

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: headerFooter.
has the following XML attributes: space.
corresponds to the following strongly-typed classes: OddHeader.

odxf

Represents the x:odxf XML element.

public static readonly XName odxf

Field Value

XName

Remarks

As an XML element, it:

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

olapPr

Represents the x:olapPr XML element.

public static readonly XName olapPr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: connection.
has the following XML attributes: local, localConnection, localRefresh, rowDrillCount, sendLocale, serverFill, serverFont, serverFontColor, serverNumberFormat.
corresponds to the following strongly-typed classes: OlapProperties.

oldFormula

Represents the x:oldFormula XML element.

public static readonly XName oldFormula

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: rdn.
has the following XML attributes: space.
corresponds to the following strongly-typed classes: OldFormula.

oleItem

Represents the x: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 XML attributes: advise, icon, name, preferPic.
corresponds to the following strongly-typed classes: OleItem.

oleItems

Represents the x:oleItems XML element.

public static readonly XName oleItems

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: oleLink.
has the following child XML elements: oleItem, oleItem.
corresponds to the following strongly-typed classes: OleItems.

oleLink

Represents the x:oleLink XML element.

public static readonly XName oleLink

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: externalLink.
has the following child XML elements: oleItems.
has the following XML attributes: progId, id.
corresponds to the following strongly-typed classes: OleLink.

oleObject

Represents the x:oleObject XML element.

public static readonly XName oleObject

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: oleObjects.
has the following child XML elements: objectPr.
has the following XML attributes: autoLoad, dvAspect, link, oleUpdate, progId, id, shapeId.
corresponds to the following strongly-typed classes: OleObject.

oleObjects

Represents the x:oleObjects XML element.

public static readonly XName oleObjects

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: dialogsheet, worksheet, macrosheet.
has the following child XML elements: oleObject.
corresponds to the following strongly-typed classes: OleObjects.

oleSize

Represents the x:oleSize XML element.

public static readonly XName oleSize

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: workbook.
has the following XML attributes: ref.
corresponds to the following strongly-typed classes: OleSize.

outline

Represents the x:outline XML element.

public static readonly XName outline

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: font, rPr.
has the following XML attributes: val.
corresponds to the following strongly-typed classes: Outline.

outlinePr

Represents the x:outlinePr XML element.

public static readonly XName outlinePr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: sheetPr.
has the following XML attributes: applyStyles, showOutlineSymbols, summaryBelow, summaryRight.
corresponds to the following strongly-typed classes: OutlineProperties.

p

Represents the x:p XML element.

public static readonly XName p

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: mdx.
has the following XML attributes: n, np.
corresponds to the following strongly-typed classes: MdxMemberProp.

page

Represents the x:page XML element.

public static readonly XName page

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pages.
has the following child XML elements: pageItem.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: Page.

pageField

Represents the x:pageField XML element.

public static readonly XName pageField

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pageFields.
has the following child XML elements: extLst.
has the following XML attributes: cap, fld, hier, item, name.
corresponds to the following strongly-typed classes: PageField.

pageFields

Represents the x:pageFields XML element.

public static readonly XName pageFields

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotTableDefinition.
has the following child XML elements: pageField.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: PageFields.

pageItem

Represents the x:pageItem XML element.

public static readonly XName pageItem

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: page.
has the following XML attributes: name.
corresponds to the following strongly-typed classes: PageItem.

pageMargins

Represents the x:pageMargins XML element.

public static readonly XName pageMargins

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: chartsheet, customSheetView, dialogsheet, worksheet, macrosheet.
has the following XML attributes: bottom, footer, header, left, right, top.
corresponds to the following strongly-typed classes: PageMargins.

pageSetUpPr

Represents the x:pageSetUpPr XML element.

public static readonly XName pageSetUpPr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: sheetPr.
has the following XML attributes: autoPageBreaks, fitToPage.
corresponds to the following strongly-typed classes: PageSetupProperties.

pageSetup

Represents the x:pageSetup XML elements.

public static readonly XName pageSetup

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: chartsheet, customSheetView, dialogsheet, worksheet, macrosheet.
has the following XML attributes: blackAndWhite, cellComments, copies, draft, errors, firstPageNumber, fitToHeight, fitToWidth, horizontalDpi, orientation, pageOrder, paperSize, id, scale, useFirstPageNumber, usePrinterDefaults, verticalDpi.
corresponds to the following strongly-typed classes: ChartSheetPageSetup, PageSetup.

pages

Represents the x:pages XML element.

public static readonly XName pages

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: consolidation.
has the following child XML elements: page.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: Pages.

pane

Represents the x:pane XML element.

public static readonly XName pane

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: customSheetView, sheetView.
has the following XML attributes: activePane, state, topLeftCell, xSplit, ySplit.
corresponds to the following strongly-typed classes: Pane.

parameter

Represents the x:parameter XML element.

public static readonly XName parameter

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: parameters.
has the following XML attributes: boolean, cell, double, integer, name, parameterType, prompt, refreshOnChange, sqlType, string.
corresponds to the following strongly-typed classes: Parameter.

parameters

Represents the x:parameters XML element.

public static readonly XName parameters

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: connection.
has the following child XML elements: parameter.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: Parameters.

patternFill

Represents the x:patternFill XML element.

public static readonly XName patternFill

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: fill.
has the following child XML elements: bgColor, fgColor.
has the following XML attributes: patternType.
corresponds to the following strongly-typed classes: PatternFill.

phoneticPr

Represents the x:phoneticPr XML element.

public static readonly XName phoneticPr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: is, si, text, worksheet, macrosheet.
has the following XML attributes: alignment, fontId, type.
corresponds to the following strongly-typed classes: PhoneticProperties.

picture

Represents the x:picture XML element.

public static readonly XName picture

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: chartsheet, worksheet, macrosheet.
has the following XML attributes: id.
corresponds to the following strongly-typed classes: Picture.

pivotArea

Represents the x:pivotArea XML element.

public static readonly XName pivotArea

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: autoSortScope, calculatedItem, chartFormat, format, pivotAreas, pivotSelection, pivotAreas.
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 x: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.

pivotCache

Represents the x:pivotCache XML element.

public static readonly XName pivotCache

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotCaches, pivotCaches, pivotCaches, timelineCachePivotCaches.
has the following XML attributes: cacheId, id.
corresponds to the following strongly-typed classes: PivotCache.

pivotCacheDefinition

Represents the x:pivotCacheDefinition XML element.

public static readonly XName pivotCacheDefinition

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: cacheFields, cacheHierarchies, cacheSource, calculatedItems, calculatedMembers, dimensions, extLst, kpis, maps, measureGroups, tupleCache.
has the following XML attributes: backgroundQuery, createdVersion, enableRefresh, invalid, minRefreshableVersion, missingItemsLimit, optimizeMemory, id, recordCount, refreshedBy, refreshedDate, refreshedDateIso, refreshedVersion, refreshOnLoad, saveData, supportAdvancedDrill, supportSubquery, tupleCache, upgradeOnRefresh.
corresponds to the following strongly-typed classes: PivotCacheDefinition.

pivotCacheRecords

Represents the x:pivotCacheRecords XML element.

public static readonly XName pivotCacheRecords

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: extLst, r.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: PivotCacheRecords.

pivotCaches

Represents the x:pivotCaches XML element.

public static readonly XName pivotCaches

Field Value

XName

Remarks

As an XML element, it:

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

pivotField

Represents the x:pivotField XML element.

public static readonly XName pivotField

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotFields.
has the following child XML elements: autoSortScope, extLst, items.
has the following XML attributes: allDrilled, autoShow, avgSubtotal, axis, compact, countASubtotal, countSubtotal, dataField, dataSourceSort, defaultAttributeDrillState, defaultSubtotal, dragOff, dragToCol, dragToData, dragToPage, dragToRow, hiddenLevel, hideNewItems, includeNewItemsInFilter, insertBlankRow, insertPageBreak, itemPageCount, maxSubtotal, measureFilter, minSubtotal, multipleItemSelectionAllowed, name, nonAutoSortDefault, numFmtId, outline, productSubtotal, rankBy, serverField, showAll, showDropDowns, showPropAsCaption, showPropCell, showPropTip, sortType, stdDevPSubtotal, stdDevSubtotal, subtotalCaption, subtotalTop, sumSubtotal, topAutoShow, uniqueMemberProperty, varPSubtotal, varSubtotal.
corresponds to the following strongly-typed classes: PivotField.

pivotFields

Represents the x:pivotFields XML element.

public static readonly XName pivotFields

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotTableDefinition.
has the following child XML elements: pivotField.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: PivotFields.

pivotHierarchies

Represents the x:pivotHierarchies XML element.

public static readonly XName pivotHierarchies

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotTableDefinition.
has the following child XML elements: pivotHierarchy.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: PivotHierarchies.

pivotHierarchy

Represents the x:pivotHierarchy XML element.

public static readonly XName pivotHierarchy

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotHierarchies.
has the following child XML elements: extLst, members, mps.
has the following XML attributes: caption, dragOff, dragToCol, dragToData, dragToPage, dragToRow, includeNewItemsInFilter, multipleItemSelectionAllowed, outline, showInFieldList, subtotalTop.
corresponds to the following strongly-typed classes: PivotHierarchy.

pivotSelection

Represents the x:pivotSelection XML element.

public static readonly XName pivotSelection

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: sheetView.
has the following child XML elements: pivotArea.
has the following XML attributes: activeCol, activeRow, axis, click, count, data, dimension, extendable, label, max, min, pane, previousCol, previousRow, id, showHeader, start.
corresponds to the following strongly-typed classes: PivotSelection.

pivotTableDefinition

Represents the x:pivotTableDefinition XML element.

public static readonly XName pivotTableDefinition

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: chartFormats, colFields, colHierarchiesUsage, colItems, conditionalFormats, dataFields, extLst, filters, formats, location, pageFields, pivotFields, pivotHierarchies, pivotTableStyleInfo, rowFields, rowHierarchiesUsage, rowItems.
has the following XML attributes: applyAlignmentFormats, applyBorderFormats, applyFontFormats, applyNumberFormats, applyPatternFormats, applyWidthHeightFormats, asteriskTotals, autoFormatId, cacheId, chartFormat, colGrandTotals, colHeaderCaption, compact, compactData, createdVersion, customListSort, dataCaption, dataOnRows, dataPosition, disableFieldList, editData, enableDrill, enableFieldProperties, enableWizard, errorCaption, fieldListSortAscending, fieldPrintTitles, grandTotalCaption, gridDropZones, immersive, indent, itemPrintTitles, mdxSubqueries, mergeItem, minRefreshableVersion, missingCaption, multipleFieldFilters, name, outline, outlineData, pageOverThenDown, pageStyle, pageWrap, pivotTableStyle, preserveFormatting, printDrill, published, rowGrandTotals, rowHeaderCaption, showCalcMbrs, showDataDropDown, showDataTips, showDrill, showDropZones, showEmptyCol, showEmptyRow, showError, showHeaders, showItems, showMemberPropertyTips, showMissing, showMultipleLabel, subtotalHiddenItems, tag, updatedVersion, useAutoFormatting, vacatedStyle, visualTotals.
corresponds to the following strongly-typed classes: PivotTableDefinition.

pivotTableStyleInfo

Represents the x:pivotTableStyleInfo XML element.

public static readonly XName pivotTableStyleInfo

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotTableDefinition.
has the following XML attributes: name, showColHeaders, showColStripes, showLastColumn, showRowHeaders, showRowStripes.
corresponds to the following strongly-typed classes: PivotTableStyle.

printOptions

Represents the x:printOptions XML element.

public static readonly XName printOptions

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: customSheetView, dialogsheet, worksheet, macrosheet.
has the following XML attributes: gridLines, gridLinesSet, headings, horizontalCentered, verticalCentered.
corresponds to the following strongly-typed classes: PrintOptions.

protectedRange

Represents the x: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 XML attributes: algorithmName, hashValue, name, password, saltValue, securityDescriptor, spinCount, sqref.
corresponds to the following strongly-typed classes: ProtectedRange.

protectedRanges

Represents the x:protectedRanges XML element.

public static readonly XName protectedRanges

Field Value

XName

Remarks

As an XML element, it:

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

protection

Represents the x:protection XML element.

public static readonly XName protection

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: dxf, ndxf, odxf, xf, dxf, dxf.
has the following XML attributes: hidden, locked.
corresponds to the following strongly-typed classes: Protection.

query

Represents the x:query XML element.

public static readonly XName query

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: queryCache.
has the following child XML elements: tpls.
has the following XML attributes: mdx.
corresponds to the following strongly-typed classes: Query.

queryCache

Represents the x:queryCache XML element.

public static readonly XName queryCache

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: tupleCache.
has the following child XML elements: query.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: QueryCache.

queryTable

Represents the x:queryTable XML element.

public static readonly XName queryTable

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: extLst, queryTableRefresh.
has the following XML attributes: adjustColumnWidth, applyAlignmentFormats, applyBorderFormats, applyFontFormats, applyNumberFormats, applyPatternFormats, applyWidthHeightFormats, autoFormatId, backgroundRefresh, connectionId, disableEdit, disableRefresh, fillFormulas, firstBackgroundRefresh, growShrinkType, headers, intermediate, name, preserveFormatting, refreshOnLoad, removeDataOnSave, rowNumbers.
corresponds to the following strongly-typed classes: QueryTable.

queryTableDeletedFields

Represents the x:queryTableDeletedFields XML element.

public static readonly XName queryTableDeletedFields

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: queryTableRefresh.
has the following child XML elements: deletedField.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: QueryTableDeletedFields.

queryTableField

Represents the x:queryTableField XML element.

public static readonly XName queryTableField

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: queryTableFields.
has the following child XML elements: extLst.
has the following XML attributes: clipped, dataBound, fillFormulas, id, name, rowNumbers, tableColumnId.
corresponds to the following strongly-typed classes: QueryTableField.

queryTableFields

Represents the x:queryTableFields XML element.

public static readonly XName queryTableFields

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: queryTableRefresh.
has the following child XML elements: queryTableField.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: QueryTableFields.

queryTableRefresh

Represents the x:queryTableRefresh XML element.

public static readonly XName queryTableRefresh

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: queryTable.
has the following child XML elements: extLst, queryTableDeletedFields, queryTableFields, sortState.
has the following XML attributes: fieldIdWrapped, headersInLastRefresh, minimumVersion, nextId, preserveSortFilterLayout, unboundColumnsLeft, unboundColumnsRight.
corresponds to the following strongly-typed classes: QueryTableRefresh.

r

Represents the x:r XML elements.

public static readonly XName r

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: is, pivotCacheRecords, si, text.
has the following child XML elements: b, d, e, m, n, rPr, s, t, x_.
corresponds to the following strongly-typed classes: PivotCacheRecord, Run.

rFont

Represents the x:rFont XML element.

public static readonly XName rFont

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: rPr.
has the following XML attributes: val.
corresponds to the following strongly-typed classes: RunFont.

rPh

Represents the x:rPh XML element.

public static readonly XName rPh

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: is, si, text.
has the following child XML elements: t.
has the following XML attributes: eb, sb.
corresponds to the following strongly-typed classes: PhoneticRun.

rPr

Represents the x:rPr XML element.

public static readonly XName rPr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: r.
has the following child XML elements: b, charset, color, condense, extend, family, i, outline, rFont, scheme, shadow, strike, sz, u, vertAlign.
corresponds to the following strongly-typed classes: RunProperties.

raf

Represents the x:raf XML element.

public static readonly XName raf

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: revisions.
has the following XML attributes: applyAlignmentFormats, applyBorderFormats, applyFontFormats, applyNumberFormats, applyPatternFormats, applyWidthHeightFormats, autoFormatId, ref, sheetId.
corresponds to the following strongly-typed classes: RevisionAutoFormat.

rangePr

Represents the x:rangePr XML element.

public static readonly XName rangePr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: fieldGroup.
has the following XML attributes: autoEnd, autoStart, endDate, endNum, groupBy, groupInterval, startDate, startNum.
corresponds to the following strongly-typed classes: RangeProperties.

rangeSet

Represents the x:rangeSet XML element.

public static readonly XName rangeSet

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: rangeSets.
has the following XML attributes: i1, i2, i3, i4, name, id, ref, sheet.
corresponds to the following strongly-typed classes: RangeSet.

rangeSets

Represents the x:rangeSets XML element.

public static readonly XName rangeSets

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: consolidation.
has the following child XML elements: rangeSet.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: RangeSets.

rc

Represents the x:rc XML element.

public static readonly XName rc

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: bk.
has the following XML attributes: t, v.
corresponds to the following strongly-typed classes: MetadataRecord.

rcc

Represents the x:rcc XML element.

public static readonly XName rcc

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: revisions, rm, rrc.
has the following child XML elements: extLst, nc, ndxf, oc, odxf.
has the following XML attributes: dxf, endOfListFormulaUpdate, numFmtId, odxf, oldPh, oldQuotePrefix, ph, quotePrefix, ra, rId, s, sId, ua, xfDxf.
corresponds to the following strongly-typed classes: RevisionCellChange.

rcft

Represents the x:rcft XML element.

public static readonly XName rcft

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: revisions.
has the following XML attributes: ra, rId, sheetId, ua.
corresponds to the following strongly-typed classes: RevisionConflict.

rcmt

Represents the x:rcmt XML element.

public static readonly XName rcmt

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: revisions.
has the following XML attributes: action, alwaysShow, author, cell, guid, hiddenColumn, hiddenRow, newLength, old, oldLength, sheetId.
corresponds to the following strongly-typed classes: RevisionComment.

rcv

Represents the x:rcv XML element.

public static readonly XName rcv

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: revisions.
has the following XML attributes: action, guid.
corresponds to the following strongly-typed classes: RevisionCustomView.

rdn

Represents the x:rdn XML element.

public static readonly XName rdn

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: revisions.
has the following child XML elements: extLst, formula, oldFormula.
has the following XML attributes: comment, customMenu, customView, description, function, functionGroupId, help, hidden, localSheetId, name, oldComment, oldCustomMenu, oldDescription, oldFunction, oldFunctionGroupId, oldHelp, oldHidden, oldShortcutKey, oldStatusBar, ra, rId, shortcutKey, statusBar, ua.
corresponds to the following strongly-typed classes: RevisionDefinedName.

reference

Represents the x:reference XML element.

public static readonly XName reference

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: references.
has the following child XML elements: extLst, x_.
has the following XML attributes: avgSubtotal, byPosition, count, countASubtotal, countSubtotal, defaultSubtotal, field, maxSubtotal, minSubtotal, productSubtotal, relative, selected, stdDevPSubtotal, stdDevSubtotal, sumSubtotal, varPSubtotal, varSubtotal.
corresponds to the following strongly-typed classes: PivotAreaReference.

references

Represents the x:references XML element.

public static readonly XName references

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotArea, pivotArea.
has the following child XML elements: reference.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: PivotAreaReferences.

reviewed

Represents the x:reviewed XML element.

public static readonly XName reviewed

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: reviewedList.
has the following XML attributes: rId.
corresponds to the following strongly-typed classes: Reviewed.

reviewedList

Represents the x:reviewedList XML element.

public static readonly XName reviewedList

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: header.
has the following child XML elements: reviewed.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: ReviewedList.

revisions

Represents the x:revisions XML element.

public static readonly XName revisions

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: raf, rcc, rcft, rcmt, rcv, rdn, rfmt, ris, rm, rqt, rrc, rsnm.
corresponds to the following strongly-typed classes: Revisions.

rfmt

Represents the x:rfmt XML element.

public static readonly XName rfmt

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: revisions, rm, rrc.
has the following child XML elements: dxf, extLst.
has the following XML attributes: length, s, sheetId, sqref, start, xfDxf.
corresponds to the following strongly-typed classes: RevisionFormat.

rgbColor

Represents the x:rgbColor XML element.

public static readonly XName rgbColor

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: indexedColors.
has the following XML attributes: rgb.
corresponds to the following strongly-typed classes: RgbColor.

right

Represents the x:right XML element.

public static readonly XName right

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: border.
has the following child XML elements: color.
has the following XML attributes: style.
corresponds to the following strongly-typed classes: RightBorder.

ris

Represents the x:ris XML element.

public static readonly XName ris

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: revisions.
has the following XML attributes: name, ra, rId, sheetId, sheetPosition, ua.
corresponds to the following strongly-typed classes: RevisionInsertSheet.

rm

Represents the x:rm XML element.

public static readonly XName rm

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: revisions.
has the following child XML elements: rcc, rfmt, undo.
has the following XML attributes: destination, ra, rId, sheetId, source, sourceSheetId, ua.
corresponds to the following strongly-typed classes: RevisionMove.

row

Represents the x:row XML elements.

public static readonly XName row

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: sheetData.
has the following child XML elements: c, cell, extLst.
has the following XML attributes: collapsed, customFormat, customHeight, hidden, ht, outlineLevel, ph, r, s, spans, thickBot, thickTop, dyDescent.
corresponds to the following strongly-typed classes: ExternalRow, Row.

rowBreaks

Represents the x:rowBreaks XML element.

public static readonly XName rowBreaks

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: customSheetView, worksheet, macrosheet.
has the following child XML elements: brk.
has the following XML attributes: count, manualBreakCount.
corresponds to the following strongly-typed classes: RowBreaks.

rowFields

Represents the x:rowFields XML element.

public static readonly XName rowFields

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotTableDefinition.
has the following child XML elements: field.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: RowFields.

rowHierarchiesUsage

Represents the x:rowHierarchiesUsage XML element.

public static readonly XName rowHierarchiesUsage

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotTableDefinition.
has the following child XML elements: rowHierarchyUsage.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: RowHierarchiesUsage.

rowHierarchyUsage

Represents the x:rowHierarchyUsage XML element.

public static readonly XName rowHierarchyUsage

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: rowHierarchiesUsage.
has the following XML attributes: hierarchyUsage.
corresponds to the following strongly-typed classes: RowHierarchyUsage.

rowItems

Represents the x:rowItems XML element.

public static readonly XName rowItems

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotTableDefinition.
has the following child XML elements: i.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: RowItems.

rqt

Represents the x:rqt XML element.

public static readonly XName rqt

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: revisions.
has the following XML attributes: fieldId, ref, sheetId.
corresponds to the following strongly-typed classes: RevisionQueryTable.

rrc

Represents the x:rrc XML element.

public static readonly XName rrc

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: revisions.
has the following child XML elements: rcc, rfmt, undo.
has the following XML attributes: action, edge, eol, ra, ref, rId, sId, ua.
corresponds to the following strongly-typed classes: RevisionRowColumn.

rsnm

Represents the x:rsnm XML element.

public static readonly XName rsnm

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: revisions.
has the following child XML elements: extLst.
has the following XML attributes: newName, oldName, ra, rId, sheetId, ua.
corresponds to the following strongly-typed classes: RevisionSheetName.

s

Represents the x:s XML elements.

public static readonly XName s

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: entries, groupItems, metadataStrings, r, sharedItems, tables.
has the following child XML elements: tpls, x_.
has the following XML attributes: b, bc, c, cp, f, fc, i, in, st, u, un, v.
corresponds to the following strongly-typed classes: CharacterValue, StringItem.

scenario

Represents the x:scenario XML element.

public static readonly XName scenario

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: scenarios.
has the following child XML elements: inputCells.
has the following XML attributes: comment, count, hidden, locked, name, user.
corresponds to the following strongly-typed classes: Scenario.

scenarios

Represents the x:scenarios XML element.

public static readonly XName scenarios

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: worksheet.
has the following child XML elements: scenario.
has the following XML attributes: current, show, sqref.
corresponds to the following strongly-typed classes: Scenarios.

scheme

Represents the x:scheme XML element.

public static readonly XName scheme

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: font, rPr.
has the following XML attributes: val.
corresponds to the following strongly-typed classes: FontScheme.

selection

Represents the x:selection XML element.

public static readonly XName selection

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: customSheetView, sheetView.
has the following XML attributes: activeCell, activeCellId, pane, sqref.
corresponds to the following strongly-typed classes: Selection.

serverFormat

Represents the x:serverFormat XML element.

public static readonly XName serverFormat

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: serverFormats.
has the following XML attributes: culture, format.
corresponds to the following strongly-typed classes: ServerFormat.

serverFormats

Represents the x:serverFormats XML element.

public static readonly XName serverFormats

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: tupleCache.
has the following child XML elements: serverFormat.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: ServerFormats.

set

Represents the x:set XML element.

public static readonly XName set

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: sets.
has the following child XML elements: sortByTuple, tpls.
has the following XML attributes: count, maxRank, queryFailed, setDefinition, sortType.
corresponds to the following strongly-typed classes: TupleSet.

sets

Represents the x:sets XML element.

public static readonly XName sets

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: tupleCache.
has the following child XML elements: set.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: Sets.

shadow

Represents the x:shadow XML element.

public static readonly XName shadow

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: font, rPr.
has the following XML attributes: val.
corresponds to the following strongly-typed classes: Shadow.

sharedItems

Represents the x:sharedItems XML element.

public static readonly XName sharedItems

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: cacheField.
has the following child XML elements: b, d, e, m, n, s.
has the following XML attributes: containsBlank, containsDate, containsInteger, containsMixedTypes, containsNonDate, containsNumber, containsSemiMixedTypes, containsString, count, longText, maxDate, maxValue, minDate, minValue.
corresponds to the following strongly-typed classes: SharedItems.

sheet

Represents the x:sheet XML element.

public static readonly XName sheet

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: sheets.
has the following XML attributes: name, id, sheetId, state.
corresponds to the following strongly-typed classes: Sheet.

sheetCalcPr

Represents the x:sheetCalcPr XML element.

public static readonly XName sheetCalcPr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: worksheet.
has the following XML attributes: fullCalcOnLoad.
corresponds to the following strongly-typed classes: SheetCalculationProperties.

sheetData

Represents the x:sheetData XML elements.

public static readonly XName sheetData

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: sheetDataSet, worksheet, macrosheet.
has the following child XML elements: row.
has the following XML attributes: refreshError, sheetId.
corresponds to the following strongly-typed classes: ExternalSheetData, SheetData.

sheetDataSet

Represents the x:sheetDataSet XML element.

public static readonly XName sheetDataSet

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: externalBook.
has the following child XML elements: sheetData.
corresponds to the following strongly-typed classes: SheetDataSet.

sheetFormatPr

Represents the x:sheetFormatPr XML element.

public static readonly XName sheetFormatPr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: dialogsheet, worksheet, macrosheet.
has the following XML attributes: baseColWidth, customHeight, defaultColWidth, defaultRowHeight, outlineLevelCol, outlineLevelRow, thickBottom, thickTop, dyDescent, zeroHeight.
corresponds to the following strongly-typed classes: SheetFormatProperties.

sheetId

Represents the x:sheetId XML element.

public static readonly XName sheetId

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: sheetIdMap.
has the following XML attributes: val.
corresponds to the following strongly-typed classes: SheetId.

sheetIdMap

Represents the x:sheetIdMap XML element.

public static readonly XName sheetIdMap

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: header.
has the following child XML elements: sheetId.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: SheetIdMap.

sheetName

Represents the x:sheetName XML element.

public static readonly XName sheetName

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: sheetNames.
has the following XML attributes: val.
corresponds to the following strongly-typed classes: SheetName.

sheetNames

Represents the x:sheetNames XML element.

public static readonly XName sheetNames

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: externalBook.
has the following child XML elements: sheetName.
corresponds to the following strongly-typed classes: SheetNames.

sheetPr

Represents the x:sheetPr XML elements.

public static readonly XName sheetPr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: chartsheet, dialogsheet, worksheet, macrosheet.
has the following child XML elements: outlinePr, pageSetUpPr, tabColor.
has the following XML attributes: codeName, enableFormatConditionsCalculation, filterMode, published, syncHorizontal, syncRef, syncVertical, transitionEntry, transitionEvaluation.
corresponds to the following strongly-typed classes: ChartSheetProperties, SheetProperties.

sheetProtection

Represents the x:sheetProtection XML elements.

public static readonly XName sheetProtection

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: chartsheet, dialogsheet, worksheet, macrosheet.
has the following XML attributes: algorithmName, autoFilter, content, deleteColumns, deleteRows, formatCells, formatColumns, formatRows, hashValue, insertColumns, insertHyperlinks, insertRows, objects, password, pivotTables, saltValue, scenarios, selectLockedCells, selectUnlockedCells, sheet, sort, spinCount.
corresponds to the following strongly-typed classes: ChartSheetProtection, SheetProtection.

sheetView

Represents the x:sheetView XML elements.

public static readonly XName sheetView

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: sheetViews.
has the following child XML elements: extLst, pane, pivotSelection, selection.
has the following XML attributes: colorId, defaultGridColor, rightToLeft, showFormulas, showGridLines, showOutlineSymbols, showRowColHeaders, showRuler, showWhiteSpace, showZeros, tabSelected, topLeftCell, view, windowProtection, workbookViewId, zoomScale, zoomScaleNormal, zoomScalePageLayoutView, zoomScaleSheetLayoutView, zoomToFit.
corresponds to the following strongly-typed classes: ChartSheetView, SheetView.

sheetViews

Represents the x:sheetViews XML elements.

public static readonly XName sheetViews

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: chartsheet, dialogsheet, worksheet, macrosheet.
has the following child XML elements: extLst, sheetView.
corresponds to the following strongly-typed classes: ChartSheetViews, SheetViews.

sheets

Represents the x:sheets XML element.

public static readonly XName sheets

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: workbook.
has the following child XML elements: sheet.
corresponds to the following strongly-typed classes: Sheets.

si

Represents the x:si XML element.

public static readonly XName si

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: sst.
has the following child XML elements: phoneticPr, r, rPh, t.
corresponds to the following strongly-typed classes: SharedStringItem.

singleXmlCell

Represents the x:singleXmlCell XML element.

public static readonly XName singleXmlCell

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: singleXmlCells.
has the following child XML elements: extLst, xmlCellPr.
has the following XML attributes: connectionId, id, r.
corresponds to the following strongly-typed classes: SingleXmlCell.

singleXmlCells

Represents the x:singleXmlCells XML element.

public static readonly XName singleXmlCells

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: singleXmlCell.
corresponds to the following strongly-typed classes: SingleXmlCells.

sortByTuple

Represents the x:sortByTuple XML element.

public static readonly XName sortByTuple

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: set.
has the following child XML elements: tpl.
has the following XML attributes: c.
corresponds to the following strongly-typed classes: SortByTuple.

sortCondition

Represents the x: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.

sortState

Represents the x:sortState XML element.

public static readonly XName sortState

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: autoFilter, queryTableRefresh, table, worksheet, macrosheet.
has the following child XML elements: extLst, sortCondition, sortCondition.
has the following XML attributes: caseSensitive, columnSort, ref, sortMethod.
corresponds to the following strongly-typed classes: SortState.

sst

Represents the x:sst XML element.

public static readonly XName sst

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: extLst, si.
has the following XML attributes: count, uniqueCount.
corresponds to the following strongly-typed classes: SharedStringTable.

start

Represents the x:start XML element.

public static readonly XName start

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: border.
has the following child XML elements: color.
has the following XML attributes: style.
corresponds to the following strongly-typed classes: StartBorder.

stop

Represents the x:stop XML element.

public static readonly XName stop

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: gradientFill.
has the following child XML elements: color.
has the following XML attributes: position.
corresponds to the following strongly-typed classes: GradientStop.

stp

Represents the x:stp XML element.

public static readonly XName stp

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: tp.
has the following XML attributes: space.
corresponds to the following strongly-typed classes: Subtopic.

strike

Represents the x:strike XML element.

public static readonly XName strike

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: font, rPr.
has the following XML attributes: val.
corresponds to the following strongly-typed classes: Strike.

styleSheet

Represents the x:styleSheet XML element.

public static readonly XName styleSheet

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: borders, cellStyles, cellStyleXfs, cellXfs, colors, dxfs, extLst, fills, fonts, numFmts, tableStyles.
corresponds to the following strongly-typed classes: Stylesheet.

sz

Represents the x:sz XML element.

public static readonly XName sz

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: font, rPr.
has the following XML attributes: val.
corresponds to the following strongly-typed classes: FontSize.

t

Represents the x:t XML elements.

public static readonly XName t

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: is, mdx, r, rPh, si, text.
has the following child XML elements: n.
has the following XML attributes: b, bc, c, ct, fc, fi, i, si, st, u, space.
corresponds to the following strongly-typed classes: MdxTuple, Text.

tabColor

Represents the x:tabColor XML element.

public static readonly XName tabColor

Field Value

XName

Remarks

As an XML element, it:

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

table

Represents the x:table XML element.

public static readonly XName table

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: autoFilter, extLst, sortState, tableColumns, tableStyleInfo.
has the following XML attributes: comment, connectionId, dataCellStyle, dataDxfId, displayName, headerRowBorderDxfId, headerRowCellStyle, headerRowCount, headerRowDxfId, id, insertRow, insertRowShift, name, published, ref, tableBorderDxfId, tableType, totalsRowBorderDxfId, totalsRowCellStyle, totalsRowCount, totalsRowDxfId, totalsRowShown.
corresponds to the following strongly-typed classes: Table.

tableColumn

Represents the x:tableColumn XML element.

public static readonly XName tableColumn

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: tableColumns.
has the following child XML elements: calculatedColumnFormula, extLst, totalsRowFormula, xmlColumnPr.
has the following XML attributes: dataCellStyle, dataDxfId, headerRowCellStyle, headerRowDxfId, id, name, queryTableFieldId, totalsRowCellStyle, totalsRowDxfId, totalsRowFunction, totalsRowLabel, uniqueName.
corresponds to the following strongly-typed classes: TableColumn.

tableColumns

Represents the x:tableColumns XML element.

public static readonly XName tableColumns

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: table.
has the following child XML elements: tableColumn.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: TableColumns.

tablePart

Represents the x:tablePart XML element.

public static readonly XName tablePart

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: tableParts.
has the following XML attributes: id.
corresponds to the following strongly-typed classes: TablePart.

tableParts

Represents the x:tableParts XML element.

public static readonly XName tableParts

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: worksheet.
has the following child XML elements: tablePart.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: TableParts.

tableStyle

Represents the x:tableStyle XML element.

public static readonly XName tableStyle

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: tableStyles.
has the following child XML elements: tableStyleElement.
has the following XML attributes: count, name, pivot, table.
corresponds to the following strongly-typed classes: TableStyle.

tableStyleElement

Represents the x:tableStyleElement XML element.

public static readonly XName tableStyleElement

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: tableStyle.
has the following XML attributes: dxfId_, size, type.
corresponds to the following strongly-typed classes: TableStyleElement.

tableStyleInfo

Represents the x:tableStyleInfo XML element.

public static readonly XName tableStyleInfo

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: table.
has the following XML attributes: name, showColumnStripes, showFirstColumn, showLastColumn, showRowStripes.
corresponds to the following strongly-typed classes: TableStyleInfo.

tableStyles

Represents the x:tableStyles XML element.

public static readonly XName tableStyles

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: styleSheet.
has the following child XML elements: tableStyle.
has the following XML attributes: count, defaultPivotStyle, defaultTableStyle.
corresponds to the following strongly-typed classes: TableStyles.

tables

Represents the x:tables XML element.

public static readonly XName tables

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: webPr.
has the following child XML elements: m, s, x_.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: Tables.

text

Represents the x:text XML element.

public static readonly XName text

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: comment.
has the following child XML elements: phoneticPr, r, rPh, t.
corresponds to the following strongly-typed classes: CommentText.

textField

Represents the x:textField XML element.

public static readonly XName textField

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: textFields.
has the following XML attributes: position, type.
corresponds to the following strongly-typed classes: TextField.

textFields

Represents the x:textFields XML element.

public static readonly XName textFields

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: textPr, textPr.
has the following child XML elements: textField.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: TextFields.

textPr

Represents the x:textPr XML element.

public static readonly XName textPr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: connection.
has the following child XML elements: textFields.
has the following XML attributes: characterSet, codePage, comma, consecutive, decimal, delimited, delimiter, fileType, firstRow, prompt, qualifier, semicolon, sourceFile, space, tab, thousands.
corresponds to the following strongly-typed classes: TextProperties.

to

Represents the x:to XML element.

public static readonly XName to

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: anchor.
has the following child XML elements: col, colOff, row, rowOff.
corresponds to the following strongly-typed classes: ToMarker.

top

Represents the x:top XML element.

public static readonly XName top

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: border.
has the following child XML elements: color.
has the following XML attributes: style.
corresponds to the following strongly-typed classes: TopBorder.

top10

Represents the x:top10 XML element.

public static readonly XName top10

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: filterColumn, filter.
has the following XML attributes: filterVal, percent, top, val.
corresponds to the following strongly-typed classes: Top10.

totalsRowFormula

Represents the x:totalsRowFormula XML element.

public static readonly XName totalsRowFormula

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: tableColumn.
has the following XML attributes: array, space.
corresponds to the following strongly-typed classes: TotalsRowFormula.

tp

Represents the x:tp XML element.

public static readonly XName tp

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: main.
has the following child XML elements: stp, tr, v.
has the following XML attributes: t.
corresponds to the following strongly-typed classes: Topic.

tpl

Represents the x:tpl XML element.

public static readonly XName tpl

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: sortByTuple, tpls.
has the following XML attributes: fld, hier, item.
corresponds to the following strongly-typed classes: Tuple.

tpls

Represents the x:tpls XML element.

public static readonly XName tpls

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: e, m, n, query, s, set.
has the following child XML elements: tpl.
has the following XML attributes: c.
corresponds to the following strongly-typed classes: Tuples.

tr

Represents the x:tr XML element.

public static readonly XName tr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: tp.
has the following XML attributes: r, s.
corresponds to the following strongly-typed classes: TopicReferences.

tupleCache

Represents the x:tupleCache XML element.

public static readonly XName tupleCache

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: pivotCacheDefinition.
has the following child XML elements: entries, extLst, queryCache, serverFormats, sets.
corresponds to the following strongly-typed classes: TupleCache.

u

Represents the x:u XML element.

public static readonly XName u

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: font, rPr.
has the following XML attributes: val.
corresponds to the following strongly-typed classes: Underline.

undo

Represents the x:undo XML element.

public static readonly XName undo

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: rm, rrc.
has the following XML attributes: array, cs, dn, dr, exp, index, nf, r, ref3D, sId, v.
corresponds to the following strongly-typed classes: Undo.

userInfo

Represents the x:userInfo XML element.

public static readonly XName userInfo

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: users.
has the following child XML elements: extLst.
has the following XML attributes: dateTime, guid, id, name.
corresponds to the following strongly-typed classes: UserInfo.

users

Represents the x:users XML element.

public static readonly XName users

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: userInfo.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: Users.

v

Represents the x:v XML elements.

public static readonly XName v

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: c, cell, nc, oc, tp.
has the following XML attributes: space.
corresponds to the following strongly-typed classes: CellValue, Xstring.

val

Represents the x:val XML element.

public static readonly XName val

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: value.
has the following XML attributes: space.
corresponds to the following strongly-typed classes: DdeLinkValue.

value

Represents the x:value XML element.

public static readonly XName value

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: values, values.
has the following child XML elements: val.
has the following XML attributes: t.
corresponds to the following strongly-typed classes: Value.

valueMetadata

Represents the x:valueMetadata XML element.

public static readonly XName valueMetadata

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: metadata.
has the following child XML elements: bk.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: ValueMetadata.

values

Represents the x:values XML element.

public static readonly XName values

Field Value

XName

Remarks

As an XML element, it:

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

vertAlign

Represents the x:vertAlign XML element.

public static readonly XName vertAlign

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: font, rPr.
has the following XML attributes: val.
corresponds to the following strongly-typed classes: VerticalTextAlignment.

vertical

Represents the x:vertical XML element.

public static readonly XName vertical

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: border.
has the following child XML elements: color.
has the following XML attributes: style.
corresponds to the following strongly-typed classes: VerticalBorder.

volType

Represents the x:volType XML element.

public static readonly XName volType

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: volTypes.
has the following child XML elements: main.
has the following XML attributes: type.
corresponds to the following strongly-typed classes: VolatileType.

volTypes

Represents the x:volTypes XML element.

public static readonly XName volTypes

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: extLst, volType.
corresponds to the following strongly-typed classes: VolatileTypes.

webPr

Represents the x:webPr XML element.

public static readonly XName webPr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: connection.
has the following child XML elements: tables.
has the following XML attributes: consecutive, editPage, firstRow, htmlFormat, htmlTables, parsePre, post, sourceData, textDates, url, xl2000, xl97, xml.
corresponds to the following strongly-typed classes: WebQueryProperties.

webPublishItem

Represents the x:webPublishItem XML element.

public static readonly XName webPublishItem

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: webPublishItems.
has the following XML attributes: autoRepublish, destinationFile, divId, id, sourceObject, sourceRef, sourceType, title.
corresponds to the following strongly-typed classes: WebPublishItem.

webPublishItems

Represents the x:webPublishItems XML element.

public static readonly XName webPublishItems

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: chartsheet, worksheet.
has the following child XML elements: webPublishItem.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: WebPublishItems.

webPublishObject

Represents the x:webPublishObject XML element.

public static readonly XName webPublishObject

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: webPublishObjects.
has the following XML attributes: autoRepublish, destinationFile, divId, id, sourceObject, title.
corresponds to the following strongly-typed classes: WebPublishObject.

webPublishObjects

Represents the x:webPublishObjects XML element.

public static readonly XName webPublishObjects

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: workbook.
has the following child XML elements: webPublishObject.
has the following XML attributes: count.
corresponds to the following strongly-typed classes: WebPublishObjects.

webPublishing

Represents the x:webPublishing XML element.

public static readonly XName webPublishing

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: workbook.
has the following XML attributes: allowPng, characterSet, codePage, css, dpi, longFileNames, targetScreenSize, thicket, vml.
corresponds to the following strongly-typed classes: WebPublishing.

workbook

Represents the x:workbook XML element.

public static readonly XName workbook

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: bookViews, calcPr, customWorkbookViews, definedNames, externalReferences, extLst, fileRecoveryPr, fileSharing, fileVersion, functionGroups, oleSize, pivotCaches, sheets, webPublishing, webPublishObjects, workbookPr, workbookProtection, absPath.
has the following XML attributes: conformance.
corresponds to the following strongly-typed classes: Workbook.

workbookPr

Represents the x:workbookPr XML element.

public static readonly XName workbookPr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: workbook.
has the following XML attributes: allowRefreshQuery, autoCompressPictures, backupFile, checkCompatibility, codeName, date1904, dateCompatibility, defaultThemeVersion, filterPrivacy, hidePivotFieldList, promptedSolutions, publishItems, refreshAllConnections, saveExternalLinkValues, showBorderUnselectedTables, showInkAnnotation, showObjects, showPivotChartFilter, updateLinks.
corresponds to the following strongly-typed classes: WorkbookProperties.

workbookProtection

Represents the x:workbookProtection XML element.

public static readonly XName workbookProtection

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: workbook.
has the following XML attributes: lockRevision, lockStructure, lockWindows, revisionsAlgorithmName, revisionsHashValue, revisionsPassword, revisionsSaltValue, revisionsSpinCount, workbookAlgorithmName, workbookHashValue, workbookPassword, workbookSaltValue, workbookSpinCount.
corresponds to the following strongly-typed classes: WorkbookProtection.

workbookView

Represents the x:workbookView XML element.

public static readonly XName workbookView

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: bookViews.
has the following child XML elements: extLst.
has the following XML attributes: activeTab, autoFilterDateGrouping, firstSheet, minimized, showHorizontalScroll, showSheetTabs, showVerticalScroll, tabRatio, visibility, windowHeight, windowWidth, xWindow, yWindow.
corresponds to the following strongly-typed classes: WorkbookView.

worksheet

Represents the x:worksheet XML element.

public static readonly XName worksheet

Field Value

XName

Remarks

As an XML element, it:

has the following child XML elements: autoFilter, cellWatches, colBreaks, cols, conditionalFormatting, controls, customProperties, customSheetViews, dataConsolidate, dataValidations, dimension, drawing, drawingHF, extLst, headerFooter, hyperlinks, ignoredErrors, legacyDrawing, legacyDrawingHF, mergeCells, oleObjects, pageMargins, pageSetup, phoneticPr, picture, printOptions, protectedRanges, rowBreaks, scenarios, sheetCalcPr, sheetData, sheetFormatPr, sheetPr, sheetProtection, sheetViews, sortState, tableParts, webPublishItems.
corresponds to the following strongly-typed classes: Worksheet.

worksheetSource

Represents the x:worksheetSource XML element.

public static readonly XName worksheetSource

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: cacheSource.
has the following XML attributes: name, id, ref, sheet.
corresponds to the following strongly-typed classes: WorksheetSource.

x

Defines the XML namespace associated with the x prefix.

public static readonly XNamespace x

Field Value

XNamespace

x_

Represents the x:x XML elements.

public static readonly XName x_

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: b, d, discretePr, e, i, m, n, r, reference, s, tables.
has the following XML attributes: v.
corresponds to the following strongly-typed classes: FieldItem, MemberPropertyIndex.

xf

Represents the x:xf XML element.

public static readonly XName xf

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: cellStyleXfs, cellXfs.
has the following child XML elements: alignment, extLst, protection.
has the following XML attributes: applyAlignment, applyBorder, applyFill, applyFont, applyNumberFormat, applyProtection, borderId, fillId, fontId, numFmtId, pivotButton, quotePrefix, xfId.
corresponds to the following strongly-typed classes: CellFormat.

xmlCellPr

Represents the x:xmlCellPr XML element.

public static readonly XName xmlCellPr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: singleXmlCell.
has the following child XML elements: extLst, xmlPr.
has the following XML attributes: id, uniqueName.
corresponds to the following strongly-typed classes: XmlCellProperties.

xmlColumnPr

Represents the x:xmlColumnPr XML element.

public static readonly XName xmlColumnPr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: tableColumn.
has the following child XML elements: extLst.
has the following XML attributes: denormalized, mapId, xmlDataType, xpath.
corresponds to the following strongly-typed classes: XmlColumnProperties.

xmlPr

Represents the x:xmlPr XML element.

public static readonly XName xmlPr

Field Value

XName

Remarks

As an XML element, it:

has the following parent XML elements: xmlCellPr.
has the following child XML elements: extLst.
has the following XML attributes: mapId, xmlDataType, xpath.
corresponds to the following strongly-typed classes: XmlProperties.

Table of Contents

Class X

Fields

DataBinding

Field Value

Remarks

MapInfo

Field Value

Remarks

Map_

Field Value

Remarks

Schema

Field Value

Remarks

alignment

Field Value

Remarks

anchor

Field Value

Remarks

author

Field Value

Remarks

authors

Field Value

Remarks

autoFilter

Field Value

Remarks

autoSortScope

Field Value

Remarks

b

Field Value

Remarks

bgColor

Field Value

Remarks

bk

Field Value

Remarks

bookViews

Field Value

Remarks

border

Field Value

Remarks

borders

Field Value

Remarks

bottom

Field Value

Remarks

brk

Field Value

Remarks

c

Field Value

Remarks

cacheField

Field Value

Remarks

cacheFields

Field Value

Remarks

cacheHierarchies

Field Value

Remarks

cacheHierarchy

Field Value

Remarks

cacheSource

Field Value

Remarks

calcChain

Field Value

Remarks

calcPr

Field Value