openpyxl.xml.constants

Constants for fixed paths in a file and xml namespace urls.

ACTIVEX

attributeACTIVEX

= 'application/vnd.ms-office.activeX+xml'

ARC_APP

attributeARC_APP

= PACKAGE_PROPS + '/app.xml'

ARC_CONTENT_TYPES

attributeARC_CONTENT_TYPES

= '[Content_Types].xml'

ARC_CORE

attributeARC_CORE

= PACKAGE_PROPS + '/core.xml'

ARC_CUSTOM

attributeARC_CUSTOM

= PACKAGE_PROPS + '/custom.xml'

ARC_CUSTOM_UI

attributeARC_CUSTOM_UI

= 'customUI/customUI.xml'

ARC_ROOT_RELS

attributeARC_ROOT_RELS

= PACKAGE_RELS + '/.rels'

ARC_SHARED_STRINGS

attributeARC_SHARED_STRINGS

= PACKAGE_XL + '/sharedStrings.xml'

ARC_STYLE

attributeARC_STYLE

= PACKAGE_XL + '/styles.xml'

ARC_THEME

attributeARC_THEME

= PACKAGE_THEME + '/theme1.xml'

ARC_WORKBOOK

attributeARC_WORKBOOK

= PACKAGE_XL + '/workbook.xml'

ARC_WORKBOOK_RELS

attributeARC_WORKBOOK_RELS

= PACKAGE_XL + '/' + PACKAGE_RELS + '/workbook.xml.rels'

CHARTSHAPE_TYPE

attributeCHARTSHAPE_TYPE

= 'application/vnd.openxmlformats-officedocument.drawingml.chartshapes+xml'

CHARTSHEET_TYPE

attributeCHARTSHEET_TYPE

= SPREADSHEET % 'chartsheet'

CHART_DRAWING_NS

attributeCHART_DRAWING_NS

= 'http://schemas.openxmlformats.org/drawingml/2006/chartDrawing'

CHART_NS

attributeCHART_NS

= 'http://schemas.openxmlformats.org/drawingml/2006/chart'

CHART_TYPE

attributeCHART_TYPE

= 'application/vnd.openxmlformats-officedocument.drawingml.chart+xml'

COMMENTS_NS

attributeCOMMENTS_NS

= REL_NS + '/comments'

COMMENTS_TYPE

attributeCOMMENTS_TYPE

= SPREADSHEET % 'comments'

CONTYPES_NS

attributeCONTYPES_NS

= PKG_NS + 'content-types'

COREPROPS_NS

attributeCOREPROPS_NS

= PKG_NS + 'metadata/core-properties'

CPROPS_FMTID

attributeCPROPS_FMTID

= '{D5CDD505-2E9C-101B-9397-08002B2CF9AE}'

CPROPS_TYPE

attributeCPROPS_TYPE

= 'application/vnd.openxmlformats-officedocument.custom-properties+xml'

CTRL

attributeCTRL

= 'application/vnd.ms-excel.controlproperties+xml'

CUSTOMUI_NS

attributeCUSTOMUI_NS

= 'http://schemas.microsoft.com/office/2006/relationships/ui/extensibility'

CUSTPROPS_NS

attributeCUSTPROPS_NS

= DOC_NS + 'custom-properties'

DCORE_NS

attributeDCORE_NS

= 'http://purl.org/dc/elements/1.1/'

DCTERMS_NS

attributeDCTERMS_NS

= 'http://purl.org/dc/terms/'

DCTERMS_PREFIX

attributeDCTERMS_PREFIX

= 'dcterms'

DOC_NS

attributeDOC_NS

= 'http://schemas.openxmlformats.org/officeDocument/2006/'

DRAWING_NS

attributeDRAWING_NS

= 'http://schemas.openxmlformats.org/drawingml/2006/main'

DRAWING_TYPE

attributeDRAWING_TYPE

= 'application/vnd.openxmlformats-officedocument.drawing+xml'

EXTERNAL_LINK

attributeEXTERNAL_LINK

= SPREADSHEET % 'externalLink'

EXTERNAL_LINK_NS

attributeEXTERNAL_LINK_NS

= REL_NS + '/externalLink'

EXT_TYPES

attributeEXT_TYPES

= {'{78C0D931-6437-407D-A8EE-F0AAD7539E65}': 'Conditional Formatting', '{CCE6A557-97BC-4B89-ADB6-D9C93CAAB3DF}': 'Data Validation', '{05C60535-1F16-4FD2-B633-F4F36F0B64E0}': 'Sparkline Group', '{A8765BA9-456A-4DAB-B4F3-ACF838C121DE}': 'Slicer List', '{FC87AEE6-9EDD-4A0A-B7FB-166176984837}': 'Protected Range', '{01252117-D84E-4E92-8308-4BE1C098FCBB}': 'Ignored Error', '{F7C9EE02-42E1-4005-9D12-6889AFFD525C}': 'Web Extension', '{3A4CF648-6AED-40f4-86FF-DC5316D8AED3}': 'Slicer List', '{7E03D99C-DC04-49d9-9315-930204A7B6E9}': 'Timeline Ref'}

IMAGE_NS

attributeIMAGE_NS

= REL_NS + '/image'

MAX_COLUMN

attributeMAX_COLUMN

= 16384

MAX_ROW

attributeMAX_ROW

= 1048576

MIN_COLUMN

attributeMIN_COLUMN

= 0

MIN_ROW

attributeMIN_ROW

= 0

NAMESPACES

attributeNAMESPACES

= {'cp': COREPROPS_NS, 'dc': DCORE_NS, DCTERMS_PREFIX: DCTERMS_NS, 'dcmitype': 'http://purl.org/dc/dcmitype/', 'xsi': XSI_NS, 'vt': VTYPES_NS, 'xml': XML_NS, 'main': SHEET_MAIN_NS, 'cust': CUSTPROPS_NS}

PACKAGE_CHARTS

attributePACKAGE_CHARTS

= PACKAGE_XL + '/' + 'charts'

PACKAGE_CHARTSHEETS

attributePACKAGE_CHARTSHEETS

= PACKAGE_XL + '/' + 'chartsheets'

PACKAGE_CHARTSHEETS_RELS

attributePACKAGE_CHARTSHEETS_RELS

= PACKAGE_CHARTSHEETS + '/' + '_rels'

PACKAGE_DRAWINGS

attributePACKAGE_DRAWINGS

= PACKAGE_XL + '/' + 'drawings'

PACKAGE_IMAGES

attributePACKAGE_IMAGES

= PACKAGE_XL + '/' + 'media'

PACKAGE_PIVOT_CACHE

attributePACKAGE_PIVOT_CACHE

= PACKAGE_XL + '/' + 'pivotCache'

PACKAGE_PIVOT_TABLE

attributePACKAGE_PIVOT_TABLE

= PACKAGE_XL + '/' + 'pivotTables'

PACKAGE_PROPS

attributePACKAGE_PROPS

= 'docProps'

PACKAGE_RELS

attributePACKAGE_RELS

= '_rels'

PACKAGE_THEME

attributePACKAGE_THEME

= PACKAGE_XL + '/' + 'theme'

PACKAGE_WORKSHEETS

attributePACKAGE_WORKSHEETS

= PACKAGE_XL + '/' + 'worksheets'

PACKAGE_WORKSHEET_RELS

attributePACKAGE_WORKSHEET_RELS

= PACKAGE_WORKSHEETS + '/' + '_rels'

PACKAGE_XL

attributePACKAGE_XL

= 'xl'

PKG_NS

attributePKG_NS

= 'http://schemas.openxmlformats.org/package/2006/'

PKG_REL_NS

attributePKG_REL_NS

= PKG_NS + 'relationships'

REL_NS

attributeREL_NS

= DOC_NS + 'relationships'

SHARED_STRINGS

attributeSHARED_STRINGS

= SPREADSHEET % 'sharedStrings'

SHEET_DRAWING_NS

attributeSHEET_DRAWING_NS

= 'http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing'

SHEET_MAIN_NS

attributeSHEET_MAIN_NS

= 'http://schemas.openxmlformats.org/spreadsheetml/2006/main'

SPREADSHEET

attributeSPREADSHEET

= 'application/vnd.openxmlformats-officedocument.spreadsheetml.%s+xml'

STYLES_TYPE

attributeSTYLES_TYPE

= SPREADSHEET % 'styles'

THEME_TYPE

attributeTHEME_TYPE

= 'application/vnd.openxmlformats-officedocument.theme+xml'

VBA

attributeVBA

= 'application/vnd.ms-office.vbaProject'

VML_NS

attributeVML_NS

= REL_NS + '/vmlDrawing'

VTYPES_NS

attributeVTYPES_NS

= DOC_NS + 'docPropsVTypes'

WORKBOOK

attributeWORKBOOK

= 'application/vnd.openxmlformats-officedocument.spreadsheetml.%s.main+xml'

WORKBOOK_MACRO

attributeWORKBOOK_MACRO

= 'application/vnd.ms-excel.%s.macroEnabled.main+xml'

WORKSHEET_TYPE

attributeWORKSHEET_TYPE

= SPREADSHEET % 'worksheet'

XLSM

attributeXLSM

= WORKBOOK_MACRO % 'sheet'

XLSX

attributeXLSX

= WORKBOOK % 'sheet'

XLTM

attributeXLTM

= WORKBOOK_MACRO % 'template'

XLTX

attributeXLTX

= WORKBOOK % 'template'

XML_NS

attributeXML_NS

= 'http://www.w3.org/XML/1998/namespace'

XPROPS_NS

attributeXPROPS_NS

= DOC_NS + 'extended-properties'

XSI_NS

attributeXSI_NS

= 'http://www.w3.org/2001/XMLSchema-instance'