Class WorkbookXmlSerializator

Xml serializator. Serializes XlsIO workbook into MsExcel xml file format.

Inheritance
System.Object
WorkbookXmlSerializator
Implements
Namespace: Syncfusion.XlsIO.Implementation.XmlSerialization
Assembly: Syncfusion.XlsIO.Portable.dll
Syntax
[XmlSerializator]
public class WorkbookXmlSerializator : Object, IXmlSerializator

Constructors

WorkbookXmlSerializator()

Initializes a new instance of the WorkbookXmlSerializator class.

Declaration
public WorkbookXmlSerializator()

Fields

DEF_ACTIVE_PANE_PREF

Represents active pane pref.

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

DEF_ACTIVE_SHEET_PREF

Represents Active sheet pref.

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

DEF_ACTIVECOL_PANE_PREF

Represents active column pane pref.

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

DEF_ACTIVEROW_PANE_PREF

Represents active row pane pref.

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

DEF_ALIGNMENT_PREF

Represents Alignment pref.

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

DEF_ALLOWTYPE_STRING

Represents the ErrorStyle Options

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

DEF_APPLICATION_STRING

Represents application string;

Declaration
public const string DEF_APPLICATION_STRING = "<?mso-application progid=\"Excel.Sheet\"?>"
Field Value
Type Description
System.String

DEF_AUTHOR_PREF

Represents Author pref.

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

DEF_AUTOFIT_HEIGHT_PREF

Represents AutoFitHeight pref.

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

DEF_AUTOFIT_WIDTH_PREF

Represents AutoFitWidth pref.

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

DEF_BAD_FORMULA

Represents bad formula reference.

Declaration
public const string DEF_BAD_FORMULA = "=#REF!"
Field Value
Type Description
System.String

DEF_BAD_REF

Represents bad reference.

Declaration
public const string DEF_BAD_REF = "#REF"
Field Value
Type Description
System.String

DEF_BAD_REF_UPDATE

Represents bad reference in xml.

Declaration
public const string DEF_BAD_REF_UPDATE = "#REF!"
Field Value
Type Description
System.String

DEF_BLACK_AND_WHITE_PREF

Represents BlackAndWhite pref.

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

DEF_BOLD_PREF

Represents Bold pref.

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

DEF_BORDER_LINE_CF

Represents border line style.

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

DEF_BORDER_LINE_TYPE_STRING

Represents border line type string.

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

DEF_BORDER_POSITION_STRING

Represents border position string.

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

DEF_BORDER_PREF

Represents Border pref.

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

DEF_BORDERBOTTOM_CF

Represents border bottom constant.

Declaration
public const string DEF_BORDERBOTTOM_CF = "border-bottom"
Field Value
Type Description
System.String

DEF_BORDERLEFT_CF

Represents border left constant.

Declaration
public const string DEF_BORDERLEFT_CF = "border-left"
Field Value
Type Description
System.String

DEF_BORDERRIGHT_CF

Represents border right constant.

Declaration
public const string DEF_BORDERRIGHT_CF = "border-right"
Field Value
Type Description
System.String

DEF_BORDERS_PREF

Represents Borders pref.

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

DEF_BORDERTOP_CF

Represents border top constant.

Declaration
public const string DEF_BORDERTOP_CF = "border-top"
Field Value
Type Description
System.String

DEF_CELL_PREF

Represents Cell pref.

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

DEF_CENTER_HORIZONTAL_PREF

Represents center horizontal pref.

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

DEF_CENTER_VERTICAL_PREF

Represents center vertical pref.

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

DEF_COLON

Represents colon.

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

DEF_COLOR_PREF

Represents Color pref.

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

DEF_COLOR_STRING

Represents color string prefix.

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

DEF_COLUMN_DIV

Represents default column div.

Declaration
public const double DEF_COLUMN_DIV = 256
Field Value
Type Description
System.Double

DEF_COLUMN_PREF

Represents Column pref.

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

DEF_COMMENT_PREF

Represents Comment pref.

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

DEF_COMMENTS_LAYOUT_PREF

Represents print comments layout pref.

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

DEF_COMPARISION_OPERATORS_PREF

Represent the XML Spreadsheet Comparision operators

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

DEF_CONDITIONAL_FORMATTING_PREF

Represents ConditionalFormatting pref.

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

