o ȷef@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*dTdUZ+dVdWZ,dXdYZ-dZd[Z.d\d]Z/d^d_Z0ddadbZ1dcddZ2dedfZ3dgdhZ4didjZ5dkdlZ6dmdnZ7dodpZ8ddqdrZ9dsdtZ:ddudvZ;dwdxZd}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|_A|BD] \}}tC|d ||qd|_DdS) z Constructor. NGeneralrCalibri minorFrset_)Esuperr__init__xf_format_indicesdxf_format_indicesxf_index dxf_index num_formatnum_format_index font_indexhas_font 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_fill has_dxf_fill fill_index fill_count border_index has_borderhas_dxf_border border_countbottom bottom_color diag_border diag_color diag_typeleft left_colorright right_colortop top_colorindentshrink merge_range reading_order just_distrib color_indexed font_onlyitemsgetattr _format_key)self properties xf_indices dxf_indiceskeyvalue __class__H/var/www/ideatree/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. NrrPrrXrXrY set_font_nameys zFormat.set_font_namercCrZ)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. NrrPrrXrXrY 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_colorrrPrrXrXrYset_font_color zFormat.set_font_colorTcCrZ)z Set the Format bold property. Args: bold: Default is True, turns property on. Returns: Nothing. N)r)rPrrXrXrYset_boldrazFormat.set_boldcCrZ)z Set the Format italic property. Args: italic: Default is True, turns property on. Returns: Nothing. N)r)rPrrXrXrY set_italicrazFormat.set_italicrcCrZ)z Set the Format underline property. Args: underline: Default is 1, single underline. Returns: Nothing. N)r)rPrrXrXrY set_underlinerazFormat.set_underlinecCrZ)z Set the Format font_strikeout property. Args: font_strikeout: Default is True, turns property on. Returns: Nothing. N)r)rPrrXrXrYset_font_strikeoutrazFormat.set_font_strikeoutcCrZ)z Set the Format font_script property. Args: font_script: Default is 1, superscript. Returns: Nothing. N)r )rPr rXrXrYset_font_scriptrazFormat.set_font_scriptcCrZ)z Set the Format font_outline property. Args: font_outline: Default is True, turns property on. Returns: Nothing. N)r)rPrrXrXrYset_font_outlinerazFormat.set_font_outlinecCrZ)z Set the Format font_shadow property. Args: font_shadow: Default is True, turns property on. Returns: Nothing. N)r)rPrrXrXrYset_font_shadowrazFormat.set_font_shadowcCrZ)z Set the Format num_format property such as '#,##0'. Args: num_format: String representing the number format. No default. Returns: Nothing. N)r)rPrrXrXrYset_num_formatrazFormat.set_num_formatcCrZ)z Set the Format locked property. Args: locked: Default is True, turns property on. Returns: Nothing. N)r*)rPr*rXrXrY set_locked razFormat.set_lockedcCrZ)z Set the Format hidden property. Args: hidden: Default is True, turns property on. Returns: Nothing. N)r))rPr)rXrXrY set_hiddenrazFormat.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. r@rcentrer centerrBfilljustify center_across centre_across distributedjustify_distributedrDvcentrevcenterr;vjustify vdistributedN)lowerset_text_h_alignrJset_text_v_align)rP alignmentrXrXrY set_align#sH                zFormat.set_aligncCs|ddS)z` Set the Format center_across property. Returns: Nothing. rzN)r)rP align_typerXrXrYset_center_acrossVszFormat.set_center_acrosscCrZ)z Set the Format text_wrap property. Args: text_wrap: Default is True, turns property on. Returns: Nothing. N)r,)rPr,rXrXrY set_text_wrap`razFormat.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/)rPr/rXrXrY set_rotationms   zFormat.set_rotationcCrZ)z Set the Format indent property. Args: indent: Default is 1, first indentation level. Returns: Nothing. N)rF)rPrFrXrXrY set_indentrazFormat.set_indentcCrZ)z Set the Format shrink property. Args: shrink: Default is True, turns property on. Returns: Nothing. N)rG)rPrGrXrXrY set_shrinkrazFormat.set_shrinkcCrZ)z Set the Format text_justlast property. Args: text_justlast: Default is True, turns property on. Returns: Nothing. N)r.)rPr.rXrXrYset_text_justlastrazFormat.set_text_justlastcCrZ)z Set the Format pattern property. Args: pattern: Default is 1, solid fill. Returns: Nothing. N)r2)rPr2rXrXrY set_patternrazFormat.set_patterncCrb)z Set the Format bg_color property. Args: bg_color: Background color. No default. Returns: Nothing. N)rdr1)rPr1rXrXrY set_bg_colorrgzFormat.set_bg_colorcCrb)z Set the Format fg_color property. Args: fg_color: Foreground color. No default. Returns: Nothing. N)rdr0)rPr0rXrXrY set_fg_colorrgzFormat.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)rPstylerXrXrY 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)rPcolorrXrXrYset_border_colorrzFormat.set_border_colorcCrZr)r;)rPr;rXrXrYrrazFormat.set_bottomcCrb)z Set the Format bottom_color property. Args: bottom_color: Color string. No default. Returns: Nothing. N)rdr<)rPr<rXrXrYrrgzFormat.set_bottom_colorcCrZ)z Set the Format diag_type property. Args: diag_type: Default is 1, border type 1. Returns: Nothing. N)r?)rPr?rXrXrY set_diag_typerazFormat.set_diag_typecCrZ)z Set the Format left property. Args: left: Default is 1, border type 1. Returns: Nothing. N)r@)rPr@rXrXrYrrazFormat.set_leftcCrb)z Set the Format left_color property. Args: left_color: Color string. No default. Returns: Nothing. N)rdrA)rPrArXrXrYr*rgzFormat.set_left_colorcCrZ)z Set the Format right property. Args: right: Default is 1, border type 1. Returns: Nothing. N)rB)rPrBrXrXrYr7razFormat.set_rightcCrb)z Set the Format right_color property. Args: right_color: Color string. No default. Returns: Nothing. N)rdrC)rPrCrXrXrYrDrgzFormat.set_right_colorcCrZ)z Set the Format top property. Args: top: Default is 1, border type 1. Returns: Nothing. N)rD)rPrDrXrXrYrQrazFormat.set_topcCrb)z Set the Format top_color property. Args: top_color: Color string. No default. Returns: Nothing. N)rdrE)rPrErXrXrYr^rgzFormat.set_top_colorcCrb)z Set the Format diag_color property. Args: diag_color: Color string. No default. Returns: Nothing. N)rdr>)rPr>rXrXrYset_diag_colorkrgzFormat.set_diag_colorcCrZ)z Set the Format diag_border property. Args: diag_border: Default is 1, border type 1. Returns: Nothing. N)r=)rPr=rXrXrYset_diag_borderxrazFormat.set_diag_bordercC ||_dSN)r)rPrrXrXrY set_has_font zFormat.set_has_fontcCrr)r3)rPr3rXrXrY set_has_fillrzFormat.set_has_fillcCrr)r)rPrrXrXrYset_font_indexrzFormat.set_font_indexcCrr)r)rPrrXrXrY set_xf_indexrzFormat.set_xf_indexcCrr)r)rPrrXrXrY set_dxf_indexrzFormat.set_dxf_indexcCrr)r)rPrrXrXrYset_num_format_indexrzFormat.set_num_format_indexcCrr)r+)rPr+rXrXrYrrzFormat.set_text_h_aligncCrr)r-)rPr-rXrXrYrrzFormat.set_text_v_alignrcCrr)rI)rP directionrXrXrYset_reading_orderrzFormat.set_reading_ordercCs||dSr)r)rPalignrXrXrY set_valignszFormat.set_valigncCrr)r!)rPr!rXrXrYset_font_familyrzFormat.set_font_familycCrr)r")rPr"rXrXrYset_font_charsetrzFormat.set_font_charsetcCrr)r#)rPr#rXrXrYset_font_schemerzFormat.set_font_schemecCrr)r$)rPr$rXrXrYset_font_condenserzFormat.set_font_condensecCrr)r%)rPr%rXrXrYset_font_extendrzFormat.set_font_extendcCrr)r&)rPr&rXrXrY set_themerzFormat.set_themecCs$d|_|d|d||_dS)Nr )r(rjrr')rPr'rXrXrY set_hyperlinks   zFormat.set_hyperlinkcCrr)rK)rP color_indexrXrXrYset_color_indexedrzFormat.set_color_indexedcCrr)rL)rPrLrXrXrY set_font_onlyrzFormat.set_font_onlycCrrr[r\rXrXrYset_fontrzFormat.set_fontcCrrr^r_rXrXrYset_sizerzFormat.set_sizecCs|||_dSrrcrerXrXrY set_colorszFormat.set_colorcCs8d}g}|js|js|js|js|js|js|jrd}n||fS|jr5|jdkr5|jdkr5|jdkr5d|_|jr;d|_|jdkrCd|_|jdkrKd|_|jdkrSd|_|jdkr[d|_|jrad|_d}|jdkrm|d|jd krw|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)Nrrrtr}rvrxcenterContinuous) horizontalr@r )rrs)rrB)rru)rrwrzr)rr|)justifyLastLiner)verticalrD)rrs)rrw)rr|rF textRotation)wrapTextr) shrinkToFitr) readingOrderr)rr ) r+r-rFr/r,rGrIrJappend)rPchangedr continuousrXrXrY_get_align_propertiess                                   zFormat._get_align_propertiescCs(g}|js |d|jr|d|S)N)r*r)r)r)r*rr))rPattribsrXrXrY_get_protection_propertiesEs   z!Format._get_protection_propertiesc sNjdur$dfddjjjfD_jS)N:c3|]}|VqdSr _to_string.0xrPrXrY Sz)Format._get_format_key..) rOjoin _get_font_key_get_border_key _get_fill_key_get_alignment_keyrr*r)rrXrrY_get_format_keyPs   zFormat._get_format_keycsPdfddjjjjjjjjj j j j j f D}|S)Nrc3rrrrrrXrYr`rz'Format._get_font_key..)rrrr"r!rr rrrrrrr&rPrTrXrrYr^s  zFormat._get_font_keycsHdfddjjjjjjjjj j j f D}|S)Nrc3rrrrrrXrYrsrz)Format._get_border_key..) rr;r<r=r>r?r@rArBrCrDrErrXrrYrqs  zFormat._get_border_keycs(dfddjjjfD}|S)Nrc3rrrrrrXrYrrz'Format._get_fill_key..)rr2r1r0rrXrrYrs  zFormat._get_fill_keyc s8dfddjjjjjjjfD}|S)Nrc3rrrrrrXrYrrz,Format._get_alignment_key..)rr+r-rFr/r,rGrIrrXrrYrs  zFormat._get_alignment_keycCsN|jdur|jS|}||jvr|j|Sdt|j}||j|<||_|S)Nr)rrrlenrPrTindexrXrXrY _get_xf_indexs    zFormat._get_xf_indexcCsJ|jdur|jS|}||jvr|j|St|j}||j|<||_|Sr)rrrrrrXrXrY_get_dxf_indexs     zFormat._get_dxf_indexcCsxiddddddddd d d d d ddddddddddddddddddd}||vr:||}|S) Nblackz#000000bluez#0000FFbrownz#800000cyanz#00FFFFgrayz#808080greenz#008000limez#00FF00magentaz#FF00FFnavyz#000080orangez#FF6600pinkpurplez#800080redz#FF0000silverz#C0C0C0whitez#FFFFFFyellowz#FFFF00rX)rPr named_colorsrXrXrYrdsH     zFormat._get_colorcCs(zt|WSty|dYSw)Nzutf-8)strUnicodeEncodeErrorencode)rPrUrXrXrYrs   zFormat._to_string)NNN)r)T)rr)r)K__name__ __module__ __qualname____doc__r r]r`rfrhrirjrkrlrmrnrorprqrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrdr __classcell__rXrXrVrYrs ^    3                T  rN)rwarningsr XMLwriterrrXrXrXrYs