o j@sddlmZddlZddlmZddlmZmZmZm Z m Z m Z ddl m Z ddlmZddlmZegdZd eZed eZGd d d eZGd ddeZGdddeZdS)) defaultdictN) Serialisable)AliasStringIntegerBoolSequence Descriptor) safe_string) Tokenizer) SHEETRANGE_RE) Print_Area Print_TitlesCriteria_FilterDatabaseExtractConsolidate_Area Sheet_Title|z^_xlnm\.(?P{0})c@seZdZdZeZeddZeddZeddZeddZ eddZ e ddZ e ddZe ddZe ddZe ddZe ddZeddZe ddZe ddZeZedZ                dddZedd Zed d Zed d ZeddZddZ dS) DefinedName definedNameT) allow_none attr_textNcCsd||_||_||_||_||_||_||_||_| |_| |_ | |_ | |_ | |_ ||_ ||_||_dSN)namecomment customMenu descriptionhelp statusBar localSheetIdhiddenfunction vbProcedurexlmfunctionGroupId shortcutKeypublishToServerworkbookParameterr)selfrrrrrrr r!r"r#r$r%r&r'r(rr*b/var/www/ticemtrilhas/avaliacao_env/lib/python3.10/site-packages/openpyxl/workbook/defined_name.py__init__2s  zDefinedName.__init__cCs.td|j}|jd}|jdkr|jS|jS)N=rOPERAND)r valueitemstypesubtype)r)tokparsedr*r*r+r1Vs   zDefinedName.typeccsh|jdkr0td|j}|jD]!}|jdkr/t|j}|dp&|d}||dfVqdSdS)NRANGEr- notquotedquotedcells)r1r r/r0r2r matchgroup)r)r3partm sheetnamer*r*r+ destinations_s    zDefinedName.destinationscCst|j}|r |dSdS)Nr)RESERVED_REGEXr9rr:)r)r<r*r*r+ is_reservedjs  zDefinedName.is_reservedcCstd|jduS)Nz ^\[\d+\].*)recompiler9r/r)r*r*r+ is_externalqszDefinedName.is_externalccsL|jD]}|dkr qt||}|dur#|tvrd|}|t|fVqdS)Nrz_xlnm.) __attrs__getattrRESERVEDr )r)keyvr*r*r+__iter__vs  zDefinedName.__iter__)NNNNNNNNNNNNNNNN)!__name__ __module__ __qualname__tagnamerrrrrrrrr rr!r"r#r$r%r&r'r(r rrr/r,propertyr1r>r@rDrJr*r*r*r+rsZ               $     rcs(eZdZdZfddZddZZS)DefinedNameDictzv Utility class for storing defined names. Allows access by name and separation of global and scoped names cs6t|ts td|j|krtdt||dS)Nz*Value must be a an instance of DefinedNamez Key must be the same as the name) isinstancer TypeErrorr ValueErrorsuper __setitem__)r)rHr/ __class__r*r+rUs  zDefinedNameDict.__setitem__cCs|||j<dS)zI Add names without worrying about key and name matching. N)r)r)r/r*r*r+addszDefinedNameDict.add)rKrLrM__doc__rUrX __classcell__r*r*rVr+rPs rPc@s<eZdZdZeedZd ddZddZdd Z d d Z d S)DefinedNameList definedNames) expected_typer*cCs ||_dSr)r)r)rr*r*r+r, zDefinedNameList.__init__cCsVtt}|jD]!}|jdur|jdvrq||d|j<qt|j}||||j<q|S)z@ Break names down into sheet locals and globals N)z_xlnm.Print_Titlesz_xlnm.Print_Areaz_xlnm._FilterDatabaseglobal)rrPrr rint)r)namesdefnsheetr*r*r+by_sheets    zDefinedNameList.by_sheetcCs.|jD]}|j|jkr|j|jkrdSqdS)zc Check for whether DefinedName with the same name and scope already exists TN)rrr )r)rbdr*r*r+ _duplicates zDefinedNameList._duplicatecCs t|jSr)lenrrCr*r*r+__len__r^zDefinedNameList.__len__N)r*) rKrLrMrNrrrr,rdrfrhr*r*r*r+r[s   r[) collectionsrrA!openpyxl.descriptors.serialisableropenpyxl.descriptorsrrrrrr openpyxl.compatr openpyxl.formular openpyxl.utils.cellr frozensetrGjoin_namesrBformatr?rdictrPr[r*r*r*r+s        f