DEF_CONDITIONAL_PREF

Represents Condition pref.

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

DEF_DATA_PREF

Represents Data pref.

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

DEF_DATAVALIDATION_PREF

Represents DataValidation pref.

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

DEF_DEFAULTCOLUMNWIDTH_PREF

Represents DefaultColumnWidth pref.

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

DEF_DEFAULTROWHEIGHT_PREF

Represents DefaultRowHeight pref.

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

DEF_DISPLAY_GRIDLINES_PREF

Represents Do Not Display Gridlines pref.

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

DEF_DRAFT_QUALITY_PREF

Represents DraftQuality pref.

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

DEF_ERRORSTYLE

Represents the ErrorStyle Options

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

DEF_EXCELWORKBOOK_PREF

Represents ExcelWorkbook pref.

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

DEF_FACE_PREF

Represents Face pref.

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

DEF_FIRST_VISIBLE_ROW_PREF

Represents first visible row pref.

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

DEF_FIRST_VISIBLE_SHEET_PREF

Represents first visible sheet pref.

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

DEF_FIT_HEIGHT_PREF

Represents fit height pref.

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

DEF_FIT_WIDTH_PREF

Represents fit width pref.

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

DEF_FONT_BOLD_CF

Represents bold font weight.

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

DEF_FONT_COLOR_CF

Represents font color.

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

DEF_FONT_PREF

Represents Font pref.

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

DEF_FONT_REGULAR_CF

Represents regular font weight.

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

DEF_FONT_SIZE

Represents default font size.

Declaration
public const int DEF_FONT_SIZE = 8
Field Value
Type Description
System.Int32

DEF_FONT_STRIKETHROUGH_CF

Represents line through

Declaration
public const string DEF_FONT_STRIKETHROUGH_CF = "text-line-through"
Field Value
Type Description
System.String

DEF_FONT_STRIKETHROUGH_SINGLE_CF

Represents Single line through

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

DEF_FONT_STYLE_CF

Represents font style.

Declaration
public const string DEF_FONT_STYLE_CF = "font-style"
Field Value
Type Description
System.String

DEF_FONT_UNDERLINE_CF

Represents font underline.

Declaration
public const string DEF_FONT_UNDERLINE_CF = "text-underline-style"
Field Value
Type Description
System.String

DEF_FONT_WEIGHT_CF

Represents font weight style.

Declaration
public const string DEF_FONT_WEIGHT_CF = "font-weight"
Field Value
Type Description
System.String

DEF_FONTNAME_PREF

Represents FontName pref.

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

Represents footer pref.

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

DEF_FORMAT_PREF

Represents Format pref.

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

DEF_FORMULA_PREF

Represents Formula pref.

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

DEF_FREEZE_PANES_PREF

Represents freeze panes pref.

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

DEF_FROZEN_NOSPLIT_PANES_PREF

Represents freeze no split panes pref.

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

DEF_GRIDLINES_PREF

Represents gridlines pref.

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

DEF_HEADER_PREF

Represents header pref.

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

DEF_HEIGHT_PREF

Represents Height pref.

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

DEF_HIDDEN_PREF

Represents Hidden pref.

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

DEF_HIDEFORMULA_PREF

Represents HideFormula pref.

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

DEF_HORIZONTAL_PREF

Represents Horizontal pref.

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

DEF_HORIZONTAL_RESOLUTION_PREF

Represents horizontal resolution pref.

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

DEF_HREF_PREF

Represents hyper link reference pref.

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

DEF_HYPRER_TIP_PREF

Represents hyper link tip pref.

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

DEF_ID_PREF

Represents ID pref.

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

DEF_INDENT_PREF

Represents Indent pref.

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

DEF_INDEX_PREF

Represents Index pref.

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

DEF_INTERIOR_PREF

Represents Interior pref.

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

DEF_ITALIC_PREF

Represents Italic pref.

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

DEF_LAYOUT_PREF

Represents layout pref.

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

DEF_LEFT_TO_RIGHT_PREF

Represents LeftToRight pref.

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

DEF_LEFTCOLUMN_RIGHT_PANE_PREF

Represents left col right pane pref.

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

DEF_LINE_STYLE_PREF

Represents line style pref.

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

DEF_MARGIN_BOTTOM_PREF

Represents margin bottom pref.

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

