Class Excel2007Serializator

Class used for Excel 2007 Serialization.

Inheritance
System.Object
Excel2007Serializator
Excel2010Serializator
Implements
System.IDisposable
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Syncfusion.XlsIO.Implementation.XmlSerialization
Assembly: Syncfusion.XlsIO.Base.dll
Syntax
public class Excel2007Serializator : IDisposable

Constructors

Excel2007Serializator(WorkbookImpl)

Initializes a new instance of the Excel2007Serializator class.

Declaration
public Excel2007Serializator(WorkbookImpl book)
Parameters
Type Name Description
WorkbookImpl book

Parent workbook.

Fields

ActiveSheetIndexAttributeName

Name of the xml attribute that specifies an unsignedInt that contains the index to the active sheet in this book view.

Declaration
public const string ActiveSheetIndexAttributeName = "activeTab"
Field Value
Type Description
System.String

AlignmentTagName

Name of the xml tag that hold all style's alignment information.

Declaration
public const string AlignmentTagName = "alignment"
Field Value
Type Description
System.String

Always

Declaration
public const string Always = "OLEUPDATE_ALWAYS"
Field Value
Type Description
System.String

AlwaysCalculateArray

True indicates that this formula is an array formula and the entire array shall be calculated in full. If false the individual cells of the array shall be calculated as needed.

Declaration
public const string AlwaysCalculateArray = "aca"
Field Value
Type Description
System.String

ApplicationNameAttribute

Specifies the application name.

Declaration
public const string ApplicationNameAttribute = "appName"
Field Value
Type Description
System.String

ApplicationNameValue

Value of the application name attribute.

Declaration
public const string ApplicationNameValue = "xl"
Field Value
Type Description
System.String

AuthorIdAttributeName

Name of the xml attribute that stores comment author id.

Declaration
public const string AuthorIdAttributeName = "authorId"
Field Value
Type Description
System.String

Auto

Name of the default color attribute.

Declaration
public const string Auto = "auto"
Field Value
Type Description
System.String

AutoFilterDateGroupingAttributeName

Name of the xml attribute that specifies a boolean value that indicates whether to group dates when presenting the user with filtering options in the user interface.

Declaration
public const string AutoFilterDateGroupingAttributeName = "autoFilterDateGrouping"
Field Value
Type Description
System.String

AutoNoTableCalcModeValue

Auto No Table Calc Mode Value

Declaration
public const string AutoNoTableCalcModeValue = "autoNoTable"
Field Value
Type Description
System.String

BackGroundAttribute

BackGround Attribute

Declaration
public const string BackGroundAttribute = "background"
Field Value
Type Description
System.String

BackgroundColorTagName

Name of the xml tag that represents background color.

Declaration
public const string BackgroundColorTagName = "bgColor"
Field Value
Type Description
System.String

BackgroundImageTagName

Name of the xml tag that represents Background sheet image.

Declaration
public const string BackgroundImageTagName = "picture"
Field Value
Type Description
System.String

BackgroundRefresh

Background refresh

Declaration
public const string BackgroundRefresh = "backgroundRefresh"
Field Value
Type Description
System.String

BaseColWidthAttribute

Name of the xml attribute that stores base column width setting

Declaration
public const string BaseColWidthAttribute = "baseColWidth"
Field Value
Type Description
System.String

BestFitAttribute

Declaration
public const string BestFitAttribute = "bestFit"
Field Value
Type Description
System.String

BorderColorTagName

Name of the xml tag that stores border color.

Declaration
public const string BorderColorTagName = "color"
Field Value
Type Description
System.String

BorderIdAttributeName

Name of the xml attribute that represents border id.

Declaration
public const string BorderIdAttributeName = "borderId"
Field Value
Type Description
System.String

BordersCollectionTagName

Name of the xml tag that stores single border collection.

Declaration
public const string BordersCollectionTagName = "border"
Field Value
Type Description
System.String

BordersTagName

Name of the xml tag that stores all border collections inside.

Declaration
public const string BordersTagName = "borders"
Field Value
Type Description
System.String

BorderStyleAttributeName

Name of the xml attribute that represents border style.

Declaration
public const string BorderStyleAttributeName = "style"
Field Value
Type Description
System.String

BottomConvergenceAttributeName

Name of the xml attribute that specifies in percentage format (from the top to the bottom) the position of the bottom edge of the inner rectangle (color 1).

Declaration
public const string BottomConvergenceAttributeName = "bottom"
Field Value
Type Description
System.String

BreakTagName

Name of the xml tag that represents individual row or column breaks;

Declaration
public const string BreakTagName = "brk"
Field Value
Type Description
System.String

CalcProperties

This element defines the collection of properties the application uses to record calculation status and details.

Declaration
public const string CalcProperties = "calcPr"
Field Value
Type Description
System.String

CalculateOnOpen

Name of the xml tag that represents Calculate On Open

Declaration
public const string CalculateOnOpen = "ca"
Field Value
Type Description
System.String

CalculationId

Calculation ID

Declaration
public const string CalculationId = "calcId"
Field Value
Type Description
System.String

CalculationMode

Calculation Mode

Declaration
public const string CalculationMode = "calcMode"
Field Value
Type Description
System.String

CellDataTypeAttributeName

Name of the xml attribute that represents an enumeration representing the cell's data type.

Declaration
public const string CellDataTypeAttributeName = "t"
Field Value
Type Description
System.String

CellFormatXFsTagName

Name of the xml tag that stores extended formats for cell formats.

Declaration
public const string CellFormatXFsTagName = "cellXfs"
Field Value
Type Description
System.String

CellMetadataIndexAttributeName

Name of the xml attribute that represents the cell metadata record associated with this cell.

Declaration
public const string CellMetadataIndexAttributeName = "cm"
Field Value
Type Description
System.String

CellStylesTagName

Name of the xml tag that stores named cell styles settings.

Declaration
public const string CellStylesTagName = "cellStyles"
Field Value
Type Description
System.String

CellStyleTagName

Name of the xml tag that stores single named cell style settings.

Declaration
public const string CellStyleTagName = "cellStyle"
Field Value
Type Description
System.String

CellTagName

Name of the xml tag that stores cell in the worksheet.

Declaration
public const string CellTagName = "c"
Field Value
Type Description
System.String

CellValueTagName

Name of xml tag that represents cell value.

Declaration
public const string CellValueTagName = "v"
Field Value
Type Description
System.String

ChartSheetPartType

Name of the relation type that indicates that part contains chartsheet data.

Declaration
public const string ChartSheetPartType = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/chartsheet"
Field Value
Type Description
System.String

CodeName

Xml attribute containing sheet codename.

Declaration
public const string CodeName = "codeName"
Field Value
Type Description
System.String

ColorID

String used to specify the color of grid line

Declaration
public const string ColorID = "colorId"
Field Value
Type Description
System.String

ColorIndexedAttributeName

Name of the indexed attribute in the color tag.

Declaration
public const string ColorIndexedAttributeName = "indexed"
Field Value
Type Description
System.String

ColorRgbAttribute

Name of the rgb attribute in the color tag.

Declaration
public const string ColorRgbAttribute = "rgb"
Field Value
Type Description
System.String

ColorSchemeTagName

Name of the xml tag that represents a set of colors which are referred to as a color scheme.

Declaration
public const string ColorSchemeTagName = "clrScheme"
Field Value
Type Description
System.String

ColorsTagName

Name of the xml tag that stores color settings.

Declaration
public const string ColorsTagName = "colors"
Field Value
Type Description
System.String

ColorTagName

Name of the xml tag that contains color settings.

Declaration
public const string ColorTagName = "color"
Field Value
Type Description
System.String

ColorThemeAttributeName

Name of the xml attribute that represents index into the theme colors collection.

Declaration
public const string ColorThemeAttributeName = "theme"
Field Value
Type Description
System.String

ColorTintAttributeName

Name of the xml attribute that represents the tint value applied to the color.

Declaration
public const string ColorTintAttributeName = "tint"
Field Value
Type Description
System.String

ColsTagName

Name of the xml tag that stores all column settings.

Declaration
public const string ColsTagName = "cols"
Field Value
Type Description
System.String

ColTagName

Name of the xml tag that stores column settings range.

Declaration
public const string ColTagName = "col"
Field Value
Type Description
System.String

ColumnCustomWidthAttribute

Name of the xml attribute that indicates whether column width differs from the default one.

Declaration
public const string ColumnCustomWidthAttribute = "customWidth"
Field Value
Type Description
System.String

ColumnMaxAttribute

Name of the xml attribute that stores maximum column index of the column range.

Declaration
public const string ColumnMaxAttribute = "max"
Field Value
Type Description
System.String

ColumnMinAttribute

Name of the xml attribute that stores minimum column index of the column range.

Declaration
public const string ColumnMinAttribute = "min"
Field Value
Type Description
System.String

ColumnStyleAttribute

Name of the xml attribute that stores style of each column from column range.

Declaration
public const string ColumnStyleAttribute = "style"
Field Value
Type Description
System.String

ColumnWidthAttribute

Name of the xml attribute that stores width of each column from column range.

Declaration
public const string ColumnWidthAttribute = "width"
Field Value
Type Description
System.String

CommandTextAttribute

Command Text Attribute

Declaration
public const string CommandTextAttribute = "command"
Field Value
Type Description
System.String

CommandTypeAttribute

Command Type Attribute

Declaration
public const string CommandTypeAttribute = "commandType"
Field Value
Type Description
System.String

CommentAttributeName

Name of the comment attribute.

Declaration
public const string CommentAttributeName = "comment"
Field Value
Type Description
System.String

CommentAuthorsTagName

Name of the xml tag that holds list of all comment authors.

Declaration
public const string CommentAuthorsTagName = "authors"
Field Value
Type Description
System.String

CommentAuthorTagName

Name of the xml tag that holds single author name.

Declaration
public const string CommentAuthorTagName = "author"
Field Value
Type Description
System.String

CommentListTagName

Name of the xml tag that holds all comment notes.

Declaration
public const string CommentListTagName = "commentList"
Field Value
Type Description
System.String

CommentsTagName

Name of the xml tag that stores all comment notes settings.

Declaration
public const string CommentsTagName = "comments"
Field Value
Type Description
System.String

CommentTagName

Name of the xml tag that holds single comment note.

Declaration
public const string CommentTagName = "comment"
Field Value
Type Description
System.String

CommentTextTagName

Name of the xml tag that stores comment text.

Declaration
public const string CommentTextTagName = "text"
Field Value
Type Description
System.String

ConnectionIdAttribute

Connection Id Attribute

Declaration
public const string ConnectionIdAttribute = "id"
Field Value
Type Description
System.String

ConnectionsTag

Represent the connections

Declaration
public const string ConnectionsTag = "connections"
Field Value
Type Description
System.String

ConnectionTag

Represent the connections

Declaration
public const string ConnectionTag = "connection"
Field Value
Type Description
System.String

