fhHddlmZddlZddlmZddlmZmZmZm Z m Z m Z ddl m Z ddlmZddlmZegdZd eZejd eZGd d eZGd deZGddeZdS)) defaultdictN) Serialisable)AliasStringIntegerBoolSequence Descriptor) safe_string) Tokenizer) SHEETRANGE_RE) Print_Area Print_TitlesCriteria_FilterDatabaseExtractConsolidate_Area Sheet_Title|z^_xlnm\.(?P{0})c&eZdZdZeZedZedZedZedZ edZ e dZ e dZe dZe dZe dZe dZedZe dZe dZeZedZ d dZedZedZed Zed Zd Z dS) DefinedName definedNameT) allow_none attr_textNc||_||_||_||_||_||_||_||_| |_| |_ | |_ | |_ | |_ ||_ ||_||_dSN)namecomment customMenu descriptionhelp statusBar localSheetIdhiddenfunction vbProcedurexlmfunctionGroupId shortcutKeypublishToServerworkbookParameterr)selfrrrr r!r"r#r$r%r&r'r(r)r*r+rs U/var/www/histauto/venv/lib/python3.11/site-packages/openpyxl/workbook/defined_name.py__init__zDefinedName.__init__2s$  $& "(   &.&.!2"c|td|jz}|jd}|jdkr|jS|jS)N=rOPERAND)r valueitemstypesubtype)r,tokparseds r-r5zDefinedName.typeVs>dj())1 ;) # #> !{r/c#4K|jdkrtd|jz}|jD]k}|jdkr\t j|j}|dp|d}||dfVjdSdS)NRANGEr1 notquotedquotedcells)r5r r3r4r6r matchgroup)r,r7partm sheetnames r- destinationszDefinedName.destinations_s 9  C$*,--C  6 6<7**%+DJ77A ! 4 4 I8I8II#QWWW%5%55555  6 6r/crt|j}|r|dSdS)Nr)RESERVED_REGEXr>rr?)r,rAs r- is_reservedzDefinedName.is_reservedjs9   + +  #776?? " # #r/c^tjd|jduS)Nz ^\[\d+\].*)recompiler>r3r,s r- is_externalzDefinedName.is_externalqs'z-((..tz::$FFr/c#K|jD]<}|dkr t||}|!|tvrd|z}|t|fV=dS)Nrz_xlnm.) __attrs__getattrRESERVEDr )r,keyvs r-__iter__zDefinedName.__iter__vsm> * *Ck!!c""A}== 1 A;q>>)))) * *r/)NNNNNNNNNNNNNNNN)!__name__ __module__ __qualname__tagnamerrrrr r!r"rr#rr$r%r&r'r(r)r*r+r rrr3r.propertyr5rCrFrKrRr/r-rrsG 688Df%%%G4(((J&D)))K 6T " " "D$'''I7d+++L TT " " "Ftt$$$H$$'''K $$   Cg...O&D)))Kdd+++O--- I E+  E !"!!%!!%#'!!#!#!#!#HX66X6##X# GGXG*****r/rc(eZdZdZfdZdZxZS)DefinedNameDictzv Utility class for storing defined names. Allows access by name and separation of global and scoped names ct|tstd|j|krt dt ||dS)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__sa%-- AHII I Z3  ?@@ @ C'''''r/c|||j<dS)zI Add names without worrying about key and name matching. N)r)r,r3s r-addzDefinedNameDict.adds!UZr/)rSrTrU__doc__r`rc __classcell__)ras@r-rZrZsQ (((((!!!!!!!r/rZcDeZdZdZeeZd dZdZdZ dZ dS) DefinedNameList definedNames) expected_typerXc||_dSr)r)r,rs r-r.zDefinedNameList.__init__s&r/ctt}|jD]H}|j|jdvr||d|j<$t |j}||||j<I|S)z@ Break names down into sheet locals and globals N)z_xlnm.Print_Titlesz_xlnm.Print_Areaz_xlnm._FilterDatabaseglobal)rrZrr#rint)r,namesdefnsheets r-by_sheetzDefinedNameList.by_sheetsxO,,$ / /D (9 ccc-1h **D-..*.e TY'' r/c`|jD]%}|j|jkr|j|jkrdS&dS)zc Check for whether DefinedName with the same name and scope already exists TN)rrr#)r,rods r- _duplicatezDefinedNameList._duplicatesF !  Av""q~9J'J'Jtt  r/c*t|jSr)lenrrJs r-__len__zDefinedNameList.__len__s4#$$$r/N)rX) rSrTrUrVr rrr.rqrtrwrXr/r-rgrgslG(555K''''    %%%%%r/rg) collectionsrrH!openpyxl.descriptors.serialisableropenpyxl.descriptorsrrrrr r openpyxl.compatr openpyxl.formular openpyxl.utils.cellr frozensetrOjoin_namesrIformatrErdictrZrgrXr/r-rs$##### ::::::('''''&&&&&&------ 9%%% & & (  4;;FCCDDc*c*c*c*c*,c*c*c*L!!!!!d!!!,&%&%&%&%&%l&%&%&%&%&%r/