U d@sddlmZddlZddlmZddlmZmZmZm Z m Z m Z ddl m Z ddlmZddlmZedd d d d d dgZdeZedeZGdddeZGdddeZGdddeZdS)) defaultdictN) Serialisable)AliasStringIntegerBoolSequence Descriptor) safe_string) Tokenizer) SHEETRANGE_REZ Print_AreaZ Print_TitlesZCriteriaZ_FilterDatabaseZExtractZConsolidate_AreaZ Sheet_Title|z^_xlnm\.(?P{0})c@seZdZdZeZeddZeddZeddZeddZ eddZ e ddZ e ddZe ddZe ddZe ddZe ddZeddZe ddZe ddZeZedZdddZedd Zed d Zed d ZeddZddZ dS) DefinedName definedNameT) allow_none attr_textNcCsd||_||_||_||_||_||_||_||_| |_| |_ | |_ | |_ | |_ ||_ ||_||_dSN)namecomment customMenu descriptionhelp statusBar localSheetIdhiddenfunction vbProcedurexlmfunctionGroupId shortcutKeypublishToServerworkbookParameterr)selfrrrrrrrrrrrrrr r!rr#B/tmp/pip-unpacked-wheel-rwywncvq/openpyxl/workbook/defined_name.py__init__2s zDefinedName.__init__cCs.td|j}|jd}|jdkr(|jS|jS)N=rZOPERAND)r valueitemstypesubtype)r"tokparsedr#r#r$r)Vs   zDefinedName.typeccsb|jdkr^td|j}|jD]>}|jdkrt|j}|dpJ|d}||dfVqdS)NRANGEr&Z notquotedquotedcells)r)r r'r(r*r matchgroup)r"r+partmZ sheetnamer#r#r$ destinations_s    zDefinedName.destinationscCst|j}|r|dSdS)Nr)RESERVED_REGEXr0rr1)r"r3r#r#r$ is_reservedjs zDefinedName.is_reservedcCstd|jdk S)Nz ^\[\d+\].*)recompiler0r'r"r#r#r$ is_externalqszDefinedName.is_externalccsJ|jD]>}|dkrqt||}|dk r|tkr6d|}|t|fVqdS)Nrz_xlnm.) __attrs__getattrRESERVEDr )r"keyvr#r#r$__iter__vs  zDefinedName.__iter__)NNNNNNNNNNNNNNNN)!__name__ __module__ __qualname__tagnamerrrrrrrrrrrrrrrrr r!r rrr'r%propertyr)r4r6r:r@r#r#r#r$rsX               $    rcs(eZdZdZfddZddZZS)DefinedNameDictzv Utility class for storing defined names. Allows access by name and separation of global and scoped names cs8t|tstdn|j|kr&tdt||dS)Nz*Value must be a an instance of DefinedNamez Key must be the same as the name) isinstancer TypeErrorr ValueErrorsuper __setitem__)r"r>r' __class__r#r$rKs    zDefinedNameDict.__setitem__cCs|||j<dS)zI Add names without worrying about key and name matching. N)r)r"r'r#r#r$addszDefinedNameDict.add)rArBrC__doc__rKrN __classcell__r#r#rLr$rFs rFc@s<eZdZdZeedZd ddZddZdd Z d d Z d S)DefinedNameListZ definedNames)Z expected_typer#cCs ||_dSr)r)r"rr#r#r$r%szDefinedNameList.__init__cCsVtt}|jD]B}|jdkr8|jdkr(q||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)rrFrrrint)r"namesdefnZsheetr#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"rUdr#r#r$ _duplicates zDefinedNameList._duplicatecCs t|jSr)lenrr9r#r#r$__len__szDefinedNameList.__len__N)r#) rArBrCrDrrrr%rVrXrZr#r#r#r$rQs    rQ) collectionsrr7Z!openpyxl.descriptors.serialisablerZopenpyxl.descriptorsrrrrrr Zopenpyxl.compatr Zopenpyxl.formular Zopenpyxl.utils.cellr frozensetr=joinZ_namesr8formatr5rdictrFrQr#r#r#r$s"       f