ContentTypeAttributeName

Name of the xml tag that stores content type string.

Declaration
public const string ContentTypeAttributeName = "ContentType"
Field Value
Type Description
System.String

ContentTypesNamespace

Namespace with ContentTypes items.

Declaration
public const string ContentTypesNamespace = "http://schemas.openxmlformats.org/package/2006/content-types"
Field Value
Type Description
System.String

CorePropertiesPartType

Name of the relation type that indicates that part contains core properties.

Declaration
public const string CorePropertiesPartType = "http://schemas.openxmlformats.org/package/2006/metadata/core-properties"
Field Value
Type Description
System.String

CorePropertiesPrefix

Prefix for core properties namespace.

Declaration
public const string CorePropertiesPrefix = "cp"
Field Value
Type Description
System.String

CountAttributeName

Name of the count attribute.

Declaration
public const string CountAttributeName = "count"
Field Value
Type Description
System.String

Credentials

Credentials

Declaration
public const string Credentials = "credentials"
Field Value
Type Description
System.String

CustomPropertiesPartType

Name of the relation type that indicates that part contains custom properties.

Declaration
public const string CustomPropertiesPartType = "http://schemas.openxmlformats.org/officeDocument/2006/custom-properties"
Field Value
Type Description
System.String

CustomPropertiesTagName

This collection is used to reference binary parts containing arbitrary user-defined data.

Declaration
public const string CustomPropertiesTagName = "customProperties"
Field Value
Type Description
System.String

CustomPropertyTagName

The custom property element provides a mechanism to store name/value pairs of arbitrary user-defined data. The name is stored in the attribute name, the arbitrary data is stored in the binary part referenced by the relationshipId.

Declaration
public const string CustomPropertyTagName = "customPr"
Field Value
Type Description
System.String

CustomWorkbookView

Name of the xml tag that specifies single custom workbook view.

Declaration
public const string CustomWorkbookView = "customWorkbookView"
Field Value
Type Description
System.String

CustomWorkbookViews

Name of the xml tag that specifies the collection of custom workbook views.

Declaration
public const string CustomWorkbookViews = "customWorkbookViews"
Field Value
Type Description
System.String

CustomXmlItemID

Custom Xml Item ID

Declaration
public const string CustomXmlItemID = "itemID"
Field Value
Type Description
System.String

CustomXmlItemPropertiesRelation

Custom Xml Item Properties Relation

Declaration
public const string CustomXmlItemPropertiesRelation = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/customXmlProps"
Field Value
Type Description
System.String

CustomXmlName

Custom Xml Name

Declaration
public const string CustomXmlName = "customXml/item{0}.xml"
Field Value
Type Description
System.String

CustomXmlNameSpace

Custom Xml Namespace

Declaration
public const string CustomXmlNameSpace = "http://schemas.openxmlformats.org/officeDocument/2006/customXml"
Field Value
Type Description
System.String

CustomXmlPartName

CustomXmlParts Constants

Declaration
public const string CustomXmlPartName = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/customXml"
Field Value
Type Description
System.String

CustomXmlPropertiesName

Custom Xml properties name

Declaration
public const string CustomXmlPropertiesName = "customXml/itemProps{0}.xml"
Field Value
Type Description
System.String

CustomXmlRelation

Custom xml relation

Declaration
public const string CustomXmlRelation = "{0}/_rels/item{1}.xml.rels"
Field Value
Type Description
System.String

CustomXmlSchemaReference

Custom Xml Schema Reference

Declaration
public const string CustomXmlSchemaReference = "schemaRef"
Field Value
Type Description
System.String

CustomXmlSchemaReferences

Custom Xml Schema References

Declaration
public const string CustomXmlSchemaReferences = "schemaRefs"
Field Value
Type Description
System.String

CustomXmlUriAttribute

Custom Xml Uri Attribute

Declaration
public const string CustomXmlUriAttribute = "ds:uri"
Field Value
Type Description
System.String

DataBaseNameAttribute

Represents DataBase Name

Declaration
public const string DataBaseNameAttribute = "name"
Field Value
Type Description
System.String

DataBasePrTag

DataBase Property Tag

Declaration
public const string DataBasePrTag = "dbPr"
Field Value
Type Description
System.String

DataBaseTypeAttribute

Represents DataBase Type

Declaration
public const string DataBaseTypeAttribute = "type"
Field Value
Type Description
System.String

DataStoreItem

Data store item

Declaration
public const string DataStoreItem = "datastoreItem"
Field Value
Type Description
System.String

dataTable2DTag

Attribute to show two-dimenssional data table

Declaration
public const string dataTable2DTag = "dt2D"
Field Value
Type Description
System.String

dataTableCellTag

Attribute to represent first input cell for data table.

Declaration
public const string dataTableCellTag = "r1"
Field Value
Type Description
System.String

dataTableRowTag

Attribute to show one-dimentional data table is a row or column

Declaration
public const string dataTableRowTag = "dtr"
Field Value
Type Description
System.String

DCMITypePartType

Name of the relation type that indicates DCMIType part.

Declaration
public const string DCMITypePartType = "http://purl.org/dc/dcmitype/"
Field Value
Type Description
System.String

DCMITypePrefix

Prefix for DCMIType namespace.

Declaration
public const string DCMITypePrefix = "dcmitype"
Field Value
Type Description
System.String

DEF_DEFAULT_ROW_DELIMITER

Default delimiter between worksheet rows.

Declaration
public const string DEF_DEFAULT_ROW_DELIMITER = "\r\n"
Field Value
Type Description
System.String

DefaultCellDataType

Defines default cell data type.

Declaration
public const string DefaultCellDataType = "n"
Field Value
Type Description
System.String

DefaultColumWidthAttribute

Name of the xml attribute that stores default col width setting.

Declaration
public const string DefaultColumWidthAttribute = "defaultColWidth"
Field Value
Type Description
System.String

DefaultRowHeightAttribute

Name of the xml attribute that stores default row height setting.

Declaration
public const string DefaultRowHeightAttribute = "defaultRowHeight"
Field Value
Type Description
System.String

DefaultTagName

Name of the xml tag that stores default type name.

Declaration
public const string DefaultTagName = "Default"
Field Value
Type Description
System.String

DefaultThemeVersion

Default Theme Version

Declaration
public const string DefaultThemeVersion = "defaultThemeVersion"
Field Value
Type Description
System.String

DefaultWorksheetPathFormat

Default worksheet path format

Declaration
public const string DefaultWorksheetPathFormat = "worksheets/sheet{0}.xml"
Field Value
Type Description
System.String

DefinedNamesXmlTagName

Name of the xml tag that contains all defined named ranges.

Declaration
public const string DefinedNamesXmlTagName = "definedNames"
Field Value
Type Description
System.String

DefinedNameXmlTagName

Name of the xml tag that contains single defined named range.

Declaration
public const string DefinedNameXmlTagName = "definedName"
Field Value
Type Description
System.String

Deleted

Deleted

Declaration
public const string Deleted = "deleted"
Field Value
Type Description
System.String

DescriptionTag

Description Tag

Declaration
public const string DescriptionTag = "description"
Field Value
Type Description
System.String

DiagonalDownAttributeName

Name of the xml attribute that indicates whether diagonalDown border is present.

Declaration
public const string DiagonalDownAttributeName = "diagonalDown"
Field Value
Type Description
System.String

DiagonalUpAttributeName

Name of the xml attribute that indicates whether diagonalUp border is present.

Declaration
public const string DiagonalUpAttributeName = "diagonalUp"
Field Value
Type Description
System.String

DialogSheetPartType

Name of the relation type that indicates that part contains dialogsheet data.

Declaration
public const string DialogSheetPartType = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/dialogsheet"
Field Value
Type Description
System.String

DiffXFsTagName

Name of the xml tag that stores extended formats for differential formats.

Declaration
public const string DiffXFsTagName = "dxfs"
Field Value
Type Description
System.String

DimensionTagName

Name of the xml tag that stores worksheet dimension.

Declaration
public const string DimensionTagName = "dimension"
Field Value
Type Description
System.String

DisplayStringAttributeName

Name of the xml attribute that represents display string, if different from string in string table.

Declaration
public const string DisplayStringAttributeName = "display"
Field Value
Type Description
System.String

DocPropsVTypesPartType

Name of the relation type that indicates DocPropsVTypes namespace

Declaration
public const string DocPropsVTypesPartType = "http://schemas.openxmlformats.org/officeDocument/2006/docPropsVTypes"
Field Value
Type Description
System.String

DocPropsVTypesPrefix

Prefix for DocPropsVTypes namespace.

Declaration
public const string DocPropsVTypesPrefix = "vt"
Field Value
Type Description
System.String

DocumentManagement

DocumentManagement Constalt

Declaration
public const string DocumentManagement = "documentManagement"
Field Value
Type Description
System.String

DublinCorePartType

Name of the relation type that indicates dublin core part.

Declaration
public const string DublinCorePartType = "http://purl.org/dc/elements/1.1/"
Field Value
Type Description
System.String

DublinCorePrefix

Prefix for dublin core namespace.

Declaration
public const string DublinCorePrefix = "dc"
Field Value
Type Description
System.String

DublinCoreTermsPartType

Name of the relation type that indicates dublin core terms part.

Declaration
public const string DublinCoreTermsPartType = "http://purl.org/dc/terms/"
Field Value
Type Description
System.String

DublinCoreTermsPrefix

Prefix for dublin core terms namespace.

Declaration
public const string DublinCoreTermsPrefix = "dcterms"
Field Value
Type Description
System.String

DxfFormattingTagName

Name of the xml tag that represents a single dxf record, expressing incremental formatting to be applied.

Declaration
public const string DxfFormattingTagName = "dxf"
Field Value
Type Description
System.String

DyDescent

Name of xml attribute that shows whether value of the descent attribute.

Declaration
public const string DyDescent = "x14ac:dyDescent"
Field Value
Type Description
System.String

EmptyCellsGapValue

String used to serialize Display of Empty Cells as gaps.

Declaration
public const string EmptyCellsGapValue = "gap"
Field Value
Type Description
System.String

EmptyCellsLineValue

String used to serialize Display of Empty Cells as Continued lines.

Declaration
public const string EmptyCellsLineValue = "span"
Field Value
Type Description
System.String

EmptyCellsZeroValue

String used to serialize Display of Empty Cells as zero.

Declaration
public const string EmptyCellsZeroValue = "zero"
Field Value
Type Description
System.String

ErrorsSequence

Sequence of error types (must be in the same order as in ErrorTagsSequence).

Declaration
public static ExcelIgnoreError[] ErrorsSequence
Field Value
Type Description
ExcelIgnoreError[]

ErrorTagsSequence

Sequence of error xml attribute names corresponding to error types defined in ErrorsSequence.

Declaration
public static string[] ErrorTagsSequence
Field Value
Type Description
System.String[]

