o ]oih@s.ddlmZddlmZGdddejZdS)) xmlwriter)warncseZdZdZdfdd ZddZddd Zd d Zdd dZdddZ dddZ dddZ dddZ dddZ dddZddZdddZdd d!Zd"d#Zdd$d%Zdd&d'Zd(d)Zdd*d+Zdd,d-Zdd.d/Zdd0d1Zd2d3Zd4d5Zdd6d7Zd8d9Zdd:d;Zdd?Z dd@dAZ!dBdCZ"ddDdEZ#dFdGZ$ddHdIZ%dJdKZ&dLdMZ'ddNdOZ(ddPdQZ)ddRdSZ*ddTdUZ+dVdWZ,dXdYZ-dZd[Z.d\d]Z/d^d_Z0d`daZ1ddcddZ2dedfZ3dgdhZ4didjZ5dkdlZ6dmdnZ7dodpZ8dqdrZ9ddsdtZ:dudvZ;ddwdxZd}d~Z?ddZ@ddZAddZBddZCddZDddZEddZFddZGddZHddZIZJS)Formatz; A class for writing the Excel XLSX Format file. Ncs|duri}tt|||_||_d|_d|_d|_d|_d|_ d|_ d|_ d|_ d|_ d|_d|_d|_d|_d|_d|_d|_d|_d|_d|_d|_d|_d|_d|_d|_d|_d|_d |_d|_ d|_!d|_"d|_#d|_$d|_%d|_&d|_'d|_(d|_)d|_*d|_+d|_,d|_-d|_.d|_/d|_0d|_1d|_2d|_3d|_4d|_5d|_6d|_7d|_8d|_9d|_:d|_;d|_d|_?d|_@d|_Ad|_B|CD] \}}tD|d ||qd|_EdS) z Constructor. NZGeneralrZCalibri minorFrZset_)Fsuperr__init__xf_format_indicesdxf_format_indicesxf_index dxf_index num_formatnum_format_index font_indexhas_fontZ has_dxf_fontbold underlineitalic font_name font_size font_colorfont_strikeout font_outline font_shadow font_script font_family font_charset font_scheme font_condense font_extendtheme hyperlinkxf_idhiddenlocked text_h_align text_wrap text_v_align text_justlastrotationfg_colorbg_colorpatternhas_fillZ has_dxf_fillZ fill_indexZ fill_countZ border_indexZ has_borderZhas_dxf_borderZ border_countbottom bottom_color diag_border diag_color diag_typeleft left_colorright right_colortop top_colorindentshrinkZ merge_range reading_order just_distrib color_indexed font_only quote_prefixitemsgetattr _format_key)self propertiesZ xf_indicesZ dxf_indiceskeyvalue __class__Y/var/www/html/kuke-dev/django-kuke/venv/lib/python3.10/site-packages/xlsxwriter/format.pyr s zFormat.__init__cC ||_dS)z Set the Format font_name property such as 'Time New Roman'. The default Excel font is 'Calibri'. Args: font_name: String with the font name. No default. Returns: Nothing. NrrErrKrKrL set_font_name{s zFormat.set_font_namercCrM)z Set the Format font_size property. The default Excel font size is 11. Args: font_size: Int with font size. No default. Returns: Nothing. NrrErrKrKrL set_font_size zFormat.set_font_sizecC|||_dS)z Set the Format font_color property. The Excel default is black. Args: font_color: String with the font color. No default. Returns: Nothing. N _get_colorrrErrKrKrLset_font_color zFormat.set_font_colorTcCrM)z Set the Format bold property. Args: bold: Default is True, turns property on. Returns: Nothing. N)r)rErrKrKrLset_boldrTzFormat.set_boldcCrM)z Set the Format italic property. Args: italic: Default is True, turns property on. Returns: Nothing. N)r)rErrKrKrL set_italicrTzFormat.set_italicrcCrM)z Set the Format underline property. Args: underline: Default is 1, single underline. Returns: Nothing. N)r)rErrKrKrL set_underlinerTzFormat.set_underlinecCrM)z Set the Format font_strikeout property. Args: font_strikeout: Default is True, turns property on. Returns: Nothing. N)r)rErrKrKrLset_font_strikeoutrTzFormat.set_font_strikeoutcCrM)z Set the Format font_script property. Args: font_script: Default is 1, superscript. Returns: Nothing. N)r)rErrKrKrLset_font_scriptrTzFormat.set_font_scriptcCrM)z Set the Format font_outline property. Args: font_outline: Default is True, turns property on. Returns: Nothing. N)r)rErrKrKrLset_font_outlinerTzFormat.set_font_outlinecCrM)z Set the Format font_shadow property. Args: font_shadow: Default is True, turns property on. Returns: Nothing. N)r)rErrKrKrLset_font_shadowrTzFormat.set_font_shadowcCrM)z Set the Format num_format property such as '#,##0'. Args: num_format: String representing the number format. No default. Returns: Nothing. N)r)rErrKrKrLset_num_formatrTzFormat.set_num_formatcCrM)z Set the Format locked property. Args: locked: Default is True, turns property on. Returns: Nothing. N)r&)rEr&rKrKrL set_locked rTzFormat.set_lockedcCrM)z Set the Format hidden property. Args: hidden: Default is True, turns property on. Returns: Nothing. N)r%)rEr%rKrKrL set_hiddenrTzFormat.set_hiddencCs>|}|dkr |d|dkr|d|dkr|d|dkr(|d|dkr1|d |d kr:|d |d krC|d |dkrL|d |dkrU|d|dkr^|d|dkred|_|dkrn|d|dkrw|d|dkr|d|dkr|d|dkr|d |dkr|d dSdS)z Set the Format cell alignment. Args: alignment: String representing alignment. No default. Returns: Nothing. r5rZcentrercenterr7filljustifyZ center_acrossZ centre_across distributedZjustify_distributedr9ZvcentreZvcenterr0ZvjustifyZ vdistributedN)lowerset_text_h_alignr>set_text_v_align)rEZ alignmentrKrKrL set_align%sH                zFormat.set_aligncCs|ddS)z` Set the Format center_across property. Returns: Nothing. rkN)ro)rEZ align_typerKrKrLset_center_acrossXszFormat.set_center_acrosscCrM)z Set the Format text_wrap property. Args: text_wrap: Default is True, turns property on. Returns: Nothing. N)r()rEr(rKrKrL set_text_wrapbrTzFormat.set_text_wrapcCsXt|}|dkr d}nd|krdkr!nn |dkr | d}ntddS||_dS)z Set the Format rotation property. Args: rotation: Rotation angle. No default. Returns: Nothing. iiZrz3Rotation rotation outside range: -90 <= angle <= 90N)intrr+)rEr+rKrKrL set_rotationos   zFormat.set_rotationcCrM)z Set the Format indent property. Args: indent: Default is 1, first indentation level. Returns: Nothing. N)r;)rEr;rKrKrL set_indentrTzFormat.set_indentcCrM)z Set the Format shrink property. Args: shrink: Default is True, turns property on. Returns: Nothing. N)r<)rEr<rKrKrL set_shrinkrTzFormat.set_shrinkcCrM)z Set the Format text_justlast property. Args: text_justlast: Default is True, turns property on. Returns: Nothing. N)r*)rEr*rKrKrLset_text_justlastrTzFormat.set_text_justlastcCrM)z Set the Format pattern property. Args: pattern: Default is 1, solid fill. Returns: Nothing. N)r.)rEr.rKrKrL set_patternrTzFormat.set_patterncCrU)z Set the Format bg_color property. Args: bg_color: Background color. No default. Returns: Nothing. N)rWr-)rEr-rKrKrL set_bg_colorrZzFormat.set_bg_colorcCrU)z Set the Format fg_color property. Args: fg_color: Foreground color. No default. Returns: Nothing. N)rWr,)rEr,rKrKrL set_fg_colorrZzFormat.set_fg_colorcC,||||||||dSz Set the Format bottom property. Args: bottom: Default is 1, border type 1. Returns: Nothing. N) set_bottomset_topset_left set_right)rEstylerKrKrL set_border  zFormat.set_bordercCr~)z Set the Format bottom property. Args: color: Color string. No default. Returns: Nothing. N)set_bottom_color set_top_colorset_left_colorset_right_color)rEcolorrKrKrLset_border_colorrzFormat.set_border_colorcCrMr)r0)rEr0rKrKrLrrTzFormat.set_bottomcCrU)z Set the Format bottom_color property. Args: bottom_color: Color string. No default. Returns: Nothing. N)rWr1)rEr1rKrKrLrrZzFormat.set_bottom_colorcCrM)z Set the Format diag_type property. Args: diag_type: Default is 1, border type 1. Returns: Nothing. N)r4)rEr4rKrKrL set_diag_typerTzFormat.set_diag_typecCrM)z Set the Format left property. Args: left: Default is 1, border type 1. Returns: Nothing. N)r5)rEr5rKrKrLrrTzFormat.set_leftcCrU)z Set the Format left_color property. Args: left_color: Color string. No default. Returns: Nothing. N)rWr6)rEr6rKrKrLr,rZzFormat.set_left_colorcCrM)z Set the Format right property. Args: right: Default is 1, border type 1. Returns: Nothing. N)r7)rEr7rKrKrLr9rTzFormat.set_rightcCrU)z Set the Format right_color property. Args: right_color: Color string. No default. Returns: Nothing. N)rWr8)rEr8rKrKrLrFrZzFormat.set_right_colorcCrM)z Set the Format top property. Args: top: Default is 1, border type 1. Returns: Nothing. N)r9)rEr9rKrKrLrSrTzFormat.set_topcCrU)z Set the Format top_color property. Args: top_color: Color string. No default. Returns: Nothing. N)rWr:)rEr:rKrKrLr`rZzFormat.set_top_colorcCrU)z Set the Format diag_color property. Args: diag_color: Color string. No default. Returns: Nothing. N)rWr3)rEr3rKrKrLset_diag_colormrZzFormat.set_diag_colorcCrM)z Set the Format diag_border property. Args: diag_border: Default is 1, border type 1. Returns: Nothing. N)r2)rEr2rKrKrLset_diag_borderzrTzFormat.set_diag_bordercCrM)z Set the Format quote prefix property. Args: quote_prefix: Default is True, turns property on. Returns: Nothing. N)rA)rErArKrKrLset_quote_prefixrTzFormat.set_quote_prefixcC ||_dSN)r)rErrKrKrL set_has_font zFormat.set_has_fontcCrr)r/)rEr/rKrKrL set_has_fillrzFormat.set_has_fillcCrr)r)rErrKrKrLset_font_indexrzFormat.set_font_indexcCrr)r )rEr rKrKrL set_xf_indexrzFormat.set_xf_indexcCrr)r)rErrKrKrL set_dxf_indexrzFormat.set_dxf_indexcCrr)r)rErrKrKrLset_num_format_indexrzFormat.set_num_format_indexcCrr)r')rEr'rKrKrLrorzFormat.set_text_h_aligncCrr)r))rEr)rKrKrLrprzFormat.set_text_v_alignrcCrr)r=)rE directionrKrKrLset_reading_orderrzFormat.set_reading_ordercCs||dSr)rq)rEalignrKrKrL set_valignszFormat.set_valigncCrr)r)rErrKrKrLset_font_familyrzFormat.set_font_familycCrr)r)rErrKrKrLset_font_charsetrzFormat.set_font_charsetcCrr)r)rErrKrKrLset_font_schemerzFormat.set_font_schemecCrr)r )rEr rKrKrLset_font_condenserzFormat.set_font_condensecCrr)r!)rEr!rKrKrLset_font_extendrzFormat.set_font_extendcCrr)r")rEr"rKrKrL set_themerzFormat.set_themecCs$d|_|d|d||_dS)Nr )r$r]rr#)rEr#rKrKrL set_hyperlinks   zFormat.set_hyperlinkcCrr)r?)rEZ color_indexrKrKrLset_color_indexedrzFormat.set_color_indexedcCrr)r@)rEr@rKrKrL set_font_onlyrzFormat.set_font_onlycCrrrNrOrKrKrLset_fontrzFormat.set_fontcCrrrQrRrKrKrLset_sizerzFormat.set_sizecCs|||_dSrrVrXrKrKrL set_colorszFormat.set_colorcCsZd}g}|js|js|js|js|js|js|jrd}n||fS|jrD|jdkrD|jdkrD|jdkrD|jdkrD|jdkrD|jdkrDd|_|jrJd|_|jdkrRd|_|jdkrZd|_|jdkrbd|_|jdkrjd|_|jrpd|_d}|jdkr||d|jd kr|d |jdkr|d |jdkr|d |jdkr|d |jdkr|d|f|jdkr|d|jr|d|jdkr|d|jd kr|d|jdkr|d|jdkr|d|jr|d|jf|jr|d|jf|jr |d|jr|d|jdkr|d|jd kr)|d||fS)NrrrfrmrjrhZcenterContinuous) horizontalr5r)rre)rr7)rrg)rrirkr)rrl)ZjustifyLastLiner)verticalr9)rre)rri)rrlZ textRotationr;)ZwrapTextr)Z shrinkToFitr) readingOrderr)rr) r'r)r;r+r(r<r=r>append)rEchangedrZ continuousrKrKrL_get_align_propertiess                                       zFormat._get_align_propertiescCs(g}|js |d|jr|d|S)N)r&r)r%r)r&rr%)rEattribsrKrKrL_get_protection_properties_s   z!Format._get_protection_propertiesc CsN|jdur$ddd|||||j|j|j|j fD|_|jS)N:cs|]}t|VqdSrstr.0xrKrKrL m  z)Format._get_format_key..) rDjoin _get_font_key_get_border_key _get_fill_key_get_alignment_keyrr&rAr%)rErKrKrL_get_format_keyjs   zFormat._get_format_keycCsLddd|j|j|j|j|j|j|j|j|j |j |j |j |j f D}|S)NrcsrrrrrKrKrLrrz'Format._get_font_key..)rrrrrrrrrrrrrr"rErGrKrKrLr}s" zFormat._get_font_keycCsDddd|j|j|j|j|j|j|j|j|j |j |j f D}|S)NrcsrrrrrKrKrLrrz)Format._get_border_key..) rr0r1r2r3r4r5r6r7r8r9r:rrKrKrLrs zFormat._get_border_keycCs$ddd|j|j|jfD}|S)NrcsrrrrrKrKrLrsz'Format._get_fill_key..)rr.r-r,rrKrKrLrs zFormat._get_fill_keyc Cs4ddd|j|j|j|j|j|j|jfD}|S)NrcsrrrrrKrKrLrrz,Format._get_alignment_key..)rr'r)r;r+r(r<r=rrKrKrLrs  zFormat._get_alignment_keycCsN|jdur|jS|}||jvr|j|Sdt|j}||j|<||_|S)Nr)r rr lenrErGindexrKrKrL _get_xf_indexs    zFormat._get_xf_indexcCsJ|jdur|jS|}||jvr|j|St|j}||j|<||_|Sr)rrr rrrKrKrL_get_dxf_indexs     zFormat._get_dxf_indexcCs~iddddddddd d d d d dddddddddddddddddddd d!}||vr=||}|S)"Nblackz#000000bluez#0000FFZbrownz#800000cyanz#00FFFFgrayz#808080greenz#008000Zlimez#00FF00magentaz#FF00FFZnavyz#000080Zorangez#FF6600Zpinkpurplez#800080redz#FF0000silverz#C0C0C0whitez#FFFFFFyellowz#FFFF00Z automaticZ AutomaticrK)rErZ named_colorsrKrKrLrWsL     zFormat._get_color)NNN)r)T)rr)r)K__name__ __module__ __qualname____doc__r rPrSrYr[r\r]r^r_r`rarbrcrdrqrrrsrwrxryrzr{r|r}rrrrrrrrrrrrrrrrrrrrrorprrrrrrrrrrrrrrrrrrrrrrrrW __classcell__rKrKrIrLrs `    3                _ rN)rwarningsrZ XMLwriterrrKrKrKrLs