o ,hv@s.ddlmZddlmZGdddejZdS))warn) xmlwritercseZdZdZdfdd 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+ddVdWZ,dXdYZ-dZd[Z.d\d]Z/d^d_Z0d`daZ1dbdcZ2ddedfZ3dgdhZ4didjZ5dkdlZ6dmdnZ7dodpZ8dqdrZ9dsdtZ:ddudvZ;dwdxZd}d~Z?ddZ@ddZAddZBddZCddZDddZEddZFddZGddZHddZIddZJZKS)Formatz; A class for writing the Excel XLSX Format file. Ncs|duri}t||_||_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|_/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. NGeneralrFCalibri minorrset_)Fsuper__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_only quote_prefixcheckboxitemsgetattr _format_key)self properties xf_indices dxf_indiceskeyvalue __class__G/var/www/html/rh/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. NrrRrrZrZr[ set_font_name~ zFormat.set_font_namercCr\)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. NrrRrrZrZr[ 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_colorrrRrrZrZr[set_font_color zFormat.set_font_colorTcCr\)z Set the Format bold property. Args: bold: Default is True, turns property on. Returns: Nothing. N)r)rRrrZrZr[set_boldrdzFormat.set_boldcCr\)z Set the Format italic property. Args: italic: Default is True, turns property on. Returns: Nothing. N)r)rRrrZrZr[ set_italicrdzFormat.set_italicrcCr\)z Set the Format underline property. Args: underline: Default is 1, single underline. Returns: Nothing. N)r)rRrrZrZr[ set_underlinerdzFormat.set_underlinecCr\)z Set the Format font_strikeout property. Args: font_strikeout: Default is True, turns property on. Returns: Nothing. N)r)rRrrZrZr[set_font_strikeoutrdzFormat.set_font_strikeoutcCr\)z Set the Format font_script property. Args: font_script: Default is 1, superscript. Returns: Nothing. N)r )rRr rZrZr[set_font_scriptrdzFormat.set_font_scriptcCr\)z Set the Format font_outline property. Args: font_outline: Default is True, turns property on. Returns: Nothing. N)r)rRrrZrZr[set_font_outlinerdzFormat.set_font_outlinecCr\)z Set the Format font_shadow property. Args: font_shadow: Default is True, turns property on. Returns: Nothing. N)r)rRrrZrZr[set_font_shadowrdzFormat.set_font_shadowcCr\)z Set the Format num_format property such as '#,##0'. Args: num_format: String representing the number format. No default. Returns: Nothing. N)r)rRrrZrZr[set_num_formatrdzFormat.set_num_formatcCr\)z Set the Format locked property. Args: locked: Default is True, turns property on. Returns: Nothing. N)r*)rRr*rZrZr[ set_lockedrdzFormat.set_lockedcCr\)z Set the Format hidden property. Args: hidden: Default is True, turns property on. Returns: Nothing. N)r))rRr)rZrZr[ set_hiddenrdzFormat.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)rR alignmentrZrZr[ set_align(sH                zFormat.set_aligncCs|ddS)z` Set the Format center_across property. Returns: Nothing. r}N)r)rR align_typerZrZr[set_center_across[s zFormat.set_center_acrosscCr\)z Set the Format text_wrap property. Args: text_wrap: Default is True, turns property on. Returns: Nothing. N)r,)rRr,rZrZr[ set_text_wrapfrdzFormat.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/)rRr/rZrZr[ set_rotationss   zFormat.set_rotationcCr\)z Set the Format indent property. Args: indent: Default is 1, first indentation level. Returns: Nothing. N)rF)rRrFrZrZr[ set_indentrdzFormat.set_indentcCr\)z Set the Format shrink property. Args: shrink: Default is True, turns property on. Returns: Nothing. N)rG)rRrGrZrZr[ set_shrinkrdzFormat.set_shrinkcCr\)z Set the Format text_justlast property. Args: text_justlast: Default is True, turns property on. Returns: Nothing. N)r.)rRr.rZrZr[set_text_justlastrdzFormat.set_text_justlastcCr\)z Set the Format pattern property. Args: pattern: Default is 1, solid fill. Returns: Nothing. N)r2)rRr2rZrZr[ set_patternrdzFormat.set_patterncCre)z Set the Format bg_color property. Args: bg_color: Background color. No default. Returns: Nothing. N)rgr1)rRr1rZrZr[ set_bg_colorrjzFormat.set_bg_colorcCre)z Set the Format fg_color property. Args: fg_color: Foreground color. No default. Returns: Nothing. N)rgr0)rRr0rZrZr[ set_fg_colorrjzFormat.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)rRstylerZrZr[ 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)rRcolorrZrZr[set_border_colorrzFormat.set_border_colorcCr\r)r;)rRr;rZrZr[rrdzFormat.set_bottomcCre)z Set the Format bottom_color property. Args: bottom_color: Color string. No default. Returns: Nothing. N)rgr<)rRr<rZrZr[r rjzFormat.set_bottom_colorcCr\)z Set the Format diag_type property. Args: diag_type: Default is 1, border type 1. Returns: Nothing. N)r?)rRr?rZrZr[ set_diag_typerdzFormat.set_diag_typecCr\)z Set the Format left property. Args: left: Default is 1, border type 1. Returns: Nothing. N)r@)rRr@rZrZr[r#rdzFormat.set_leftcCre)z Set the Format left_color property. Args: left_color: Color string. No default. Returns: Nothing. N)rgrA)rRrArZrZr[r0rjzFormat.set_left_colorcCr\)z Set the Format right property. Args: right: Default is 1, border type 1. Returns: Nothing. N)rB)rRrBrZrZr[r=rdzFormat.set_rightcCre)z Set the Format right_color property. Args: right_color: Color string. No default. Returns: Nothing. N)rgrC)rRrCrZrZr[rJrjzFormat.set_right_colorcCr\)z Set the Format top property. Args: top: Default is 1, border type 1. Returns: Nothing. N)rD)rRrDrZrZr[rWrdzFormat.set_topcCre)z Set the Format top_color property. Args: top_color: Color string. No default. Returns: Nothing. N)rgrE)rRrErZrZr[rdrjzFormat.set_top_colorcCre)z Set the Format diag_color property. Args: diag_color: Color string. No default. Returns: Nothing. N)rgr>)rRr>rZrZr[set_diag_colorqrjzFormat.set_diag_colorcCr\)z Set the Format diag_border property. Args: diag_border: Default is 1, border type 1. Returns: Nothing. N)r=)rRr=rZrZr[set_diag_border~rdzFormat.set_diag_bordercCr\)z Set the Format quote prefix property. Args: quote_prefix: Default is True, turns property on. Returns: Nothing. N)rM)rRrMrZrZr[set_quote_prefixrdzFormat.set_quote_prefixcCr\)a Set the Format property to show a checkbox in a cell. This format property can be used with a cell that contains a boolean value to display it as a checkbox. This property isn't required very often and it is generally easier to create a checkbox using the ``worksheet.insert_checkbox()`` method. Args: checkbox: Default is True, turns property on. Returns: Nothing. N)rN)rRrNrZrZr[ set_checkboxs zFormat.set_checkboxcCr\)z Set the property to indicate the format has a font. Args: has_font: Default is True, turns property on. Returns: Nothing. N)r)rRrrZrZr[ set_has_fontrdzFormat.set_has_fontcCr\)z Set the property to indicate the format has a fill. Args: has_fill: Default is True, turns property on. Returns: Nothing. N)r3)rRr3rZrZr[ set_has_fillrdzFormat.set_has_fillcCr\)z Set the unique font index property. Args: font_index: The unique font index. Returns: Nothing. N)r)rRrrZrZr[set_font_indexrdzFormat.set_font_indexcCr\)z Set the unique format index property. Args: xf_index: The unique Excel format index. Returns: Nothing. N)r)rRrrZrZr[ set_xf_indexrdzFormat.set_xf_indexcCr\)z Set the unique conditional format index property. Args: dxf_index: The unique Excel conditional format index. Returns: Nothing. N)r)rRrrZrZr[ set_dxf_indexrdzFormat.set_dxf_indexcCr\)z Set the number format_index property. Args: num_format_index: The unique number format index. Returns: Nothing. N)r)rRrrZrZr[set_num_format_indexrdzFormat.set_num_format_indexcCr\)z Set the horizontal text alignment property. Args: text_h_align: Horizontal text alignment. Returns: Nothing. N)r+)rRr+rZrZr[rrdzFormat.set_text_h_aligncCr\)z Set the vertical text alignment property. Args: text_h_align: Vertical text alignment. Returns: Nothing. N)r-)rRr-rZrZr[r rdzFormat.set_text_v_alignrcCr\)z Set the reading order property. Args: direction: Default is 0, left to right. Returns: Nothing. N)rI)rR directionrZrZr[set_reading_orderr`zFormat.set_reading_ordercCs||dS)a Set vertical cell alignment property. This is required by the constructor properties dict to differentiate between the vertical and horizontal properties. Args: align: Alignment property. Returns: Nothing. N)r)rRalignrZrZr[ set_valign'szFormat.set_valigncCr\)z Set the font family property. Args: font_family: Font family number. Returns: Nothing. N)r!)rRr!rZrZr[set_font_family:rdzFormat.set_font_familycCr\)z Set the font character set property. Args: font_charset: The font character set number. Returns: Nothing. N)r")rRr"rZrZr[set_font_charsetGrdzFormat.set_font_charsetcCr\)z Set the font scheme property. Args: font_scheme: The font scheme. Returns: Nothing. N)r#)rRr#rZrZr[set_font_schemeTrdzFormat.set_font_schemecCr\)z Set the font condense property. Args: font_condense: The font condense property. Returns: Nothing. N)r$)rRr$rZrZr[set_font_condenseardzFormat.set_font_condensecCr\)z Set the font extend property. Args: font_extend: The font extend property. Returns: Nothing. N)r%)rRr%rZrZr[set_font_extendnrdzFormat.set_font_extendcCr\)z Set the theme property. Args: theme: Format theme. Returns: Nothing. N)r&)rRr&rZrZr[ set_theme{rdzFormat.set_themecCs$d|_|d|d||_dS)z Set the properties for the hyperlink style. Args: hyperlink: Default is True, turns property on. Returns: Nothing. r N)r(rmrr')rRr'rZrZr[ set_hyperlinks   zFormat.set_hyperlinkcCr\)z Set the color index property. Some fundamental format properties use an indexed color instead of a rbg or theme color. Args: color_index: Generally 0 or 1. Returns: Nothing. N)rK)rR color_indexrZrZr[set_color_indexedr`zFormat.set_color_indexedcCr\)z Set property to indicate that the format is used for fonts only. Args: font_only: Default is True, turns property on. Returns: Nothing. N)rL)rRrLrZrZr[ set_font_onlyrdzFormat.set_font_onlycCr\)z(Deprecated: Use set_font_name() instead.Nr]r^rZrZr[set_font zFormat.set_fontcCr\)z(Deprecated: Use set_font_size() instead.NrarbrZrZr[set_sizerzFormat.set_sizecCre)z)Deprecated: Use set_font_color() instead.NrfrhrZrZr[ 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)Nrrrwrr{rycenterContinuous) horizontalr@r )rrv)rrB)rrx)rrzr}r)rr)justifyLastLiner)verticalrD)rrv)rrz)rr textRotationrF)wrapTextr) shrinkToFitr) readingOrderr)rr ) r+r-rFr/r,rGrIrJappend)rRchangedr continuousrZrZr[_get_align_propertiess                                       zFormat._get_align_propertiescCs(g}|js |d|jr|d|S)N)r*r)r)r)r*rr))rR attributesrZrZr[_get_protection_properties)s   z!Format._get_protection_propertiesc CsR|jdur&ddd|||||j|j|j|j |j f D|_|jS)N:cs|]}t|VqdSNstr.0xrZrZr[ 7  z)Format._get_format_key..) rQjoin _get_font_key_get_border_key _get_fill_key_get_alignment_keyrr*rNrMr))rRrZrZr[_get_format_key4s   zFormat._get_format_keycCsLddd|j|j|j|j|j|j|j|j|j |j |j |j |j f D}|S)NrcsrrrrrZrZr[rJrz'Format._get_font_key..)rrrr"r!rr rrrrrrr&rRrVrZrZr[rHs" zFormat._get_font_keycCsDddd|j|j|j|j|j|j|j|j|j |j |j f D}|S)NrcsrrrrrZrZr[rarz)Format._get_border_key..) rr;r<r=r>r?r@rArBrCrDrErrZrZr[r_s zFormat._get_border_keycCs$ddd|j|j|jfD}|S)NrcsrrrrrZrZr[rvsz'Format._get_fill_key..)rr2r1r0rrZrZr[rts zFormat._get_fill_keyc Cs4ddd|j|j|j|j|j|j|jfD}|S)NrcsrrrrrZrZr[r}rz,Format._get_alignment_key..)rr+r-rFr/r,rGrIrrZrZr[rzs  zFormat._get_alignment_keycCsN|jdur|jS|}||jvr|j|Sdt|j}||j|<||_|S)Nr)rrrlenrRrVindexrZrZr[ _get_xf_indexs    zFormat._get_xf_indexcCsJ|jdur|jS|}||jvr|j|St|j}||j|<||_|Sr)rrrrrrZrZr[_get_dxf_indexs     zFormat._get_dxf_indexcCsviddddddddd d d d d dddddddddddddddddddd d!}|||S)"Nblackz#000000bluez#0000FFbrownz#800000cyanz#00FFFFgrayz#808080greenz#008000limez#00FF00magentaz#FF00FFnavyz#000080orangez#FF6600pinkpurplez#800080redz#FF0000silverz#C0C0C0whitez#FFFFFFyellowz#FFFF00 automatic Automatic)get)rRr named_colorsrZrZr[rgsH      zFormat._get_color)NNN)r)T)rr)r)L__name__ __module__ __qualname____doc__r r_rcrirkrlrmrnrorprqrrrsrtrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrg __classcell__rZrZrXr[rs a    3                         ` rN)warningsrr XMLwriterrrZrZrZr[s