ExtendedFormatTagName

Name of the xml tag that stores single extended format settings.

Declaration
public const string ExtendedFormatTagName = "xf"
Field Value
Type Description
System.String

ExtendedPropertiesPartType

Name of the relation type that indicates that part contains extended document properties.

Declaration
public const string ExtendedPropertiesPartType = "http://schemas.openxmlformats.org/officeDocument/2006/extended-properties"
Field Value
Type Description
System.String

Extension

Name of the xml tag that represents extension

Declaration
public const string Extension = "ext"
Field Value
Type Description
System.String

ExtensionAttributeName

Name of the xml attribute with part extension.

Declaration
public const string ExtensionAttributeName = "Extension"
Field Value
Type Description
System.String

Extensionlist

Name of the xml tag that represents extension list

Declaration
public const string Extensionlist = "extLst"
Field Value
Type Description
System.String

ExternListUri

Extern List URi

Declaration
public const string ExternListUri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}"
Field Value
Type Description
System.String

FalseValue

String used to serialize boolean False value.

Declaration
public const string FalseValue = "0"
Field Value
Type Description
System.String

FileHyperlinkStartString

Represent file hyperlink string prefix.

Declaration
public const string FileHyperlinkStartString = "file:///"
Field Value
Type Description
System.String

FileVersionTag

This element defines properties that track which version of the application accessed the data and source code contained in the file.

Declaration
public const string FileVersionTag = "fileVersion"
Field Value
Type Description
System.String

FillIdAttributeName

Name of the xml attribute that represents fill id.

Declaration
public const string FillIdAttributeName = "fillId"
Field Value
Type Description
System.String

FillsTagName

Name of the xml tag that represents fills collection.

Declaration
public const string FillsTagName = "fills"
Field Value
Type Description
System.String

FillTagName

Name of the xml tag that represents single fill object.

Declaration
public const string FillTagName = "fill"
Field Value
Type Description
System.String

FirstSheetAttributeName

Name of the xml attribute that specifies the index to the first sheet in this book view.

Declaration
public const string FirstSheetAttributeName = "firstSheet"
Field Value
Type Description
System.String

FitToPageAttribute

Flag indicating whether the Fit to Page print option is enabled.

Declaration
public const string FitToPageAttribute = "fitToPage"
Field Value
Type Description
System.String

FontBoldTagName

Name of the xml tag that indicates that font is bold.

Declaration
public const string FontBoldTagName = "b"
Field Value
Type Description
System.String

FontCharsetTagName

Name of the xml tag that stores font charset settings.

Declaration
public const string FontCharsetTagName = "charset"
Field Value
Type Description
System.String

FontFamilyTagName

Name of the xml tag that stores font family settings.

Declaration
public const string FontFamilyTagName = "family"
Field Value
Type Description
System.String

FontIdAttributeName

Name of the xml attribute that represents font id.

Declaration
public const string FontIdAttributeName = "fontId"
Field Value
Type Description
System.String

FontItalicTagName

Name of the xml tag that indicates that font is italic.

Declaration
public const string FontItalicTagName = "i"
Field Value
Type Description
System.String

FontNameTagName

Name of the xml tag that represents font name.

Declaration
public const string FontNameTagName = "name"
Field Value
Type Description
System.String

FontSizeTagName

Name of the xml tag that stores font underline settings.

Declaration
public const string FontSizeTagName = "sz"
Field Value
Type Description
System.String

FontsTagName

Name of the xml tag that contains all fonts settings inside.

Declaration
public const string FontsTagName = "fonts"
Field Value
Type Description
System.String

FontStrikeTagName

Name of the xml tag that indicates that font has strike settings.

Declaration
public const string FontStrikeTagName = "strike"
Field Value
Type Description
System.String

FontTagName

Name of the xml tag that contains all font settings inside.

Declaration
public const string FontTagName = "font"
Field Value
Type Description
System.String

FontUnderlineTagName

Name of the xml tag that stores font underline settings.

Declaration
public const string FontUnderlineTagName = "u"
Field Value
Type Description
System.String

FontVerticalAlignmentTagName

Name of the xml tag that stores font vertical alignment settings.

Declaration
public const string FontVerticalAlignmentTagName = "vertAlign"
Field Value
Type Description
System.String

ForegroundColorTagName

Name of the xml tag that represents foreground color.

Declaration
public const string ForegroundColorTagName = "fgColor"
Field Value
Type Description
System.String

FormulaTagName

Name of xml tag that represents formula.

Declaration
public const string FormulaTagName = "f"
Field Value
Type Description
System.String

FormulaTypeAttributeName

Name of xml attribute that represents formula type.

Declaration
public const string FormulaTypeAttributeName = "t"
Field Value
Type Description
System.String

FunctionGroups

Name of the xml tag that represents funtion groups

Declaration
public const string FunctionGroups = "functionGroups"
Field Value
Type Description
System.String

GradientFillTagName

Name of the xml tag that represents gradient-style cell fill.

Declaration
public const string GradientFillTagName = "gradientFill"
Field Value
Type Description
System.String

GradientFillTypeAttributeName

Name of the xml attribute that represents type of gradient fill.

Declaration
public const string GradientFillTypeAttributeName = "type"
Field Value
Type Description
System.String

GradientFillTypeLinear

This gradient fill is of linear gradient type.

Declaration
public const string GradientFillTypeLinear = "linear"
Field Value
Type Description
System.String

GradientFillTypePath

This gradient fill is of path gradient type.

Declaration
public const string GradientFillTypePath = "path"
Field Value
Type Description
System.String

GradientStopPositionAttributeName

Name of the xml attribute that represents position information for this gradient stop.

Declaration
public const string GradientStopPositionAttributeName = "position"
Field Value
Type Description
System.String

GradientStopTagName

Name of the xml tag name that represents one of a sequence of two or more gradient stops, constituting this gradient fill.

Declaration
public const string GradientStopTagName = "stop"
Field Value
Type Description
System.String

HAlignAttributeName

Name of the xml attribute that specifies the type of horizontal alignment in cells.

Declaration
public const string HAlignAttributeName = "horizontal"
Field Value
Type Description
System.String

HiddenAttributeName

Name of the xml attribute that indicates whether cell is hidden.

Declaration
public const string HiddenAttributeName = "hidden"
Field Value
Type Description
System.String

HiddenDefaultValue

Default value for FormulaHidden value.

Declaration
public const bool HiddenDefaultValue = false
Field Value
Type Description
System.Boolean

HidePivotFieldList

Attribute for showing or hiding the fields list of pivot table in workbook

Declaration
public const string HidePivotFieldList = "hidePivotFieldList"
Field Value
Type Description
System.String

HideValuesRowAttribute

Hide values row attribute

Declaration
public const string HideValuesRowAttribute = "hideValuesRow"
Field Value
Type Description
System.String

HorizontalPageBreaksTagName

Name of the xml tag that represents horizontal page break information.

Declaration
public const string HorizontalPageBreaksTagName = "rowBreaks"
Field Value
Type Description
System.String

HttpStartString

Represent http hyperlink string prefix.

Declaration
public const string HttpStartString = "http://"
Field Value
Type Description
System.String

HyperlinkNamespace

Namespace for hyperlink.

Declaration
public const string HyperlinkNamespace = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/hyperlink"
Field Value
Type Description
System.String

HyperlinkReferenceAttributeName

Name of the xml attribute that represents cell location of hyperlink on worksheet.

Declaration
public const string HyperlinkReferenceAttributeName = "ref"
Field Value
Type Description
System.String

HyperlinksTagName

Name of the xml tag that represents a collection of hyperlinks.

Declaration
public const string HyperlinksTagName = "hyperlinks"
Field Value
Type Description
System.String

HyperlinkTagName

Name of the xml tag that represents a single hyperlink.

Declaration
public const string HyperlinkTagName = "hyperlink"
Field Value
Type Description
System.String

IdAttributeName

Name of the xml attribute that represents zero-based row or column Id of the page break. Breaks occur above the specified row and left of the specified column.

Declaration
public const string IdAttributeName = "id"
Field Value
Type Description
System.String

IgnoredErrorsTag

A collection of ignored errors, by cell range.

Declaration
public const string IgnoredErrorsTag = "ignoredErrors"
Field Value
Type Description
System.String

IgnoredErrorTag

A single ignored error type for a range of cells.

Declaration
public const string IgnoredErrorTag = "ignoredError"
Field Value
Type Description
System.String

IncludeAlignmentAttributeName

Name of the xml attribute indicating whether the alignment formatting specified for this xf should be applied.

Declaration
public const string IncludeAlignmentAttributeName = "applyAlignment"
Field Value
Type Description
System.String

IncludeBorderAttributeName

Name of the xml attribute indicating whether the border formatting specified for this xf should be applied.

Declaration
public const string IncludeBorderAttributeName = "applyBorder"
Field Value
Type Description
System.String

IncludeFontAttributeName

Name of the xml attribute indicating whether the font formatting specified for this xf should be applied.

Declaration
public const string IncludeFontAttributeName = "applyFont"
Field Value
Type Description
System.String

IncludeNumberFormatAttributeName

Name of the xml attribute indicating whether the number formatting specified for this xf should be applied.

Declaration
public const string IncludeNumberFormatAttributeName = "applyNumberFormat"
Field Value
Type Description
System.String

IncludePatternsAttributeName

Name of the xml attribute indicating whether the fill formatting specified for this xf should be applied.

Declaration
public const string IncludePatternsAttributeName = "applyFill"
Field Value
Type Description
System.String

IncludeProtectionAttributeName

Name of the xml attribute indicating whether the protection formatting specified for this xf should be applied.

Declaration
public const string IncludeProtectionAttributeName = "applyProtection"
Field Value
Type Description
System.String

IndentAttributeName

Name of the xml attribute that stores style indent level settings.

Declaration
public const string IndentAttributeName = "indent"
Field Value
Type Description
System.String

IndexedColorsTagName

Name of the xml tag that stores indexed color values.

Declaration
public const string IndexedColorsTagName = "indexedColors"
Field Value
Type Description
System.String

Interval

Interval

Declaration
public const string Interval = "interval"
Field Value
Type Description
System.String

ItemIdAttribute

Item Id Attribute

Declaration
public const string ItemIdAttribute = "ds:itemID"
Field Value
Type Description
System.String

ItemPropertiesPrefix

Item properties prefix

Declaration
public const string ItemPropertiesPrefix = "ds"
Field Value
Type Description
System.String

ItemPrpertiesUri

Item Properties Uri

Declaration
public const string ItemPrpertiesUri = "uri"
Field Value
Type Description
System.String

JustifyLastLineAttributeName

Name of the xml attribute indicating if the cells justified or distributed alignment should be used on the last line of text.

Declaration
public const string JustifyLastLineAttributeName = "justifyLastLine"
Field Value
Type Description
System.String

LastEdited

Name of the xml tag that represents last edited

Declaration
public const string LastEdited = "lastEdited"
Field Value
Type Description
System.String

Layout

String used to serialize sheet zooming

Declaration
public const string Layout = "pageLayout"
Field Value
Type Description
System.String

LeftConvergenceAttributeName

Name of the xml attribute that specifies in percentage format (from the left to the right) the position of the left edge of the inner rectangle (color 1).

Declaration
public const string LeftConvergenceAttributeName = "left"
Field Value
Type Description
System.String

LinearGradientDegreeAttributeName

Name of the xml attribute that represents angle of the linear gradient - vertical, horizontal, diagonal.

Declaration
public const string LinearGradientDegreeAttributeName = "degree"
Field Value
Type Description
System.String

LocationAttributeName

Name of the xml attribute that represents location within target.

Declaration
public const string LocationAttributeName = "location"
Field Value
Type Description
System.String

LockedAttributeName

Name of the xml attribute that indicates whether cell is locked.

Declaration
public const string LockedAttributeName = "locked"
Field Value
Type Description
System.String

LockedDefaultValue

Default value for Locked value.

Declaration
public const bool LockedDefaultValue = true
Field Value
Type Description
System.Boolean

LowestEdited

Name of the xml tag that represents lowest edited

Declaration
public const string LowestEdited = "lowestEdited"
Field Value
Type Description
System.String

MacOSShadowTagName

Name of the xml tag that stores MacOSShadow settings.

Declaration
public const string MacOSShadowTagName = "shadow"
Field Value
Type Description
System.String

ManualBreakCountAttributeName

Name of the xml attribute that represents number of manual breaks in the collection.

Declaration
public const string ManualBreakCountAttributeName = "manualBreakCount"
Field Value
Type Description
System.String

ManualCalcModeValue

Manual Calc Mode Value

Declaration
public const string ManualCalcModeValue = "manual"
Field Value
Type Description
System.String

ManualPageBreakAttributeName

Name of the xml attribute that represents manual Break flag. '1' means the break is a manually inserted break.

Declaration
public const string ManualPageBreakAttributeName = "man"
Field Value
Type Description
System.String

MaximumAttributeName

Name of the xml attribute that represents zero-based index of end row or column of the break. For row breaks, specifies column index; for column breaks, specifies row index.

Declaration
public const string MaximumAttributeName = "max"
Field Value
Type Description
System.String

MCNamespace

MC Namespace

Declaration
public const string MCNamespace = "http://schemas.openxmlformats.org/markup-compatibility/2006"
Field Value
Type Description
System.String

MCPrefix

MC prefix

Declaration
public const string MCPrefix = "mc"
Field Value
Type Description
System.String

MergeCellsXmlTagName

Name of the xml tag that contains merged cells data.

Declaration
public const string MergeCellsXmlTagName = "mergeCells"
Field Value
Type Description
System.String

MergeCellXmlTagName

Name of the xml tag that contains single merge region's data.

Declaration
public const string MergeCellXmlTagName = "mergeCell"
Field Value
Type Description
System.String

MinimizedAttributeName

Name of the xml attribute that specifies a boolean value that indicates whether the book window is minimized.

Declaration
public const string MinimizedAttributeName = "minimized"
Field Value
Type Description
System.String

MinimumAttributeName

Name of the xml attribute that represents zero-based index of start row or column of the break. For row breaks, specifies column index; for column breaks, specifies row index.

Declaration
public const string MinimumAttributeName = "min"
Field Value
Type Description
System.String

MSNamespaceMain

Main Microsoft Namespace

Declaration
public const string MSNamespaceMain = "http://schemas.microsoft.com/office/excel/2006/main"
Field Value
Type Description
System.String

MSNamespaceMainAttribute

Main Microsoft Namespace Attribute

Declaration
public const string MSNamespaceMainAttribute = "xmlns"
Field Value
Type Description
System.String

MSPrefix

Prefix for Microsoft Main Namespace.

Declaration
public const string MSPrefix = "xm"
Field Value
Type Description
System.String

NameAttributeName

Name of the name attribute.

Declaration
public const string NameAttributeName = "name"
Field Value
Type Description
System.String

NamedStyleXFsTagName

Name of the xml tag that stores extended formats for named styles.

Declaration
public const string NamedStyleXFsTagName = "cellStyleXfs"
Field Value
Type Description
System.String

NameSheetIdAttribute

Name of the attribute that stores sheet id for named range.

Declaration
public const string NameSheetIdAttribute = "localSheetId"
Field Value
Type Description
System.String

Normal

String used to serialize Normal layout.

Declaration
public const string Normal = "normal"
Field Value
Type Description
System.String

NumberFormatIdAttributeName

Name of the xml attribute that defines number format id.

Declaration
public const string NumberFormatIdAttributeName = "numFmtId"
Field Value
Type Description
System.String

NumberFormatsTagName

Name of the xml tag that represents number formats.

Declaration
public const string NumberFormatsTagName = "numFmts"
Field Value
Type Description
System.String

NumberFormatStringAttributeName

Name of the xml attribute that defines number format string.

Declaration
public const string NumberFormatStringAttributeName = "formatCode"
Field Value
Type Description
System.String

NumberFormatTagName

Name of the xml tag that represents single number format.

Declaration
public const string NumberFormatTagName = "numFmt"
Field Value
Type Description
System.String

OdbcFileAttribute

Represents ODBC File

Declaration
public const string OdbcFileAttribute = "odcFile"
Field Value
Type Description
System.String

OlapPrTag

Represent the Olap Property

Declaration
public const string OlapPrTag = "olapPr"
Field Value
Type Description
System.String

OleObjectContentType

OleObject Content Type

Declaration
public const string OleObjectContentType = "application/vnd.openxmlformats-officedocument.oleObject"
Field Value
Type Description
System.String

OleObjectFileExtension

OleObject File Extension

Declaration
public const string OleObjectFileExtension = "bin"
Field Value
Type Description
System.String

OnCall

Declaration
public const string OnCall = "OLEUPDATE_ONCALL"
Field Value
Type Description
System.String

OnlyUseConnectionFile

Only use connection file

Declaration
public const string OnlyUseConnectionFile = "onlyUseConnectionFile"
Field Value
Type Description
System.String

OutlineLevelAttribute

Indicates that this formatting is for an outline style.

Declaration
public const string OutlineLevelAttribute = "iLevel"
Field Value
Type Description
System.String

OutlineLevelColAttribute

Name of the xml attribute that stores outlineLevelCol setting

Declaration
public const string OutlineLevelColAttribute = "outlineLevelCol"
Field Value
Type Description
System.String

OutlineLevelRowAttribute

Name of the xml attribute that stores outlineLevelRow setting

Declaration
public const string OutlineLevelRowAttribute = "outlineLevelRow"
Field Value
Type Description
System.String

OverrideTagName

Name of the xml tag that stores type override.

Declaration
public const string OverrideTagName = "Override"
Field Value
Type Description
System.String

PageBreakCountAttributeName

Name of the xml attribute that represents number of breaks in the collection.

Declaration
public const string PageBreakCountAttributeName = "count"
Field Value
Type Description
System.String

PageBreakPreview

String used to serialize Page break preview layout.

Declaration
public const string PageBreakPreview = "pageBreakPreview"
Field Value
Type Description
System.String

PageSetupPropertiesTag

Page setup properties of the worksheet.

Declaration
public const string PageSetupPropertiesTag = "pageSetUpPr"
Field Value
Type Description
System.String

PartNameAttributeName

Name of the xml attribute that stores part name.

Declaration
public const string PartNameAttributeName = "PartName"
Field Value
Type Description
System.String

PartnerControlsNameSpace

PartnerControls NameSpace

Declaration
public const string PartnerControlsNameSpace = "http://schemas.microsoft.com/office/infopath/2007/PartnerControls"
Field Value
Type Description
System.String

PatternAttributeName

Name of the xml attribute that defines pattern.

Declaration
public const string PatternAttributeName = "patternType"
Field Value
Type Description
System.String

PatternFillTagName

Name of the xml tag that represents pattern fill object.

Declaration
public const string PatternFillTagName = "patternFill"
Field Value
Type Description
System.String

PCPrefix

PC prefix

Declaration
public const string PCPrefix = "pc"
Field Value
Type Description
System.String

Phonetic

Name of the xml tag that represents phonetic text

Declaration
public const string Phonetic = "phonetic"
Field Value
Type Description
System.String

PhoneticPr

Name of the xml tag that represents a collection of phonetic properties that affect the display of phonetic text.

Declaration
public const string PhoneticPr = "phoneticPr"
Field Value
Type Description
System.String

PivotButton

Indicating whether cell has pivot button

Declaration
public const string PivotButton = "pivotButton"
Field Value
Type Description
System.String

PivotFieldUri

Pivot Field URi

Declaration
public const string PivotFieldUri = "{E15A36E0-9728-4e99-A89B-3F7291B0FE68}"
Field Value
Type Description
System.String

PPrefix

P prefix

Declaration
public const string PPrefix = "p"
Field Value
Type Description
System.String

PreserveValue

Value specifying white space preservation in a string.

Declaration
public const string PreserveValue = "preserve"
Field Value
Type Description
System.String

Properties

Properties Constant

Declaration
public const string Properties = "properties"
Field Value
Type Description
System.String

PropertiesNameSpace

Properties NameSpace

Declaration
public const string PropertiesNameSpace = "http://schemas.microsoft.com/office/2006/metadata/properties"
Field Value
Type Description
System.String

ProtectionTagName

Name of the xml tag that hold all style's protection information.

Declaration
public const string ProtectionTagName = "protection"
Field Value
Type Description
System.String

QuotePreffixAttributeName

Name of the xml attribute that stores value indicating whether the text string in a cell should be prefixed by a single quote mark.

Declaration
public const string QuotePreffixAttributeName = "quotePrefix"
Field Value
Type Description
System.String

RangeOfCellsAttributeName

Name of xml attribute that represents range of cells which the formula applies to.

Declaration
public const string RangeOfCellsAttributeName = "ref"
Field Value
Type Description
System.String

RangeReferenceAttribute

Attribute used to store range reference.

Declaration
public const string RangeReferenceAttribute = "sqref"
Field Value
Type Description
System.String

ReadingOrderAttributeName

Name of the xml attribute that holds reading order settings.

Declaration
public const string ReadingOrderAttributeName = "readingOrder"
Field Value
Type Description
System.String

RefAttributeName

Name of the ref attribute.

Declaration
public const string RefAttributeName = "ref"
Field Value
Type Description
System.String

ReferenceAttributeName

Name of the xml attribute that represents an A1 style reference to the location of this cell.

Declaration
public const string ReferenceAttributeName = "r"
Field Value
Type Description
System.String

RefreshedVersionAttribute

Refreshed Version Attribute

Declaration
public const string RefreshedVersionAttribute = "refreshedVersion"
Field Value
Type Description
System.String

