o ˷e@sddlZddlmZddlmZmZmZmZmZm Z m Z m Z m Z m Z ddlmZddlmZddlmZmZegdZdeZed eZd ZeeZd ZeeZed eeeej Z!d dZ"ddZ#GdddeZ$GdddeZ%dS)N) Serialisable) AliasTypedStringFloatIntegerBoolNoneSetSetSequence Descriptor) safe_string) Tokenizer) SHEETRANGE_RE SHEET_TITLE) Print_Area Print_TitlesCriteria_FilterDatabaseExtractConsolidate_Area Sheet_Title|z^_xlnm\.(?P{0})z-(?P[$]?[a-zA-Z]{1,3}:[$]?[a-zA-Z]{1,3})z(?P[$]?\d+:[$]?\d+)z {0}{1}?,?{2}?cCs2t|j}tdd|D}|d|dfS)zg Extract rows and or columns from print titles so that they can be assigned to a worksheet css2|]}|D] \}}|r ||fVq qdSN) groupdictitems).0matchkvr U/var/www/ideatree/venv/lib/python3.10/site-packages/openpyxl/workbook/defined_name.py /s  z'_unpack_print_titles..rowscols) TITLES_REGEXfinditervaluedictget)defnscannerkwr r r!_unpack_print_titles)s r-cCs2g}t|jD]}|d}|r||q|S)z Extract print area cells)rr&r'groupappend)r*newmcoordr r r!_unpack_print_area5s  r4c@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||_||_||_||_||_||_||_||_| |_| |_ | |_ | |_ | |_ ||_ ||_||_dSr)namecomment customMenu descriptionhelp statusBar localSheetIdhiddenfunction vbProcedurexlmfunctionGroupId shortcutKeypublishToServerworkbookParameterr8)selfr9r:r;r<r=r>r?r@rArBrCrDrErFrGr8r r r!__init__Xs  zDefinedName.__init__cCs.td|j}|jd}|jdkr|jS|jS)N=rOPERAND)rr'rtypesubtype)rHtokparsedr r r!rL|s   zDefinedName.typeccsh|jdkr0td|j}|jD]!}|jdkr/t|j}|dp&|d}||dfVqdSdS)NRANGErJ notquotedquotedr.)rLrr'rrMrrr/)rHrNpartr2 sheetnamer r r! destinationss    zDefinedName.destinationscCst|j}|r |dSdS)Nr9)RESERVED_REGEXrr9r/)rHr2r r r! is_reserveds  zDefinedName.is_reservedcCstd|jduS)Nz ^\[\d+\].*)recompilerr'rHr r r! is_externalszDefinedName.is_externalccsL|jD]}|dkr qt||}|dur#|tvrd|}|t|fVqdS)Nr8z_xlnm.) __attrs__getattrRESERVEDr )rHkeyrr r r!__iter__s  zDefinedName.__iter__)NNNNNNNNNNNNNNNN)!__name__ __module__ __qualname__tagnamerr9r:r;r<r=r>rr?rr@rArBrCrDrErFrGr r8rr'rIpropertyrLrUrWr[r`r r r r!r5AsZ               $     r5c@sxeZdZdZeedZdddZddZdd Z d d Z d d Z ddZ ddZ dddZddZdddZddZdS)DefinedNameList definedNames) expected_typer cCs ||_dSrr6)rHr6r r r!rI zDefinedNameList.__init__cCsFg}|jD]}|jdvr|jdurq|jdkrq||q||_dS)zJ Strip invalid definitions and remove special hidden ones )z_xlnm.Print_Titlesz_xlnm.Print_AreaNz_xlnm._FilterDatabase)r6r9r?r0)rH valid_namesnr r r!_cleanups    zDefinedNameList._cleanupcCs.|jD]}|j|jkr|j|jkrdSqdS)zc Check for whether DefinedName with the same name and scope already exists TNr6r9r?)rHr*dr r r! _duplicates zDefinedNameList._duplicatecCsFt|ts td||rtd|jdd}||||_dS)Nz You can only append DefinedNamesz7DefinedName with the same name and scope already exists) isinstancer5 TypeErrorrp ValueErrorr6r0)rHr*namesr r r!r0s    zDefinedNameList.appendcCs t|jSr)lenr6rZr r r!__len__rjzDefinedNameList.__len__cCs*|jD]}|j|kr|jdurdSqdS)z6 See if a globaly defined name exists NTrnrHr9r*r r r! __contains__s zDefinedNameList.__contains__cCs ||}|std||S)z+ Get globally defined name zNo definition called {0})r)KeyErrorformatrwr r r! __getitem__s zDefinedNameList.__getitem__NcCs,|jD]}|j|kr|j|kr|SqdS)zE Get the name assigned to a specicic sheet or global Nrn)rHr9scoper*r r r!r)s zDefinedNameList.getcCs||s td|dS)z0 Delete a globally defined name zNo globally defined name {0}N)deleteryrz)rHr9r r r! __delitem__s zDefinedNameList.__delitem__cCs:t|jD]\}}|j|kr|j|kr|j|=dSqdS)z@ Delete a name assigned to a specific or global TN) enumerater6r9r?)rHr9r|idxr*r r r!r}s zDefinedNameList.deletecsfdd|jDS)zH Provide a list of all names for a particular worksheet csg|] }|jkr|jqSr )r?r9)rr*r|r r! sz.DefinedNameList.localnames..ri)rHr|r rr! localnamesszDefinedNameList.localnames)r r)rarbrcrdr r5r6rIrmrpr0rvrxr{r)r~r}rr r r r!rfs       rf)&rX!openpyxl.descriptors.serialisableropenpyxl.descriptorsrrrrrrr r r r openpyxl.compatr openpyxl.formularopenpyxl.utils.cellrr frozensetr^join_namesrYrzrV COL_RANGE COL_RANGE_RE ROW_RANGE ROW_RANGE_REVERBOSEr%r-r4r5rfr r r r!s( 0       f