DEF_MARGIN_LEFT_PREF

Represents margin left pref.

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

DEF_MARGIN_PREF

Represents margin pref.

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

DEF_MARGIN_RIGHT_PREF

Represents margin right pref.

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

DEF_MARGIN_TOP_PREF

Represents margin top pref.

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

DEF_MAX_COLUMN

Represents default maximum column index.

Declaration
public const int DEF_MAX_COLUMN = 256
Field Value
Type Description
System.Int32

DEF_MERGE_ACROSS_PREF

Represents merge column count pref.

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

DEF_MERGE_COD

Represents default cod for generate unique style index.

Declaration
public const long DEF_MERGE_COD = 10000000000L
Field Value
Type Description
System.Int64

DEF_MERGE_DOWN_PREF

Represents merge row count pref.

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

DEF_MIN_COLUMN

Represents default minimum column index.

Declaration
public const int DEF_MIN_COLUMN = 0
Field Value
Type Description
System.Int32

DEF_NAME_PREF

Represents Name pref.

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

DEF_NAMEDRANGE_PREF

Represents NamedRange pref.

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

DEF_NAMES_PREF

Represents Names pref.

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

DEF_NUMBER_OF_COPIES

Represents default numbers of copies to print.

Declaration
public const int DEF_NUMBER_OF_COPIES = 1
Field Value
Type Description
System.Int32

DEF_NUMBER_OF_COPIES_PREF

Represents number of copies to print.

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

DEF_NUMBER_PANE_PREF

Represents number pane pref.

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

DEF_NUMBERFORMAT_PREF

Represents NumberFormat pref.

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

DEF_ORIENTATION_PREF

Represents orientation pref.

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

DEF_OUTLINE_PREF

Represents Outline pref.

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

DEF_PAGE_MARGINS_PREF

Represents page margins pref.

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

DEF_PAGE_SETUP_PREF

Represents page setup pref.

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

DEF_PANE_PREF

Represents pane pref.

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

DEF_PANES_PREF

Represents panes pref.

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

DEF_PAPER_SIZE_INDEX_PREF

Represents paper size index pref.

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

DEF_PARENT_PREF

Represents Parent pref.

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

DEF_PATTERN_BACKGROUND_CF

Represents pattern back color.

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

DEF_PATTERN_FILL_CF

Represents fill pattern.

Declaration
public const string DEF_PATTERN_FILL_CF = "mso-pattern"
Field Value
Type Description
System.String

DEF_PATTERN_PREF

Represents Pattern pref.

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

DEF_PATTERN_STRING

Represents pattern string.

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

DEF_PATTERN_STRING_CF

Represents pattern string.

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

DEF_PATTERNCOLOR_PREF

Represents PatternColor pref.

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

DEF_POSITION_PREF

Represents Position pref.

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

DEF_PRINT_ERROR_STRING

Represents print error string.

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

DEF_PRINT_ERRORS_PREF

Represents print errors pref.

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

DEF_PRINT_LOCATION_STRING

Represents print location string.

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

DEF_PRINT_PREF

Represents print pref.

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

DEF_PROTECTED_PREF

Represents Protected pref.

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

DEF_PROTECTION_PREF

Represents Protection pref.

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

DEF_QUALIFIER_PREF

Represents Qualifier pref.

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

DEF_RANGE_PREF

Represents Range pref.

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

DEF_READINGORDER_PREF

Represents ReadingOrder pref.

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

DEF_REFERSTO_PREF

Represents RefersTo pref.

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

DEF_RIGHTTOLEFT_PREF

Represents RightToLeft pref.

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

DEF_ROTATE_PREF

Represents Rotate pref.

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

DEF_ROTATION_TEXT

Represents default rotation text.

Declaration
public const int DEF_ROTATION_TEXT = 255
Field Value
Type Description
System.Int32

DEF_ROW_DIV

Represents default row div.

Declaration
public const double DEF_ROW_DIV = 20
Field Value
Type Description
System.Double

DEF_ROW_HEIGHT

Represents default row Height.

Declaration
public const double DEF_ROW_HEIGHT = 12.75
Field Value
Type Description
System.Double

DEF_ROW_PREF

Represents Row pref.

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

DEF_ROWCOL_HEADINGS_PREF

Represents row and column headings pref.

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

DEF_SCALE_PREF