RelationAttribute

Name of the xml attribute that stores relation id.

Declaration
public const string RelationAttribute = "id"
Field Value
Type Description
System.String

RelationExternalTargetMode

Name of relationship external target mode.

Declaration
public const string RelationExternalTargetMode = "External"
Field Value
Type Description
System.String

RelationIdAttribute

Name of the xml attribute that stores relation id, it is used in .rels file (starts with capital letter).

Declaration
public const string RelationIdAttribute = "Id"
Field Value
Type Description
System.String

RelationIdFormat

Relation id format

Declaration
public const string RelationIdFormat = "rId{0}"
Field Value
Type Description
System.String

RelationNamespace

Namespace for relation tags/attributes.

Declaration
public const string RelationNamespace = "http://schemas.openxmlformats.org/officeDocument/2006/relationships"
Field Value
Type Description
System.String

RelationPrefix

Prefix for relation namespace.

Declaration
public const string RelationPrefix = "r"
Field Value
Type Description
System.String

RelationshipIdAttributeName

Name of the xml attribute that represents relationship Id in this sheet's relationships part, expressing the target location of the resource.

Declaration
public const string RelationshipIdAttributeName = "id"
Field Value
Type Description
System.String

RelationsTagName

Name of the xml tag that holds relationships data.

Declaration
public const string RelationsTagName = "Relationships"
Field Value
Type Description
System.String

RelationTagName

Name of the xml tag that holds relationship data.

Declaration
public const string RelationTagName = "Relationship"
Field Value
Type Description
System.String

RelationTargetAttribute

Name of the xml attribute that holds relationship target.

Declaration
public const string RelationTargetAttribute = "Target"
Field Value
Type Description
System.String

RelationTargetModeAttribute

Name of the xml attribute that holds relationship target mode.

Declaration
public const string RelationTargetModeAttribute = "TargetMode"
Field Value
Type Description
System.String

RelationTypeAttribute

Name of the xml attribute that holds relationship type.

Declaration
public const string RelationTypeAttribute = "Type"
Field Value
Type Description
System.String

RgbColorTagName

Name of the xml tag that stores rgb color.

Declaration
public const string RgbColorTagName = "rgbColor"
Field Value
Type Description
System.String

RGBHexColorValueAttributeName

Name of the xml attribute name that the actual color value, expressed as a sequence of hex digits RRGGBB.

Declaration
public const string RGBHexColorValueAttributeName = "val"
Field Value
Type Description
System.String

RichTextInlineTagName

Name of xml tag that represents rich text.

Declaration
public const string RichTextInlineTagName = "is"
Field Value
Type Description
System.String

RichTextRunFontTagName

Name of xml tag that represents rich text run font name.

Declaration
public const string RichTextRunFontTagName = "rFont"
Field Value
Type Description
System.String

RichTextRunPropertiesTagName

Name of xml tag that represents rich text run properties.

Declaration
public const string RichTextRunPropertiesTagName = "rPr"
Field Value
Type Description
System.String

RichTextRunTagName

Name of the xml tag that represents rich text run.

Declaration
public const string RichTextRunTagName = "r"
Field Value
Type Description
System.String

RightConvergenceAttributeName

Name of the xml attribute that specifies in percentage format (from the left to the right) the position of the right edge of the inner rectangle (color 1).

Declaration
public const string RightConvergenceAttributeName = "right"
Field Value
Type Description
System.String

RightToLeft

Flag indicating whether the sheet is in 'right to left' display mode. When in this mode, Column A is on the far right, Column B ;is one column left of Column A, and so on. Also, information in cells is displayed in the Right to Left format.

Declaration
public const string RightToLeft = "rightToLeft"
Field Value
Type Description
System.String

RowColumnCollapsedAttribute

Name of xml attribute that shows whether row has been collapsed or not.

Declaration
public const string RowColumnCollapsedAttribute = "collapsed"
Field Value
Type Description
System.String

RowColumnOutlineLevelAttribute

Name of xml attribute that represents outlining level of the row.

Declaration
public const string RowColumnOutlineLevelAttribute = "outlineLevel"
Field Value
Type Description
System.String

RowCustomFormatAttributeName

Name of xml attribute that shows whether row style should be applied or not.

Declaration
public const string RowCustomFormatAttributeName = "customFormat"
Field Value
Type Description
System.String

RowCustomHeightAttributeName

Name of xml attribute that shows whether row height has been manually set or not.

Declaration
public const string RowCustomHeightAttributeName = "customHeight"
Field Value
Type Description
System.String

RowHeightAttributeName

Name of xml attribute that represents row height in point size.

Declaration
public const string RowHeightAttributeName = "ht"
Field Value
Type Description
System.String

RowHiddenAttributeName

Name of xml attribute that shows whether row is visible or not.

Declaration
public const string RowHiddenAttributeName = "hidden"
Field Value
Type Description
System.String

RowIndexAttributeName

Name of xml attribute that represents row index.

Declaration
public const string RowIndexAttributeName = "r"
Field Value
Type Description
System.String

RowTagName

Name of xml tag that represents row.

Declaration
public const string RowTagName = "row"
Field Value
Type Description
System.String

RowThickBottomAttributeName

Name of xml attribute that represents thick bottom flag.

Declaration
public const string RowThickBottomAttributeName = "thickBot"
Field Value
Type Description
System.String

RowThickTopAttributeName

Name of xml attribute that represents thick top flag.

Declaration
public const string RowThickTopAttributeName = "thickTop"
Field Value
Type Description
System.String

RupBuild

Specifies the incremental public release of the application. For example, betas, service packs, and versions.

Declaration
public const string RupBuild = "rupBuild"
Field Value
Type Description
System.String

SaveData

Save Data

Declaration
public const string SaveData = "saveData"
Field Value
Type Description
System.String

SavePassword

Save password

Declaration
public const string SavePassword = "savePassword"
Field Value
Type Description
System.String

SharedGroupIndexAttributeName

Name of xml attribute that represents shared formula group index.

Declaration
public const string SharedGroupIndexAttributeName = "si"
Field Value
Type Description
System.String

SharedStringTableTagName

Name of the xml tag that represents shared string table.

Declaration
public const string SharedStringTableTagName = "sst"
Field Value
Type Description
System.String

SheetDataTagName

Name of the xml tag that stores sheet data.

Declaration
public const string SheetDataTagName = "sheetData"
Field Value
Type Description
System.String

SheetFormatPropertiesTag

Name of the xml tag that stores sheet format properties.

Declaration
public const string SheetFormatPropertiesTag = "sheetFormatPr"
Field Value
Type Description
System.String

SheetGridColor

Flag indicating whether this sheet gridline is modified by user

Declaration
public const string SheetGridColor = "defaultGridColor"
Field Value
Type Description
System.String

SheetIdAttribute

Name of the xml attribute that stores unique sheet id.

Declaration
public const string SheetIdAttribute = "sheetId"
Field Value
Type Description
System.String

SheetLevelPropertiesTagName

Name of the xml tag that represents sheet level properties.

Declaration
public const string SheetLevelPropertiesTagName = "sheetPr"
Field Value
Type Description
System.String

SheetNameAttribute

Name of the xml attribute that stores sheet name.

Declaration
public const string SheetNameAttribute = "name"
Field Value
Type Description
System.String

SheetOutlinePropertiesTagName

Name of the xml tag that represents sheet outline properties.

Declaration
public const string SheetOutlinePropertiesTagName = "outlinePr"
Field Value
Type Description
System.String

SheetsTagName

Name of the xml tag that represents the collection of sheets in the workbook.

Declaration
public const string SheetsTagName = "sheets"
Field Value
Type Description
System.String

SheetStateAttributeName

Name of the xml attribute that specifies the visible state of this sheet.

Declaration
public const string SheetStateAttributeName = "state"
Field Value
Type Description
System.String

SheetTabColorTagName

Name of the xml tag that represents background color of the sheet tab.

Declaration
public const string SheetTabColorTagName = "tabColor"
Field Value
Type Description
System.String

SheetTabRatioAttributeName

Name of the xml attribute that specifies ratio between the workbook tabs bar and the horizontal scroll bar.

Declaration
public const string SheetTabRatioAttributeName = "tabRatio"
Field Value
Type Description
System.String

SheetTagName

Name of the xml tag that defines a sheet in this workbook.

Declaration
public const string SheetTagName = "sheet"
Field Value
Type Description
System.String

SheetViewsTag

Worksheet/chartsheet views collection.

Declaration
public const string SheetViewsTag = "sheetViews"
Field Value
Type Description
System.String

SheetViewTag

This element specifies a chart sheet view.

Declaration
public const string SheetViewTag = "sheetView"
Field Value
Type Description
System.String

SheetZoomScale

String used to serialize sheet zooming

Declaration
public const string SheetZoomScale = "zoomScale"
Field Value
Type Description
System.String

ShowGridLines

Flag indicating whether this sheet should display gridlines.

Declaration
public const string ShowGridLines = "showGridLines"
Field Value
Type Description
System.String

ShowHorizontalScrollAttributeName

Name of the xml attribute that specifies a boolean value that indicates whether to display the horizontal scroll bar in the user interface.

Declaration
public const string ShowHorizontalScrollAttributeName = "showHorizontalScroll"
Field Value
Type Description
System.String

ShowPhoneticAttributeName

Name of the xml attribute that represents boolean value to show phonetic information.

Declaration
public const string ShowPhoneticAttributeName = "ph"
Field Value
Type Description
System.String

ShowRowColHeaders

Flag indicating whether this sheet should display row and column headers.

Declaration
public const string ShowRowColHeaders = "showRowColHeaders"
Field Value
Type Description
System.String

ShowSheetTabsAttributeName

Name of the xml attribute that specifies a boolean value that indicates whether to display the sheet tabs in the user interface.

Declaration
public const string ShowSheetTabsAttributeName = "showSheetTabs"
Field Value
Type Description
System.String

ShowVerticalScrollAttributeName

Name of the xml attribute that specifies a boolean value that indicates whether to display the vertical scroll bar.

Declaration
public const string ShowVerticalScrollAttributeName = "showVerticalScroll"
Field Value
Type Description
System.String

ShowZeros

Flag indicating whether this sheet should display zero values.

Declaration
public const string ShowZeros = "showZeros"
Field Value
Type Description
System.String

ShrinkToFitAttributeName

Name of the xml attribute that holds shrink to fit option.

Declaration
public const string ShrinkToFitAttributeName = "shrinkToFit"
Field Value
Type Description
System.String

SlicerExtensionUri

Slicer Extersion URi

Declaration
public const string SlicerExtensionUri = "{A8765BA9-456A-4dab-B4F3-ACF838C121DE}"
Field Value
Type Description
System.String

SlicerList

Name of the xml tag that contains slicer list

Declaration
public const string SlicerList = "slicerList"
Field Value
Type Description
System.String

SourceFile

Source File

