Spread.Sheets
Spreadスキーマ

これは、Spreadの完全バージョンのJSONスキーマです。

Schema
コードのコピー
{
    "$schema": "http://json-schema.org/draft-04/schema#",
    "title": "Spread",
    "description": "Represent a spreadsheet.",
    "type": "object",
    "properties": {
        "version": {
            "type": "string"
        },
        "sheets": {
            "type": "object",
            "patternProperties": {
                ".+": {
                    "$ref": "#/definitions/Sheet"
                }
            }
        },
        "namedStyles": {
            "type": "array",
            "description": "The name property of the Style in namedStyles can not be null,undefined or '',it must be set a value.",
            "items": {
                "$ref": "#/definitions/Style"
            }
        },
        "names": {
            "type": "array",
            "items": {
                "$ref": "#/definitions/NameInfo"
            }
        },
        "activeSheetIndex": {
            "type": "integer"
        },
        "sheetCount": {
            "type": "integer",
            "minimum": 0
        },
        "startSheetIndex": {
            "type": "integer",
            "default": 0
        },
        "sparklineExs": {
            "type": "array",
            "items": {
                "$ref": "#/definitions/SparklineEx"
            }
        },
        "customFunctions": {
            "type": "object",
            "patternProperties": {
                ".+": {
                    "$ref": "#/definitions/Function"
                }
            }
        },
        "canUserDragDrop": {
            "type": "boolean",
            "default": true
        },
        "canUserDragFill": {
            "type": "boolean",
            "default": true
        },
        "allowUserZoom": {
            "type": "boolean",
            "default": true
        },
        "allowUserResize": {
            "type": "boolean",
            "default": true
        },
        "allowUndo": {
            "type": "boolean",
            "default": true
        },
        "allowSheetReorder": {
            "type": "boolean",
            "default": true
        },
        "allowUserDragMerge": {
            "type": "boolean",
            "default": false
        },
        "defaultDragFillType": {
            "$ref": "#/definitions/AutoFillType",
            "default": 5
        },
        "showDragFillSmartTag": {
            "type": "boolean",
            "default": true
        },
        "showHorizontalScrollbar": {
            "type": "boolean",
            "default": true
        },
        "showVerticalScrollbar": {
            "type": "boolean",
            "default": true
        },
        "scrollbarShowMax": {
            "type": "boolean",
            "default": true
        },
        "scrollbarMaxAlign": {
            "type": "boolean",
            "default": false
        },
        "tabStripVisible": {
            "type": "boolean",
            "default": true
        },
        "tabStripRatio": {
            "type": "number",
            "default": 0.5
        },
        "tabEditable": {
            "type": "boolean",
            "default": true
        },
        "newTabVisible": {
            "type": "boolean",
            "default": true
        },
        "cutCopyIndicatorVisible": {
            "type": "boolean",
            "default": "true"
        },
        "cutCopyIndicatorBorderColor": {
            "type": "string",
            "default": "#217346"
        },
        "tabNavigationVisible": {
            "type": "boolean",
            "default": true
        },
        "backColor": {
            "type": "string",
            "default": "white"
        },
        "backgroundImage": {
            "type": "string"
        },
        "backgroundImageLayout": {
            "$ref": "#/definitions/ImageLayout",
            "default": 0
        },
        "showResizeTip": {
            "$ref": "#/definitions/ShowResizeTip",
            "default": 0
        },
        "showDragDropTip": {
            "type": "boolean",
            "default": true
        },
        "showDragFillTip": {
            "type": "boolean",
            "default": true
        },
        "scrollIgnoreHidden": {
            "type": "boolean",
            "default": false
        },
        "highlightInvalidData": {
            "type": "boolean",
            "default": false
        },
        "showScrollTip": {
            "$ref": "#/definitions/ShowScrollTip",
            "default": 0
        },
        "grayAreaBackColor": {
            "type": "string"
        },
        "useTouchLayout": {
            "type": "boolean",
            "default": false
        },
        "hideSelection": {
            "type": "boolean",
            "default": false
        },
        "resizeZeroIndicator": {
            "$ref": "#/definitions/ResizeZeroIndicator",
            "default": 1
        },
        "canUserEditFormula": {
            "type": "boolean",
            "default": true
        },
        "enableFormulaTextbox": {
            "type": "boolean",
            "default": true
        },
        "referenceStyle": {
            "$ref": "#/definitions/ReferenceStyle",
            "default": 0
        },
        "autoFitType": {
            "$ref": "#/definitions/AutoFitType",
            "default": 0
        },
        "font": {
            "type": "string"
        },
        "allowCopyPasteExcelStyle": {
            "type": "boolean",
            "default": true
        },
        "allowExtendPasteRange": {
            "type": "boolean",
            "default": false
        },
        "copyPasteHeaderOptions": {
            "$ref": "#/definitions/CopyPasteHeaderOptions",
            "default": 3
        }
    },
    "definitions": {
        "NameInfo": {
            "title": "NameInfo",
            "description": "Represents a custom named expression that can be used by formulas.",
            "type": "object",
            "properties": {
                "name": {
                    "type": "string"
                },
                "row": {
                    "type": "integer",
                    "minimum": 0
                },
                "col": {
                    "type": "integer",
                    "minimum": 0
                },
                "formula": {
                    "type": "string"
                },
                "comment": {
                    "type": "string"
                }
            }
        },
        "Style": {
            "title": "Style",
            "description": " Represents the style for a cell, row, and column.",
            "type": "object",
            "properties": {
                "backColor": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "foreColor": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "hAlign": {
                    "anyOf": [
                        {
                            "$ref": "#/definitions/HorizontalAlign"
                        },
                        {
                            "type": "null"
                        }
                    ]
                },
                "vAlign": {
                    "anyOf": [
                        {
                            "$ref": "#/definitions/VerticalAlign"
                        },
                        {
                            "type": "null"
                        }
                    ]
                },
                "font": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "themeFont": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "formatter": {
                    "anyOf": [
                        {
                            "type": [
                                "string",
                                "null"
                            ]
                        },
                        {
                            "$ref": "#/definitions/GeneralFormatter"
                        },
                        {
                            "$ref": "#/definitions/CustomFormatter"
                        }
                    ]
                },
                "borderLeft": {
                    "$ref": "#/definitions/LineBorder"
                },
                "borderTop": {
                    "$ref": "#/definitions/LineBorder"
                },
                "borderRight": {
                    "$ref": "#/definitions/LineBorder"
                },
                "borderBottom": {
                    "$ref": "#/definitions/LineBorder"
                },
                "diagonalUp": {
                    "$ref": "#/definitions/LineBorder"
                },
                "diagonalDown": {
                    "$ref": "#/definitions/LineBorder"
                },
                "locked": {
                    "type": [
                        "boolean",
                        "null"
                    ]
                },
                "textIndent": {
                    "type": [
                        "number",
                        "null"
                    ]
                },
                "wordWrap": {
                    "type": [
                        "boolean",
                        "null"
                    ]
                },
                "shrinkToFit": {
                    "type": [
                        "boolean",
                        "null"
                    ]
                },
                "isVerticalText": {
                    "type": [
                        "boolean",
                        "null"
                    ]
                },
                "backgroundImage": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "backgroundImageLayout": {
                    "anyOf": [
                        {
                            "$ref": "#/definitions/ImageLayout"
                        },
                        {
                            "type": "null"
                        }
                    ]
                },
                "cellType": {
                    "$ref": "#/definitions/CellType"
                },
                "tabStop": {
                    "type": [
                        "boolean",
                        "null"
                    ]
                },
                "name": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "parentName": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "textDecoration": {
                    "anyOf": [
                        {
                            "$ref": "#/definitions/TextDecorationType"
                        },
                        {
                            "type": "null"
                        }
                    ],
                    "default": 0
                },
                "imeMode": {
                    "anyOf": [
                        {
                            "$ref": "#/definitions/ImeMode"
                        },
                        {
                            "type": "null"
                        }
                    ]
                },
                "watermark": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "cellPadding": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "labelOptions": {
                    "$ref": "#/definitions/LabelOptions"
                },
                "quotePrefix": {
                    "type": [
                        "boolean",
                        "null"
                    ]
                }
            }
        },
        "CellType": {
            "title": "CellType",
            "anyOf": [
                {
                    "type": "null"
                },
                {
                    "$ref": "#/definitions/CornerCellType"
                },
                {
                    "$ref": "#/definitions/RowHeaderCellType"
                },
                {
                    "$ref": "#/definitions/ColumnHeaderCellType"
                },
                {
                    "$ref": "#/definitions/TextCellType"
                },
                {
                    "$ref": "#/definitions/ButtonCellType"
                },
                {
                    "$ref": "#/definitions/CheckBoxCellType"
                },
                {
                    "$ref": "#/definitions/ComboBoxCellType"
                },
                {
                    "$ref": "#/definitions/HyperLinkCellType"
                },
                {
                    "$ref": "#/definitions/BaseCellType"
                }
            ]
        },
        "BaseCellType": {
            "title": "BaseCellType",
            "description": "Represents the base class for the other cell type classes.",
            "type": "object",
            "properties": {
                "typeName": {
                    "description": "It's value is fixed value '0'.",
                    "type": "string"
                }
            }
        },
        "CornerCellType": {
            "title": "CornerCellType",
            "description": "Represents the painter of the corner cell.",
            "type": "object",
            "properties": {
                "typeName": {
                    "description": "It's value is fixed value '4'.",
                    "type": "string"
                }
            }
        },
        "RowHeaderCellType": {
            "title": "RowHeaderCellType",
            "description": "Represents the painter of the row header cells.",
            "type": "object",
            "properties": {
                "typeName": {
                    "description": "It's value is fixed value '3'.",
                    "type": "string"
                }
            }
        },
        "ColumnHeaderCellType": {
            "title": "ColumnHeaderCellType",
            "description": "Represents the painter of the column header cells.",
            "type": "object",
            "properties": {
                "typeName": {
                    "description": "It's value is fixed value '2'.",
                    "type": "string"
                }
            }
        },
        "TextCellType": {
            "title": "TextCellType",
            "description": "Represents a text cell type.",
            "type": "object",
            "properties": {
                "typeName": {
                    "description": "It's value is fixed value '1'.",
                    "type": "string"
                },
                "editorType": {
                    "$ref": "#/definitions/EditorType",
                    "default": 1
                }
            }
        },
        "ButtonCellType": {
            "title": "ButtonCellType",
            "description": " Represents a button cell.",
            "type": "object",
            "properties": {
                "typeName": {
                    "description": "It's value is fixed value '6'.",
                    "type": "string"
                },
                "marginTop": {
                    "type": "number",
                    "default": 2
                },
                "marginRight": {
                    "type": "number",
                    "default": 2
                },
                "marginBottom": {
                    "type": "number",
                    "default": 2
                },
                "marginLeft": {
                    "type": "number",
                    "default": 2
                },
                "text": {
                    "type": "string",
                    "default": ""
                },
                "buttonBackColor": {
                    "type": "string"
                }
            }
        },
        "CheckBoxCellType": {
            "title": "CheckBoxCellType",
            "description": "Represents a check box cell.",
            "type": "object",
            "properties": {
                "typeName": {
                    "description": "It's value is fixed value '5'.",
                    "type": "string"
                },
                "caption": {
                    "type": "string",
                    "default": ""
                },
                "textTrue": {
                    "type": "string",
                    "default": ""
                },
                "textIndeterminate": {
                    "type": "string",
                    "default": ""
                },
                "textFalse": {
                    "type": "string",
                    "default": ""
                },
                "textAlign": {
                    "$ref": "#/definitions/CheckBoxAlign",
                    "default": 3
                },
                "isThreeState": {
                    "type": "boolean",
                    "default": false
                }
            }
        },
        "ComboBoxCellType": {
            "title": "ComboBoxCellType",
            "description": "Represents an ordinary combo box cell.",
            "type": "object",
            "properties": {
                "typeName": {
                    "description": "It's value is fixed value '7'.",
                    "type": "string"
                },
                "editorValueType": {
                    "$ref": "#/definitions/EditorValueType",
                    "default": 0
                },
                "items": {
                    "type": "array",
                    "items": {
                        "type": [
                            "array",
                            "boolean",
                            "number",
                            "null",
                            "object",
                            "string"
                        ]
                    }
                },
                "itemHeight": {
                    "type": "integer",
                    "default": 22
                },
                "editable": {
                    "type": "boolean",
                    "default": false
                },
                "maxDropDownItems": {
                    "type": "integer",
                    "default": 20
                }
            }
        },
        "HyperLinkCellType": {
            "title": "HyperLinkCellType",
            "description": "Represents the hyperlink cell.",
            "type": "object",
            "properties": {
                "typeName": {
                    "description": "It's value is fixed value '8'.",
                    "type": "string"
                },
                "linkColor": {
                    "type": "string",
                    "default": "#0066cc"
                },
                "visitedLinkColor": {
                    "type": "string",
                    "default": "#3399ff"
                },
                "text": {
                    "type": "string",
                    "default": ""
                },
                "linkToolTip": {
                    "type": "string",
                    "default": ""
                },
                "target": {
                    "$ref": "#/definitions/HyperLinkTargetType",
                    "default": 0
                },
                "link": {
                    "type": "string",
                    "default": ""
                },
                "activeOnClick": {
                    "type": "boolean",
                    "default": true
                }
            }
        },
        "CheckBoxAlign": {
            "title": "CheckBoxAlign",
            "description": "Specifies the text alignment for check box cells. top:0,bottom:1,left:2,right:3.",
            "enum": [
                0,
                1,
                2,
                3
            ]
        },
        "EditorValueType": {
            "title": "EditorValueType",
            "description": "Specifies what is written out to the data model for a selected item from certain cell types that offer a selection of multiple values. text:0,index:1,value:2.",
            "enum": [
                0,
                1,
                2
            ]
        },
        "HyperLinkTargetType": {
            "title": "HyperLinkTargetType",
            "description": "Specifies the hyperlink's target type. blank:0,self:1,parent:2,top:3.",
            "enum": [
                0,
                1,
                2,
                3
            ]
        },
        "GeneralFormatter": {
            "title": "GeneralFormatter",
            "description": "Represents a formatter with the specified format mode and format string.",
            "type": "object",
            "properties": {
                "formatCached": {
                    "type": "string",
                    "default": "General"
                },
                "customerCultureName": {
                    "type": "string"
                }
            }
        },
        "CustomFormatter": {
            "title": "CustomFormatter",
            "description": "Represents a custom formatter with the specified format string.",
            "type": "object",
            "properties": {
                "formatCached": {
                    "type": "string"
                },
                "cultureName": {
                    "type": "string"
                },
                "typeName": {
                    "type": "string",
                    "default": ""
                }
            }
        },
        "HorizontalAlign": {
            "title": "HorizontalAlign",
            "description": "Indicates the horizontal alignment. left:0,center:1,right:2,general:3.",
            "enum": [
                0,
                1,
                2,
                3
            ]
        },
        "VerticalAlign": {
            "title": "VerticalAlign",
            "description": "Indicates the vertical alignment. top:0,center:1,bottom:2.",
            "enum": [
                0,
                1,
                2
            ]
        },
        "DefaultDataValidator": {
            "title": "DefaultDataValidator",
            "description": "Represents a data validator.",
            "type": "object",
            "properties": {
                "errorStyle": {
                    "$ref": "#/definitions/ErrorStyle",
                    "default": 0
                },
                "ignoreBlank": {
                    "type": "boolean",
                    "default": true
                },
                "inCellDropdown": {
                    "type": "boolean",
                    "default": true
                },
                "showInputMessage": {
                    "type": "boolean",
                    "default": true
                },
                "showErrorMessage": {
                    "type": "boolean",
                    "default": true
                },
                "inputTitle": {
                    "type": "string",
                    "default": ""
                },
                "errorTitle": {
                    "type": "string",
                    "default": ""
                },
                "inputMessage": {
                    "type": "string",
                    "default": ""
                },
                "errorMessage": {
                    "type": "string",
                    "default": ""
                },
                "comparisonOperator": {
                    "$ref": "#/definitions/ComparisonOperator",
                    "default": 6
                },
                "type": {
                    "$ref": "#/definitions/CriteriaType",
                    "default": 7
                },
                "condition": {
                    "$ref": "#/definitions/Condition"
                },
                "ranges": {
                    "type": "string"
                }
            }
        },
        "ErrorStyle": {
            "title": "ErrorStyle",
            "description": "Indicates the data validation error style. stop:0,warning:1,information:2.",
            "enum": [
                0,
                1,
                2
            ]
        },
        "CriteriaType": {
            "title": "CriteriaType",
            "description": "Indicates the data validator criteria type. anyValue:0,wholeNumber:1,decimalValues:2,list:3,date:4,time:5,textLength:6,custom:7.",
            "enum": [
                0,
                1,
                2,
                3,
                4,
                5,
                6,
                7
            ]
        },
        "Condition": {
            "title": "Condition",
            "description": "Represents a condition.",
            "type": "object",
            "anyOf": [
                {
                    "$ref": "#/definitions/RelationCondition"
                },
                {
                    "$ref": "#/definitions/NumberCondition"
                },
                {
                    "$ref": "#/definitions/TextCondition"
                },
                {
                    "$ref": "#/definitions/ColorCondition"
                },
                {
                    "$ref": "#/definitions/FormulaCondition"
                },
                {
                    "$ref": "#/definitions/DateCondition"
                },
                {
                    "$ref": "#/definitions/DateExCondition"
                },
                {
                    "$ref": "#/definitions/TextLengthCondition"
                },
                {
                    "$ref": "#/definitions/Top10Condition"
                },
                {
                    "$ref": "#/definitions/UniqueCondition"
                },
                {
                    "$ref": "#/definitions/AverageCondition"
                },
                {
                    "$ref": "#/definitions/CellValueCondition"
                },
                {
                    "$ref": "#/definitions/AreaCondition"
                }
            ]
        },
        "RelationCondition": {
            "title": "RelationCondition",
            "description": "Represents a relation condition with a specified relation type.",
            "type": "object",
            "properties": {
                "conType": {
                    "description": "relationCondition:0.",
                    "enum": [
                        0
                    ]
                },
                "compareType": {
                    "$ref": "#/definitions/LogicalOperators"
                },
                "item1": {
                    "$ref": "#/definitions/Condition"
                },
                "item2": {
                    "$ref": "#/definitions/Condition"
                },
                "ignoreBlank": {
                    "type": "boolean",
                    "default": false
                }
            }
        },
        "NumberCondition": {
            "title": "NumberCondition",
            "description": "Represents a number condition of the specified type with the specified expected value.",
            "type": "object",
            "properties": {
                "conType": {
                    "description": "numberCondition:1.",
                    "enum": [
                        1
                    ]
                },
                "compareType": {
                    "$ref": "#/definitions/GeneralComparisonOperators"
                },
                "integerValue": {
                    "type": "boolean",
                    "default": false
                },
                "expected": {
                    "type": "number"
                },
                "formula": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "ignoreBlank": {
                    "type": "boolean",
                    "default": false
                }
            }
        },
        "TextCondition": {
            "title": "TextCondition",
            "description": "Represents a text condition with the specified text comparison type based on the specified cell.",
            "type": "object",
            "properties": {
                "conType": {
                    "description": "textCondition:2.",
                    "enum": [
                        2
                    ]
                },
                "compareType": {
                    "$ref": "#/definitions/TextCompareType"
                },
                "ignoreCase": {
                    "type": "boolean",
                    "default": false
                },
                "useWildCards": {
                    "type": "boolean",
                    "default": true
                },
                "forceValue2Text": {
                    "type": "boolean",
                    "default": false
                },
                "expected": {
                    "type": "string"
                },
                "formula": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "regex": {
                    "$ref": "#/definitions/RegExp"
                },
                "ignoreBlank": {
                    "type": "boolean",
                    "default": false
                }
            }
        },
        "ColorCondition": {
            "title": "ColorCondition",
            "description": "Represents a style condition with the specified comparison type and expected color.",
            "type": "object",
            "properties": {
                "conType": {
                    "description": "colorCondition:3.",
                    "enum": [
                        3
                    ]
                },
                "compareType": {
                    "$ref": "#/definitions/ColorCompareType"
                },
                "expected": {
                    "type": "string"
                },
                "ignoreBlank": {
                    "type": "boolean",
                    "default": false
                }
            }
        },
        "FormulaCondition": {
            "title": "FormulaCondition",
            "description": "Represents a custom condition with a specified formula or expression.",
            "type": "object",
            "properties": {
                "conType": {
                    "description": "formulaCondition:4.",
                    "enum": [
                        4
                    ]
                },
                "customValueType": {
                    "$ref": "#/definitions/CustomValueType"
                },
                "expected": {
                    "type": "string"
                },
                "formula": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "ignoreBlank": {
                    "type": "boolean",
                    "default": false
                }
            }
        },
        "DateCondition": {
            "title": "DateCondition",
            "description": "Represents a date condition with the specified comparison type, expected date condition, and formula.",
            "type": "object",
            "properties": {
                "conType": {
                    "description": "dateCondition:5.",
                    "enum": [
                        5
                    ]
                },
                "compareType": {
                    "$ref": "#/definitions/DateCompareType"
                },
                "expected": {
                    "type": "string"
                },
                "formula": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "ignoreBlank": {
                    "type": "boolean",
                    "default": false
                }
            }
        },
        "DateExCondition": {
            "title": "DateExCondition",
            "description": "Represents a date condition with the specified comparison type, expected date condition, and formula.",
            "type": "object",
            "properties": {
                "conType": {
                    "description": "dateExCondition:6.",
                    "enum": [
                        6
                    ]
                },
                "expectTypeId": {
                    "type": "integer",
                    "default": 0
                },
                "ignoreBlank": {
                    "type": "boolean",
                    "default": false
                },
                "formula": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "expected": {
                    "$ref": "#/definitions/DateOccurringType"
                }
            }
        },
        "TextLengthCondition": {
            "title": "TextLengthCondition",
            "description": "Represents a text length condition with the specified comparison type, expected number, and formula.",
            "type": "object",
            "properties": {
                "conType": {
                    "description": "textLengthCondition:7.",
                    "enum": [
                        7
                    ]
                },
                "compareType": {
                    "$ref": "#/definitions/GeneralComparisonOperators"
                },
                "expected": {
                    "type": "string"
                },
                "formula": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "ignoreBlank": {
                    "type": "boolean",
                    "default": false
                }
            }
        },
        "Top10Condition": {
            "title": "Top10Condition",
            "description": "Represents a top 10 condition with the specified type and rank, for the specified cell ranges.",
            "type": "object",
            "properties": {
                "conType": {
                    "description": "top10Condition:8.",
                    "enum": [
                        8
                    ]
                },
                "type": {
                    "$ref": "#/definitions/Top10ConditionType"
                },
                "isPercent": {
                    "type": "boolean",
                    "default": false
                },
                "ranges": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Range"
                    }
                },
                "expected": {
                    "type": "number"
                },
                "formula": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "ignoreBlank": {
                    "type": "boolean",
                    "default": false
                }
            }
        },
        "UniqueCondition": {
            "title": "UniqueCondition",
            "description": " Represents a unique condition and sets whether to check for duplicate data.",
            "type": "object",
            "properties": {
                "conType": {
                    "description": "uniqueCondition:9.",
                    "enum": [
                        9
                    ]
                },
                "ranges": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Range"
                    }
                },
                "expected": {
                    "type": "boolean"
                },
                "formula": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "ignoreBlank": {
                    "type": "boolean",
                    "default": false
                }
            }
        },
        "AverageCondition": {
            "title": "AverageCondition",
            "description": "Represents a new average condition of the specified type for the specified cell ranges.",
            "type": "object",
            "properties": {
                "conType": {
                    "description": "averageCondition:10.",
                    "enum": [
                        10
                    ]
                },
                "type": {
                    "$ref": "#/definitions/AverageConditionType"
                },
                "ranges": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Range"
                    }
                },
                "ignoreBlank": {
                    "type": "boolean",
                    "default": false
                }
            }
        },
        "CellValueCondition": {
            "title": "CellValueCondition",
            "description": "Represents a cell value condition with a specified compare type, expected value, and formula.",
            "type": "object",
            "properties": {
                "conType": {
                    "description": "cellValueCondition:11.",
                    "enum": [
                        11
                    ]
                },
                "compareType": {
                    "$ref": "#/definitions/GeneralComparisonOperators"
                },
                "treatNullValueAsZero": {
                    "type": "boolean",
                    "default": false
                },
                "expected": {
                    "type": "string"
                },
                "formula": {
                    "type": [
                        "string",
                        "null"
                    ]
                }
            }
        },
        "AreaCondition": {
            "title": "AreaCondition",
            "description": "Represents an area condition using the expected source or formula.",
            "type": "object",
            "properties": {
                "conType": {
                    "description": "areaConditon:12.",
                    "enum": [
                        12
                    ]
                },
                "expected": {
                    "type": "string"
                },
                "formula": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "ignoreBlank": {
                    "type": "boolean",
                    "default": false
                }
            }
        },
        "GeneralComparisonOperators": {
            "title": "GeneralComparisonOperators",
            "description": "Specifies the general operator. equalsTo:0,notEqualsTo:1,greaterThan:2,greaterThanOrEqualsTo:3,lessThan:4,lessThanOrEqualsTo:5.",
            "enum": [
                0,
                1,
                2,
                3,
                4,
                5
            ]
        },
        "LogicalOperators": {
            "title": "LogicalOperators",
            "description": "Specifies the relation operator. or:0,and:1.",
            "enum": [
                0,
                1
            ]
        },
        "ComparisonOperator": {
            "title": "ComparisonOperator",
            "description": "Specifies the comparison operator. equalsTo:0,notEqualsTo:1,greaterThan:2,greaterThanOrEqualsTo:3,lessThan:4,lessThanOrEqualsTo:5,between:6,notBetween:7.",
            "enum": [
                0,
                1,
                2,
                3,
                4,
                5,
                6,
                7
            ]
        },
        "TextComparisonOperator": {
            "title": "TextComparisonOperator",
            "description": "Specifies the text comparison operator. contains:0,doesNotContain:1,beginsWith:2,endsWith:3.",
            "enum": [
                0,
                1,
                2,
                3
            ]
        },
        "TextCompareType": {
            "title": "TextCompareType",
            "description": "Specifies the text compare type. 0:equalsTo,1:notEqualsTo,2:beginsWith,3:doesNotBeginWith,4:endsWith,5:doesNotEndWith,6:contains,7:doesNotContain.",
            "enum": [
                0,
                1,
                2,
                3,
                4,
                5,
                6,
                7
            ]
        },
        "ColorCompareType": {
            "title": "ColorCompareType",
            "description": "Specifies the color compare type. backgroundColor:0,foregroundColor:1.",
            "enum": [
                0,
                1
            ]
        },
        "CustomValueType": {
            "title": "CustomValueType",
            "description": "Specifies the custom value type. empty:0,nonEmpty:1,error:2,nonError:3,formula:4.",
            "enum": [
                0,
                1,
                2,
                3,
                4
            ]
        },
        "DateCompareType": {
            "title": "DateCompareType",
            "description": "Specifies the date compare type. equalsTo:0,notEqualsTo:1,before:2,beforeEqualsTo:3,after:4,afterEqualsTo:5.",
            "enum": [
                0,
                1,
                2,
                3,
                4,
                5
            ]
        },
        "DateOccurringType": {
            "title": "DateOccurringType",
            "description": "Specifies the date occurring type. today:0,yesterday:1,tomorrow:2,last7Days:3,thisMonth:4,lastMonth:5,nextMonth:6,thisWeek:7,lastWeek:8,nextWeek:9.",
            "enum": [
                0,
                1,
                2,
                3,
                4,
                5,
                6,
                7,
                8,
                9
            ]
        },
        "Top10ConditionType": {
            "title": "Top10ConditionType",
            "description": "Specifies the top 10 condition type. top:0,bottom:1.",
            "enum": [
                0,
                1
            ]
        },
        "AverageConditionType": {
            "title": "AverageConditionType",
            "description": "Specifies the average condition type. above:0,below:1,equalOrAbove:2,equalOrBelow:3,above1StdDev:4,below1StdDev:5,above2StdDev:6,below2StdDev:7,above3StdDev:8,below3StdDev:9.",
            "enum": [
                0,
                1,
                2,
                3,
                4,
                5,
                6,
                7,
                8,
                9
            ]
        },
        "Rule": {
            "title": "Rule",
            "type": "object",
            "anyOf": [
                {
                    "$ref": "#/definitions/CellValueRule"
                },
                {
                    "$ref": "#/definitions/SpecificTextRule"
                },
                {
                    "$ref": "#/definitions/FormulaRule"
                },
                {
                    "$ref": "#/definitions/DateOccurringRule"
                },
                {
                    "$ref": "#/definitions/Top10Rule"
                },
                {
                    "$ref": "#/definitions/UniqueRule"
                },
                {
                    "$ref": "#/definitions/DuplicateRule"
                },
                {
                    "$ref": "#/definitions/AverageRule"
                },
                {
                    "$ref": "#/definitions/TwoScaleRule"
                },
                {
                    "$ref": "#/definitions/ThreeScaleRule"
                },
                {
                    "$ref": "#/definitions/DataBarRule"
                },
                {
                    "$ref": "#/definitions/IconSetRule"
                }
            ]
        },
        "CellValueRule": {
            "title": "CellValueRule",
            "description": "Represents a cell value conditional rule.",
            "type": "object",
            "properties": {
                "ruleType": {
                    "description": "cellValueRule:1.",
                    "enum": [
                        1
                    ]
                },
                "ranges": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Range"
                    }
                },
                "style": {
                    "$ref": "#/definitions/Style"
                },
                "stopIfTrue": {
                    "type": "boolean",
                    "default": false
                },
                "priority": {
                    "type": "integer",
                    "default": 1
                },
                "operator": {
                    "$ref": "#/definitions/ComparisonOperator"
                },
                "value1": {
                    "type": [
                        "array",
                        "boolean",
                        "number",
                        "null",
                        "object",
                        "string"
                    ]
                },
                "value2": {
                    "type": [
                        "array",
                        "boolean",
                        "number",
                        "null",
                        "object",
                        "string"
                    ]
                }
            }
        },
        "SpecificTextRule": {
            "title": "SpecificTextRule",
            "description": "Represents a specific text rule based on the specified cell.",
            "type": "object",
            "properties": {
                "ruleType": {
                    "description": "specificTextRule:2.",
                    "enum": [
                        2
                    ]
                },
                "ranges": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Range"
                    }
                },
                "style": {
                    "$ref": "#/definitions/Style"
                },
                "stopIfTrue": {
                    "type": "boolean",
                    "default": false
                },
                "priority": {
                    "type": "integer",
                    "default": 1
                },
                "operator": {
                    "$ref": "#/definitions/TextComparisonOperator"
                },
                "text": {
                    "type": "string"
                }
            }
        },
        "FormulaRule": {
            "title": "FormulaRule",
            "description": "Represents a formula rule with the specified formula and style.",
            "type": "object",
            "properties": {
                "ruleType": {
                    "description": "formulaRule:3.",
                    "enum": [
                        3
                    ]
                },
                "ranges": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Range"
                    }
                },
                "style": {
                    "$ref": "#/definitions/Style"
                },
                "stopIfTrue": {
                    "type": "boolean",
                    "default": false
                },
                "priority": {
                    "type": "integer",
                    "default": 1
                },
                "formula": {
                    "type": [
                        "string",
                        "null"
                    ]
                }
            }
        },
        "DateOccurringRule": {
            "title": "DateOccurringRule",
            "description": "Represents a DateOccurringRule with the specified type and style.",
            "type": "object",
            "properties": {
                "ruleType": {
                    "description": "dateOccurringRule:4.",
                    "enum": [
                        4
                    ]
                },
                "ranges": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Range"
                    }
                },
                "style": {
                    "$ref": "#/definitions/Style"
                },
                "type": {
                    "$ref": "#/definitions/DateOccurringType"
                },
                "priority": {
                    "type": "integer",
                    "default": 1
                },
                "stopIfTrue": {
                    "type": "boolean",
                    "default": false
                }
            }
        },
        "Top10Rule": {
            "title": "Top10Rule",
            "description": "Represents a formula rule with the specified formula and style.",
            "type": "object",
            "properties": {
                "ruleType": {
                    "description": "top10Rule:5.",
                    "enum": [
                        5
                    ]
                },
                "ranges": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Range"
                    }
                },
                "style": {
                    "$ref": "#/definitions/Style"
                },
                "stopIfTrue": {
                    "type": "boolean",
                    "default": false
                },
                "priority": {
                    "type": "integer",
                    "default": 1
                },
                "type": {
                    "$ref": "#/definitions/Top10ConditionType"
                },
                "rank": {
                    "type": "integer"
                }
            }
        },
        "UniqueRule": {
            "title": "UniqueRule",
            "description": "",
            "type": "object",
            "properties": {
                "ruleType": {
                    "description": "uniqueRule:6.",
                    "enum": [
                        6
                    ]
                },
                "ranges": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Range"
                    }
                },
                "style": {
                    "$ref": "#/definitions/Style"
                },
                "stopIfTrue": {
                    "type": "boolean",
                    "default": false
                },
                "priority": {
                    "type": "integer",
                    "default": 1
                }
            }
        },
        "DuplicateRule": {
            "title": "DuplicateRule",
            "description": "Represents a duplicate conditional rule.",
            "type": "object",
            "properties": {
                "ruleType": {
                    "description": "duplicateRule:7.",
                    "enum": [
                        7
                    ]
                },
                "ranges": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Range"
                    }
                },
                "style": {
                    "$ref": "#/definitions/Style"
                },
                "stopIfTrue": {
                    "type": "boolean",
                    "default": false
                },
                "priority": {
                    "type": "integer",
                    "default": 1
                }
            }
        },
        "AverageRule": {
            "title": "AverageRule",
            "description": "Represents a average conditional rule.",
            "type": "object",
            "properties": {
                "ruleType": {
                    "description": "averageRule:8.",
                    "enum": [
                        8
                    ]
                },
                "ranges": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Range"
                    }
                },
                "style": {
                    "$ref": "#/definitions/Style"
                },
                "stopIfTrue": {
                    "type": "boolean",
                    "default": false
                },
                "priority": {
                    "type": "integer",
                    "default": 1
                },
                "type": {
                    "$ref": "#/definitions/AverageConditionType"
                }
            }
        },
        "TwoScaleRule": {
            "title": "TwoScaleRule",
            "description": " Represents a two-color conditional scale rule with the specified parameters.",
            "type": "object",
            "properties": {
                "ruleType": {
                    "description": "twoScaleRule:10.",
                    "enum": [
                        10
                    ]
                },
                "ranges": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Range"
                    }
                },
                "priority": {
                    "type": "integer",
                    "default": 1
                },
                "minType": {
                    "$ref": "#/definitions/ScaleValueType"
                },
                "minValue": {
                    "type": [
                        "array",
                        "boolean",
                        "number",
                        "null",
                        "object",
                        "string"
                    ]
                },
                "minColor": {
                    "type": "string"
                },
                "maxType": {
                    "$ref": "#/definitions/ScaleValueType"
                },
                "maxValue": {
                    "type": [
                        "array",
                        "boolean",
                        "number",
                        "null",
                        "object",
                        "string"
                    ]
                },
                "maxColor": {
                    "type": "string"
                }
            }
        },
        "ThreeScaleRule": {
            "title": "ThreeScaleRule",
            "description": "Represents a three-color scale conditional rule with the specified parameters.",
            "type": "object",
            "properties": {
                "ruleType": {
                    "description": "threeScaleRule:11.",
                    "enum": [
                        11
                    ]
                },
                "ranges": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Range"
                    }
                },
                "priority": {
                    "type": "integer",
                    "default": 1
                },
                "minType": {
                    "$ref": "#/definitions/ScaleValueType"
                },
                "minValue": {
                    "type": [
                        "array",
                        "boolean",
                        "number",
                        "null",
                        "object",
                        "string"
                    ]
                },
                "minColor": {
                    "type": "string"
                },
                "midType": {
                    "$ref": "#/definitions/ScaleValueType"
                },
                "midValue": {
                    "type": [
                        "array",
                        "boolean",
                        "number",
                        "null",
                        "object",
                        "string"
                    ]
                },
                "midColor": {
                    "type": "string"
                },
                "maxType": {
                    "$ref": "#/definitions/ScaleValueType"
                },
                "maxValue": {
                    "type": [
                        "array",
                        "boolean",
                        "number",
                        "null",
                        "object",
                        "string"
                    ]
                },
                "maxColor": {
                    "type": "string"
                }
            }
        },
        "DataBarRule": {
            "title": "DataBarRule",
            "description": " Represents a data bar conditional rule with the specified parameters.",
            "type": "object",
            "properties": {
                "ruleType": {
                    "description": "dataBarRule:12.",
                    "enum": [
                        12
                    ]
                },
                "ranges": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Range"
                    }
                },
                "priority": {
                    "type": "integer",
                    "default": 1
                },
                "minType": {
                    "$ref": "#/definitions/ScaleValueType"
                },
                "minValue": {
                    "type": [
                        "array",
                        "boolean",
                        "number",
                        "null",
                        "object",
                        "string"
                    ]
                },
                "maxType": {
                    "$ref": "#/definitions/ScaleValueType"
                },
                "maxValue": {
                    "type": [
                        "array",
                        "boolean",
                        "number",
                        "null",
                        "object",
                        "string"
                    ]
                },
                "gradient": {
                    "type": "boolean",
                    "default": true
                },
                "color": {
                    "type": "string"
                },
                "showBorder": {
                    "type": "boolean",
                    "default": false
                },
                "borderColor": {
                    "type": "string",
                    "default": "black"
                },
                "dataBarDirection": {
                    "$ref": "#/definitions/BarDirection",
                    "default": 0
                },
                "negativeFillColor": {
                    "type": "string",
                    "default": "red"
                },
                "useNegativeFillColor": {
                    "type": "boolean",
                    "default": true
                },
                "negativeBorderColor": {
                    "type": "string",
                    "default": "black"
                },
                "useNegativeBorderColor": {
                    "type": "boolean",
                    "default": false
                },
                "axisPosition": {
                    "$ref": "#/definitions/DataBarAxisPosition",
                    "default": 0
                },
                "axisColor": {
                    "type": "string",
                    "default": "black"
                },
                "showBarOnly": {
                    "type": "boolean",
                    "default": false
                }
            }
        },
        "IconSetRule": {
            "title": "IconSetRule",
            "description": "Represents an icon set rule with the specified parameters.",
            "type": "object",
            "properties": {
                "ruleType": {
                    "description": "iconSetRule:13.",
                    "enum": [
                        13
                    ]
                },
                "ranges": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Range"
                    }
                },
                "priority": {
                    "type": "integer",
                    "default": 1
                },
                "iconSetType": {
                    "$ref": "#/definitions/IconSetType"
                },
                "iconCriteria": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/IconCriterion"
                    }
                },
                "icons": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/IconInfo"
                    }
                },
                "showIconOnly": {
                    "type": "boolean",
                    "default": false
                },
                "reverseIconOrder": {
                    "type": "boolean",
                    "default": false
                }
            }
        },
        "IconCriterion": {
            "title": "IconCriterion",
            "description": "Represents an icon criteria with the specified parameters.",
            "type": "object",
            "properties": {
                "isGreaterThanOrEqualTo": {
                    "type": "boolean"
                },
                "iconValueType": {
                    "$ref": "#/definitions/IconValueType"
                },
                "iconValue": {
                    "type": [
                        "array",
                        "boolean",
                        "number",
                        "null",
                        "object",
                        "string"
                    ]
                }
            }
        },
        "IconInfo": {
            "title": "IconInfo",
            "description": "Represents an specified icon.",
            "type": "object",
            "properties": {
                "iconSetType": {
                    "$ref": "#/definitions/IconSetType"
                },
                "iconIndex": {
                    "type": "integer"
                }
            }
        },
        "IconValueType": {
            "title": "IconValueType",
            "description": "Indicates whether to return a specified number directly. number:1,percent:4,percentile:5,formula:7.",
            "enum": [
                1,
                4,
                5,
                7
            ]
        },
        "ScaleValueType": {
            "title": "ScaleValueType",
            "description": "Specifies the scale value type. number:0,lowestValue:1,highestValue:2,percent:3,percentile:4,automin:5,formula:6,automax:7.",
            "enum": [
                0,
                1,
                2,
                3,
                4,
                5,
                6,
                7
            ]
        },
        "BarDirection": {
            "title": "BarDirection",
            "description": "Specifies the data bar direction. leftToRight:0,rightToLeft:1.",
            "enum": [
                0,
                1
            ]
        },
        "DataBarAxisPosition": {
            "title": "DataBarAxisPosition",
            "description": "Specifies the position of the data bar's axis. automatic:0,cellMidPoint:1,none:2.",
            "enum": [
                0,
                1,
                2
            ]
        },
        "IconSetType": {
            "title": "IconSetType",
            "description": "Specifies the icon set. threeArrowsColored:0,threeArrowGray:1,threeTriangles:2,threeStars:3,threeFlags:4,threeTrafficLightsUnrimmed:5,threeTrafficLightsRimmed:6,threeSigns:7,threeSymbolsCircled:8,threeSymbolsUncircled:9,fourArrowsColored:10,fourArrowGray:11,fourRedToBlack:12,fourRatings:13,fourTrafficLights:14,fiveArrowsColored:15,fiveArrowsGray:16,fiveRatings:17,fiveQuarters:18,fiveBoxes:19,noIcons:20.",
            "enum": [
                0,
                1,
                2,
                3,
                4,
                5,
                6,
                7,
                8,
                9,
                10,
                11,
                12,
                13,
                14,
                15,
                16,
                17,
                18,
                19,
                20
            ]
        },
        "RegExp": {
            "title": "RegExp",
            "description": "A javaScript build in object,represent a RegExp",
            "type": "object",
            "properties": {
                "source": {
                    "type": "string"
                },
                "global": {
                    "type": "boolean",
                    "default": false
                },
                "ignoreCase": {
                    "type": "boolean",
                    "default": false
                },
                "multiline": {
                    "type": "boolean",
                    "default": false
                },
                "lastIndex": {
                    "type": "integer"
                }
            }
        },
        "LineBorder": {
            "title": "LineBorder",
            "description": "Indicates the color of the border line. Use a known color name or HEX style color value. The default value is black.",
            "type": [
                "object",
                "null"
            ],
            "properties": {
                "color": {
                    "type": "string",
                    "default": "black"
                },
                "style": {
                    "$ref": "#/definitions/LineStyle",
                    "default": 0
                }
            }
        },
        "LineStyle": {
            "title": "LineStyle",
            "description": "Specifies the line drawing style for the border. empty:0,thin:1,medium:2,dashed:3,dotted:4,thick:5,double:6,hair:7,mediumDashed:8,dashDot:9,mediumDashDot:10,dashDotDot:11,mediumDashDotDot:12,slantedDashDot:13.",
            "enum": [
                0,
                1,
                2,
                3,
                4,
                5,
                6,
                7,
                8,
                9,
                10,
                11,
                12,
                13
            ]
        },
        "TextDecorationType": {
            "title": "TextDecorationType",
            "description": " Defines the type of the text decoration. none:0,underline:1,lineThrough:2,overline:4,doubleUnderline:8.",
            "enum": [
                0,
                1,
                2,
                3,
                4,
                5,
                6,
                7,
                8,
                9,
                10,
                11,
                12,
                13,
                14,
                15
            ]
        },
        "ImeMode": {
            "title": "ImeMode",
            "description": "Defines the ime mode to controls the state of the Input Method Editor (IME). disabled:0,auto:1,active:2,inactive:4.",
            "enum": [
                0,
                1,
                2,
                4
            ]
        },
        "ReferenceStyle": {
            "title": "ReferenceStyle",
            "description": "Specifies the formula reference style. a1:0,r1c1:1.",
            "enum": [
                0,
                1
            ]
        },
        "AutoFillType": {
            "title": "AutoFillType",
            "description": "Represents the type of drag fill. copyCells:0,fillSeries:1,fillFormattingOnly:2,fillWithoutFormatting:3,flearValues:4,auto:5.",
            "enum": [
                0,
                1,
                2,
                3,
                4,
                5
            ]
        },
        "AutoFitType": {
            "title": "AutoFitType",
            "description": "Represents whether the component autofits cells or headers. cell:0,cellWithHeader:1.",
            "enum": [
                0,
                1
            ]
        },
        "ShowScrollTip": {
            "title": "ShowScrollTip",
            "description": "Specifies how the scroll tip is displayed. none:0,horizontal:1,vertical:2,both:3",
            "enum": [
                0,
                1,
                2,
                3
            ]
        },
        "ShowResizeTip": {
            "title": "ShowResizeTip",
            "description": "Defines how the resize tip is displayed. none:0,column:1,row:2,both:3",
            "enum": [
                0,
                1,
                2,
                3
            ]
        },
        "ImageLayout": {
            "title": "ImageLayout",
            "description": "Defines the background image layout. stretch:0,center:1,zoom:2,none:3.",
            "enum": [
                0,
                1,
                2,
                3
            ]
        },
        "Sheet": {
            "title": "Sheet",
            "description": "Represent a sheet",
            "type": "object",
            "properties": {
                "name": {
                    "type": "string"
                },
                "defaults": {
                    "$ref": "#/definitions/SheetDefaultOption"
                },
                "frozenRowCount": {
                    "type": "integer",
                    "default": 0
                },
                "frozenColCount": {
                    "type": "integer",
                    "default": 0
                },
                "frozenTrailingRowCount": {
                    "type": "integer",
                    "default": 0
                },
                "frozenTrailingColCount": {
                    "type": "integer",
                    "default": 0
                },
                "rowCount": {
                    "type": "integer"
                },
                "columnCount": {
                    "type": "integer"
                },
                "activeRow": {
                    "type": "integer",
                    "default": 0
                },
                "activeCol": {
                    "type": "integer",
                    "default": 0
                },
                "zoomFactor": {
                    "type": "number",
                    "minimum": 0.25,
                    "maximum": 4.0,
                    "default": 1.0
                },
                "rowHeaderColCount": {
                    "type": "integer",
                    "default": 1
                },
                "colHeaderRowCount": {
                    "type": "integer",
                    "default": 1
                },
                "visible": {
                    "type": "boolean",
                    "default": true
                },
                "tag": {
                    "type": [
                        "array",
                        "boolean",
                        "number",
                        "null",
                        "object",
                        "string"
                    ]
                },
                "spans": {
                    "$ref": "#/definitions/SpanModel"
                },
                "rowHeaderSpan": {
                    "$ref": "#/definitions/SpanModel"
                },
                "colHeaderSpan": {
                    "$ref": "#/definitions/SpanModel"
                },
                "data": {
                    "$ref": "#/definitions/SheetModel"
                },
                "rowHeaderData": {
                    "$ref": "#/definitions/SheetModel"
                },
                "colHeaderData": {
                    "$ref": "#/definitions/SheetModel"
                },
                "selections": {
                    "$ref": "#/definitions/SelectionModel"
                },
                "theme": {
                    "anyOf": [
                        {
                            "type": "string"
                        },
                        {
                            "$ref": "#/definitions/SpreadTheme"
                        }
                    ]
                },
                "rows": {
                    "type": "array",
                    "items": {
                        "anyOf": [
                            {
                                "type": "null"
                            },
                            {
                                "$ref": "#/definitions/RowColInfo"
                            }
                        ]
                    }
                },
                "columns": {
                    "type": "array",
                    "items": {
                        "anyOf": [
                            {
                                "type": "null"
                            },
                            {
                                "$ref": "#/definitions/RowColInfo"
                            }
                        ]
                    }
                },
                "rowHeaderColInfos": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/RowColInfo"
                    }
                },
                "colHeaderRowInfos": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/RowColInfo"
                    }
                },
                "namedStyles": {
                    "type": "array",
                    "description": "The name property of the Style in namedStyles can not be null,undefined or '',it must be set a value.",
                    "items": {
                        "$ref": "#/definitions/Style"
                    }
                },
                "names": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/NameInfo"
                    }
                },
                "rowFilter": {
                    "anyOf": [
                        {
                            "$ref": "#/definitions/HideRowFilter"
                        },
                        {
                            "$ref": "#/definitions/RowFilterBase"
                        }
                    ]
                },
                "autoGenerateColumns": {
                    "type": "boolean",
                    "default": true
                },
                "sparklineGroups": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/SparklineGroup"
                    }
                },
                "comments": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Comment"
                    }
                },
                "showRowOutline": {
                    "type": "boolean",
                    "default": true
                },
                "showColumnOutline": {
                    "type": "boolean",
                    "default": true
                },
                "rowOutlines": {
                    "$ref": "#/definitions/Outline"
                },
                "columnOutlines": {
                    "$ref": "#/definitions/Outline"
                },
                "conditionalFormats": {
                    "type": "object",
                    "properties": {
                        "rules": {
                            "type": "array",
                            "items": {
                                "$ref": "#/definitions/Rule"
                            }
                        }
                    }
                },
                "tables": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/SheetTable"
                    }
                },
                "floatingObjects": {
                    "type": "array",
                    "items": {
                        "anyOf": [
                            {
                                "$ref": "#/definitions/FloatingObject"
                            },
                            {
                                "$ref": "#/definitions/Picture"
                            }
                        ]
                    }
                },
                "customFunctions": {
                    "type": "object",
                    "patternProperties": {
                        ".+": {
                            "$ref": "#/definitions/Function"
                        }
                    }
                },
                "printInfo": {
                    "$ref": "#/definitions/PrintInfo"
                },
                "slicers": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Slicer"
                    }
                },
                "allowCellOverflow": {
                    "type": "boolean",
                    "default": true
                },
                "sheetTabColor": {
                    "type": "string"
                },
                "frozenlineColor": {
                    "type": "string",
                    "default": "black"
                },
                "clipBoardOptions": {
                    "$ref": "#/definitions/ClipboardPasteOptions",
                    "default": 0
                },
                "gridline": {
                    "$ref": "#/definitions/SheetGridlineOption"
                },
                "sheetAreaOffset": {
                    "$ref": "#/definitions/SheetAreaOffsetOption"
                },
                "rowHeaderVisible": {
                    "type": "boolean",
                    "default": true
                },
                "colHeaderVisible": {
                    "type": "boolean",
                    "default": true
                },
                "rowHeaderAutoText": {
                    "$ref": "#/definitions/HeaderAutoText",
                    "default": 1
                },
                "colHeaderAutoText": {
                    "$ref": "#/definitions/HeaderAutoText",
                    "default": 2
                },
                "rowHeaderAutoTextIndex": {
                    "type": "integer",
                    "default": -1
                },
                "colHeaderAutoTextIndex": {
                    "type": "integer",
                    "default": -1
                },
                "isProtected": {
                    "type": "boolean",
                    "default": false
                },
                "protectionOptions": {
                    "$ref": "#/definitions/ProtectionOption"
                },
                "selectionBackColor": {
                    "type": "string",
                    "default": "rgba(180,180,200,0.2)"
                },
                "selectionBorderColor": {
                    "type": "string",
                    "default": "black"
                },
                "borderColor": {
                    "type": "string",
                    "default": "black"
                },
                "borderWidth": {
                    "type": "integer",
                    "minimum": 0,
                    "default": 0
                },
                "validations": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/DefaultDataValidator"
                    }
                },
                "charts": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Chart"
                    }
                },
                "outlineColumnOptions": {
                    "$ref": "#/definitions/OutlineColumnOptions"
                }
            }
        },
        "SelectionModel": {
            "title": "SelectionModel",
            "description": "Represent a data model for cell selection.",
            "type": "object",
            "properties": {
                "selectionPolicy": {
                    "$ref": "#/definitions/SelectionPolicy",
                    "default": 2
                },
                "selectionUnit": {
                    "$ref": "#/definitions/SelectionUnit",
                    "default": 0
                },
                "activeSelectedRangeIndex": {
                    "type": "integer"
                },
                "length": {
                    "type": "integer",
                    "minimum": 0
                }
            },
            "patternProperties": {
                "[0-9]+": {
                    "$ref": "#/definitions/Range"
                }
            }
        },
        "SelectionPolicy": {
            "title": "SelectionPolicy",
            "description": "Specifies how users can select items in the control. single:0,range:1,multiRange:2.",
            "enum": [
                0,
                1,
                2
            ]
        },
        "SelectionUnit": {
            "title": "SelectionUnit",
            "description": "Specifies the smallest unit users or the application can select. cell:0,row:1,column:2.",
            "enum": [
                0,
                1,
                2
            ]
        },
        "SheetModel": {
            "title": "SheetModel",
            "description": "Represent a data model for worksheet.",
            "type": "object",
            "properties": {
                "dataTable": {
                    "type": "object",
                    "patternProperties": {
                        "[0-9]+": {
                            "type": "object",
                            "patternProperties": {
                                "[0-9]+": {
                                    "type": "object",
                                    "properties": {
                                        "value": {
                                            "type": [
                                                "array",
                                                "boolean",
                                                "number",
                                                "null",
                                                "object",
                                                "string"
                                            ]
                                        },
                                        "style": {
                                            "anyOf": [
                                                {
                                                    "type": "string"
                                                },
                                                {
                                                    "$ref": "#/definitions/Style"
                                                }
                                            ]
                                        },
                                        "tag": {
                                            "type": [
                                                "array",
                                                "boolean",
                                                "number",
                                                "null",
                                                "object",
                                                "string"
                                            ]
                                        },
                                        "formula": {
                                            "type": [
                                                "string",
                                                "null"
                                            ]
                                        },
                                        "bindingPath": {
                                            "type": "string"
                                        }
                                    }
                                }
                            }
                        }
                    }
                },
                "rowDataArray": {
                    "type": "array",
                    "items": {
                        "type": [
                            "object",
                            "null"
                        ],
                        "properties": {
                            "style": {
                                "anyOf": [
                                    {
                                        "type": "string"
                                    },
                                    {
                                        "$ref": "#/definitions/Style"
                                    }
                                ]
                            },
                            "tag": {
                                "type": [
                                    "array",
                                    "boolean",
                                    "number",
                                    "null",
                                    "object",
                                    "string"
                                ]
                            }
                        }
                    }
                },
                "columnDataArray": {
                    "type": "array",
                    "items": {
                        "type": [
                            "object",
                            "null"
                        ],
                        "properties": {
                            "style": {
                                "anyOf": [
                                    {
                                        "type": "string"
                                    },
                                    {
                                        "$ref": "#/definitions/Style"
                                    }
                                ]
                            },
                            "tag": {
                                "type": [
                                    "array",
                                    "boolean",
                                    "number",
                                    "null",
                                    "object",
                                    "string"
                                ]
                            }
                        }
                    }
                },
                "defaultDataNode": {
                    "type": "object",
                    "properties": {
                        "style": {
                            "anyOf": [
                                {
                                    "type": "string"
                                },
                                {
                                    "$ref": "#/definitions/Style"
                                }
                            ]
                        }
                    }
                }
            }
        },
        "SheetGridlineOption": {
            "title": "SheetGridlineOption",
            "description": "Represent a sheet gridline option.",
            "type": "object",
            "properties": {
                "color": {
                    "type": "string"
                },
                "showVerticalGridline": {
                    "type": "boolean"
                },
                "showHorizontalGridline": {
                    "type": "boolean"
                }
            }
        },
        "SheetAreaOffsetOption": {
            "title": "SheetAreaOffsetOption",
            "description": "Represent a sheet area offset option.",
            "type": "object",
            "properties": {
                "left": {
                    "type": "number",
                    "minimum": 0
                },
                "top": {
                    "type": "number",
                    "minimum": 0
                }
            }
        },
        "SpreadTheme": {
            "title": "SpreadTheme",
            "description": "Represents an expression with a named variable as the expression.",
            "type": "object",
            "properties": {
                "name": {
                    "type": "string"
                },
                "themeColor": {
                    "$ref": "#/definitions/ThemeColor"
                },
                "headingFont": {
                    "type": "string"
                },
                "bodyFont": {
                    "type": "string"
                }
            }
        },
        "ThemeColor": {
            "title": "ThemeColor",
            "description": " Creates a ThemeColor instance.",
            "type": "object",
            "properties": {
                "name": {
                    "type": "string"
                },
                "text1": {
                    "$ref": "#/definitions/Color"
                },
                "text2": {
                    "$ref": "#/definitions/Color"
                },
                "background1": {
                    "$ref": "#/definitions/Color"
                },
                "background2": {
                    "$ref": "#/definitions/Color"
                },
                "accent1": {
                    "$ref": "#/definitions/Color"
                },
                "accent2": {
                    "$ref": "#/definitions/Color"
                },
                "accent3": {
                    "$ref": "#/definitions/Color"
                },
                "accent4": {
                    "$ref": "#/definitions/Color"
                },
                "accent5": {
                    "$ref": "#/definitions/Color"
                },
                "accent6": {
                    "$ref": "#/definitions/Color"
                },
                "hyperlink": {
                    "$ref": "#/definitions/Color"
                },
                "followedHyperlink": {
                    "$ref": "#/definitions/Color"
                }
            }
        },
        "Color": {
            "title": "Color",
            "description": "Represents an argb(alpha,red, green, blue) color.",
            "type": "object",
            "properties": {
                "a": {
                    "type": "number",
                    "minimum": 0,
                    "maximum": 255
                },
                "r": {
                    "type": "number",
                    "minimum": 0,
                    "maximum": 255
                },
                "g": {
                    "type": "number",
                    "minimum": 0,
                    "maximum": 255
                },
                "b": {
                    "type": "number",
                    "minimum": 0,
                    "maximum": 255
                }
            }
        },
        "Function": {
            "title": "Function",
            "description": "Represents an abstract base class for defining functions.",
            "type": "object",
            "properties": {
                "name": {
                    "type": "string"
                },
                "minArgs": {
                    "type": "number"
                },
                "maxArgs": {
                    "type": "number"
                },
                "typeName": {
                    "type": "string",
                    "default": ""
                }
            }
        },
        "Range": {
            "title": "Range",
            "description": "Represents a range, which is described by the row index, column index, row count, and column count.",
            "type": "object",
            "properties": {
                "row": {
                    "type": "integer"
                },
                "col": {
                    "type": "integer"
                },
                "rowCount": {
                    "type": "integer",
                    "minimum": 0
                },
                "colCount": {
                    "type": "integer",
                    "minimum": 0
                }
            }
        },
        "RowFilterBase": {
            "title": "RowFilterBase",
            "description": "Represents a row filter base that supports row filters for filtering rows in a sheet.",
            "type": "object",
            "properties": {
                "typeName": {
                    "type": "string",
                    "default": ""
                },
                "range": {
                    "$ref": "#/definitions/Range"
                },
                "filterItemMap": {
                    "type": "array",
                    "items": {
                        "type": "object",
                        "properties": {
                            "index": {
                                "type": "integer",
                                "minimum": 0
                            },
                            "conditions": {
                                "type": "array",
                                "items": {
                                    "$ref": "#/definitions/Condition"
                                }
                            }
                        }
                    }
                },
                "filteredColumns": {
                    "type": "array",
                    "items": {
                        "type": "integer",
                        "minimum": 0
                    }
                },
                "sortInfo": {
                    "$ref": "#/definitions/SortInfo"
                },
                "showFilterButton": {
                    "type": "boolean"
                },
                "filterButtonVisibleInfo": {
                    "type": "object",
                    "patternProperties": {
                        "[0-9]+": {
                            "description": "The property name is the column's index that realtive to the sheet.",
                            "type": "boolean"
                        }
                    }
                }
            }
        },
        "HideRowFilter": {
            "title": "HideRowFilter",
            "description": "Represents a default row filter.",
            "type": "object",
            "properties": {
                "range": {
                    "$ref": "#/definitions/Range"
                },
                "dialogVisibleInfo": {
                    "type": "object",
                    "properties": {
                        "sortByValue": {
                            "type": "boolean",
                            "default": true
                        },
                        "sortByColor": {
                            "type": "boolean",
                            "default": true
                        },
                        "filterByColor": {
                            "type": "boolean",
                            "default": true
                        },
                        "filterByValue": {
                            "type": "boolean",
                            "default": true
                        },
                        "listFilterArea": {
                            "type": "boolean",
                            "default": true
                        }
                    }
                },
                "filterItemMap": {
                    "type": "array",
                    "items": {
                        "type": "object",
                        "properties": {
                            "index": {
                                "type": "integer",
                                "minimum": 0
                            },
                            "conditions": {
                                "type": "array",
                                "items": {
                                    "$ref": "#/definitions/Condition"
                                }
                            }
                        }
                    }
                },
                "filteredColumns": {
                    "type": "array",
                    "items": {
                        "type": "integer",
                        "minimum": 0
                    }
                },
                "sortInfo": {
                    "$ref": "#/definitions/SortInfo"
                },
                "showFilterButton": {
                    "type": "boolean"
                },
                "filterButtonVisibleInfo": {
                    "type": "object",
                    "patternProperties": {
                        "[0-9]+": {
                            "description": "The property name is the column's index that realtive to the sheet.",
                            "type": "boolean"
                        }
                    }
                }
            }
        },
        "TableFilter": {
            "title": "TableFilter",
            "description": "Represents a table  filter.",
            "type": "object",
            "properties": {
                "range": {
                    "$ref": "#/definitions/Range"
                },
                "filterItemMap": {
                    "type": "array",
                    "items": {
                        "type": "object",
                        "properties": {
                            "index": {
                                "type": "integer",
                                "minimum": 0
                            },
                            "conditions": {
                                "type": "array",
                                "items": {
                                    "$ref": "#/definitions/Condition"
                                }
                            }
                        }
                    }
                },
                "filteredColumns": {
                    "type": "array",
                    "items": {
                        "type": "integer",
                        "minimum": 0
                    }
                },
                "sortInfo": {
                    "$ref": "#/definitions/SortInfo"
                },
                "showFilterButton": {
                    "type": "boolean"
                },
                "filterButtonVisibleInfo": {
                    "type": "object",
                    "patternProperties": {
                        "[0-9]+": {
                            "description": "The property name is the column's index that realtive to the table.",
                            "type": "boolean"
                        }
                    }
                }
            }
        },
        "SortInfo": {
            "title": "SortInfo",
            "description": "",
            "type": "object",
            "properties": {
                "index": {
                    "type": "integer"
                },
                "ascending": {
                    "type": "boolean"
                }
            }
        },
        "SheetDefaultOption": {
            "title": "SheetDefaultOption",
            "description": "",
            "type": "object",
            "properties": {
                "rowHeight": {
                    "type": "number",
                    "minimum": 0,
                    "default": 20
                },
                "colHeaderRowHeight": {
                    "type": "number",
                    "minimum": 0,
                    "default": 20
                },
                "colWidth": {
                    "type": "number",
                    "minimum": 0,
                    "default": 62
                },
                "rowHeaderColWidth": {
                    "type": "number",
                    "minimum": 0,
                    "default": 40
                }
            }
        },
        "RowColInfo": {
            "title": "RowColInfo",
            "description": "Represent a row or column.",
            "type": "object",
            "properties": {
                "size": {
                    "type": "number",
                    "minimum": 0
                },
                "visible": {
                    "type": "boolean"
                },
                "resizable": {
                    "type": "boolean"
                },
                "pageBreak": {
                    "type": "boolean"
                }
            }
        },
        "SparklineGroup": {
            "title": "SparklineGroup",
            "description": "Represents a sparkline group.",
            "type": "object",
            "properties": {
                "setting": {
                    "$ref": "#/definitions/SparklineSetting",
                    "default": null
                },
                "displayDateAxis": {
                    "type": "boolean",
                    "default": false
                },
                "sparklineType": {
                    "$ref": "#/definitions/SparklineType"
                },
                "axisReference": {
                    "title": "axisReference",
                    "description": "Represents the sparkline group axisReference, it has a sheet name when the sparkline is cross sheet",
                    "type": "object",
                    "properties": {
                        "row": {
                            "type": "integer"
                        },
                        "col": {
                            "type": "integer"
                        },
                        "rowCount": {
                            "type": "integer",
                            "minimum": 0
                        },
                        "colCount": {
                            "type": "integer",
                            "minimum": 0
                        },
                        "sheetName": {
                            "type": "string",
                            "default": null
                        }
                    },
                    "default": null
                },
                "axisOrientation": {
                    "$ref": "#/definitions/DataOrientation",
                    "default": 1
                },
                "sparklines": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/Sparkline"
                    }
                }
            }
        },
        "SparklineSetting": {
            "title": "SparklineSetting",
            "description": "Represents the sparkline settings.",
            "type": "object",
            "properties": {
                "axisColor": {
                    "type": "string",
                    "default": "Black"
                },
                "firstMarkerColor": {
                    "type": "string",
                    "default": "rgba(149,179,215,255)"
                },
                "highMarkerColor": {
                    "type": "string",
                    "default": "Blue"
                },
                "lastMarkerColor": {
                    "type": "string",
                    "default": "rgba(149,179,215,255)"
                },
                "lowMarkerColor": {
                    "type": "string",
                    "default": "Blue"
                },
                "markersColor": {
                    "type": "string",
                    "default": "rgba(36,64,98,255)"
                },
                "negativeColor": {
                    "type": "string",
                    "default": "Brown"
                },
                "seriesColor": {
                    "type": "string",
                    "default": "rgba(36,64,98,255)"
                },
                "displayEmptyCellsAs": {
                    "$ref": "#/definitions/EmptyValueStyle",
                    "default": 0
                },
                "rightToLeft": {
                    "type": "boolean",
                    "default": false
                },
                "displayHidden": {
                    "type": "boolean",
                    "default": false
                },
                "displayXAxis": {
                    "type": "boolean",
                    "default": false
                },
                "showFirst": {
                    "type": "boolean",
                    "default": false
                },
                "showHigh": {
                    "type": "boolean",
                    "default": false
                },
                "showLast": {
                    "type": "boolean",
                    "default": false
                },
                "showLow": {
                    "type": "boolean",
                    "default": false
                },
                "showNegative": {
                    "type": "boolean",
                    "default": false
                },
                "showMarkers": {
                    "type": "boolean",
                    "default": false
                },
                "manualMax": {
                    "type": "number",
                    "default": 0.0
                },
                "manualMin": {
                    "type": "number",
                    "default": 0.0
                },
                "maxAxisType": {
                    "$ref": "#/definitions/SparklineAxisMinMax",
                    "default": 0
                },
                "minAxisType": {
                    "$ref": "#/definitions/SparklineAxisMinMax",
                    "default": 0
                },
                "lineWeight": {
                    "type": "number",
                    "default": 1
                }
            }
        },
        "Sparkline": {
            "title": "Sparkline",
            "description": "Represents a Sparkline.",
            "type": "object",
            "properties": {
                "row": {
                    "type": "integer",
                    "minimum": 0
                },
                "col": {
                    "type": "integer",
                    "minimum": 0
                },
                "orientation": {
                    "$ref": "#/definitions/DataOrientation"
                },
                "data": {
                    "title": "data",
                    "description": "Represents the sparkline data, it has a sheet name when the sparkline is cross sheet",
                    "type": "object",
                    "properties": {
                        "row": {
                            "type": "integer"
                        },
                        "col": {
                            "type": "integer"
                        },
                        "rowCount": {
                            "type": "integer",
                            "minimum": 0
                        },
                        "colCount": {
                            "type": "integer",
                            "minimum": 0
                        },
                        "sheetName": {
                            "type": "string",
                            "default": null
                        }
                    },
                    "default": null
                }
            }
        },
        "SparklineType": {
            "title": "SparklineType",
            "description": "Represents the sparkline type. line:0,column:1,winloss:2.",
            "enum": [
                0,
                1,
                2
            ]
        },
        "SparklineAxisMinMax": {
            "title": "SparklineAxisMinMax",
            "description": "An enumeration that specifies information about how the vertical axis minimum or maximum is computed for this sparkline group. individual:0,group:1,custom:2.",
            "enum": [
                0,
                1,
                2
            ]
        },
        "EmptyValueStyle": {
            "title": "EmptyValueStyle",
            "description": "Specifies how to show an empty value from a data series in the chart. gaps:0,zero:1,connect:2.",
            "enum": [
                0,
                1,
                2
            ]
        },
        "DataOrientation": {
            "title": "DataOrientation",
            "description": "Represents the orientation of the range. vertical:0,horizontal:1.",
            "enum": [
                0,
                1
            ]
        },
        "Comment": {
            "title": "Comment",
            "description": "Represents a comment.",
            "type": "object",
            "properties": {
                "text": {
                    "type": "string",
                    "default": ""
                },
                "location": {
                    "$ref": "#/definitions/Point"
                },
                "width": {
                    "type": "number",
                    "minimum": 0,
                    "exclusiveMinimum": true,
                    "default": 160
                },
                "height": {
                    "type": "number",
                    "minimum": 0,
                    "exclusiveMinimum": true,
                    "default": 100
                },
                "fontFamily": {
                    "type": "string",
                    "default": "Arial"
                },
                "fontStyle": {
                    "type": "string",
                    "default": "normal"
                },
                "fontSize": {
                    "type": "string",
                    "default": "9pt"
                },
                "fontWeight": {
                    "type": "string",
                    "default": "normal"
                },
                "textDecoration": {
                    "$ref": "#/definitions/TextDecorationType",
                    "default": 0
                },
                "foreColor": {
                    "type": "string",
                    "default": "black"
                },
                "backColor": {
                    "type": "string",
                    "default": "#FFFFE1"
                },
                "locked": {
                    "type": "boolean",
                    "default": true
                },
                "lockText": {
                    "type": "boolean",
                    "default": true
                },
                "horizontalAlign": {
                    "$ref": "#/definitions/HorizontalAlign",
                    "default": 0
                },
                "autoSize": {
                    "type": "boolean",
                    "default": false
                },
                "dynamicMove": {
                    "type": "boolean",
                    "default": true
                },
                "dynamicSize": {
                    "type": "boolean",
                    "default": true
                },
                "opacity": {
                    "type": "number",
                    "minimum": 0,
                    "maximum": 1,
                    "default": 1
                },
                "borderWidth": {
                    "type": "number",
                    "default": 1
                },
                "borderStyle": {
                    "type": "string",
                    "default": "solid"
                },
                "borderColor": {
                    "type": "string",
                    "default": "black"
                },
                "padding": {
                    "$ref": "#/definitions/Padding"
                },
                "showShadow": {
                    "type": "boolean",
                    "default": false
                },
                "displayMode": {
                    "$ref": "#/definitions/DisplayMode",
                    "default": 2
                },
                "commentState": {
                    "$ref": "#/definitions/CommentState",
                    "default": 3
                },
                "zIndex": {
                    "type": "integer",
                    "default": -1
                },
                "ignoreDefaultLocation": {
                    "type": "boolean",
                    "default": false
                },
                "rowIndex": {
                    "type": "integer",
                    "default": -1
                },
                "colIndex": {
                    "type": "integer",
                    "default": -1
                }
            }
        },
        "Padding": {
            "title": "Padding",
            "description": "Represent a padding.",
            "type": "object",
            "properties": {
                "left": {
                    "type": "number",
                    "default": 0
                },
                "top": {
                    "type": "number",
                    "default": 0
                },
                "right": {
                    "type": "number",
                    "default": 0
                },
                "bottom": {
                    "type": "number",
                    "default": 0
                }
            }
        },
        "Point": {
            "title": "Point",
            "description": "Represents an x and y coordinate pair in two-dimensional space.",
            "type": "object",
            "properties": {
                "x": {
                    "type": "number"
                },
                "y": {
                    "type": "number"
                }
            }
        },
        "CommentState": {
            "title": "CommentState",
            "description": "Defines the state of Comment. active:1,edit:2,normal:3",
            "enum": [
                1,
                2,
                3
            ]
        },
        "DisplayMode": {
            "title": "DisplayMode",
            "description": "Defines when the comment is displayed. alwaysShown:1,hoverShown:2.",
            "enum": [
                1,
                2
            ]
        },
        "SheetTable": {
            "title": "SheetTable",
            "description": "Represents a table that can be added in a sheet.",
            "type": "object",
            "properties": {
                "name": {
                    "type": "string"
                },
                "row": {
                    "type": "integer",
                    "default": -1
                },
                "col": {
                    "type": "integer",
                    "default": -1
                },
                "rowCount": {
                    "type": "integer",
                    "default": -1
                },
                "colCount": {
                    "type": "integer",
                    "default": -1
                },
                "showHeader": {
                    "type": "boolean",
                    "default": true
                },
                "showFooter": {
                    "type": "boolean",
                    "default": false
                },
                "highlightFirstColumn": {
                    "type": "boolean",
                    "default": false
                },
                "highlightLastColumn": {
                    "type": "boolean",
                    "default": false
                },
                "bandRows": {
                    "type": "boolean",
                    "default": true
                },
                "bandColumns": {
                    "type": "boolean",
                    "default": false
                },
                "style": {
                    "$ref": "#/definitions/TableTheme"
                },
                "autoGenerateColumns": {
                    "type": "boolean",
                    "default": true
                },
                "bindingPath": {
                    "type": "string"
                },
                "columns": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/TableColumnInfo"
                    }
                },
                "rowFilter": {
                    "$ref": "#/definitions/TableFilter"
                }
            }
        },
        "TableColumnInfo": {
            "title": "TableColumnInfo",
            "description": "Represents the table column.",
            "type": "object",
            "properties": {
                "id": {
                    "type": "integer"
                },
                "name": {
                    "type": "string"
                },
                "dataField": {
                    "type": [
                        "string",
                        "null"
                    ]
                },
                "footerFormula": {
                    "type": "string"
                },
                "dataAreaFormula": {
                    "type": "string"
                },
                "footerValue": {
                    "type": [
                        "array",
                        "boolean",
                        "number",
                        "null",
                        "object",
                        "string"
                    ]
                }
            }
        },
        "TableTheme": {
            "title": "TableTheme",
            "anyOf": [
                {
                    "$ref": "#/definitions/BuildInTableTheme"
                },
                {
                    "$ref": "#/definitions/CustomTableTheme"
                }
            ]
        },
        "BuildInTableTheme": {
            "title": "BuildInTableTheme",
            "description": "Represents a built-in table style setting.",
            "type": "object",
            "properties": {
                "buildInName": {
                    "type": "string"
                }
            }
        },
        "CustomTableTheme": {
            "title": "CustomTableTheme",
            "description": "Represents a custom table style setting.",
            "type": "object",
            "properties": {
                "name": {
                    "type": "string"
                },
                "wholeTableStyle": {
                    "$ref": "#/definitions/TableStyle"
                },
                "headerRowStyle": {
                    "$ref": "#/definitions/TableStyle"
                },
                "footerRowStyle": {
                    "$ref": "#/definitions/TableStyle"
                },
                "firstRowStripStyle": {
                    "$ref": "#/definitions/TableStyle"
                },
                "secondRowStripStyle": {
                    "$ref": "#/definitions/TableStyle"
                },
                "firstRowStripSize": {
                    "type": "number",
                    "default": 1
                },
                "secondRowStripSize": {
                    "type": "number",
                    "default": 1
                },
                "firstColumnStripStyle": {
                    "$ref": "#/definitions/TableStyle"
                },
                "secondColumnStripStyle": {
                    "$ref": "#/definitions/TableStyle"
                },
                "firstColumnStripSize": {
                    "type": "number",
                    "default": 1
                },
                "secondColumnStripSize": {
                    "type": "number",
                    "default": 1
                },
                "highlightFirstColumnStyle": {
                    "$ref": "#/definitions/TableStyle"
                },
                "highlightLastColumnStyle": {
                    "$ref": "#/definitions/TableStyle"
                },
                "firstHeaderCellStyle": {
                    "$ref": "#/definitions/TableStyle"
                },
                "lastHeaderCellStyle": {
                    "$ref": "#/definitions/TableStyle"
                },
                "firstFooterCellStyle": {
                    "$ref": "#/definitions/TableStyle"
                },
                "lastFooterCellStyle": {
                    "$ref": "#/definitions/TableStyle"
                }
            }
        },
        "TableStyle": {
            "title": "TableStyle",
            "description": "Represents table style information.",
            "type": "object",
            "properties": {
                "backColor": {
                    "type": "string"
                },
                "foreColor": {
                    "type": "string"
                },
                "font": {
                    "type": "string"
                },
                "borderLeft": {
                    "$ref": "#/definitions/LineBorder"
                },
                "borderTop": {
                    "$ref": "#/definitions/LineBorder"
                },
                "borderRight": {
                    "$ref": "#/definitions/LineBorder"
                },
                "borderBottom": {
                    "$ref": "#/definitions/LineBorder"
                },
                "borderHorizontal": {
                    "$ref": "#/definitions/LineBorder"
                },
                "borderVertical": {
                    "$ref": "#/definitions/LineBorder"
                },
                "textDecoration": {
                    "$ref": "#/definitions/TextDecorationType",
                    "default": 0
                }
            }
        },
        "FloatingObject": {
            "title": "FloatingObject",
            "description": "Represents a custom floating object.",
            "type": "object",
            "properties": {
                "name": {
                    "type": "string"
                },
                "x": {
                    "type": "number",
                    "default": 0
                },
                "y": {
                    "type": "number",
                    "default": 0
                },
                "width": {
                    "type": "number",
                    "default": 0
                },
                "height": {
                    "type": "number",
                    "default": 0
                },
                "canPrint": {
                    "type": "boolean",
                    "default": true
                },
                "isSelected": {
                    "type": "boolean",
                    "default": false
                },
                "isLocked": {
                    "type": "boolean",
                    "default": true
                },
                "isVisible": {
                    "type": "boolean",
                    "default": true
                },
                "dynamicMove": {
                    "type": "boolean",
                    "default": true
                },
                "dynamicSize": {
                    "type": "boolean",
                    "default": true
                },
                "fixedPosition": {
                    "type": "boolean"
                },
                "allowResize": {
                    "type": "boolean",
                    "default": true
                },
                "allowMove": {
                    "type": "boolean",
                    "default": true
                },
                "typeName": {
                    "type": "string"
                },
                "content": {
                    "type": "string"
                },
                "zIndex": {
                    "type": "integer"
                }
            }
        },
        "Picture": {
            "title": "Picture",
            "description": "Represents a picture.",
            "type": "object",
            "properties": {
                "name": {
                    "type": "string"
                },
                "x": {
                    "type": "number",
                    "default": 0
                },
                "y": {
                    "type": "number",
                    "default": 0
                },
                "width": {
                    "type": "number",
                    "default": 0
                },
                "height": {
                    "type": "number",
                    "default": 0
                },
                "canPrint": {
                    "type": "boolean",
                    "default": true
                },
                "isSelected": {
                    "type": "boolean",
                    "default": false
                },
                "isLocked": {
                    "type": "boolean",
                    "default": true
                },
                "isVisible": {
                    "type": "boolean",
                    "default": true
                },
                "dynamicMove": {
                    "type": "boolean",
                    "default": true
                },
                "dynamicSize": {
                    "type": "boolean",
                    "default": true
                },
                "fixedPosition": {
                    "type": "boolean"
                },
                "allowResize": {
                    "type": "boolean",
                    "default": true
                },
                "allowMove": {
                    "type": "boolean",
                    "default": true
                },
                "typeName": {
                    "type": "string"
                },
                "src": {
                    "type": "string"
                },
                "backColor": {
                    "type": "string"
                },
                "borderRadius": {
                    "type": "number",
                    "default": -1
                },
                "borderWidth": {
                    "type": "number",
                    "default": 1
                },
                "borderStyle": {
                    "type": "string",
                    "default": "none"
                },
                "borderColor": {
                    "type": "string"
                },
                "pictureStretch": {
                    "$ref": "#/definitions/ImageLayout",
                    "default": 0
                },
                "zIndex": {
                    "type": "integer"
                }
            }
        },
        "SpanModel": {
            "title": "SpanModel",
            "description": "Represent a data model for cell spans.",
            "type": "array",
            "items": {
                "$ref": "#/definitions/Range"
            }
        },
        "HeaderAutoText": {
            "title": "HeaderAutoText",
            "description": "Specifies which default labels are displayed in headers. blank:0,numbers:1,letters:2.",
            "enum": [
                0,
                1,
                2
            ]
        },
        "ClipboardPasteOptions": {
            "title": "ClipboardPasteOptions",
            "description": "Specifies what data is pasted from the Clipboard. all:0,values:1,formatting:2,formulas:3.",
            "enum": [
                0,
                1,
                2,
                3
            ]
        },
        "ProtectionOption": {
            "title": "ProtectionOption",
            "description": "Specifies the elements that you want users to be able to change.",
            "type": "object",
            "properties": {
                "allowSelectLockedCells": {
                    "type": "boolean"
                },
                "allowSelectUnlockedCells": {
                    "type": "boolean"
                },
                "allowSort": {
                    "type": "boolean"
                },
                "allowFilter": {
                    "type": "boolean"
                },
                "allowEditObjects": {
                    "type": "boolean"
                },
                "allowResizeRows": {
                    "type": "boolean"
                },
                "allowResizeColumns": {
                    "type": "boolean"
                }
            }
        },
        "Outline": {
            "title": "Outline",
            "description": "Represents an outline for the worksheet.",
            "type": "object",
            "properties": {
                "head": {
                    "$ref": "#/definitions/OutlineItemInfo"
                },
                "tail": {
                    "$ref": "#/definitions/OutlineItemInfo"
                },
                "direction": {
                    "$ref": "#/definitions/OutlineDirection",
                    "default": 1
                },
                "itemsData": {
                    "type": "array",
                    "items": {
                        "type": "object",
                        "properties": {
                            "index": {
                                "type": "integer"
                            },
                            "count": {
                                "type": "integer"
                            },
                            "info": {
                                "$ref": "#/definitions/OutlineItemInfo"
                            }
                        }
                    }
                }
            }
        },
        "OutlineItemInfo": {
            "title": "OutlineItemInfo",
            "description": "Represents an outline item information.",
            "type": "object",
            "properties": {
                "level": {
                    "type": "integer",
                    "default": 0
                },
                "collapsed": {
                    "type": "boolean",
                    "default": false
                }
            }
        },
        "OutlineDirection": {
            "title": "OutlineDirection",
            "description": "Specifies the status of an outline summary row or column position. backward:0,forward:1.",
            "enum": [
                0,
                1
            ]
        },
        "OutlineColumnOptions": {
            "title": "OutlineColumnOptions",
            "description": "Represents the outline column options",
            "type": "object",
            "properties": {
                "columnIndex": {
                    "type": "number"
                },
                "showImage": {
                    "type": "boolean",
                    "default": false
                },
                "images": {
                    "type": "array",
                    "items": {
                        "type": "string"
                    }
                },
                "showCheckBox": {
                    "type": "boolean",
                    "default": false
                },
                "showIndicator": {
                    "type": "boolean",
                    "default": true
                },
                "expandIndicator": {
                    "type": "string",
                    "default": ""
                },
                "collapseIndicator": {
                    "type": "boolean",
                    "default": ""
                },
                "maxLevel": {
                    "type": "number",
                    "default": 10
                },
                "data": {
                    "type": "array",
                    "items": {
                        "$ref": "#/definitions/OutlineColumnItemData"
                    }
                }
            }
        },
        "OutlineColumnItemData": {
            "title": "OutlineColumnItemData",
            "description": "Represents the data of row in the outline column.",
            "type": "object",
            "properties": {
                "checked": {
                    "type": "boolean",
                    "default": false
                }
            }
        },
        "SparklineEx": {
            "title": "SparklineEx",
            "description": "Represents the base class for the other SparklineEx classes.",
            "type": "object",
            "properties": {
                "typeName": {
                    "type": "string",
                    "default": ""
                }
            }
        },
        "ResizeZeroIndicator": {
            "title": "ResizeZeroIndicator",
            "description": "Specifies the drawing policy of the row or column when it is resized to zero. default:0,enhanced:1.",
            "enum": [
                0,
                1
            ]
        },
        "PrintInfo": {
            "title": "PrintInfo",
            "description": "Represents the information to use when printing a Sheet.",
            "type": "object",
            "properties": {
                "bestFitRows": {
                    "type": "boolean",
                    "default": false
                },
                "bestFitColumns": {
                    "type": "boolean",
                    "default": false
                },
                "columnStart": {
                    "type": "number",
                    "default": -1
                },
                "columnEnd": {
                    "type": "number",
                    "default": -1
                },
                "rowStart": {
                    "type": "number",
                    "default": -1
                },
                "rowEnd": {
                    "type": "number",
                    "default": -1
                },
                "repeatColumnStart": {
                    "type": "number",
                    "default": -1
                },
                "repeatColumnEnd": {
                    "type": "number",
                    "default": -1
                },
                "repeatRowStart": {
                    "type": "number",
                    "default": -1
                },
                "repeatRowEnd": {
                    "type": "number",
                    "default": -1
                },
                "showBorder": {
                    "type": "boolean",
                    "default": true
                },
                "showGridLine": {
                    "type": "boolean",
                    "default": false
                },
                "showColumnHeader": {
                    "$ref": "#/definitions/PrintVisibilityType",
                    "default": 0
                },
                "showRowHeader": {
                    "$ref": "#/definitions/PrintVisibilityType",
                    "default": 0
                },
                "useMax": {
                    "type": "boolean",
                    "default": true
                },
                "centering": {
                    "$ref": "#/definitions/PrintCentering",
                    "default": 0
                },
                "firstPageNumber": {
                    "type": "number",
                    "default": 1
                },
                "headerLeft": {
                    "type": "string"
                },
                "headerCenter": {
                    "type": "string"
                },
                "headerRight": {
                    "type": "string"
                },
                "footerLeft": {
                    "type": "string"
                },
                "footerCenter": {
                    "type": "string"
                },
                "footerRight": {
                    "type": "string"
                },
                "headerLeftImage": {
                    "type": "string"
                },
                "headerCenterImage": {
                    "type": "string"
                },
                "headerRightImage": {
                    "type": "string"
                },
                "footerLeftImage": {
                    "type": "string"
                },
                "footerCenterImage": {
                    "type": "string"
                },
                "footerRightImage": {
                    "type": "string"
                },
                "margin": {
                    "$ref": "#/definitions/PrintMargins"
                },
                "orientation": {
                    "$ref": "#/definitions/PrintPageOrientation",
                    "default": 1
                },
                "pageRange": {
                    "type": "string"
                },
                "pageOrder": {
                    "$ref": "#/definitions/PrintPageOrder",
                    "default": 0
                },
                "blackAndWhite": {
                    "type": "boolean",
                    "default": false
                },
                "zoomFactor": {
                    "type": "number",
                    "default": 1
                },
                "fitPagesTall": {
                    "type": "number",
                    "default": -1
                },
                "fitPagesWide": {
                    "type": "number",
                    "default": -1
                },
                "paperSize": {
                    "$ref": "#/definitions/PaperSize"
                }
            }
        },
        "PrintVisibilityType": {
            "title": "PrintVisibilityType",
            "description": "Specifies whether the area is visible. inherit:0,hide:1,show:2,showOnce:3",
            "enum": [
                0,
                1,
                2,
                3
            ]
        },
        "PrintCentering": {
            "title": "PrintCentering",
            "description": "Specifics the type of centering for the printed page. none:0,horizontal:1,vertical:2,both:3",
            "enum": [
                0,
                1,
                2,
                3
            ]
        },
        "PrintPageOrientation": {
            "title": "PrintPageOrientation",
            "description": "Specifies the page orientation used for printing. portrait:1,landscape:2",
            "enum": [
                1,
                2
            ]
        },
        "PrintPageOrder": {
            "title": "PrintPageOrder",
            "description": "Specifies the order in which pages are printed. auto:0,downThenOver:1,overThenDown:2",
            "enum": [
                0,
                1,
                2
            ]
        },
        "PaperKind": {
            "title": "PaperKind",
            "description": "pecifies the paper kind for the printed page. 0 : custom, 1 : letter, 2 : letterSmall, 3 : tabloid, 4 : ledger, 5 : legal, 6 : statement, 7 : executive, 8 : a3, 9 : a4, 10 : a4Small, 11 : a5, 12 : b4, 13 : b5, 14 : folio, 15 : quarto, 16 : standard10x14, 17 : standard11x17, 18 : note, 19 : number9Envelope, 20 : number10Envelope, 21 : number11Envelope, 22 : number12Envelope, 23 : number14Envelope, 24 : cSheet, 25 : dSheet, 26 : eSheet, 27 : dLEnvelope, 28 : c5Envelope, 29 : c3Envelope, 30 : c4Envelope, 31 : c6Envelope, 32 : c65Envelope, 33 : b4Envelope, 34 : b5Envelope, 35 : b6Envelope, 36 : italyEnvelope, 37 : monarchEnvelope, 38 : personalEnvelope, 39 : uSStandardFanfold, 40 : germanStandardFanfold, 41 : germanLegalFanfold, 42 : isoB4, 43 : japanesePostcard, 44 : standard9x11, 45 : standard10x11, 46 : standard15x11, 47 : inviteEnvelope, 50 : letterExtra, 51 : legalExtra, 52 : tabloidExtra, 53 : a4Extra, 54 : letterTransverse, 55 : a4Transverse, 56 : letterExtraTransverse, 57 : aPlus, 58 : bPlus, 59 : letterPlus, 60 : a4Plus, 61 : a5Transverse, 62 : b5Transverse, 63 : a3Extra, 64 : a5Extra, 65 : b5Extra, 66 : a2, 67 : a3Transverse, 68 : a3ExtraTransverse, 69 : japaneseDoublePostcard, 70 : a6, 71 : japaneseEnvelopeKakuNumber2, 72 : japaneseEnvelopeKakuNumber3, 73 : japaneseEnvelopeChouNumber3, 74 : japaneseEnvelopeChouNumber4, 75 : letterRotated, 76 : a3Rotated, 77 : a4Rotated, 78 : a5Rotated, 79 : b4JisRotated, 80 : b5JisRotated, 81 : japanesePostcardRotated, 82 : japaneseDoublePostcardRotated, 83 : a6Rotated, 84 : japaneseEnvelopeKakuNumber2Rotated, 85 : japaneseEnvelopeKakuNumber3Rotated, 86 : japaneseEnvelopeChouNumber3Rotated, 87 : japaneseEnvelopeChouNumber4Rotated, 88 : b6Jis, 89 : b6JisRotated, 90 : standard12x11, 91 : japaneseEnvelopeYouNumber4, 92 : japaneseEnvelopeYouNumber4Rotated, 93 : prc16K, 94 : prc32K, 95 : prc32KBig, 96 : prcEnvelopeNumber1, 97 : prcEnvelopeNumber2, 98 : prcEnvelopeNumber3, 99 : prcEnvelopeNumber4, 100 : prcEnvelopeNumber5, 101 : prcEnvelopeNumber6,102 : prcEnvelopeNumber7,103 : prcEnvelopeNumber8,104 : prcEnvelopeNumber9,105 : prcEnvelopeNumber10,106: prc16KRotated,107: prc32KRotated,108: prc32KBigRotated,109: prcEnvelopeNumber1Rotated,110: prcEnvelopeNumber2Rotated,111: prcEnvelopeNumber3Rotated,112: prcEnvelopeNumber4Rotated,113: prcEnvelopeNumber5Rotated,114: prcEnvelopeNumber6Rotated,115: prcEnvelopeNumber7Rotated,116: prcEnvelopeNumber8Rotated,117: prcEnvelopeNumber9Rotated,118: prcEnvelopeNumber10Rotated",
            "enum": [
                0,
                1,
                2,
                3,
                4,
                5,
                6,
                7,
                8,
                9,
                10,
                11,
                12,
                13,
                14,
                15,
                16,
                17,
                18,
                19,
                20,
                21,
                22,
                23,
                24,
                25,
                26,
                27,
                28,
                29,
                30,
                31,
                32,
                33,
                34,
                35,
                36,
                37,
                38,
                39,
                40,
                41,
                42,
                43,
                44,
                45,
                46,
                47,
                50,
                51,
                52,
                53,
                54,
                55,
                56,
                57,
                58,
                59,
                60,
                61,
                62,
                63,
                64,
                65,
                66,
                67,
                68,
                69,
                70,
                71,
                72,
                73,
                74,
                75,
                76,
                77,
                78,
                79,
                80,
                81,
                82,
                83,
                84,
                85,
                86,
                87,
                88,
                89,
                90,
                91,
                92,
                93,
                94,
                95,
                96,
                97,
                98,
                99,
                100,
                101,
                102,
                103,
                104,
                105,
                106,
                107,
                108,
                109,
                110,
                111,
                112,
                113,
                114,
                115,
                116,
                117,
                118
            ]
        },
        "PrintMargins": {
            "title": "PrintMargins",
            "description": "Specifies the dimensions of the printed page margins.",
            "type": "object",
            "properties": {
                "top": {
                    "type": "number",
                    "default": 75
                },
                "bottom": {
                    "type": "number",
                    "default": 75
                },
                "left": {
                    "type": "number",
                    "default": 70
                },
                "right": {
                    "type": "number",
                    "default": 70
                },
                "header": {
                    "type": "number",
                    "default": 30
                },
                "footer": {
                    "type": "number",
                    "default": 30
                }
            }
        },
        "PaperSize": {
            "title": "PaperSize",
            "description": "Specifies the paper size.",
            "properties": {
                "height": {
                    "type": "number"
                },
                "width": {
                    "type": "number"
                },
                "kind": {
                    "anyOf": [
                        {
                            "$ref": "#/definitions/PaperKind"
                        },
                        {
                            "type": "null"
                        }
                    ]
                }
            }
        },
        "Slicer": {
            "title": "Slicer",
            "description": "Represents a slicer.",
            "type": "object",
            "properties": {
                "x": {
                    "type": "number",
                    "default": 100
                },
                "y": {
                    "type": "number",
                    "default": 100
                },
                "width": {
                    "type": "number",
                    "default": 192
                },
                "height": {
                    "type": "number",
                    "default": 250
                },
                "dynamicMove": {
                    "type": "boolean",
                    "default": false
                },
                "dynamicSize": {
                    "type": "boolean",
                    "default": false
                },
                "isLocked": {
                    "type": "boolean",
                    "default": true
                },
                "fixedPosition": {
                    "type": "boolean",
                    "default": false
                },
                "sourceName": {
                    "type": "string"
                },
                "tableName": {
                    "type": "string"
                },
                "name": {
                    "type": "string"
                },
                "captionName": {
                    "type": "string"
                },
                "columnCount": {
                    "type": "number",
                    "default": 1
                },
                "itemHeight": {
                    "type": "number",
                    "default": 21
                },
                "showHeader": {
                    "type": "boolean",
                    "default": true
                },
                "sortState": {
                    "$ref": "#/definitions/SortState",
                    "default": 1
                },
                "disableResizingAndMoving": {
                    "type": "boolean",
                    "default": false
                },
                "showNoDataItems": {
                    "type": "boolean",
                    "default": true
                },
                "showNoDataItemsInLast": {
                    "type": "boolean",
                    "default": true
                },
                "visuallyNoDataItems": {
                    "type": "boolean",
                    "default": true
                },
                "style": {
                    "$ref": "#/definitions/SlicerStyle"
                },
                "columnName": {
                    "type": "string"
                },
                "nameInFormula": {
                    "type": "string"
                }
            }
        },
        "SlicerStyle": {
            "title": "SlicerStyle",
            "description": "Represents the slicer style settings.",
            "type": "object",
            "properties": {
                "name": {
                    "type": "string",
                    "default": ""
                },
                "wholeSlicerStyle": {
                    "$ref": "#/definitions/SlicerStyleInfo"
                },
                "headerStyle": {
                    "$ref": "#/definitions/SlicerStyleInfo"
                },
                "selectedItemWithDataStyle": {
                    "$ref": "#/definitions/SlicerStyleInfo"
                },
                "selectedItemWithNoDataStyle": {
                    "$ref": "#/definitions/SlicerStyleInfo"
                },
                "unSelectedItemWithDataStyle": {
                    "$ref": "#/definitions/SlicerStyleInfo"
                },
                "unSelectedItemWithNoDataStyle": {
                    "$ref": "#/definitions/SlicerStyleInfo"
                },
                "hoveredSelectedItemWithDataStyle": {
                    "$ref": "#/definitions/SlicerStyleInfo"
                },
                "hoveredSelectedItemWithNoDataStyle": {
                    "$ref": "#/definitions/SlicerStyleInfo"
                },
                "hoveredUnSelectedItemWithDataStyle": {
                    "$ref": "#/definitions/SlicerStyleInfo"
                },
                "hoveredUnSelectedItemWithNoDataStyle": {
                    "$ref": "#/definitions/SlicerStyleInfo"
                }
            }
        },
        "SlicerStyleInfo": {
            "title": "SlicerStyleInfo",
            "description": "Represents slicer style information.",
            "type": "object",
            "properties": {
                "backColor": {
                    "type": "string",
                    "default": "white"
                },
                "foreColor": {
                    "type": "string",
                    "default": "black"
                },
                "font": {
                    "type": "string",
                    "default": "normal 11pt calibri"
                },
                "borderLeft": {
                    "$ref": "#/definitions/SlicerBorder"
                },
                "borderTop": {
                    "$ref": "#/definitions/SlicerBorder"
                },
                "borderRight": {
                    "$ref": "#/definitions/SlicerBorder"
                },
                "borderBottom": {
                    "$ref": "#/definitions/SlicerBorder"
                },
                "textDecoration": {
                    "$ref": "#/definitions/TextDecorationType",
                    "default": 0
                }
            }
        },
        "SlicerBorder": {
            "title": "SlicerBorder",
            "description": "Represents the slicer border.",
            "type": "object",
            "properties": {
                "borderWidth": {
                    "type": "number",
                    "default": 0
                },
                "borderStyle": {
                    "type": "number",
                    "default": ""
                },
                "borderColor": {
                    "type": "number",
                    "default": ""
                }
            }
        },
        "SortState": {
            "title": "SortState",
            "description": "Specifies the type of sorting to perform. none:0,ascending:1,descending:2.",
            "enum": [
                0,
                1,
                2
            ]
        },
        "LabelAlignment": {
            "title": "LabelAlignment",
            "description": "Specifies the cell label position. topLeft:0,topCenter:1,topRight:2,bottomLeft:3,bottomCenter:4,bottomRight:5.",
            "enum": [
                0,
                1,
                2,
                3,
                4,
                5
            ]
        },
        "LabelVisibility": {
            "title": "LabelVisibility",
            "description": "Specifies to always show the watermark in the padding area and not to show the watermark in the cell area, regardless of the cell value. visible:0,hidden:1,auto:2.",
            "enum": [
                0,
                1,
                2
            ]
        },
        "LabelOptions": {
            "title": "LabelOptions",
            "description": "Specifies the cell label options.",
            "type": [
                "object",
                "null"
            ],
            "properties": {
                "alignment": {
                    "$ref": "#/definitions/LabelAlignment",
                    "default": 0
                },
                "visibility": {
                    "$ref": "#/definitions/LabelVisibility",
                    "default": 2
                },
                "font": {
                    "type": "string"
                },
                "foreColor": {
                    "type": "string"
                },
                "margin": {
                    "type": "string"
                }
            }
        },
        "CopyPasteHeaderOptions": {
            "title": "CopyPasteHeaderOptions",
            "description": "Specifies which headers are included when data is copied to or pasted. noHeaders:0,rowHeaders:1,columnHeaders:2,allHeaders:3",
            "enum": [
                0,
                1,
                2,
                3
            ]
        },
        "Chart": {
            "title": "Chart",
            "description": "Represents a chart.",
            "type": "object",
            "properties": {
                "name": {
                    "type": "string"
                },
                "x": {
                    "type": "number",
                    "default": 0
                },
                "y": {
                    "type": "number",
                    "default": 0
                },
                "width": {
                    "type": "number",
                    "default": 0
                },
                "height": {
                    "type": "number",
                    "default": 0
                },
                "canPrint": {
                    "type": "boolean",
                    "default": true
                },
                "isSelected": {
                    "type": "boolean",
                    "default": false
                },
                "isLocked": {
                    "type": "boolean",
                    "default": true
                },
                "isVisible": {
                    "type": "boolean",
                    "default": true
                },
                "dynamicMove": {
                    "type": "boolean",
                    "default": true
                },
                "dynamicSize": {
                    "type": "boolean",
                    "default": true
                },
                "fixedPosition": {
                    "type": "boolean"
                },
                "allowResize": {
                    "type": "boolean",
                    "default": true
                },
                "allowMove": {
                    "type": "boolean",
                    "default": true
                },
                "typeName": {
                    "type": "string"
                },
                "zIndex": {
                    "type": "integer"
                },
                "chartSpace": {
                    "description": "Specifies overall settings for a chart.",
                    "type": "object",
                    "properties": {
                        "chart": {
                            "description": "Represents a chart.",
                            "type": "object",
                            "properties": {
                                "legend": {
                                    "description": "Specifies the legend.",
                                    "type": "object",
                                    "properties": {
                                        "legendPos": {
                                            "$ref": "#/definitions/LegendPosition"
                                        }
                                    }
                                },
                                "plotArea": {
                                    "description": "Specifies the plot area of the chart.",
                                    "type": "object",
                                    "properties": {
                                        "axes": {
                                            "description": "Represents the axis collection.",
                                            "type": "array",
                                            "items": {
                                                "$ref": "#/definitions/Axis"
                                            }
                                        },
                                        "chartGroups": {
                                            "description": "Represents the collection of all series in a chart.",
                                            "type": "array",
                                            "items": {
                                                "description": "Specifies the settings for each series type.",
                                                "type": "object",
                                                "properties": {
                                                    "chartType": {
                                                        "$ref": "#/definitions/CT_ChartType"
                                                    },
                                                    "ser": {
                                                        "description": "Specifies a series collection for each chart type.",
                                                        "type": "array",
                                                        "items": {
                                                            "$ref": "#/definitions/Series"
                                                        }
                                                    },
                                                    "axId": {
                                                        "description": "Specifies the axis id for series, the id is same with axId of one item in axes.",
                                                        "type": "array",
                                                        "items": {
                                                            "type": "number"
                                                        }
                                                    },
                                                    "firstSliceAng": {
                                                        "description": "Represents the first slice angle of pie chart.",
                                                        "type": "number"
                                                    }
                                                }
                                            }
                                        }
                                    }
                                },
                                "title": {
                                    "description": "Specifies the chart title.",
                                    "type": "object",
                                    "properties": {
                                        "tx": {
                                            "$ref": "#/definitions/CT_Tx"
                                        },
                                        "spPr": {
                                            "$ref": "#/definitions/ShapeProperties"
                                        },
                                        "txPr": {
                                            "$ref": "#/definitions/CT_TextBody"
                                        }
                                    }
                                }
                            }
                        },
                        "spPr": {
                            "$ref": "#/definitions/ShapeProperties"
                        },
                        "txPr": {
                            "$ref": "#/definitions/CT_TextBody"
                        }
                    }
                }
            }
        },
        "ShapeProperties": {
            "title": "ShapeProperties",
            "description": "Represents the shape properties.",
            "type": "object",
            "properties": {
                "solidFill": {
                    "$ref": "#/definitions/SolidColorFillProperties"
                },
                "ln": {
                    "description": "Represents the line or border of chart elements.",
                    "type": "object",
                    "properties": {
                        "w": {
                            "description": "Indicates the line width or border width.",
                            "type": "number"
                        },
                        "solidFill": {
                            "$ref": "#/definitions/SolidColorFillProperties"
                        }
                    }
                }
            }
        },
        "SolidColorFillProperties": {
            "title": "SolidColorFillProperties",
            "description": "Indicates the solid fill properties.",
            "type": "object",
            "properties": {
                "srgbClr": {
                    "description": "Represents the fill color is a RGB color.",
                    "type": "object",
                    "properties": {
                        "val": {
                            "description": "Specifies the value of RGB color.",
                            "type": "array",
                            "items": {
                                "type": "number"
                            }
                        }
                    }
                },
                "schemeClr": {
                    "description": "Represents the fill color is a theme color.",
                    "type": "object",
                    "properties": {
                        "lumMod": {
                            "description": "Specifies the input color with its luminance modulated by the given percentage.",
                            "type": "array",
                            "items": {
                                "type": "number"
                            }
                        },
                        "val": {
                            "$ref": "#/definitions/ColorScheme"
                        }
                    }
                }
            }
        },
        "CT_Tx": {
            "title": "CT_Tx",
            "description": " Specifies the text to use on a chart.",
            "type": "object",
            "properties": {
                "rich": {
                    "$ref": "#/definitions/CT_TextBody"
                }
            }
        },
        "CT_TextBody": {
            "title": "CT_TextBody",
            "description": "Specifies text formatting.",
            "type": "object",
            "properties": {
                "txPr": {
                    "description": "Indicates the text properties.",
                    "type": "object",
                    "properties": {
                        "p": {
                            "description": "Specifies paragraphs of text within the text body.",
                            "type": "array",
                            "items": {
                                "type": "object",
                                "properties": {
                                    "pPr": {
                                        "description": "Specifies all paragraph level text properties.",
                                        "type": "object",
                                        "properties": {
                                            "defRPr": {
                                                "description": "Specifies all default run level text properties.",
                                                "type": "object",
                                                "properties": {
                                                    "latin": {
                                                        "description": "Sepcifies a Latin font for the text.",
                                                        "type": "object",
                                                        "properties": {
                                                            "typeface": {
                                                                "description": "Specifies the typeface or name of the font.",
                                                                "type": "string"
                                                            }
                                                        }
                                                    },
                                                    "solidFill": {
                                                        "$ref": "#/definitions/SolidColorFillProperties"
                                                    },
                                                    "sz": {
                                                        "description": "Specifies the size of text.",
                                                        "type": "number"
                                                    }
                                                }
                                            }
                                        }
                                    },
                                    "elements": {
                                        "description": "Specifies the text fields.",
                                        "type": "array",
                                        "items": {
                                            "type": "object",
                                            "properties": {
                                                "t": {
                                                    "type": "string"
                                                }
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
        },
        "DataLabels": {
            "title": "Data labels",
            "description": "Represents data labels.",
            "type": "object",
            "properties": {
                "dLblPos": {
                    "$ref": "#/definitions/DataLabelPosition"
                },
                "showCatName": {
                    "description": "Specifies whether show category(x axis) name in data label.",
                    "type": "boolean"
                },
                "showSerName": {
                    "description": "Specifies whether show series name in data label.",
                    "type": "boolean"
                },
                "showVal": {
                    "description": "Specifies whether show value(y axis) name in data label.",
                    "type": "boolean"
                },
                "showPercent": {
                    "description": "Specifies whether show precentage in data label.",
                    "type": "boolean"
                },
                "numFmt": {
                    "$ref": "#/definitions/NumberFormat"
                },
                "txPr": {
                    "$ref": "#/definitions/CT_TextBody"
                }
            }
        },
        "Axis": {
            "title": "Axis",
            "description": "Represents a chart axis.",
            "type": "object",
            "properties": {
                "axId": {
                    "description": "Represents the unique id of axis, the id is used in chart group.",
                    "type": "number"
                },
                "majorGridlines": {
                    "description": "Represents the major grid line.",
                    "type": "object",
                    "properties": {
                        "spPr": {
                            "$ref": "#/definitions/ShapeProperties"
                        }
                    }
                },
                "majorTickMark": {
                    "$ref": "#/definitions/TickMark"
                },
                "majorUnit": {
                    "description": "Represents the major unit of axis.",
                    "type": "number"
                },
                "minorGridlines": {
                    "description": "Represents the minor grid line.",
                    "type": "object",
                    "properties": {
                        "spPr": {
                            "$ref": "#/definitions/ShapeProperties"
                        }
                    }
                },
                "minorTickMark": {
                    "$ref": "#/definitions/TickMark"
                },
                "minorUnit": {
                    "description": "Represents the minor unit of axis.",
                    "type": "number"
                },
                "numFmt": {
                    "$ref": "#/definitions/NumberFormat"
                },
                "title": {
                    "description": "Represents the axis title.",
                    "type": "object",
                    "properties": {
                        "tx": {
                            "$ref": "#/definitions/CT_Tx"
                        },
                        "spPr": {
                            "$ref": "#/definitions/ShapeProperties"
                        },
                        "txPr": {
                            "$ref": "#/definitions/CT_TextBody"
                        }
                    }
                },
                "delete": {
                    "description": "Represents whether the axis is invisible.",
                    "type": "boolean"
                },
                "tickLblPos": {
                    "$ref": "#/definitions/TickLabelPosition"
                },
                "scaling": {
                    "type": "object",
                    "properties": {
                        "min": {
                            "description": "Specifies the minimum value of the axis.",
                            "type": "number"
                        },
                        "max": {
                            "description": "Specifies the maximum value of the axis.",
                            "type": "number"
                        }
                    }
                },
                "spPr": {
                    "$ref": "#/definitions/ShapeProperties"
                },
                "txPr": {
                    "$ref": "#/definitions/CT_TextBody"
                }
            }
        },
        "CT_StrRef": {
            "title": "CT_StrRef",
            "description": "Represents a string reference for a single data label or title.",
            "type": "object",
            "properties": {
                "f": {
                    "description": "Specifies the formula.",
                    "type": "string"
                }
            }
        },
        "CT_NumRef": {
            "title": "CT_NumRef",
            "description": "Represents a number reference to numeric data.",
            "type": "object",
            "properties": {
                "f": {
                    "description": "Specifies the formula.",
                    "type": "string"
                }
            }
        },
        "Series": {
            "title": "Series",
            "description": "Represents a chart series.",
            "type": "object",
            "properties": {
                "cat": {
                    "description": "Specifies the data used for the category(x) axis.",
                    "type": "object",
                    "properties": {
                        "strRef": {
                            "$ref": "#/definitions/CT_StrRef"
                        }
                    }
                },
                "spPr": {
                    "$ref": "#/definitions/ShapeProperties"
                },
                "tx": {
                    "description": "Specifies text for the series name.",
                    "type": "object",
                    "properties": {
                        "strRef": {
                            "$ref": "#/definitions/CT_StrRef"
                        }
                    }
                },
                "val": {
                    "description": "Specifies the data used for the value(y) axis.",
                    "type": "object",
                    "properties": {
                        "numRef": {
                            "$ref": "#/definitions/CT_NumRef"
                        }
                    }
                },
                "xVal": {
                    "description": "Specifies the x values used for the x axis.",
                    "type": "object",
                    "properties": {
                        "numRef": {
                            "$ref": "#/definitions/CT_NumRef"
                        }
                    }
                },
                "yVal": {
                    "description": "Specifies the y values used for the y axis.",
                    "type": "object",
                    "properties": {
                        "numRef": {
                            "$ref": "#/definitions/CT_NumRef"
                        }
                    }
                },
                "bubbleSize": {
                    "description": "Specifies the data for the sizes of the bubbles on the bubble chart.",
                    "type": "object",
                    "properties": {
                        "numRef": {
                            "$ref": "#/definitions/CT_NumRef"
                        }
                    }
                },
                "dLbls": {
                    "$ref": "#/definitions/DataLabels"
                }
            }
        },
        "DataLabelPosition": {
            "title": "DataLabelPosition",
            "description": "Defines the data label position. bestFit: 0,below: 1,center: 2,insideBase: 3,insideEnd: 4,left: 5,outsideEnd: 6,right: 7,above: 8.",
            "enum": [
                0,
                1,
                2,
                3,
                4,
                5,
                6,
                7,
                8
            ]
        },
        "LegendPosition": {
            "title": "LegendPosition",
            "description": "Defines the legend position. top: 1,right: 2,left: 3,bottom: 4.",
            "enum": [
                1,
                2,
                3,
                4
            ]
        },
        "TickMark": {
            "title": "TickMark",
            "description": "Defines the tick mark position. cross: 0,inside: 1,none: 2,outside: 3.",
            "enum": [
                0,
                1,
                2,
                3
            ]
        },
        "CT_ChartType": {
            "title": "CT_ChartType",
            "description": "Defines the chart type in json. CT_StockChart: 0,CT_ScatterChart: 1,CT_RadarChart: 2,CT_BubbleChart: 3,CT_AreaChart: 4,CT_Area3DChart: 5,CT_BarChart: 6,CT_Bar3DChart: 7,CT_LineChart: 8,CT_Line3DChart: 9,CT_PieChart: 10,CT_Pie3DChart: 11,CT_DoughnutChart: 12,CT_OfPieChart: 13,CT_SurfaceChart: 14,CT_Surface3DChart: 15.",
            "enum": [
                0,
                1,
                2,
                3,
                4,
                5,
                6,
                7,
                8,
                9,
                10,
                11,
                12,
                13,
                14,
                15
            ]
        },
        "ColorScheme": {
            "title": "ColorScheme",
            "description": "Defines the scheme color. LT1: 0, DK1: 1, LT2: 2, DK2: 3, Accent1: 4, Accent2: 5, Accent3: 6, Accent4: 7, Accent5: 8, Accent6: 9, Hlink: 10, FolHlink: 11.",
            "enum": [
                0,
                1,
                2,
                3,
                4,
                5,
                6,
                7,
                8,
                9,
                10,
                11
            ]
        },
        "TickLabelPosition": {
            "title": "TickLabelPosition",
            "description": "Defines the tick label position. nextToAxis: 2, none: 3.",
            "enum": [
                2,
                3
            ]
        },
        "NumberFormat": {
            "title": "NumberFormat",
            "description": "Represents a number format.",
            "type": "object",
            "properties": {
                "formatCode": {
                    "type": "string"
                }
            }
        },
        "EditorType": {
            "title": "EditorType",
            "description": "Defines the editor type of the text cell type. textarea: 0, editableDiv: 1.",
            "enum": [
                0,
                1
            ]
        }
    }
}

 

 


© 2016-2018, GrapeCity inc. All rights reserved.