;idZddlZddlmZddlmZmZedur2ddlmZm Z m Z m Z m Z m Z ddlmZmZe d Zeee Zn dd lmZm Z mZmZm Z m Z dd lm Z edurdd lmZddlmZedurddlmZddlmZmZmZmZmZmZmZmZmZmZm Z m!Z!e e ee dde dee dee dee dee dee dee dee dee de!e deeedZej"dZ#dZ$d Z%dS)!z XML compatibility functions N)partial) DEFUSEDXMLLXMLT)Element SubElementregister_namespaceQNamexmlfile XMLParser) fromstringtostringF)resolve_entities)parser)rrr r r r)r )r ) iterparse) CHART_NS DRAWING_NSSHEET_DRAWING_NSCHART_DRAWING_NS SHEET_MAIN_NSREL_NS VTYPES_NS COREPROPS_NS CUSTPROPS_NS DCTERMS_NSDCTERMS_PREFIXXML_NSdcmitypezhttp://purl.org/dc/dcmitype/cpcasrvtxdrcdrxmlcustzutf-8)encodingz'({(?P.*)})?(?P.*)ct|jrdSt|j}|dS)Ncomment localname)callabletagNS_REGEXmatchgroup)nodems JC:\PYTHON\MyICR_Workspace\venv\Lib\site-packages\openpyxl/xml/functions.pyr+r+Ms>ytx  A 77;  c|j}|r+|j|kr"|dtzddSdSdS)Nz {%s}spacepreserve)textstripsetr)r1strippeds r3 whitespacer;TsVy  H3DI)) v%z2222233))r4)&__doc__re functoolsropenpyxlrr lxml.etreerrrr r r r r safe_parserxml.etree.ElementTree et_xmlfiledefusedxml.ElementTreeropenpyxl.xml.constantsrrrrrrrrrrrrcompiler.r+r;r4r3rHsT  %%%%%%%%4<<0///////)U333KK888JJ#"""""T555555++++++ 000000                            >:...:=>>>4&&&3!!!3 ###3 &&&34###5*+++5*+++5&!!!6<((( 78g . . . 2:? @ @   33333r4