Declaration
public const string SourceFile = "sourceFile"
Field Value
Type Description
System.String

SpaceAttributeName

Attribute to specify string spacing.

Declaration
public const string SpaceAttributeName = "space"
Field Value
Type Description
System.String

SparklineColumnValue

String used to serialize Sparkline Column type.

Declaration
public const string SparklineColumnValue = "column"
Field Value
Type Description
System.String

SparklineUri

Uri for the Sparkline properties.

Declaration
public const string SparklineUri = "{05C60535-1F16-4fd2-B633-F4F36F0B64E0}"
Field Value
Type Description
System.String

SparklineWinLossValue

String used to serialize Sparkline WinLoss type.

Declaration
public const string SparklineWinLossValue = "stacked"
Field Value
Type Description
System.String

StateHidden

Indicates the book window is hidden, but can be shown by the user via the user interface.

Declaration
public const string StateHidden = "hidden"
Field Value
Type Description
System.String

StateVeryHidden

Indicates the sheet is hidden and cannot be shown in the user interface (UI). This state is only available programmatically.

Declaration
public const string StateVeryHidden = "veryHidden"
Field Value
Type Description
System.String

StateVisible

Indicates the sheet is visible.

Declaration
public const string StateVisible = "visible"
Field Value
Type Description
System.String

StringItemTagName

Name of the xml tag that represents individual string in SST.

Declaration
public const string StringItemTagName = "si"
Field Value
Type Description
System.String

StyleBuiltinIdAttributeName

Name of the xml attribute that stores built in style id.

Declaration
public const string StyleBuiltinIdAttributeName = "builtinId"
Field Value
Type Description
System.String

StyleCustomizedAttributeName

Name of the xml attribute that define the customized buildinstyles.

Declaration
public const string StyleCustomizedAttributeName = "customBuiltin"
Field Value
Type Description
System.String

StyleIndexAttributeName

Name of the xml attribute that represents the index of this cell's style.

Declaration
public const string StyleIndexAttributeName = "s"
Field Value
Type Description
System.String

StyleSheetTagName

Name of the xml tag that contains all styles settings (fonts, number formats, fills, etc.) inside.

Declaration
public const string StyleSheetTagName = "styleSheet"
Field Value
Type Description
System.String

SummaryColumnRight

Name of the xml tag that represents Summary column right property of sheet outline

Declaration
public const string SummaryColumnRight = "summaryRight"
Field Value
Type Description
System.String

SummaryRowBelow

Name of the xml tag that represents Summary Row below property of sheet outline

Declaration
public const string SummaryRowBelow = "summaryBelow"
Field Value
Type Description
System.String

SystemColorLastColorAttributeName

Name of the xml attribute that represents the color value that was last computed by the generating application.

Declaration
public const string SystemColorLastColorAttributeName = "lastClr"
Field Value
Type Description
System.String

SystemColorTagName

Name of the xml tag that represents a color bound to predefined operating system elements.

Declaration
public const string SystemColorTagName = "sysClr"
Field Value
Type Description
System.String

SystemColorValueAttributeName

Name of the xml attribute that represents the system color value.

Declaration
public const string SystemColorValueAttributeName = "val"
Field Value
Type Description
System.String

TableStylesTagName

Name of the xml tag that stores table styles.

Declaration
public const string TableStylesTagName = "tableStyles"
Field Value
Type Description
System.String

TabSelected

Tab Selected

Declaration
public const string TabSelected = "tabSelected"
Field Value
Type Description
System.String

TemporaryRoot

Root items for data preserving.

Declaration
public const string TemporaryRoot = "root"
Field Value
Type Description
System.String

TextPr

Text Properties

Declaration
public const string TextPr = "textPr"
Field Value
Type Description
System.String

TextRotationAttributeName

Name of the xml attribute that holds text rotation value.

Declaration
public const string TextRotationAttributeName = "textRotation"
Field Value
Type Description
System.String

TextTagName

Name of the xml tag that represents the text content shown as part of a string.

Declaration
public const string TextTagName = "t"
Field Value
Type Description
System.String

ThemeElementsTagName

Name of the xml tag that represents the theme formatting options for the theme and is the workhorse of the theme.

Declaration
public const string ThemeElementsTagName = "themeElements"
Field Value
Type Description
System.String

ThemeTagName

Name of the xml tag that represents the root level complex type associated with a shared style sheet (or theme).

Declaration
public const string ThemeTagName = "theme"
Field Value
Type Description
System.String

ThickBottomAttribute

Name of the xml attribute that stores thickBottom setting

Declaration
public const string ThickBottomAttribute = "thickBottom"
Field Value
Type Description
System.String

ThickTopAttribute

Name of the xml attribute that stores thickTop setting

Declaration
public const string ThickTopAttribute = "thickTop"
Field Value
Type Description
System.String

ToolTipAttributeName

Name of the xml attribute that represents additional text to help the user understand more about the hyperlink.

Declaration
public const string ToolTipAttributeName = "tooltip"
Field Value
Type Description
System.String

TopConvergenceAttributeName

Name of the xml attribute that specifies in percentage format (from the top to the bottom) the position of the top edge of the inner rectangle (color 1).

Declaration
public const string TopConvergenceAttributeName = "top"
Field Value
Type Description
System.String

TransitionEvaluation

Name of the xml tag that represents transition evaluation

Declaration
public const string TransitionEvaluation = "transitionEvaluation"
Field Value
Type Description
System.String

TrueValue

String used to serialize boolean True value.

Declaration
public const string TrueValue = "1"
Field Value
Type Description
System.String

TypesTagName

Name of the xml tag that stores content types definitions.

Declaration
public const string TypesTagName = "Types"
Field Value
Type Description
System.String

UniqueStringCountAttributeName

Name of the xml attribute that represents the total count of unique strings in the SST.

Declaration
public const string UniqueStringCountAttributeName = "uniqueCount"
Field Value
Type Description
System.String

UpperLeftCornerXAttributeName

Name of the xml attribute that specifies the X coordinate for the upper left corner of the book window.

Declaration
public const string UpperLeftCornerXAttributeName = "xWindow"
Field Value
Type Description
System.String

UpperLeftCornerYAttributeName

Name of the xml attribute that specifies the Y coordinate for the upper left corner of the book window.

Declaration
public const string UpperLeftCornerYAttributeName = "yWindow"
Field Value
Type Description
System.String

URL

url

Declaration
public const string URL = "url"
Field Value
Type Description
System.String

ValueAttributeName

Name of the value attribute.

Declaration
public const string ValueAttributeName = "val"
Field Value
Type Description
System.String

ValueMetadataIndexAttributeName

Name of the xml attribute that represents index of the value metadata record associated with this cell's value.

Declaration
public const string ValueMetadataIndexAttributeName = "vm"
Field Value
Type Description
System.String

VerticalAttributeName

Name of the xml attribute that specifies the type of vertical alignment in cells.

Declaration
public const string VerticalAttributeName = "vertical"
Field Value
Type Description
System.String

VerticalCustomTypeValue

String used to serialize Vertical Axis type as custom.

Declaration
public const string VerticalCustomTypeValue = "custom"
Field Value
Type Description
System.String

VerticalPageBreaksTagName

Name of the xml tag that represents vertical page break information

Declaration
public const string VerticalPageBreaksTagName = "colBreaks"
Field Value
Type Description
System.String

VerticalSameTypeValue

String used to serialize Vertical Axis type as same.

Declaration
public const string VerticalSameTypeValue = "group"
Field Value
Type Description
System.String

ViewTag

String used to serialize sheet view

Declaration
public const string ViewTag = "view"
Field Value
Type Description
System.String

VisibilityAttributeName

Name of the xml attribute that specifies visible state of the book window.

Declaration
public const string VisibilityAttributeName = "visibility"
Field Value
Type Description
System.String

WebPrTag

Represent the WebProperties

Declaration
public const string WebPrTag = "webPr"
Field Value
Type Description
System.String

WindowHeightAttributeName

Name of the xml attribute that specifies the height of the workbook window.

Declaration
public const string WindowHeightAttributeName = "windowHeight"
Field Value
Type Description
System.String

WindowWidthAttributeName

Name of the xml attribute that specifies the width of the workbook window.

Declaration
public const string WindowWidthAttributeName = "windowWidth"
Field Value
Type Description
System.String

WorkbookDate1904

This element stores information about the Date format to be used.

Declaration
public const string WorkbookDate1904 = "date1904"
Field Value
Type Description
System.String

WorkbookPr

This xml element stores the details of WorkbookPr.

Declaration
public const string WorkbookPr = "workbookPr"
Field Value
Type Description
System.String

WorkbookPrecision

This element stores information about the Precision to be followed.

Declaration
public const string WorkbookPrecision = "fullPrecision"
Field Value
Type Description
System.String

WorkbookTagName

Name of the xml tag that defines the structure of the workbook.

Declaration
public const string WorkbookTagName = "workbook"
Field Value
Type Description
System.String

WorkbookViewIdAttribute

Zero-based index of this workbook view, pointing to a workbookView element in the bookViews collection.

Declaration
public const string WorkbookViewIdAttribute = "workbookViewId"
Field Value
Type Description
System.String

WorkbookViewsTagName

Name of the xml tag that specifies the collection of workbook views.

Declaration
public const string WorkbookViewsTagName = "bookViews"
Field Value
Type Description
System.String

WorkbookViewTagName

Name of the xml tag that specifies a single Workbook view.

Declaration
public const string WorkbookViewTagName = "workbookView"
Field Value
Type Description
System.String

WorksheetPartType

Name of the relation type that indicates that part contains worksheet data.

Declaration
public const string WorksheetPartType = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet"
Field Value
Type Description
System.String

WorksheetTagName

This is the root element of Sheet Parts that are of type 'worksheet'.

Declaration
public const string WorksheetTagName = "worksheet"
Field Value
Type Description
System.String

WrapTextAttributeName

Name of the xml attribute that holds wrap text option.

Declaration
public const string WrapTextAttributeName = "wrapText"
Field Value
Type Description
System.String

X14Namespace

Name of the relation type that indicates that part contains the Sparkline properties.

Declaration
public const string X14Namespace = "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main"
Field Value
Type Description
System.String

X14NameSpaceAttribute

X14 Namespace Attibute

Declaration
public const string X14NameSpaceAttribute = "xmlns"
Field Value
Type Description
System.String

x14PivotTableDefinitionAttributes

x14 PivotTable Definition Attribute

Declaration
public const string x14PivotTableDefinitionAttributes = "pivotTableDefinition"
Field Value
Type Description
System.String

X14Prefix

Prefix for Sparkline namespace.

Declaration
public const string X14Prefix = "x14"
Field Value
Type Description
System.String

XFIdAttributeName

Name of the xml attribute that represents extended format index.

Declaration
public const string XFIdAttributeName = "xfId"
Field Value
Type Description
System.String

Xml

xml

