menu

Xamarin.Android

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class Excel2007Serializator - Xamarin.Android API Reference | Syncfusion

    Show / Hide Table of Contents

    Class Excel2007Serializator

    Class used for Excel 2007 Serialization.

    Inheritance
    System.Object
    Excel2007Serializator
    Excel2010Serializator
    Implements
    System.IDisposable
    Namespace: Syncfusion.XlsIO.Implementation.XmlSerialization
    Assembly: Syncfusion.XlsIO.Portable.dll
    Syntax
    public class Excel2007Serializator : Object, 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
    System.String

    AlignmentTagName

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

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

    Always

    Declaration
    public const string Always = "OLEUPDATE_ALWAYS"
    Field Value
    Type
    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
    System.String

    ApplicationNameAttribute

    Specifies the application name.

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

    ApplicationNameValue

    Value of the application name attribute.

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

    AuthorIdAttributeName

    Name of the xml attribute that stores comment author id.

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

    Auto

    Name of the default color attribute.

    Declaration
    public const string Auto = "auto"
    Field Value
    Type
    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
    System.String

    AutoNoTableCalcModeValue

    Auto No Table Calc Mode Value

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

    BackGroundAttribute

    BackGround Attribute

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

    BackgroundColorTagName

    Name of the xml tag that represents background color.

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

    BackgroundImageTagName

    Name of the xml tag that represents Background sheet image.

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

    BackgroundRefresh

    Background refresh

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

    BaseColWidthAttribute

    Name of the xml attribute that stores base column width setting

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

    BestFitAttribute

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

    BorderColorTagName

    Name of the xml tag that stores border color.

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

    BorderIdAttributeName

    Name of the xml attribute that represents border id.

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

    BordersCollectionTagName

    Name of the xml tag that stores single border collection.

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

    BordersTagName

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

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

    BorderStyleAttributeName

    Name of the xml attribute that represents border style.

    Declaration
    public const string BorderStyleAttributeName = "style"
    Field Value
    Type
    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
    System.String

    BreakTagName

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

    Declaration
    public const string BreakTagName = "brk"
    Field Value
    Type
    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
    System.String

    CalculateOnOpen

    Name of the xml tag that represents Calculate On Open

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

    CalculationId

    Calculation ID

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

    CalculationMode

    Calculation Mode

    Declaration
    public const string CalculationMode = "calcMode"
    Field Value
    Type
    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
    System.String

    CellFormatXFsTagName

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

    Declaration
    public const string CellFormatXFsTagName = "cellXfs"
    Field Value
    Type
    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
    System.String

    CellStylesTagName

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

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

    CellStyleTagName

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

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

    CellTagName

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

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

    CellValueTagName

    Name of xml tag that represents cell value.

    Declaration
    public const string CellValueTagName = "v"
    Field Value
    Type
    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
    System.String

    CodeName

    Xml attribute containing sheet codename.

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

    ColorID

    String used to specify the color of grid line

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

    ColorIndexedAttributeName

    Name of the indexed attribute in the color tag.

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

    ColorRgbAttribute

    Name of the rgb attribute in the color tag.

    Declaration
    public const string ColorRgbAttribute = "rgb"
    Field Value
    Type
    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
    System.String

    ColorsTagName

    Name of the xml tag that stores color settings.

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

    ColorTagName

    Name of the xml tag that contains color settings.

    Declaration
    public const string ColorTagName = "color"
    Field Value
    Type
    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
    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
    System.String

    ColsTagName

    Name of the xml tag that stores all column settings.

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

    ColTagName

    Name of the xml tag that stores column settings range.

    Declaration
    public const string ColTagName = "col"
    Field Value
    Type
    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
    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
    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
    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
    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
    System.String

    CommandTextAttribute

    Command Text Attribute

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

    CommandTypeAttribute

    Command Type Attribute

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

    CommentAttributeName

    Name of the comment attribute.

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

    CommentAuthorsTagName

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

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

    CommentAuthorTagName

    Name of the xml tag that holds single author name.

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

    CommentListTagName

    Name of the xml tag that holds all comment notes.

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

    CommentsTagName

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

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

    CommentTagName

    Name of the xml tag that holds single comment note.

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

    CommentTextTagName

    Name of the xml tag that stores comment text.

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

    ConnectionIdAttribute

    Connection Id Attribute

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

    ConnectionsTag

    Represent the connections

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

    ConnectionTag

    Represent the connections

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

    ContentTypeAttributeName

    Name of the xml tag that stores content type string.

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

    ContentTypesNamespace

    Namespace with ContentTypes items.

    Declaration
    public const string ContentTypesNamespace = "http://schemas.openxmlformats.org/package/2006/content-types"
    Field Value
    Type
    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
    System.String

    CorePropertiesPrefix

    Prefix for core properties namespace.

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

    CountAttributeName

    Name of the count attribute.

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

    Credentials

    Credentials

    Declaration
    public const string Credentials = "credentials"
    Field Value
    Type
    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
    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
    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
    System.String

    CustomWorkbookView

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

    Declaration
    public const string CustomWorkbookView = "customWorkbookView"
    Field Value
    Type
    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
    System.String

    CustomXmlItemID

    Custom Xml Item ID

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

    CustomXmlItemPropertiesRelation

    Custom Xml Item Properties Relation

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

    CustomXmlName

    Custom Xml Name

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

    CustomXmlNameSpace

    Custom Xml Namespace

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

    CustomXmlPartName

    CustomXmlParts Constants

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

    CustomXmlPropertiesName

    Custom Xml properties name

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

    CustomXmlRelation

    Custom xml relation

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

    CustomXmlSchemaReference

    Custom Xml Schema Reference

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

    CustomXmlSchemaReferences

    Custom Xml Schema References

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

    CustomXmlUriAttribute

    Custom Xml Uri Attribute

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

    DataBaseNameAttribute

    Represents DataBase Name

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

    DataBasePrTag

    DataBase Property Tag

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

    DataBaseTypeAttribute

    Represents DataBase Type

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

    DataStoreItem

    Data store item

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

    dataTable2DTag

    Attribute to show two-dimenssional data table

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

    dataTableCellTag

    Attribute to represent first input cell for data table.

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

    dataTableRowTag

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

    Declaration
    public const string dataTableRowTag = "dtr"
    Field Value
    Type
    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
    System.String

    DCMITypePrefix

    Prefix for DCMIType namespace.

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

    DEF_DEFAULT_ROW_DELIMITER

    Default delimiter between worksheet rows.

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

    DefaultCellDataType

    Defines default cell data type.

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

    DefaultColumWidthAttribute

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

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

    DefaultRowHeightAttribute

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

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

    DefaultTagName

    Name of the xml tag that stores default type name.

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

    DefaultThemeVersion

    Default Theme Version

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

    DefaultWorksheetPathFormat

    Default worksheet path format

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

    DefinedNamesXmlTagName

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

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

    DefinedNameXmlTagName

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

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

    Deleted

    Deleted

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

    DescriptionTag

    Description Tag

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

    DiagonalDownAttributeName

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

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

    DiagonalUpAttributeName

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

    Declaration
    public const string DiagonalUpAttributeName = "diagonalUp"
    Field Value
    Type
    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
    System.String

    DiffXFsTagName

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

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

    DimensionTagName

    Name of the xml tag that stores worksheet dimension.

    Declaration
    public const string DimensionTagName = "dimension"
    Field Value
    Type
    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
    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
    System.String

    DocPropsVTypesPrefix

    Prefix for DocPropsVTypes namespace.

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

    DocumentManagement

    DocumentManagement Constalt

    Declaration
    public const string DocumentManagement = "documentManagement"
    Field Value
    Type
    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
    System.String

    DublinCorePrefix

    Prefix for dublin core namespace.

    Declaration
    public const string DublinCorePrefix = "dc"
    Field Value
    Type
    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
    System.String

    DublinCoreTermsPrefix

    Prefix for dublin core terms namespace.

    Declaration
    public const string DublinCoreTermsPrefix = "dcterms"
    Field Value
    Type
    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
    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
    System.String

    EmptyCellsGapValue

    String used to serialize Display of Empty Cells as gaps.

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

    EmptyCellsLineValue

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

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

    EmptyCellsZeroValue

    String used to serialize Display of Empty Cells as zero.

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

    ErrorsSequence

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

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

    ErrorTagsSequence

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

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

    ExtendedFormatTagName

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

    Declaration
    public const string ExtendedFormatTagName = "xf"
    Field Value
    Type
    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
    System.String

    Extension

    Name of the xml tag that represents extension

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

    ExtensionAttributeName

    Name of the xml attribute with part extension.

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

    Extensionlist

    Name of the xml tag that represents extension list

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

    ExternListUri

    Extern List URi

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

    FalseValue

    String used to serialize boolean False value.

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

    FileHyperlinkStartString

    Represent file hyperlink string prefix.

    Declaration
    public const string FileHyperlinkStartString = "file:///"
    Field Value
    Type
    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
    System.String

    FillIdAttributeName

    Name of the xml attribute that represents fill id.

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

    FillsTagName

    Name of the xml tag that represents fills collection.

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

    FillTagName

    Name of the xml tag that represents single fill object.

    Declaration
    public const string FillTagName = "fill"
    Field Value
    Type
    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
    System.String

    FitToPageAttribute

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

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

    FontBoldTagName

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

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

    FontCharsetTagName

    Name of the xml tag that stores font charset settings.

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

    FontFamilyTagName

    Name of the xml tag that stores font family settings.

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

    FontIdAttributeName

    Name of the xml attribute that represents font id.

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

    FontItalicTagName

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

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

    FontNameTagName

    Name of the xml tag that represents font name.

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

    FontSizeTagName

    Name of the xml tag that stores font underline settings.

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

    FontsTagName

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

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

    FontStrikeTagName

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

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

    FontTagName

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

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

    FontUnderlineTagName

    Name of the xml tag that stores font underline settings.

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

    FontVerticalAlignmentTagName

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

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

    ForegroundColorTagName

    Name of the xml tag that represents foreground color.

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

    FormulaTagName

    Name of xml tag that represents formula.

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

    FormulaTypeAttributeName

    Name of xml attribute that represents formula type.

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

    FunctionGroups

    Name of the xml tag that represents funtion groups

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

    GradientFillTagName

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

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

    GradientFillTypeAttributeName

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

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

    GradientFillTypeLinear

    This gradient fill is of linear gradient type.

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

    GradientFillTypePath

    This gradient fill is of path gradient type.

    Declaration
    public const string GradientFillTypePath = "path"
    Field Value
    Type
    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
    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
    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
    System.String

    HiddenAttributeName

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

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

    HiddenDefaultValue

    Default value for FormulaHidden value.

    Declaration
    public const bool HiddenDefaultValue = false
    Field Value
    Type
    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
    System.String

    HideValuesRowAttribute

    Hide values row attribute

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

    HorizontalPageBreaksTagName

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

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

    HttpStartString

    Represent http hyperlink string prefix.

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

    HyperlinkNamespace

    Namespace for hyperlink.

    Declaration
    public const string HyperlinkNamespace = "http://schemas.openxmlformats.org/officeDocument/2006/relationships/hyperlink"
    Field Value
    Type
    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
    System.String

    HyperlinksTagName

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

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

    HyperlinkTagName

    Name of the xml tag that represents a single hyperlink.

    Declaration
    public const string HyperlinkTagName = "hyperlink"
    Field Value
    Type
    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
    System.String

    IgnoredErrorsTag

    A collection of ignored errors, by cell range.

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

    IgnoredErrorTag

    A single ignored error type for a range of cells.

    Declaration
    public const string IgnoredErrorTag = "ignoredError"
    Field Value
    Type
    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
    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
    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
    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
    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
    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
    System.String

    IndentAttributeName

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

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

    IndexedColorsTagName

    Name of the xml tag that stores indexed color values.

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

    Interval

    Interval

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

    ItemIdAttribute

    Item Id Attribute

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

    ItemPropertiesPrefix

    Item properties prefix

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

    ItemPrpertiesUri

    Item Properties Uri

    Declaration
    public const string ItemPrpertiesUri = "uri"
    Field Value
    Type
    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
    System.String

    LastEdited

    Name of the xml tag that represents last edited

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

    Layout

    String used to serialize sheet zooming

    Declaration
    public const string Layout = "pageLayout"
    Field Value
    Type
    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
    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
    System.String

    LocationAttributeName

    Name of the xml attribute that represents location within target.

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

    LockedAttributeName

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

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

    LockedDefaultValue

    Default value for Locked value.

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

    LowestEdited

    Name of the xml tag that represents lowest edited

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

    MacOSShadowTagName

    Name of the xml tag that stores MacOSShadow settings.

    Declaration
    public const string MacOSShadowTagName = "shadow"
    Field Value
    Type
    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
    System.String

    ManualCalcModeValue

    Manual Calc Mode Value

    Declaration
    public const string ManualCalcModeValue = "manual"
    Field Value
    Type
    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
    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
    System.String

    MCNamespace

    MC Namespace

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

    MCPrefix

    MC prefix

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

    MergeCellsXmlTagName

    Name of the xml tag that contains merged cells data.

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

    MergeCellXmlTagName

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

    Declaration
    public const string MergeCellXmlTagName = "mergeCell"
    Field Value
    Type
    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
    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
    System.String

    MSNamespaceMain

    Main Microsoft Namespace

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

    MSNamespaceMainAttribute

    Main Microsoft Namespace Attribute

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

    MSPrefix

    Prefix for Microsoft Main Namespace.

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

    NameAttributeName

    Name of the name attribute.

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

    NamedStyleXFsTagName

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

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

    NameSheetIdAttribute

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

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

    Normal

    String used to serialize Normal layout.

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

    NumberFormatIdAttributeName

    Name of the xml attribute that defines number format id.

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

    NumberFormatsTagName

    Name of the xml tag that represents number formats.

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

    NumberFormatStringAttributeName

    Name of the xml attribute that defines number format string.

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

    NumberFormatTagName

    Name of the xml tag that represents single number format.

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

    OdbcFileAttribute

    Represents ODBC File

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

    OlapPrTag

    Represent the Olap Property

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

    OleObjectContentType

    OleObject Content Type

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

    OleObjectFileExtension

    OleObject File Extension

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

    OnCall

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

    OnlyUseConnectionFile

    Only use connection file

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

    OutlineLevelAttribute

    Indicates that this formatting is for an outline style.

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

    OutlineLevelColAttribute

    Name of the xml attribute that stores outlineLevelCol setting

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

    OutlineLevelRowAttribute

    Name of the xml attribute that stores outlineLevelRow setting

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

    OverrideTagName

    Name of the xml tag that stores type override.

    Declaration
    public const string OverrideTagName = "Override"
    Field Value
    Type
    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
    System.String

    PageBreakPreview

    String used to serialize Page break preview layout.

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

    PageSetupPropertiesTag

    Page setup properties of the worksheet.

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

    PartNameAttributeName

    Name of the xml attribute that stores part name.

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

    PartnerControlsNameSpace

    PartnerControls NameSpace

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

    PatternAttributeName

    Name of the xml attribute that defines pattern.

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

    PatternFillTagName

    Name of the xml tag that represents pattern fill object.

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

    PCPrefix

    PC prefix

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

    Phonetic

    Name of the xml tag that represents phonetic text

    Declaration
    public const string Phonetic = "phonetic"
    Field Value
    Type
    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
    System.String

    PivotButton

    Indicating whether cell has pivot button

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

    PivotFieldUri

    Pivot Field URi

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

    PPrefix

    P prefix

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

    PreserveValue

    Value specifying white space preservation in a string.

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

    Properties

    Properties Constant

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

    PropertiesNameSpace

    Properties NameSpace

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

    ProtectionTagName

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

    Declaration
    public const string ProtectionTagName = "protection"
    Field Value
    Type
    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
    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
    System.String

    RangeReferenceAttribute

    Attribute used to store range reference.

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

    ReadingOrderAttributeName

    Name of the xml attribute that holds reading order settings.

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

    RefAttributeName

    Name of the ref attribute.

    Declaration
    public const string RefAttributeName = "ref"
    Field Value
    Type
    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
    System.String

    RefreshedVersionAttribute

    Refreshed Version Attribute

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

    RelationAttribute

    Name of the xml attribute that stores relation id.

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

    RelationExternalTargetMode

    Name of relationship external target mode.

    Declaration
    public const string RelationExternalTargetMode = "External"
    Field Value
    Type
    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
    System.String

    RelationIdFormat

    Relation id format

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

    RelationNamespace

    Namespace for relation tags/attributes.

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

    RelationPrefix

    Prefix for relation namespace.

    Declaration
    public const string RelationPrefix = "r"
    Field Value
    Type
    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
    System.String

    RelationsTagName

    Name of the xml tag that holds relationships data.

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

    RelationTagName

    Name of the xml tag that holds relationship data.

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

    RelationTargetAttribute

    Name of the xml attribute that holds relationship target.

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

    RelationTargetModeAttribute

    Name of the xml attribute that holds relationship target mode.

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

    RelationTypeAttribute

    Name of the xml attribute that holds relationship type.

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

    RgbColorTagName

    Name of the xml tag that stores rgb color.

    Declaration
    public const string RgbColorTagName = "rgbColor"
    Field Value
    Type
    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
    System.String

    RichTextInlineTagName

    Name of xml tag that represents rich text.

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

    RichTextRunFontTagName

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

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

    RichTextRunPropertiesTagName

    Name of xml tag that represents rich text run properties.

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

    RichTextRunTagName

    Name of the xml tag that represents rich text run.

    Declaration
    public const string RichTextRunTagName = "r"
    Field Value
    Type
    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
    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
    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
    System.String

    RowColumnOutlineLevelAttribute

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

    Declaration
    public const string RowColumnOutlineLevelAttribute = "outlineLevel"
    Field Value
    Type
    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
    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
    System.String

    RowHeightAttributeName

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

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

    RowHiddenAttributeName

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

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

    RowIndexAttributeName

    Name of xml attribute that represents row index.

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

    RowTagName

    Name of xml tag that represents row.

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

    RowThickBottomAttributeName

    Name of xml attribute that represents thick bottom flag.

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

    RowThickTopAttributeName

    Name of xml attribute that represents thick top flag.

    Declaration
    public const string RowThickTopAttributeName = "thickTop"
    Field Value
    Type
    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
    System.String

    SaveData

    Save Data

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

    SavePassword

    Save password

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

    SharedGroupIndexAttributeName

    Name of xml attribute that represents shared formula group index.

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

    SharedStringTableTagName

    Name of the xml tag that represents shared string table.

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

    SheetDataTagName

    Name of the xml tag that stores sheet data.

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

    SheetFormatPropertiesTag

    Name of the xml tag that stores sheet format properties.

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

    SheetGridColor

    Flag indicating whether this sheet gridline is modified by user

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

    SheetIdAttribute

    Name of the xml attribute that stores unique sheet id.

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

    SheetLevelPropertiesTagName

    Name of the xml tag that represents sheet level properties.

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

    SheetNameAttribute

    Name of the xml attribute that stores sheet name.

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

    SheetOutlinePropertiesTagName

    Name of the xml tag that represents sheet outline properties.

    Declaration
    public const string SheetOutlinePropertiesTagName = "outlinePr"
    Field Value
    Type
    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
    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
    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
    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
    System.String

    SheetTagName

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

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

    SheetViewsTag

    Worksheet/chartsheet views collection.

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

    SheetViewTag

    This element specifies a chart sheet view.

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

    SheetZoomScale

    String used to serialize sheet zooming

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

    ShowGridLines

    Flag indicating whether this sheet should display gridlines.

    Declaration
    public const string ShowGridLines = "showGridLines"
    Field Value
    Type
    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
    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
    System.String

    ShowRowColHeaders

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

    Declaration
    public const string ShowRowColHeaders = "showRowColHeaders"
    Field Value
    Type
    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
    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
    System.String

    ShowZeros

    Flag indicating whether this sheet should display zero values.

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

    ShrinkToFitAttributeName

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

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

    SlicerExtensionUri

    Slicer extersion URi

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

    SourceFile

    Source File

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

    SpaceAttributeName

    Attribute to specify string spacing.

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

    SparklineColumnValue

    String used to serialize Sparkline Column type.

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

    SparklineUri

    Uri for the Sparkline properties.

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

    SparklineWinLossValue

    String used to serialize Sparkline WinLoss type.

    Declaration
    public const string SparklineWinLossValue = "stacked"
    Field Value
    Type
    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
    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
    System.String

    StateVisible

    Indicates the sheet is visible.

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

    StringItemTagName

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

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

    StyleBuiltinIdAttributeName

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

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

    StyleCustomizedAttributeName

    Name of the xml attribute that define the customized buildinstyles.

    Declaration
    public const string StyleCustomizedAttributeName = "customBuiltin"
    Field Value
    Type
    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
    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
    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
    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
    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
    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
    System.String

    SystemColorValueAttributeName

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

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

    TableStylesTagName

    Name of the xml tag that stores table styles.

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

    TabSelected

    Tab Selected

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

    TemporaryRoot

    Root items for data preserving.

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

    TextPr

    Text Properties

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

    TextRotationAttributeName

    Name of the xml attribute that holds text rotation value.

    Declaration
    public const string TextRotationAttributeName = "textRotation"
    Field Value
    Type
    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
    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
    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
    System.String

    ThickBottomAttribute

    Name of the xml attribute that stores thickBottom setting

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

    ThickTopAttribute

    Name of the xml attribute that stores thickTop setting

    Declaration
    public const string ThickTopAttribute = "thickTop"
    Field Value
    Type
    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
    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
    System.String

    TransitionEvaluation

    Name of the xml tag that represents transition evaluation

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

    TrueValue

    String used to serialize boolean True value.

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

    TypesTagName

    Name of the xml tag that stores content types definitions.

    Declaration
    public const string TypesTagName = "Types"
    Field Value
    Type
    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
    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
    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
    System.String

    URL

    url

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

    ValueAttributeName

    Name of the value attribute.

    Declaration
    public const string ValueAttributeName = "val"
    Field Value
    Type
    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
    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
    System.String

    VerticalCustomTypeValue

    String used to serialize Vertical Axis type as custom.

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

    VerticalPageBreaksTagName

    Name of the xml tag that represents vertical page break information

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

    VerticalSameTypeValue

    String used to serialize Vertical Axis type as same.

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

    ViewTag

    String used to serialize sheet view

    Declaration
    public const string ViewTag = "view"
    Field Value
    Type
    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
    System.String

    WebPrTag

    Represent the WebProperties

    Declaration
    public const string WebPrTag = "webPr"
    Field Value
    Type
    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
    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
    System.String

    WorkbookDate1904

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

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

    WorkbookPr

    This xml element stores the details of WorkbookPr.

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

    WorkbookPrecision

    This element stores information about the Precision to be followed.

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

    WorkbookTagName

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

    Declaration
    public const string WorkbookTagName = "workbook"
    Field Value
    Type
    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
    System.String

    WorkbookViewsTagName

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

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

    WorkbookViewTagName

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

    Declaration
    public const string WorkbookViewTagName = "workbookView"
    Field Value
    Type
    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
    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
    System.String

    WrapTextAttributeName

    Name of the xml attribute that holds wrap text option.

    Declaration
    public const string WrapTextAttributeName = "wrapText"
    Field Value
    Type
    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
    System.String

    X14NameSpaceAttribute

    X14 Namespace Attibute

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

    x14PivotTableDefinitionAttributes

    x14 PivotTable Definition Attribute

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

    X14Prefix

    Prefix for Sparkline namespace.

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

    XFIdAttributeName

    Name of the xml attribute that represents extended format index.

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

    Xml

    xml

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

    XmlFileHeading

    File heading.

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

    XmlItemName

    Xml Item Name

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

    XmlNamespaceMain

    Main xml namespace.

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

    XmlPrefix

    Xml prefix.

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

    XmlPropertiesName

    Xml Properties Name

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

    XMNamespaceMain

    Main XM Namespace

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

    XMNamespaceMainAttribute

    Main XM Namespace Attribute

    Declaration
    public const string XMNamespaceMainAttribute = "xmlns"
    Field Value
    Type
    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
    System.String

    XSIPrefix

    Prefix for XSI namespace.

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

    ZeroHeightAttribute

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

    Declaration
    public const string ZeroHeightAttribute = "zeroHeight"
    Field Value
    Type
    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
    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
    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
    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
    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
    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
    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.

    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
    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
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved