United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Office and SharePoint development

Office client development

Office 2013

Office 2013

Open XML SDK 2.5

Class library reference

DocumentFormat.OpenXml.Spreadsheet

Alignment class

Author class

Authors class

AutoFilter class

AutoSortScope class

BackgroundColor class

Bold class

BookViews class

BooleanItem class

BooleanPropertyType class

Border class

BorderPropertiesType class

Borders class

BorderStyleValues enumeration

BottomBorder class

Break class

CacheField class

CacheFieldExtension class

CacheFieldExtensionList class

CacheFields class

CacheHierarchies class

CacheHierarchy class

CacheHierarchyExtension class

CacheHierarchyExtensionList class

CacheSource class

CacheSourceExtension class

CacheSourceExtensionList class

CalculatedColumnFormula class

CalculatedItem class

CalculatedItems class

CalculatedMember class

CalculatedMemberExtension class

CalculatedMemberExtensionList class

CalculatedMembers class

CalculateModeValues enumeration

CalculationCell class

CalculationChain class

CalculationProperties class

CalendarValues enumeration

Cell class

CellCommentsValues enumeration

CellFormat class

CellFormats class

CellFormula class

CellFormulaValues enumeration

CellMetadata class

CellStyle class

CellStyleFormats class

CellStyles class

CellValue class

CellValues enumeration

CellWatch class

CellWatches class

CharacterValue class

ChartFormat class

ChartFormats class

Chartsheet class

ChartSheetPageSetup class

ChartSheetProperties class

ChartSheetProtection class

ChartSheetView class

ChartSheetViews class

Color class

ColorFilter class

Colors class

ColorScale class

ColorType class

Column class

ColumnBreaks class

ColumnFields class

ColumnHierarchiesUsage class

ColumnHierarchyUsage class

ColumnItems class

Columns class

Comment class

CommentList class

CommentProperties class

CommentsValues enumeration

CommentText class

ConditionalFormat class

ConditionalFormats class

ConditionalFormatting class

ConditionalFormattingOperatorValues enumeration

ConditionalFormattingRule class

ConditionalFormattingRuleExtension class

ConditionalFormattingRuleExtensionList class

ConditionalFormatValueObject class

ConditionalFormatValueObjectValues enumeration

ConditionalFormatValues enumeration

ConformanceClass enumeration

Connection class

ConnectionExtension class

ConnectionExtensionList class

Connections class

Consolidation class

Control class

ControlProperties class

CredentialsMethodValues enumeration

CustomChartsheetView class

CustomChartsheetViews class

CustomFilter class

CustomFilters class

CustomProperties class

CustomProperty class

CustomSheetView class

CustomSheetViews class

CustomWorkbookView class

CustomWorkbookViews class

DataBar class

DatabaseProperties class

DataBinding class

DataConsolidate class

DataConsolidateFunctionValues enumeration

DataField class

DataFieldExtension class

DataFieldExtensionList class

DataFields class

DataReference class

DataReferences class

DataValidation class

DataValidationErrorStyleValues enumeration

DataValidationImeModeValues enumeration

DataValidationOperatorValues enumeration

DataValidations class

DataValidationValues enumeration

DataViewAspectValues enumeration

DateGroupItem class

DateTimeGroupingValues enumeration

DateTimeItem class

DdeItem class

DdeLink class

DdeLinkValue class

DdeValues enumeration

DefinedName class

DefinedNames class

DeletedField class

DiagonalBorder class

DialogSheet class

DifferentialFormat class

DifferentialFormats class

DifferentialFormatType class

Dimension class

Dimensions class

DiscreteProperties class

Drawing class

DrawingHeaderFooter class

DynamicFilter class

DynamicFilterValues enumeration

EmbeddedObjectProperties class

EndBorder class

Entries class

ErrorItem class

EvenFooter class

EvenHeader class

Extend class

Extension class

ExtensionList class

ExternalBook class

ExternalCell class

ExternalConnectionValues enumeration

ExternalDefinedName class

ExternalDefinedNames class

ExternalLink class

ExternalReference class

ExternalReferences class

ExternalRow class

ExternalSheetData class

Field class

FieldGroup class

FieldItem class

FieldSortValues enumeration

FieldsUsage class

FieldUsage class

