class CT_ColorFilter(BaseOxmlElement): """ Complex type (sml-autoFilter.xsd) """ dxfId = OptionalAttribute('dxfId', ST_DxfId) # Differential Format Record Id cellColor = OptionalAttribute('cellColor', XsdBoolean, True) # Filter By Cell Color
class CT_DocGrid(BaseOxmlElement): """ ``<w:DocGrid>`` """ type = OptionalAttribute('w:type', ST_DocGrid) linePitch = OptionalAttribute('w:linePitch', ST_DecimalNumber) charSpace = OptionalAttribute('w:charSpace', ST_DecimalNumber)
class CT_SmartTagPr(BaseOxmlElement): """ Complex type (sml-workbook.xsd) """ embed = OptionalAttribute('embed', XsdBoolean, False) # Embed SmartTags show = OptionalAttribute('show', ST_SmartTagShow, 'all') # Show Smart Tags
class CT_Blip(BaseOxmlElement): """ ``<a:blip>`` element, specifies image source and adjustments such as alpha and tint. """ embed = OptionalAttribute('r:embed', ST_RelationshipId) link = OptionalAttribute('r:link', ST_RelationshipId)
class CT_CellProtection(BaseOxmlElement): """ Complex type (sml-styles.xsd) """ locked = OptionalAttribute('locked', XsdBoolean) # Cell Locked hidden = OptionalAttribute('hidden', XsdBoolean) # Hidden Cell
class CT_CustomFilter(BaseOxmlElement): """ Complex type (sml-autoFilter.xsd) """ operator = OptionalAttribute('operator', ST_FilterOperator, 'equal') # Filter Comparison Operator val = OptionalAttribute('val', ST_Xstring) # Top or Bottom Value
class CT_SST(BaseOxmlElement): si = ZeroOrMore('ssml:si') extLst = ZeroOrOne('ssml:extLst') # None count = OptionalAttribute('count', XsdUnsignedInt) # String Count uniqueCount = OptionalAttribute('uniqueCount', XsdUnsignedInt) # Unique String Count
class CT_ChartsheetProtection(BaseOxmlElement): """ Complex type (sml-sheet.xsd) """ password = OptionalAttribute('password', ST_UnsignedShortHex) # Password content = OptionalAttribute('content', XsdBoolean, False) # Contents objects = OptionalAttribute('objects', XsdBoolean, False) # Objects Locked
class CT_TableStyleElement(BaseOxmlElement): """ Complex type (sml-styles.xsd) """ type = RequiredAttribute('type', ST_TableStyleType) # Table Style Type size = OptionalAttribute('size', XsdUnsignedInt, 1) # Band Size dxfId = OptionalAttribute('dxfId', ST_DxfId) # Formatting Id
class CT_DynamicFilter(BaseOxmlElement): """ Complex type (sml-autoFilter.xsd) """ type = RequiredAttribute('type', ST_DynamicFilterType) # Dynamic filter type val = OptionalAttribute('val', XsdDouble) # Value maxVal = OptionalAttribute('maxVal', XsdDouble) # Max Value
class CT_PhoneticPr(BaseOxmlElement): """ Complex type: """ fontId = RequiredAttribute('fontId', ST_FontId) # Font Id type = OptionalAttribute('type', ST_PhoneticType) # Character Type alignment = OptionalAttribute('alignment', ST_PhoneticAlignment) # Alignment
class CT_Ind(BaseOxmlElement): """ ``<w:ind>`` element, specifying paragraph indentation. """ left = OptionalAttribute('w:left', ST_SignedTwipsMeasure) right = OptionalAttribute('w:right', ST_SignedTwipsMeasure) firstLine = OptionalAttribute('w:firstLine', ST_TwipsMeasure) hanging = OptionalAttribute('w:hanging', ST_TwipsMeasure)
class CT_Top10(BaseOxmlElement): """ Complex type (sml-autoFilter.xsd) """ top = OptionalAttribute('top', XsdBoolean, True) # Top percent = OptionalAttribute('percent', XsdBoolean, False) # Filter by Percent val = RequiredAttribute('val', XsdDouble) # Top or Bottom Value filterVal = OptionalAttribute('filterVal', XsdDouble) # Filter Value
class CT_Fonts(BaseOxmlElement): """ ``<w:rFonts>`` element, specifying typeface name for the various language types. """ ascii = OptionalAttribute('w:ascii', ST_String) hAnsi = OptionalAttribute('w:hAnsi', ST_String) hint = OptionalAttribute('w:hint', ST_Hint) eastAsia = OptionalAttribute('w:eastAsia', ST_String)
class CT_Spacing(BaseOxmlElement): """ ``<w:spacing>`` element, specifying paragraph spacing attributes such as space before and line spacing. """ after = OptionalAttribute('w:after', ST_TwipsMeasure) before = OptionalAttribute('w:before', ST_TwipsMeasure) line = OptionalAttribute('w:line', ST_SignedTwipsMeasure) lineRule = OptionalAttribute('w:lineRule', WD_LINE_SPACING)
class CT_ChartsheetPr(BaseOxmlElement): """ Complex type (sml-sheet.xsd) """ tabColor = ZeroOrOne('ssml:tabColor') # None published = OptionalAttribute('published', XsdBoolean, True) # Published codeName = OptionalAttribute('codeName', XsdString) # Code Name
class CT_DataRef(BaseOxmlElement): """ Complex type (sml-sheet.xsd) """ ref = OptionalAttribute('ref', ST_Ref) # Reference name = OptionalAttribute('name', ST_Xstring) # Named Range sheet = OptionalAttribute('sheet', ST_Xstring) # Sheet Name rid = OptionalAttribute('r:id', ST_RelationshipId) # relationship Id
class CT_PageSz(BaseOxmlElement): """ ``<w:pgSz>`` element, defining page dimensions and orientation. """ w = OptionalAttribute('w:w', ST_TwipsMeasure) h = OptionalAttribute('w:h', ST_TwipsMeasure) orient = OptionalAttribute( 'w:orient', WD_ORIENTATION, default=WD_ORIENTATION.PORTRAIT )
class CT_SmartTagType(BaseOxmlElement): """ Complex type (sml-workbook.xsd) """ namespaceUri = OptionalAttribute('namespaceUri', ST_Xstring) # SmartTag Namespace URI name = OptionalAttribute('name', ST_Xstring) # Name url = OptionalAttribute('url', ST_Xstring) # Smart Tag URL
class CT_PageSetUpPr(BaseOxmlElement): """ Complex type (sml-sheet.xsd) """ autoPageBreaks = OptionalAttribute('autoPageBreaks', XsdBoolean, True) # Show Auto Page Breaks fitToPage = OptionalAttribute('fitToPage', XsdBoolean, False) # Fit To Page
class CT_CellSmartTag(BaseOxmlElement): """ Complex type (sml-sheet.xsd) """ cellSmartTagPr = ZeroOrMore('ssml:cellSmartTagPr') # Smart Tag Properties type = RequiredAttribute('type', XsdUnsignedInt) # Smart Tag Type Index deleted = OptionalAttribute('deleted', XsdBoolean, False) # Deleted xmlBased = OptionalAttribute('xmlBased', XsdBoolean, False) # XML Based
class CT_Cfvo(BaseOxmlElement): """ Complex type (sml-sheet.xsd) """ extLst = ZeroOrOne('ssml:extLst') # None type = RequiredAttribute('type', ST_CfvoType) # Type val = OptionalAttribute('val', ST_Xstring) # Value gte = OptionalAttribute('gte', XsdBoolean, True) # Greater Than Or Equal
class CT_PageBreak(BaseOxmlElement): """ Complex type (sml-sheet.xsd) """ brk = ZeroOrMore('ssml:brk') # Break count = OptionalAttribute('count', XsdUnsignedInt, 0) # Page Break Count manualBreakCount = OptionalAttribute('manualBreakCount', XsdUnsignedInt, 0) # Manual Break Count
class CT_Break(BaseOxmlElement): """ Complex type (sml-sheet.xsd) """ id = OptionalAttribute('id', XsdUnsignedInt, 0) # Id min = OptionalAttribute('min', XsdUnsignedInt, 0) # Minimum max = OptionalAttribute('max', XsdUnsignedInt, 0) # Maximum man = OptionalAttribute('man', XsdBoolean, False) # Manual Page Break pt = OptionalAttribute('pt', XsdBoolean, False) # Pivot-Created Page Break
class CT_Hyperlink(BaseOxmlElement): """ Complex type (sml-sheet.xsd) """ ref = RequiredAttribute('ref', ST_Ref) # Reference rid = OptionalAttribute('r:id', ST_RelationshipId) # Relationship Id location = OptionalAttribute('location', ST_Xstring) # Location tooltip = OptionalAttribute('tooltip', ST_Xstring) # Tool Tip display = OptionalAttribute('display', ST_Xstring) # Display String
class CT_Filters(BaseOxmlElement): """ Complex type (sml-autoFilter.xsd) """ filter = ZeroOrMore('ssml:filter') # Filter dateGroupItem = ZeroOrMore('ssml:dateGroupItem') # Date Grouping blank = OptionalAttribute('blank', XsdBoolean, False) # Filter by Blank calendarType = OptionalAttribute('calendarType', ST_CalendarType, 'none') # Calendar Type
class CT_Scenarios(BaseOxmlElement): """ Complex type (sml-sheet.xsd) """ scenario = OneOrMore('ssml:scenario') # Scenario current = OptionalAttribute('current', XsdUnsignedInt) # Current Scenario show = OptionalAttribute('show', XsdUnsignedInt) # Last Shown Scenario sqref = OptionalAttribute('sqref', ST_Sqref) # Sequence of References
class CT_ProtectedRange(BaseOxmlElement): """ Complex type (sml-sheet.xsd) """ password = OptionalAttribute('password', ST_UnsignedShortHex) # Password sqref = RequiredAttribute('sqref', ST_Sqref) # Sequence of References name = RequiredAttribute('name', ST_Xstring) # Name securityDescriptor = OptionalAttribute('securityDescriptor', XsdString) # Security Descriptor
class CT_InputCells(BaseOxmlElement): """ Complex type (sml-sheet.xsd) """ r = RequiredAttribute('r', ST_CellRef) # Reference deleted = OptionalAttribute('deleted', XsdBoolean, False) # Deleted undone = OptionalAttribute('undone', XsdBoolean, False) # Undone val = RequiredAttribute('val', ST_Xstring) # Value numFmtId = OptionalAttribute('numFmtId', ST_NumFmtId) # Number Format Id
class CT_SheetPr(BaseOxmlElement): """ Complex type (sml-sheet.xsd) """ tabColor = ZeroOrOne('ssml:tabColor') # Sheet Tab Color outlinePr = ZeroOrOne('ssml:outlinePr') # Outline Properties pageSetUpPr = ZeroOrOne('ssml:pageSetUpPr') # Page Setup Properties syncHorizontal = OptionalAttribute('syncHorizontal', XsdBoolean, False) # Synch Horizontal syncVertical = OptionalAttribute('syncVertical', XsdBoolean, False) # Synch Vertical syncRef = OptionalAttribute('syncRef', ST_Ref) # Synch Reference transitionEvaluation = OptionalAttribute( 'transitionEvaluation', XsdBoolean, False) # Transition Formula Evaluation transitionEntry = OptionalAttribute('transitionEntry', XsdBoolean, False) # Transition Formula Entry published = OptionalAttribute('published', XsdBoolean, True) # Published codeName = OptionalAttribute('codeName', XsdString) # Code Name filterMode = OptionalAttribute('filterMode', XsdBoolean, False) # Filter Mode enableFormatConditionsCalculation = OptionalAttribute( 'enableFormatConditionsCalculation', XsdBoolean, True) # Enable Conditional Formatting Calculations