Represents Scale pref.

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

DEF_SEMICOLON

Represents semicolon.

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

DEF_SHADOW_PREF

Represents Shadow pref.

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

DEF_SHOWALWAYS_PREF

Represents ShowAlways pref.

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

DEF_SHRINKTOFIT_PREF

Represents ShrinkToFit pref.

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

DEF_SIZE_PREF

Represents Size pref.

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

DEF_SPAN_PREF

Represents Span pref.

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

DEF_SPLIT_HORIZONTAL_PANE_PREF

Represents split horizontal pane pref.

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

DEF_SPLIT_VERTICAL_PANE_PREF

Represents split vertical pane pref.

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

DEF_START_PAGE_NUMBER_PREF

Represents start page number pref.

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

DEF_STRIKETHROUGH_PREF

Represents StrikeThrough pref.

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

DEF_STYLE_NAME

Represents default style name.

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

DEF_STYLE_PREF

Represents Style pref.

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

DEF_STYLE_ROTATION

Represents rotation constant.

Declaration
public const int DEF_STYLE_ROTATION = 90
Field Value
Type Description
System.Int32

DEF_STYLE_ZERO

Represents zero constant.

Declaration
public const int DEF_STYLE_ZERO = 0
Field Value
Type Description
System.Int32

DEF_STYLEID_PREF

Represents StyleID pref.

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

DEF_STYLES_PREF

Represents Styles pref.

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

DEF_TABCOLOR_INDEX_PREF

Represents tab color index pref.

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

DEF_TABLE_PREF

Represents Table pref.

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

DEF_TOPROW_BOTTOM_PANE_PREF

Represents top row bottom pane pref.

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

DEF_TYPE_PREF

Represents Type pref.

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

DEF_UNDERLINE_PREF

Represents Underline pref.

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

DEF_VALUE1_PREF

Represents Value1 pref.

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

DEF_VALUE2_PREF

Represents Value2 pref.

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

DEF_VERSION_STRING

Represents xml version.

Declaration
public const string DEF_VERSION_STRING = "<?xml version=\"1.0\"?>"
Field Value
Type Description
System.String

DEF_VERTICAL_ALIGN_PREF

Represents vertical align pref.

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

DEF_VERTICAL_PREF

Represents Vertical pref.

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

DEF_VERTICALTEXT_PREF

Represents VerticalText pref.

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

DEF_VISIBLE_PREF

Represents Visible pref.

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

DEF_VISIBLE_STRING

Represents visibility string.

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

DEF_WEIGHT_PREF

Represents weight pref.

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

DEF_WIDTH_PREF

Represents Width pref.

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

DEF_WORKBOOK_PREF

Represents WorkBook pref.

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

DEF_WORKSHEET_OPTIONS_PREF

Represents worksheet options pref.

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

DEF_WORKSHEET_PREF

Represents WorkSheet pref.

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

DEF_WRAPTEXT_PREF

Represents WrapText pref.

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

DEF_ZOOM_PREF

Represents zoom pref.

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

Methods

GetCellIndexByUniqueId(Int64)

Gets cell index by unique id.

Declaration
public static long GetCellIndexByUniqueId(long lUniqueId)
Parameters
Type Name Description
System.Int64 lUniqueId

Represents unique id.
Returns
Type Description
System.Int64

Returns cell index.

GetSheetIndexByUniqueId(Int64)

Gets sheet index by unique id.

Declaration
public static int GetSheetIndexByUniqueId(long lUniqueId)
Parameters
Type Name Description
System.Int64 lUniqueId

Represents unique id.
Returns
Type Description
System.Int32

Returns sheet index.

GetUniqueID(Int32, Int64)

Gets unique id for coding sheet index and cell index.

Declaration
public static long GetUniqueID(int iSheetIndex, long lCellIndex)
Parameters
Type Name Description
System.Int32 iSheetIndex

Represents sheet index.
System.Int64 lCellIndex

Represents cell index.
Returns
Type Description
System.Int64

Returns unique id.

Serialize(XmlWriter, IWorkbook)

Serializes workbook to xml.

Declaration
public void Serialize(XmlWriter writer, IWorkbook book)
Parameters
Type Name Description
System.Xml.XmlWriter writer

Xml writer.
IWorkbook book

Workbook to serialize.

Implements