FileRecoveryProperties class

FileSharing class

FileTypeValues enumeration

FileVersion class

Fill class

Fills class

Filter class

FilterColumn class

FilterOperatorValues enumeration

Filters class

FirstFooter class

FirstHeader class

Font class

FontCharSet class

FontFamily class

FontFamilyNumbering class

Fonts class

FontScheme class

FontSchemeValues enumeration

ForegroundColor class

Format class

FormatActionValues enumeration

Formats class

Formula class

FormulaExpressionValues enumeration

FromMarker class

FunctionGroup class

FunctionGroups class

FutureMetadata class

FutureMetadataBlock class

GradientFill class

GradientStop class

GradientValues enumeration

Group class

GroupByValues enumeration

GroupItems class

GroupLevel class

GroupLevels class

GroupMember class

GroupMembers class

Groups class

GrowShrinkValues enumeration

Header class

HeaderFooter class

Headers class

HierarchyUsageType class

HorizontalAlignmentValues enumeration

HorizontalBorder class

HtmlFormattingValues enumeration

Hyperlink class

Hyperlinks class

IconFilter class

IconSet class

IconSetValues enumeration

IgnoredError class

IgnoredErrors class

IndexedColors class

InlineString class

InputCells class

InternationalPropertyType class

Italic class

Item class

Items class

ItemValues enumeration

Kpi class

Kpis class

LeftBorder class

LegacyDrawing class

LegacyDrawingHeaderFooter class

LegacyDrawingType class

Main class

Map class

MapInfo class

Maps class

MarkerType class

Mdx class

MdxFunctionValues enumeration

MdxKpi class

MdxKPIPropertyValues enumeration

MdxMemberProp class

MdxMetadata class

MdxSet class

MdxSetOrderValues enumeration

MeasureDimensionMap class

MeasureGroup class

MeasureGroups class

Member class

MemberProperties class

MemberPropertiesMap class

MemberProperty class

MemberPropertyIndex class

Members class

MergeCell class

MergeCells class

MetadataBlock class

MetadataBlocksType class

MetadataRecord class

MetadataStrings class

MetadataType class

MetadataTypes class

MissingItem class

MissingTable class

MruColors class

NameIndex class

NewCell class

NewDifferentialFormat class

NumberingFormat class

NumberingFormats class

NumberItem class

ObjectAnchor class

ObjectDisplayValues enumeration

OddFooter class

OddHeader class

OlapProperties class

OldCell class

OldDifferentialFormat class

OldFormula class

OleItem class

OleLink class

OleObject class

OleObjects class

OleSize class

OleUpdateValues enumeration

OrientationValues enumeration

Outline class

OutlineProperties class

Page class

PageBreakType class

PageField class

PageFields class

PageMargins class

PageOrderValues enumeration

Pages class

PageSetup class

PageSetupProperties class

Pane class

PaneStateValues enumeration

PaneValues enumeration

Parameter class

Parameters class

ParameterValues enumeration

PatternFill class

PatternValues enumeration

PhoneticAlignmentValues enumeration

PhoneticProperties class

PhoneticRun class

PhoneticValues enumeration

Picture class

PivotArea class

PivotAreaReference class

PivotAreaReferences class

PivotAreas class

PivotAreaValues enumeration

PivotCache class

PivotCacheDefinition class

PivotCacheDefinitionExtension class

PivotCacheDefinitionExtensionList class

PivotCacheRecord class

PivotCacheRecords class

PivotCaches class

PivotField class

PivotFieldExtension class

PivotFieldExtensionList class

PivotFields class

PivotFilter class

PivotFilterExtension class

PivotFilterExtensionList class

PivotFilters class

PivotFilterValues enumeration

PivotHierarchies class

PivotHierarchy class

PivotHierarchyExtension class

PivotHierarchyExtensionList class

PivotSelection class

PivotTableAxisValues enumeration

PivotTableDefinition class

PivotTableDefinitionExtension class

PivotTableDefinitionExtensionList class

PivotTableStyle class

PrintErrorValues enumeration

PrintOptions class

ProtectedRange class

ProtectedRanges class

Protection class

QualifierValues enumeration

Query class

QueryCache class

QueryTable class

QueryTableDeletedFields class

QueryTableExtension class

QueryTableExtensionList class

QueryTableField class

QueryTableFields class

QueryTableRefresh class

RangeProperties class

RangeSets class

ReferenceModeValues enumeration

ReviewedList class

RevisionActionValues enumeration

RevisionAutoFormat class

RevisionCellChange class

RevisionComment class

RevisionConflict class

RevisionCustomView class

RevisionDefinedName class

RevisionFormat class

RevisionInsertSheet class

RevisionMove class

RevisionQueryTable class

RevisionRowColumn class

Revisions class

RevisionSheetName class

RightBorder class

Row class

RowBreaks class

RowColumnActionValues enumeration

RowFields class

RowHierarchiesUsage class

RowHierarchyUsage class

RowItem class

RstType class

RuleValues enumeration

Run class

RunFont class

RunProperties class

RunPropertyCharSet class

Scenarios class

Schema class

ScopeValues enumeration

Selection class

ServerFormat class

ServerFormats class

Sets class

Shadow class

SharedItems class

SharedStringItem class

SharedStringTable class

Sheet class

SheetCalculationProperties class

SheetData class

SheetDataSet class

SheetDimension class

SheetFormatProperties class

SheetId class

SheetIdMap class

SheetName class

SheetNames class

SheetProperties class

SheetProtection class

Sheets class

SheetStateValues enumeration

SheetView class

SheetViews class

SheetViewValues enumeration

ShowDataAsValues enumeration

SingleXmlCell class

SingleXmlCells class

SlicerCacheDefinitionExtension class

SortByTuple class

SortByValues enumeration

SortCondition class

SortMethodValues enumeration

SortState class

SortValues enumeration

SourceValues enumeration

StartBorder class

Strike class

StringItem class

Stylesheet class

StylesheetExtension class

StylesheetExtensionList class

Table class

TableColumn class

TableColumns class

TableExtension class

TableExtensionList class

TableFormulaType class

TablePart class

TableParts class

Tables class

TableStyle class

TableStyleElement class

TableStyleInfo class

TableStyles class

TableStyleValues enumeration

TableValues enumeration

TargetScreenSizeValues enumeration

Text class

TextField class

TextFields class

TextHorizontalAlignmentValues enumeration

TextProperties class

TextVerticalAlignmentValues enumeration

TimePeriodValues enumeration

Top10 class

TopBorder class

Topic class

TopicReferences class

TotalsRowFormula class

TotalsRowFunctionValues enumeration

Tuple class

TupleCache class

Tuples class

TuplesType class

Underline class

UnderlineValues enumeration

Undo class

UpdateLinksBehaviorValues enumeration

Users class

Value class

ValueMetadata class

Values class

VerticalAlignmentRunValues enumeration

VerticalAlignmentValues enumeration

VerticalBorder class

VerticalTextAlignment class

VisibilityValues enumeration

VolatileDependencyValues enumeration

VolatileType class

VolatileTypes class

VolatileValues enumeration

WebPublishing class

WebPublishItem class

WebPublishItems class

WebPublishObject class

WebPublishObjects class

WebQueryProperties class

WebSourceValues enumeration

WorkbookExtension class

WorkbookExtensionList class

WorkbookProperties class

WorkbookProtection class

WorkbookView class

Worksheet class

WorksheetExtension class

WorksheetExtensionList class

WorksheetSource class

XmlCellProperties class

XmlColumnProperties class

XmlDataValues enumeration

XmlProperties class

Xstring class

XstringType class

XType class

Minimize

This topic has not yet been rated - Rate this topic

CellValues enumeration

Office 2013

Office 2010

Cell Type

Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

public enum CellValues

	Member name	Description
	Boolean	Boolean. When the item is serialized out as xml, its value is "b".
	Number	Number. When the item is serialized out as xml, its value is "n".
	Error	Error. When the item is serialized out as xml, its value is "e".
	SharedString	Shared String. When the item is serialized out as xml, its value is "s".
	String	String. When the item is serialized out as xml, its value is "str".
	InlineString	Inline String. When the item is serialized out as xml, its value is "inlineStr".
	Date	d. When the item is serialized out as xml, its value is "d".This item is only available in Office2010.

Reference

DocumentFormat.OpenXml.Spreadsheet namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.