Mwg"ddlmZddlZddlmZddlmZmZmZm Z m Z m Z ddl m Z ddlmZddlmZegdZd j)eZej,d j/eZGd d eZGd deZGddeZy)) defaultdictN) Serialisable)AliasStringIntegerBoolSequence Descriptor) safe_string) Tokenizer) SHEETRANGE_RE) Print_Area Print_TitlesCriteria_FilterDatabaseExtractConsolidate_Area Sheet_Title|z^_xlnm\.(?P{0})ceZdZdZeZedZedZedZedZ edZ e dZ e dZe dZe dZe dZe dZedZe dZe dZeZedZ d dZedZedZed Zed Zd Z y) DefinedName definedNameT) allow_none attr_textNc||_||_||_||_||_||_||_||_| |_| |_ | |_ | |_ | |_ ||_ ||_||_yN)namecomment customMenu descriptionhelp statusBar localSheetIdhiddenfunction vbProcedurexlmfunctionGroupId shortcutKeypublishToServerworkbookParameterr)selfrrrr r!r"r#r$r%r&r'r(r)r*r+rs U/var/www/horilla/myenv/lib/python3.12/site-packages/openpyxl/workbook/defined_name.py__init__zDefinedName.__init__2s{$  $& "(   &.&.!2"ctd|jz}|jd}|jdk(r |jS|jS)N=rOPERAND)r valueitemstypesubtype)r,tokparseds r-r5zDefinedName.typeVsBdjj()1 ;;) #>> !{{r/c#NK|jdk(rtd|jz}|jD]j}|jdk(st j |j}|jdxs|jd}||jdflyyw)NRANGEr1 notquotedquotedcells)r5r r3r4r6r matchgroup)r,r7partm sheetnames r- destinationszDefinedName.destinations_s 99 C$**,-C  6<<7*%++DJJ7A ! 4 I8II#QWWW%555  6 s AB% AB%chtj|j}|r|jdSy)Nr)RESERVED_REGEXr>rr?)r,rAs r- is_reservedzDefinedName.is_reservedjs,   + 776? " r/cbtjdj|jduS)Nz ^\[\d+\].*)recompiler>r3r,s r- is_externalzDefinedName.is_externalqs%zz-(..tzz:$FFr/c#K|jD]3}|dk(r t||}||tvrd|z}|t|f5yw)Nrz_xlnm.) __attrs__getattrRESERVEDr )r,keyvs r-__iter__zDefinedName.__iter__vsT>> *Ck!c"A}= 1 A;q>)) *s $AA)NNNNNNNNNNNNNNNN)!__name__ __module__ __qualname__tagnamerrrrr r!r"rr#rr$r%r&r'r(r)r*r+r rrr3r.propertyr5rCrFrKrRr/r-rrs;G 8D%G4(JD)K T "D$'Id+L T "Ft$H$'K $ C.OD)Kd+O- I + E !"!!%!!%#'!!#H66## GG*r/rc(eZdZdZfdZdZxZS)DefinedNameDictzv Utility class for storing defined names. Allows access by name and separation of global and scoped names ct|ts td|j|k7r t dt |||y)Nz*Value must be a an instance of DefinedNamez Key must be the same as the name) isinstancer TypeErrorr ValueErrorsuper __setitem__)r,rPr3 __class__s r-r`zDefinedNameDict.__setitem__s@%-HI I ZZ3 ?@ @ C'r/c"|||j<y)zI Add names without worrying about key and name matching. N)r)r,r3s r-addzDefinedNameDict.adds!UZZr/)rSrTrU__doc__r`rc __classcell__)ras@r-rZrZs (!r/rZc<eZdZdZeeZddZdZdZ dZ y) DefinedNameList definedNames) expected_typec||_yr)r)r,rs r-r.zDefinedNameList.__init__s &r/ctt}|jD]W}|j"|jdvr||d|j<1t |j}||||j<Y|S)z@ Break names down into sheet locals and globals )z_xlnm.Print_Titlesz_xlnm.Print_Areaz_xlnm._FilterDatabaseglobal)rrZrr#rint)r,namesdefnsheets r-by_sheetzDefinedNameList.by_sheetszO,$$ /D  (99 cc-1h *D--.*.e TYY' / r/c|jD]7}|j|jk(s|j|jk(s7yy)zc Check for whether DefinedName with the same name and scope already exists TN)rrr#)r,rods r- _duplicatezDefinedNameList._duplicates= !! Avv"q~~9J9J'J r/c,t|jSr)lenrrJs r-__len__zDefinedNameList.__len__s4##$$r/N)rX) rSrTrUrVr rrr.rqrtrwrXr/r-rgrgs%G5K'  %r/rg) collectionsrrH!openpyxl.descriptors.serialisableropenpyxl.descriptorsrrrrr r openpyxl.compatr openpyxl.formular openpyxl.utils.cellr frozensetrOjoin_namesrIformatrErdictrZrgrXr/r-rs$ :(&- % & ( 4;;FCDc*,c*L!d!,&%l&%r/