Declaration
public const string Xml = "xml"
Field Value
Type Description
System.String

XmlFileHeading

File heading.

Declaration
public const string XmlFileHeading = "<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\" ?>"
Field Value
Type Description
System.String

XmlItemName

Xml Item Name

Declaration
public const string XmlItemName = "item{0}.xml"
Field Value
Type Description
System.String

XmlNamespaceMain

Main xml namespace.

Declaration
public const string XmlNamespaceMain = "http://schemas.openxmlformats.org/spreadsheetml/2006/main"
Field Value
Type Description
System.String

XmlPrefix

Xml prefix.

Declaration
public const string XmlPrefix = "xml"
Field Value
Type Description
System.String

XmlPropertiesName

Xml Properties Name

Declaration
public const string XmlPropertiesName = "itemProps{0}.xml"
Field Value
Type Description
System.String

XMNamespaceMain

Main XM Namespace

Declaration
public const string XMNamespaceMain = "http://schemas.microsoft.com/office/excel/2006/main"
Field Value
Type Description
System.String

XMNamespaceMainAttribute

Main XM Namespace Attribute

Declaration
public const string XMNamespaceMainAttribute = "xmlns"
Field Value
Type Description
System.String

XSIPartType

Name of the relation type that indicates XSI part.

Declaration
public const string XSIPartType = "http://www.w3.org/2001/XMLSchema-instance"
Field Value
Type Description
System.String

XSIPrefix

Prefix for XSI namespace.

Declaration
public const string XSIPrefix = "xsi"
Field Value
Type Description
System.String

ZeroHeightAttribute

Name of the xml attribute that stores rows are hidden by default.

Declaration
public const string ZeroHeightAttribute = "zeroHeight"
Field Value
Type Description
System.String

Properties

HFVmlSerializators

Gets Dictionary with serializators that can be used to serialize header/footer vml shapes. Read-only.

Declaration
public Dictionary<int, ShapeSerializator> HFVmlSerializators { get; }
Property Value
Type Description
System.Collections.Generic.Dictionary<System.Int32, ShapeSerializator>

Version

Gets version that is supported by this serializator.

Declaration
public virtual ExcelVersion Version { get; }
Property Value
Type Description
ExcelVersion

VmlSerializators

Gets Dictionary with serializators that can be used to serialize vml shapes. Read-only.

Declaration
public Dictionary<int, ShapeSerializator> VmlSerializators { get; }
Property Value
Type Description
System.Collections.Generic.Dictionary<System.Int32, ShapeSerializator>

Methods

CapitalizeFirstLetter(String)

Upper first letter in the string.

Declaration
public static string CapitalizeFirstLetter(string value)
Parameters
Type Name Description
System.String value

String to process.
Returns
Type Description
System.String

New string with the first letter in upper case.

Dispose()

Dispose

Declaration
public void Dispose()

HasAlternateContent(IShapes)

Checks whether the shapes has alternate content

Declaration
public static bool HasAlternateContent(IShapes shapes)
Parameters
Type Name Description
IShapes shapes
Returns
Type Description
System.Boolean

LowerFirstLetter(String)

Lower first letter in the string.

Declaration
public static string LowerFirstLetter(string value)
Parameters
Type Name Description
System.String value

String to process.
Returns
Type Description
System.String

New string with the first letter in lower case.

SeiralizeSheet(XmlWriter, WorksheetBaseImpl)

Serializes single sheet.

Declaration
[Obsolete("This method is obsolete and will be removed soon. Please use SerializeSheet(XmlWriter writer, WorksheetBaseImpl sheet) method. Sorry for inconvenience.")]
public void SeiralizeSheet(XmlWriter writer, WorksheetBaseImpl sheet)
Parameters
Type Name Description
System.Xml.XmlWriter writer

Writer to serialize into.
WorksheetBaseImpl sheet

Sheet to serialize.

SerializeAppVersion(XmlWriter)

Serialize App version

Declaration
protected virtual void SerializeAppVersion(XmlWriter writer)
Parameters
Type Name Description
System.Xml.XmlWriter writer

SerializeAutoFilters(XmlWriter, IAutoFilters)

Serializes auto filters.

Declaration
public void SerializeAutoFilters(XmlWriter writer, IAutoFilters autoFilters)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize auto filters.
IAutoFilters autoFilters

Auto filters collection.

SerializeCommentNotes(XmlWriter, WorksheetImpl)

Serializes comment notes part (authors, text and parent cell address).

Declaration
public void SerializeCommentNotes(XmlWriter writer, WorksheetImpl sheet)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize into.
WorksheetImpl sheet

Worksheet to get comments from.

SerializeConditionValueObject(XmlWriter, IConditionValue, Boolean)

Serializes conditional value object.

Declaration
public void SerializeConditionValueObject(XmlWriter writer, IConditionValue conditionValue, bool isIconSet)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize into.
IConditionValue conditionValue

Object to serialize.
System.Boolean isIconSet

Check is iconset.

SerializeConditionValueObject(XmlWriter, IConditionValue, Boolean, Boolean)

Serializes conditional value object.

Declaration
public void SerializeConditionValueObject(XmlWriter writer, IConditionValue conditionValue, bool isIconSet, bool isMinPoint)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize into.
IConditionValue conditionValue

Object to serialize.
System.Boolean isIconSet

whether it is iconset conditional format
System.Boolean isMinPoint

whether the conditional format value is min point

SerializeConnection(XmlWriter, ExternalConnection)

Serialize connection

Declaration
public void SerializeConnection(XmlWriter writer, ExternalConnection connection)
Parameters
Type Name Description
System.Xml.XmlWriter writer
ExternalConnection connection

SerializeConnections(XmlWriter)

Serialize connections

Declaration
public void SerializeConnections(XmlWriter writer)
Parameters
Type Name Description
System.Xml.XmlWriter writer

SerializeContentTypeProperties(XmlWriter)

Serializes Document Management of the ContentType Properties into XmlWriter.

Declaration
public void SerializeContentTypeProperties(XmlWriter writer)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize properties into.

SerializeContentTypes(XmlWriter, IDictionary<String, String>, IDictionary<String, String>)

Serialize content types.

Declaration
public void SerializeContentTypes(XmlWriter writer, IDictionary<string, string> contentDefaults, IDictionary<string, string> contentOverrides)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to save into.
System.Collections.Generic.IDictionary<System.String, System.String> contentDefaults

Dictionary which is used to identify content type and stores default types. Key - file extension (string), Value - content type (string).
System.Collections.Generic.IDictionary<System.String, System.String> contentOverrides

Dictionary which is used to identify content type and stores type overrides. Key - part name, Value - content type (string).

SerializeCoreProperties(XmlWriter)

Serializes core properties into XmlWriter.

Declaration
public void SerializeCoreProperties(XmlWriter writer)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize core properties into.

SerializeCustomProperties(XmlWriter)

Serializes custom properties into XmlWriter.

Declaration
public void SerializeCustomProperties(XmlWriter writer)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize properties into.

SerializeCustomXmlPartProperty(XmlWriter, ICustomXmlPart)

Declaration
public void SerializeCustomXmlPartProperty(XmlWriter writer, ICustomXmlPart customXmlPart)
Parameters
Type Name Description
System.Xml.XmlWriter writer
ICustomXmlPart customXmlPart

SerializeDataBaseProerty(XmlWriter, DataBaseProperty)

Serialize DataBase Property

Declaration
[Obsolete("This method is obsolete and will be removed soon. Please use SerializeDatabaseProperty(XmlWriter writer, DataBaseProperty dbProperty) method. Sorry for inconvenience.")]
public void SerializeDataBaseProerty(XmlWriter writer, DataBaseProperty dbProperty)
Parameters
Type Name Description
System.Xml.XmlWriter writer
DataBaseProperty dbProperty

SerializeDatabaseProperty(XmlWriter, DataBaseProperty)

Serialize Database property

Declaration
public void SerializeDatabaseProperty(XmlWriter writer, DataBaseProperty dbProperty)
Parameters
Type Name Description
System.Xml.XmlWriter writer
DataBaseProperty dbProperty

SerializeDdeObjectLink(XmlWriter, ExternWorkbookImpl)

Serializes dde object link into specified XmlWriter.

Declaration
public RelationCollection SerializeDdeObjectLink(XmlWriter writer, ExternWorkbookImpl book)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize into.
ExternWorkbookImpl book

External workbook to serialize.
Returns
Type Description
RelationCollection

Collection with external link item relations.

SerializeDrawings(XmlWriter, ShapesCollection, WorksheetDataHolder)

Serializes drawings.

Declaration
public void SerializeDrawings(XmlWriter writer, ShapesCollection shapes, WorksheetDataHolder holder)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize into.
ShapesCollection shapes

Shapes to serialize.
WorksheetDataHolder holder

Parent worksheet data holder.

SerializeDxfs(ref Stream, WorksheetConditionalFormats, ref Int32)

Serializes Dxf styles and conditional formatting.

Declaration
public Stream SerializeDxfs(ref Stream streamDxfs, WorksheetConditionalFormats conditionalFormats, ref int iDxfIndex)
Parameters
Type Name Description
System.IO.Stream streamDxfs

Dxf stream.
WorksheetConditionalFormats conditionalFormats

Conditional formatting.
System.Int32 iDxfIndex
Returns
Type Description
System.IO.Stream

Stream containing conditional formats.

SerializeElementString(XmlWriter, String, String, String)

Serializes element if it differs from default value.

Declaration
protected static void SerializeElementString(XmlWriter writer, string elementName, string value, string defaultValue)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize into.
System.String elementName

Element name.
System.String value

Element value.
System.String defaultValue

Default value.

SerializeExtendedProperties(XmlWriter)

Serializes extended document properties.

Declaration
public void SerializeExtendedProperties(XmlWriter writer)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize extended properties into.

SerializeExtent(XmlWriter, Size)

Extracts extent settings from reader and converts them into pixels.

Declaration
public static void SerializeExtent(XmlWriter writer, Size extent)
Parameters
Type Name Description
System.Xml.XmlWriter writer

Writer to save extent data into.
System.Drawing.Size extent

Size of the shape in pixels.

SerializeExternalLink(XmlWriter, ExternWorkbookImpl)

Serializes external workbook into specified XmlWriter.

Declaration
public RelationCollection SerializeExternalLink(XmlWriter writer, ExternWorkbookImpl book)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize into.
ExternWorkbookImpl book

External workbook to serialize.
Returns
Type Description
RelationCollection

Collection with external link item relations.

SerializeLinkItem(XmlWriter, ExternWorkbookImpl)

Serialize Link Item

Declaration
public RelationCollection SerializeLinkItem(XmlWriter writer, ExternWorkbookImpl book)
Parameters
Type Name Description
System.Xml.XmlWriter writer
ExternWorkbookImpl book
Returns
Type Description
RelationCollection

SerializeMerges(XmlWriter, MergeCellsImpl)

