U ª…7hévã@s.ddlmZddlmZGdd„dejƒZdS)é)Úwarné)Ú xmlwritercsŽeZdZdZd•‡fdd„ Zdd„Zd–dd „Zd d „Zd—d d„Zd˜dd„Z d™dd„Z dšdd„Z d›dd„Z dœdd„Z ddd„Zdd„Zdždd„ZdŸd d!„Zd"d#„Zd d$d%„Zd¡d&d'„Zd(d)„Zd¢d*d+„Zd£d,d-„Zd¤d.d/„Zd¥d0d1„Zd2d3„Zd4d5„Zd¦d6d7„Zd8d9„Zd§d:d;„Zdd?„Z d©d@dA„Z!dBdC„Z"dªdDdE„Z#dFdG„Z$d«dHdI„Z%dJdK„Z&dLdM„Z'd¬dNdO„Z(d­dPdQ„Z)d®dRdS„Z*d¯dTdU„Z+d°dVdW„Z,dXdY„Z-dZd[„Z.d\d]„Z/d^d_„Z0d`da„Z1dbdc„Z2d±dedf„Z3dgdh„Z4didj„Z5dkdl„Z6dmdn„Z7dodp„Z8dqdr„Z9dsdt„Z:d²dudv„Z;dwdx„Zd}d~„Z?dd€„Z@dd‚„ZAdƒd„„ZBd…d†„ZCd‡dˆ„ZDd‰dŠ„ZEd‹dŒ„ZFddŽ„ZGdd„ZHd‘d’„ZId“d”„ZJ‡ZKS)´ÚFormatz; A class for writing the Excel XLSX Format file. NcsÌ|dkr i}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| C¡D]\}}tD|d |ƒ|ƒq¤d|_EdS) z Constructor. NZGeneralrFZCalibrié éÚminorrÚset_)FÚsuperÚ__init__Úxf_format_indicesÚdxf_format_indicesÚxf_indexÚ dxf_indexÚ num_formatÚnum_format_indexÚ font_indexÚhas_fontZ has_dxf_fontÚboldÚ underlineÚitalicÚ font_nameÚ font_sizeÚ font_colorÚfont_strikeoutÚ font_outlineÚ font_shadowÚ font_scriptÚ font_familyÚ font_charsetÚ font_schemeÚ font_condenseÚ font_extendÚthemeÚ hyperlinkÚxf_idÚhiddenÚlockedÚ text_h_alignÚ text_wrapÚ text_v_alignÚ text_justlastÚrotationÚfg_colorÚbg_colorÚpatternÚhas_fillZ has_dxf_fillZ fill_indexZ fill_countZ border_indexZ has_borderZhas_dxf_borderZ border_countÚbottomÚ bottom_colorÚ diag_borderÚ diag_colorÚ diag_typeÚleftÚ left_colorÚrightÚ right_colorÚtopÚ top_colorÚindentÚshrinkZ merge_rangeÚ reading_orderÚ just_distribÚ color_indexedÚ font_onlyÚ quote_prefixÚcheckboxÚitemsÚgetattrÚ _format_key)ÚselfÚ propertiesZ xf_indicesZ dxf_indicesÚkeyÚvalue©Ú __class__©úK/var/www/formularioweb/env/lib/python3.8/site-packages/xlsxwriter/format.pyr sŽ zFormat.__init__cCs ||_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. N©r©rGrrMrMrNÚ set_font_name~s zFormat.set_font_namercCs ||_dS)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. N©r©rGrrMrMrNÚ set_font_sizeŒs zFormat.set_font_sizecCs| |¡|_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_colorr©rGrrMrMrNÚset_font_color™s zFormat.set_font_colorTcCs ||_dS)zœ Set the Format bold property. Args: bold: Default is True, turns property on. Returns: Nothing. N)r)rGrrMrMrNÚset_bold¦s zFormat.set_boldcCs ||_dS)z  Set the Format italic property. Args: italic: Default is True, turns property on. Returns: Nothing. N)r)rGrrMrMrNÚ set_italic³s zFormat.set_italicrcCs ||_dS)z¢ Set the Format underline property. Args: underline: Default is 1, single underline. Returns: Nothing. N)r)rGrrMrMrNÚ set_underlineÀs zFormat.set_underlinecCs ||_dS)z° Set the Format font_strikeout property. Args: font_strikeout: Default is True, turns property on. Returns: Nothing. N)r)rGrrMrMrNÚset_font_strikeoutÍs zFormat.set_font_strikeoutcCs ||_dS)z¡ Set the Format font_script property. Args: font_script: Default is 1, superscript. Returns: Nothing. N)r)rGrrMrMrNÚset_font_scriptÚs zFormat.set_font_scriptcCs ||_dS)z¬ Set the Format font_outline property. Args: font_outline: Default is True, turns property on. Returns: Nothing. N)r)rGrrMrMrNÚset_font_outlineçs zFormat.set_font_outlinecCs ||_dS)zª Set the Format font_shadow property. Args: font_shadow: Default is True, turns property on. Returns: Nothing. N)r)rGrrMrMrNÚset_font_shadowôs zFormat.set_font_shadowcCs ||_dS)zÇ Set the Format num_format property such as '#,##0'. Args: num_format: String representing the number format. No default. Returns: Nothing. N)r)rGrrMrMrNÚset_num_formats zFormat.set_num_formatcCs ||_dS)z  Set the Format locked property. Args: locked: Default is True, turns property on. Returns: Nothing. N)r')rGr'rMrMrNÚ set_lockeds zFormat.set_lockedcCs ||_dS)z  Set the Format hidden property. Args: hidden: Default is True, turns property on. Returns: Nothing. N)r&)rGr&rMrMrNÚ set_hiddens zFormat.set_hiddencCsB| ¡}|dkr| d¡|dkr,| d¡|dkr>| d¡|dkrP| d¡|dkrb| d ¡|d krt| d ¡|d kr†| d ¡|dkr˜| d ¡|dkrª| d¡|dkr¼| d¡|dkrÊd|_|dkrÜ| d¡|dkrî| d¡|dkr| d¡|dkr| d¡|dkr*| d ¡|dkr>| d ¡dS)z¨ Set the Format cell alignment. Args: alignment: String representing alignment. No default. Returns: Nothing. r6rZcentrerÚcenterr8éÚfilléÚjustifyéZ center_acrosséZ centre_acrossÚ distributedéZjustify_distributedr:ZvcentreZvcenterr1ZvjustifyZ vdistributedN)ÚlowerÚset_text_h_alignr?Úset_text_v_align)rGZ alignmentrMrMrNÚ set_align(sF                    zFormat.set_aligncCs| d¡dS)z` Set the Format center_across property. Returns: Nothing. riN)rm)rGZ align_typerMrMrNÚset_center_across[s zFormat.set_center_acrosscCs ||_dS)z¦ Set the Format text_wrap property. Args: text_wrap: Default is True, turns property on. Returns: Nothing. N)r))rGr)rMrMrNÚ set_text_wrapfs zFormat.set_text_wrapcCsXt|ƒ}|dkrd}n8d|kr*dkrBnn|dkrN| d}n tdƒdS||_dS)zœ Set the Format rotation property. Args: rotation: Rotation angle. No default. Returns: Nothing. iéÿi¦ÿÿÿéZrz3Rotation rotation outside range: -90 <= angle <= 90N)Úintrr,)rGr,rMrMrNÚ set_rotationss  zFormat.set_rotationcCs ||_dS)z£ Set the Format indent property. Args: indent: Default is 1, first indentation level. Returns: Nothing. N)r<)rGr<rMrMrNÚ set_indentŒs zFormat.set_indentcCs ||_dS)z  Set the Format shrink property. Args: shrink: Default is True, turns property on. Returns: Nothing. N)r=)rGr=rMrMrNÚ set_shrink™s zFormat.set_shrinkcCs ||_dS)z® Set the Format text_justlast property. Args: text_justlast: Default is True, turns property on. Returns: Nothing. N)r+)rGr+rMrMrNÚset_text_justlast¦s zFormat.set_text_justlastcCs ||_dS)z˜ Set the Format pattern property. Args: pattern: Default is 1, solid fill. Returns: Nothing. N)r/)rGr/rMrMrNÚ set_pattern³s zFormat.set_patterncCs| |¡|_dS)zž Set the Format bg_color property. Args: bg_color: Background color. No default. Returns: Nothing. N)rVr.)rGr.rMrMrNÚ set_bg_colorÀs zFormat.set_bg_colorcCs| |¡|_dS)zž Set the Format fg_color property. Args: fg_color: Foreground color. No default. Returns: Nothing. N)rVr-)rGr-rMrMrNÚ set_fg_colorÍs zFormat.set_fg_colorcCs,| |¡| |¡| |¡| |¡dS©z™ Set the Format bottom property. Args: bottom: Default is 1, border type 1. Returns: Nothing. N)Ú set_bottomÚset_topÚset_leftÚ set_right)rGÚstylerMrMrNÚ set_borderÛs   zFormat.set_bordercCs,| |¡| |¡| |¡| |¡dS)z• Set the Format bottom property. Args: color: Color string. No default. Returns: Nothing. N)Úset_bottom_colorÚ set_top_colorÚset_left_colorÚset_right_color)rGÚcolorrMrMrNÚset_border_colorìs   zFormat.set_border_colorcCs ||_dSr|)r1)rGr1rMrMrNr}üs zFormat.set_bottomcCs| |¡|_dS)z¢ Set the Format bottom_color property. Args: bottom_color: Color string. No default. Returns: Nothing. N)rVr2)rGr2rMrMrNrƒ s zFormat.set_bottom_colorcCs ||_dS)zŸ Set the Format diag_type property. Args: diag_type: Default is 1, border type 1. Returns: Nothing. N)r5)rGr5rMrMrNÚ set_diag_types zFormat.set_diag_typecCs ||_dS)z• Set the Format left property. Args: left: Default is 1, border type 1. Returns: Nothing. N)r6)rGr6rMrMrNr#s zFormat.set_leftcCs| |¡|_dS)zž Set the Format left_color property. Args: left_color: Color string. No default. Returns: Nothing. N)rVr7)rGr7rMrMrNr…0s zFormat.set_left_colorcCs ||_dS)z— Set the Format right property. Args: right: Default is 1, border type 1. Returns: Nothing. N)r8)rGr8rMrMrNr€=s zFormat.set_rightcCs| |¡|_dS)z  Set the Format right_color property. Args: right_color: Color string. No default. Returns: Nothing. N)rVr9)rGr9rMrMrNr†Js zFormat.set_right_colorcCs ||_dS)z“ Set the Format top property. Args: top: Default is 1, border type 1. Returns: Nothing. N)r:)rGr:rMrMrNr~Ws zFormat.set_topcCs| |¡|_dS)zœ Set the Format top_color property. Args: top_color: Color string. No default. Returns: Nothing. N)rVr;)rGr;rMrMrNr„ds zFormat.set_top_colorcCs| |¡|_dS)zž Set the Format diag_color property. Args: diag_color: Color string. No default. Returns: Nothing. N)rVr4)rGr4rMrMrNÚset_diag_colorqs zFormat.set_diag_colorcCs ||_dS)z£ Set the Format diag_border property. Args: diag_border: Default is 1, border type 1. Returns: Nothing. N)r3)rGr3rMrMrNÚset_diag_border~s zFormat.set_diag_bordercCs ||_dS)z¬ Set the Format quote prefix property. Args: quote_prefix: Default is True, turns property on. Returns: Nothing. N)rB)rGrBrMrMrNÚset_quote_prefix‹s zFormat.set_quote_prefixcCs ||_dS)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)rC)rGrCrMrMrNÚ set_checkbox˜szFormat.set_checkboxcCs ||_dS)z¶ Set the property to indicate the format has a font. Args: has_font: Default is True, turns property on. Returns: Nothing. N)r)rGrrMrMrNÚ set_has_font±s zFormat.set_has_fontcCs ||_dS)z¶ Set the property to indicate the format has a fill. Args: has_fill: Default is True, turns property on. Returns: Nothing. N)r0)rGr0rMrMrNÚ set_has_fill¾s zFormat.set_has_fillcCs ||_dS)z› Set the unique font index property. Args: font_index: The unique font index. Returns: Nothing. N)r)rGrrMrMrNÚset_font_indexËs zFormat.set_font_indexcCs ||_dS)z£ Set the unique format index property. Args: xf_index: The unique Excel format index. Returns: Nothing. N)r)rGrrMrMrNÚ set_xf_indexØs zFormat.set_xf_indexcCs ||_dS)z¼ Set the unique conditional format index property. Args: dxf_index: The unique Excel conditional format index. Returns: Nothing. N)r)rGrrMrMrNÚ set_dxf_indexås zFormat.set_dxf_indexcCs ||_dS)z¬ Set the number format_index property. Args: num_format_index: The unique number format index. Returns: Nothing. N)r)rGrrMrMrNÚset_num_format_indexòs zFormat.set_num_format_indexcCs ||_dS)z© Set the horizontal text alignment property. Args: text_h_align: Horizontal text alignment. Returns: Nothing. N)r()rGr(rMrMrNrmÿs zFormat.set_text_h_aligncCs ||_dS)z¥ Set the vertical text alignment property. Args: text_h_align: Vertical text alignment. Returns: Nothing. N)r*)rGr*rMrMrNrn s zFormat.set_text_v_alignrcCs ||_dS)zœ Set the reading order property. Args: direction: Default is 0, left to right. Returns: Nothing. N)r>)rGÚ directionrMrMrNÚset_reading_orders 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)ro)rGÚalignrMrMrNÚ set_valign'szFormat.set_valigncCs ||_dS)z“ Set the font family property. Args: font_family: Font family number. Returns: Nothing. N)r)rGrrMrMrNÚset_font_family:s zFormat.set_font_familycCs ||_dS)z¦ Set the font character set property. Args: font_charset: The font character set number. Returns: Nothing. N)r)rGrrMrMrNÚset_font_charsetGs zFormat.set_font_charsetcCs ||_dS)z Set the font scheme property. Args: font_scheme: The font scheme. Returns: Nothing. N)r )rGr rMrMrNÚset_font_schemeTs zFormat.set_font_schemecCs ||_dS)zŸ Set the font condense property. Args: font_condense: The font condense property. Returns: Nothing. N)r!)rGr!rMrMrNÚset_font_condenseas zFormat.set_font_condensecCs ||_dS)z™ Set the font extend property. Args: font_extend: The font extend property. Returns: Nothing. N)r")rGr"rMrMrNÚset_font_extendns zFormat.set_font_extendcCs ||_dS)z Set the theme property. Args: theme: Format theme. Returns: Nothing. N)r#)rGr#rMrMrNÚ set_theme{s zFormat.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%r[rr$)rGr$rMrMrNÚ set_hyperlinkˆs   zFormat.set_hyperlinkcCs ||_dS)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)r@)rGZ color_indexrMrMrNÚset_color_indexed˜s zFormat.set_color_indexedcCs ||_dS)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)rA)rGrArMrMrNÚ set_font_only¦s zFormat.set_font_onlycCs ||_dS)z(Deprecated: Use set_font_name() instead.NrOrPrMrMrNÚset_font·szFormat.set_fontcCs ||_dS)z(Deprecated: Use set_font_size() instead.NrRrSrMrMrNÚset_size»szFormat.set_sizecCs| |¡|_dS)z)Deprecated: Use set_font_color() instead.NrUrWrMrMrNÚ set_color¿szFormat.set_colorcCsrd}g}|js2|js2|js2|js2|js2|js2|jr8d}n||fS|jrˆ|jdkrˆ|jdkrˆ|jdkrˆ|jdkrˆ|jdkrˆ|jdkrˆd|_|jr”d|_|jdkr¤d|_|jdkr´d|_|jdkrÄd|_|jdkrÔd|_|jràd|_d}|jdkrø| d¡|jd kr| d ¡|jdkr$| d ¡|jdkr:| d ¡|jdkrP| d ¡|jdkrj| 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¡|jdkrT| d¡|jd krj| d¡||fS)NrrrdrkrhrfZcenterContinuous)Ú horizontalr6r)r¥rc)r¥r8)r¥re)r¥rgrir¥)r¥rj)ZjustifyLastLiner)Úverticalr:)r¦rc)r¦rg)r¦rjZ textRotationr<)ZwrapTextr)Z shrinkToFitr)Ú readingOrderr)r§r) r(r*r<r,r)r=r>r?Úappend)rGÚchangedr–Z continuousrMrMrNÚ_get_align_propertiesÉs¦ÿþýüûúù ÿþýüûúù                                 zFormat._get_align_propertiescCs(g}|js| d¡|jr$| d¡|S)N)r'r)r&r)r'r¨r&)rGÚ attributesrMrMrNÚ_get_protection_properties)s   z!Format._get_protection_propertiesc CsR|jdkrLd dd„| ¡| ¡| ¡| ¡|j|j|j|j |j f Dƒ¡|_|jS)Nú:css|]}t|ƒVqdS©N©Ústr©Ú.0ÚxrMrMrNÚ 7sÿz)Format._get_format_key..) rFÚjoinÚ _get_font_keyÚ_get_border_keyÚ _get_fill_keyÚ_get_alignment_keyrr'rCrBr&)rGrMrMrNÚ_get_format_key4s  ÷þ zFormat._get_format_keycCsLd dd„|j|j|j|j|j|j|j|j|j |j |j |j |j f Dƒ¡}|S)Nr­css|]}t|ƒVqdSr®r¯r±rMrMrNr´Jsÿz'Format._get_font_key..)rµrrrrrrrrrrrrr#©rGrIrMrMrNr¶Hs" óþzFormat._get_font_keycCsDd dd„|j|j|j|j|j|j|j|j|j |j |j f Dƒ¡}|S)Nr­css|]}t|ƒVqdSr®r¯r±rMrMrNr´asÿz)Format._get_border_key..) rµr1r2r3r4r5r6r7r8r9r:r;r»rMrMrNr·_s õþzFormat._get_border_keycCs$d dd„|j|j|jfDƒ¡}|S)Nr­css|]}t|ƒVqdSr®r¯r±rMrMrNr´vsz'Format._get_fill_key..)rµr/r.r-r»rMrMrNr¸ts zFormat._get_fill_keyc Cs4d dd„|j|j|j|j|j|j|jfDƒ¡}|S)Nr­css|]}t|ƒVqdSr®r¯r±rMrMrNr´}sÿz,Format._get_alignment_key..)rµr(r*r<r,r)r=r>r»rMrMrNr¹zs ùþ zFormat._get_alignment_keycCsN|jdk r|jS| ¡}||jkr,|j|Sdt|jƒ}||j|<||_|S)Nr)rrºr Úlen©rGrIÚindexrMrMrNÚ _get_xf_indexŒs    zFormat._get_xf_indexcCsJ|jdk r|jS| ¡}||jkr,|j|St|jƒ}||j|<||_|Sr®)rrºr r¼r½rMrMrNÚ_get_dxf_index s     zFormat._get_dxf_indexcCs4ddddddddd d dd d d ddddœ}| ||¡S)Nz#000000z#0000FFz#800000z#00FFFFz#808080z#008000z#00FF00z#FF00FFz#000080z#FF6600z#800080z#FF0000z#C0C0C0z#FFFFFFz#FFFF00Z Automatic)ÚblackÚblueZbrownÚcyanÚgrayÚgreenZlimeÚmagentaZnavyZorangeZpinkÚpurpleÚredÚsilverÚwhiteÚyellowZ automatic)Úget)rGr‡Z named_colorsrMrMrNrV³s&ïzFormat._get_color)NNN)r)T)T)r)T)r)T)T)T)T)N)T)r)T)T)r)r)r)r)r)r)r)r)T)T)T)T)r)T)T)LÚ__name__Ú __module__Ú __qualname__Ú__doc__r rQrTrXrYrZr[r\r]r^r_r`rarbrorprqrurvrwrxryrzr{r‚rˆr}rƒr‰rr…r€r†r~r„rŠr‹rŒrrŽrrr‘r’r“rmrnr•r—r˜r™ršr›rœrrŸr r¡r¢r£r¤rªr¬rºr¶r·r¸r¹r¿rÀrVÚ __classcell__rMrMrKrNrs a   3                         ` rN)ÚwarningsrÚrZ XMLwriterrrMrMrMrNÚ s