Serializes merged cells.

Declaration
public void SerializeMerges(XmlWriter writer, MergeCellsImpl mergedCells)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to save into.
MergeCellsImpl mergedCells

Object to serialize.

SerializeNamedRanges(XmlWriter)

Serializes named ranges into specified writer.

Declaration
public void SerializeNamedRanges(XmlWriter writer)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to save named ranges into.

SerializeOleObjectLink(XmlWriter, ExternWorkbookImpl)

Serializes external workbook into specified XmlWriter.

Declaration
public RelationCollection SerializeOleObjectLink(XmlWriter writer, ExternWorkbookImpl book)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize into.
ExternWorkbookImpl book

External workbook to serialize.
Returns
Type Description
RelationCollection

Collection with external link item relations.

SerializePageMargins(XmlWriter, IPageSetupBase, IPageSetupConstantsProvider)

Serializes page margins.

Declaration
public static void SerializePageMargins(XmlWriter writer, IPageSetupBase pageSetup, IPageSetupConstantsProvider constants)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize into.
IPageSetupBase pageSetup

Object that stores all necessary margin values.
IPageSetupConstantsProvider constants

Object that provides xml tag/attribute names used for page setup serialization.

SerializePageSetup(XmlWriter, IPageSetupBase, IPageSetupConstantsProvider)

Serialize PageSetup tag.

Declaration
public static void SerializePageSetup(XmlWriter writer, IPageSetupBase pageSetup, IPageSetupConstantsProvider constants)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize into.
IPageSetupBase pageSetup

Object to get necessary settings from.
IPageSetupConstantsProvider constants

SerializePrintSettings(XmlWriter, IPageSetupBase, IPageSetupConstantsProvider, Boolean)

Serializes all print settings (margins, header, footer, etc.).

Declaration
public static void SerializePrintSettings(XmlWriter writer, IPageSetupBase pageSetup, IPageSetupConstantsProvider constants, bool isChartSettings)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize into.
IPageSetupBase pageSetup
IPageSetupConstantsProvider constants
System.Boolean isChartSettings

SerializeRelations(XmlWriter, RelationCollection, WorksheetDataHolder)

Serializes relations collection into specified xml writer.

Declaration
public void SerializeRelations(XmlWriter writer, RelationCollection relations, WorksheetDataHolder holder)
Parameters
Type Name Description
System.Xml.XmlWriter writer

Writer to serialize into.
RelationCollection relations

Relations to serialize.
WorksheetDataHolder holder

SerializeRgbColor(XmlWriter, String, ColorObject)

Serializes rgb color value.

Declaration
public void SerializeRgbColor(XmlWriter writer, string tagName, ColorObject color)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize into.
System.String tagName

Xml tag name to use for color serialization.
ColorObject color

Color to serialize.

SerializeShape(XmlWriter, ShapeImpl, WorksheetDataHolder, RelationCollection, Int32)

This method serializes specified shape into specified writer.

Declaration
public void SerializeShape(XmlWriter writer, ShapeImpl shape, WorksheetDataHolder holder, RelationCollection vmlRelations, int index)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize shape settings into.
ShapeImpl shape

Shape to serialize.
WorksheetDataHolder holder

Parent worksheet data holder.
RelationCollection vmlRelations
System.Int32 index

SerializeSheet(XmlWriter, WorksheetBaseImpl)

Serializes single sheet.

Declaration
public void SerializeSheet(XmlWriter writer, WorksheetBaseImpl sheet)
Parameters
Type Name Description
System.Xml.XmlWriter writer

Writer to serialize into.
WorksheetBaseImpl sheet

Sheet to serialize.

SerializeSheetData(XmlWriter, CellRecordCollection, Dictionary<Int32, Int32>, String, Dictionary<String, String>, Boolean)

Serializes sheet data.

Declaration
public void SerializeSheetData(XmlWriter writer, CellRecordCollection cells, Dictionary<int, int> hashNewParentIndexes, string cellTag, Dictionary<string, string> additionalAttributes, bool isSpansNeeded)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize into.
CellRecordCollection cells

Cell record collection.
System.Collections.Generic.Dictionary<System.Int32, System.Int32> hashNewParentIndexes

Dictionary with new extended format indexes. Key - index in our collection of extended formats, value - index in the cellStyleXfs block.
System.String cellTag
System.Collections.Generic.Dictionary<System.String, System.String> additionalAttributes
System.Boolean isSpansNeeded

SerializeSheetProtection(XmlWriter, WorksheetBaseImpl)

Serializes protection options if necessary.

Declaration
public void SerializeSheetProtection(XmlWriter writer, WorksheetBaseImpl sheet)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize into.
WorksheetBaseImpl sheet

Worksheet to get protection options from.

SerializeSST(XmlWriter)

Serializes shared string table into specified XmlWriter.

Declaration
public void SerializeSST(XmlWriter writer)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to save SST into.

SerializeStream(XmlWriter, Stream, String)

Serializes stream data.

Declaration
public static void SerializeStream(XmlWriter writer, Stream data, string strRootName)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize into.
System.IO.Stream data

Data to be serialized
System.String strRootName

Root name of the data.

SerializeStyles(XmlWriter, ref Stream)

Serializes styles collection into specified XmlWriter.

Declaration
public Dictionary<int, int> SerializeStyles(XmlWriter writer, ref Stream streamDxfs)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize styles into.
System.IO.Stream streamDxfs

Stream that contains Dxfs formatting tags.
Returns
Type Description
System.Collections.Generic.Dictionary<System.Int32, System.Int32>

Dictionary with new XF indexes.

SerializeVmlHFShapesWorksheetPart(XmlWriter, WorksheetBaseImpl, IPageSetupConstantsProvider, RelationCollection)

Serializes part of the worksheet that contains information about vml shapes (legacydrawing tag).

Declaration
public static void SerializeVmlHFShapesWorksheetPart(XmlWriter writer, WorksheetBaseImpl sheet, IPageSetupConstantsProvider constants, RelationCollection relations)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize into.
WorksheetBaseImpl sheet

Worksheet to serialize.
IPageSetupConstantsProvider constants
RelationCollection relations

SerializeVmlShapes(XmlWriter, ShapeCollectionBase, WorksheetDataHolder, Dictionary<Int32, ShapeSerializator>, RelationCollection)

Serializes vml shapes. WARNING: this method doesn't check whether there are any shapes to serialize or not.

Declaration
public void SerializeVmlShapes(XmlWriter writer, ShapeCollectionBase shapes, WorksheetDataHolder holder, Dictionary<int, ShapeSerializator> dictSerializators, RelationCollection vmlRelations)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize into.
ShapeCollectionBase shapes

Shapes to serialize.
WorksheetDataHolder holder

Parent worksheet data holder.
System.Collections.Generic.Dictionary<System.Int32, ShapeSerializator> dictSerializators

Dictionary with all known vml shapes serializators.
RelationCollection vmlRelations

SerializeVmlShapesWorksheetPart(XmlWriter, WorksheetBaseImpl)

Serializes part of the worksheet that contains information about vml shapes (legacydrawing tag).

Declaration
public void SerializeVmlShapesWorksheetPart(XmlWriter writer, WorksheetBaseImpl sheet)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize into.
WorksheetBaseImpl sheet

Worksheet to serialize.

SerializeWebProperty(XmlWriter, ExternalConnection)

Serialize Web property

Declaration
public void SerializeWebProperty(XmlWriter writer, ExternalConnection Connection)
Parameters
Type Name Description
System.Xml.XmlWriter writer
ExternalConnection Connection

SerializeWorkbook(XmlWriter, Stream, Stream, List<Dictionary<String, String>>, RelationCollection, Dictionary<PivotCacheImpl, String>, Stream, List<Dictionary<String, String>>)

Serializes workbook part (workbook.xml content) into XmlWriter.

Declaration
public void SerializeWorkbook(XmlWriter writer, Stream streamStart, Stream streamEnd, List<Dictionary<string, string>> lstBookViews, RelationCollection relations, Dictionary<PivotCacheImpl, string> cacheFiles, Stream functionGroups, List<Dictionary<string, string>> lstCustomBookViews)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize workbook properties into.
System.IO.Stream streamStart

Stream that contains additional workbook information that wasn't parsed on load and that is placed before sheets.
System.IO.Stream streamEnd

Stream that contains additional workbook information that wasn't parsed on load and that is placed after named ranges.
System.Collections.Generic.List<System.Collections.Generic.Dictionary<System.String, System.String>> lstBookViews

Workbook views collection.
RelationCollection relations

Workbook relations.
System.Collections.Generic.Dictionary<PivotCacheImpl, System.String> cacheFiles

Dictionary that will contain pivot cache files (key - cache object, value - cache file name).
System.IO.Stream functionGroups

Stream containing functionGroups tag data.
System.Collections.Generic.List<System.Collections.Generic.Dictionary<System.String, System.String>> lstCustomBookViews

Custom workbook view collection

SerializeWorksheet(XmlWriter, WorksheetImpl, Stream, Stream, Dictionary<Int32, Int32>, Stream)

Serializes single worksheet object.

Declaration
public void SerializeWorksheet(XmlWriter writer, WorksheetImpl sheet, Stream streamStart, Stream streamConFormats, Dictionary<int, int> hashXFIndexes, Stream streamExtCondFormats)
Parameters
Type Name Description
System.Xml.XmlWriter writer

XmlWriter to serialize into.
WorksheetImpl sheet

Worksheet to serialize.
System.IO.Stream streamStart

Stream with xml text starting from the beginning of worksheet to sheetData or cols tag.
System.IO.Stream streamConFormats

Stream with conditional formatting.
System.Collections.Generic.Dictionary<System.Int32, System.Int32> hashXFIndexes

Dictionary with new XF indexes, key - old index, value - new index.
System.IO.Stream streamExtCondFormats

SerilaizeExtensions(XmlWriter, WorksheetImpl)

Serialize Extensions

Declaration
protected virtual void SerilaizeExtensions(XmlWriter writer, WorksheetImpl sheet)
Parameters
Type Name Description
System.Xml.XmlWriter writer
WorksheetImpl sheet

WriteAlternateContentControlsHeader(XmlWriter)

Write Alternate Content Controls Header

Declaration
public static void WriteAlternateContentControlsHeader(XmlWriter writer)
Parameters
Type Name Description
System.Xml.XmlWriter writer

WriteAlternateContentFooter(XmlWriter)

Write Alternate Content Footer

Declaration
public static void WriteAlternateContentFooter(XmlWriter writer)
Parameters
Type Name Description
System.Xml.XmlWriter writer

WriteAlternateContentHeader(XmlWriter)

Write Alternate Cotent Header

Declaration
public static void WriteAlternateContentHeader(XmlWriter writer)
Parameters
Type Name Description
System.Xml.XmlWriter writer

Implements

System.IDisposable