a èÞJbfã@s.ddlmZddlmZGdd„dejƒZdS)é)Ú xmlwriteré)Úwarncs‚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 d›dd„Zdd„Zdœdd„Zdd 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*dTdU„Z+dVdW„Z,dXdY„Z-dZd[„Z.d\d]„Z/d^d_„Z0d­dadb„Z1dcdd„Z2dedf„Z3dgdh„Z4didj„Z5dkdl„Z6dmdn„Z7dodp„Z8d®dqdr„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’„ZI‡ZJS)°ÚFormatz; A class for writing the Excel XLSX Format file. NcsÄ|dur i}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| B¡D]\}}tC|d |ƒ|ƒqœd|_DdS) z Constructor. NZGeneralrZCalibrié éÚminorFrZset_)EÚsuperrÚ__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ÚitemsÚgetattrÚ _format_key)ÚselfZ propertiesZ xf_indicesZ dxf_indicesÚkeyÚvalue©Ú __class__©ú0lib/python3.9/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©rDrrIrIrJÚ set_font_nameys 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©rDrrIrIrJÚ 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©rDrrIrIrJÚ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)rDrrIrIrJÚ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)rDrrIrIrJÚ set_italic®s zFormat.set_italicrcCs ||_dS)z¢ Set the Format underline property. Args: underline: Default is 1, single underline. Returns: Nothing. N)r)rDrrIrIrJÚ 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)rDrrIrIrJÚ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)rDrrIrIrJÚ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)rDrrIrIrJÚ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)rDrrIrIrJÚ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)rDrrIrIrJÚset_num_formatüs zFormat.set_num_formatcCs ||_dS)z  Set the Format locked property. Args: locked: Default is True, turns property on. Returns: Nothing. N)r&)rDr&rIrIrJÚ set_locked s zFormat.set_lockedcCs ||_dS)z  Set the Format hidden property. Args: hidden: Default is True, turns property on. Returns: Nothing. N)r%)rDr%rIrIrJÚ 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. r5rZcentrerÚcenterr7éÚfilléÚjustifyéZ center_acrosséZ centre_acrossÚ distributedéZjustify_distributedr9ZvcentreZvcenterr0ZvjustifyZ vdistributedN)ÚlowerÚset_text_h_alignr>Úset_text_v_align)rDZ alignmentrIrIrJÚ set_align#sF                    zFormat.set_aligncCs| d¡dS)z` Set the Format center_across property. Returns: Nothing. reN)ri)rDZ align_typerIrIrJÚset_center_acrossVszFormat.set_center_acrosscCs ||_dS)z¦ Set the Format text_wrap property. Args: text_wrap: Default is True, turns property on. Returns: Nothing. N)r()rDr(rIrIrJÚ set_text_wrap`s 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+)rDr+rIrIrJÚ set_rotationms  zFormat.set_rotationcCs ||_dS)z£ Set the Format indent property. Args: indent: Default is 1, first indentation level. Returns: Nothing. N)r;)rDr;rIrIrJÚ 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<)rDr<rIrIrJÚ 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*)rDr*rIrIrJÚ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.)rDr.rIrIrJÚ set_pattern­s zFormat.set_patterncCs| |¡|_dS)zž Set the Format bg_color property. Args: bg_color: Background color. No default. Returns: Nothing. N)rRr-)rDr-rIrIrJÚ 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)rRr,)rDr,rIrIrJÚ 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)rDZstylerIrIrJÚ 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)rDÚcolorrIrIrJÚset_border_coloræs   zFormat.set_border_colorcCs ||_dSrx)r0)rDr0rIrIrJryös zFormat.set_bottomcCs| |¡|_dS)z¢ Set the Format bottom_color property. Args: bottom_color: Color string. No default. Returns: Nothing. N)rRr1)rDr1rIrIrJr~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)r4)rDr4rIrIrJÚ 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)r5)rDr5rIrIrJr{s zFormat.set_leftcCs| |¡|_dS)zž Set the Format left_color property. Args: left_color: Color string. No default. Returns: Nothing. N)rRr6)rDr6rIrIrJr€*s zFormat.set_left_colorcCs ||_dS)z— Set the Format right property. Args: right: Default is 1, border type 1. Returns: Nothing. N)r7)rDr7rIrIrJr|7s zFormat.set_rightcCs| |¡|_dS)z  Set the Format right_color property. Args: right_color: Color string. No default. Returns: Nothing. N)rRr8)rDr8rIrIrJrDs zFormat.set_right_colorcCs ||_dS)z“ Set the Format top property. Args: top: Default is 1, border type 1. Returns: Nothing. N)r9)rDr9rIrIrJrzQs zFormat.set_topcCs| |¡|_dS)zœ Set the Format top_color property. Args: top_color: Color string. No default. Returns: Nothing. N)rRr:)rDr:rIrIrJr^s zFormat.set_top_colorcCs| |¡|_dS)zž Set the Format diag_color property. Args: diag_color: Color string. No default. Returns: Nothing. N)rRr3)rDr3rIrIrJÚset_diag_colorks zFormat.set_diag_colorcCs ||_dS)z£ Set the Format diag_border property. Args: diag_border: Default is 1, border type 1. Returns: Nothing. N)r2)rDr2rIrIrJÚset_diag_borderxs zFormat.set_diag_bordercCs ||_dS©N)r)rDrrIrIrJÚ set_has_fontŒszFormat.set_has_fontcCs ||_dSr‡)r/)rDr/rIrIrJÚ set_has_fillszFormat.set_has_fillcCs ||_dSr‡)r)rDrrIrIrJÚset_font_index”szFormat.set_font_indexcCs ||_dSr‡)r )rDr rIrIrJÚ set_xf_index˜szFormat.set_xf_indexcCs ||_dSr‡)r)rDrrIrIrJÚ set_dxf_indexœszFormat.set_dxf_indexcCs ||_dSr‡)r)rDrrIrIrJÚset_num_format_index szFormat.set_num_format_indexcCs ||_dSr‡)r')rDr'rIrIrJri¤szFormat.set_text_h_aligncCs ||_dSr‡)r))rDr)rIrIrJrj¨szFormat.set_text_v_alignrcCs ||_dSr‡)r=)rDÚ directionrIrIrJÚset_reading_order¬szFormat.set_reading_ordercCs| |¡dSr‡)rk)rDÚalignrIrIrJÚ set_valign°szFormat.set_valigncCs ||_dSr‡)r)rDrrIrIrJÚset_font_family¶szFormat.set_font_familycCs ||_dSr‡)r)rDrrIrIrJÚset_font_charsetºszFormat.set_font_charsetcCs ||_dSr‡)r)rDrrIrIrJÚset_font_scheme¾szFormat.set_font_schemecCs ||_dSr‡)r )rDr rIrIrJÚset_font_condenseÂszFormat.set_font_condensecCs ||_dSr‡)r!)rDr!rIrIrJÚset_font_extendÆszFormat.set_font_extendcCs ||_dSr‡)r")rDr"rIrIrJÚ set_themeÊszFormat.set_themecCs$d|_| d¡| d¡||_dS)Nré )r$rWr—r#)rDr#rIrIrJÚ set_hyperlinkÎs  zFormat.set_hyperlinkcCs ||_dSr‡)r?)rDZ color_indexrIrIrJÚset_color_indexedÖszFormat.set_color_indexedcCs ||_dSr‡)r@)rDr@rIrIrJÚ set_font_onlyÚszFormat.set_font_onlycCs ||_dSr‡rKrLrIrIrJÚset_fontßszFormat.set_fontcCs ||_dSr‡rNrOrIrIrJÚset_sizeãszFormat.set_sizecCs| |¡|_dSr‡rQrSrIrIrJÚ set_colorçszFormat.set_colorcCsRd}g}|js2|js2|js2|js2|js2|js2|jr8d}n||fS|jrj|jdkrj|jdkrj|jdkrjd|_|jrvd|_|jdkr†d|_|jdkr–d|_|jdkr¦d|_|jdkr¶d|_|jrÂd|_d}|jdkrÚ| d¡|jd krî| d ¡|jdkr| d ¡|jdkr| d ¡|jdkr0| d ¡|jdkrJ| d|f¡|jdkr`| d¡|jrr| d¡|jdkrˆ| d¡|jd krž| d¡|jdkr´| d¡|jdkrÊ| d¡|jrâ| d|jf¡|jrú| d|jf¡|jr | d¡|jr| d¡|jdkr4| d¡|jd krJ| d¡||fS)Nrrr`rgrbrdZcenterContinuous)Ú horizontalr5r)rŸr_)rŸr7)rŸra)rŸrcrerŸ)rŸrf)ZjustifyLastLiner)Úverticalr9)r r_)r rc)r rfr;Z textRotation)ZwrapTextr)Z shrinkToFitr)Ú readingOrderr)r¡r) r'r)r;r+r(r<r=r>Úappend)rDZchangedrZ continuousrIrIrJÚ_get_align_propertiesñsŽÿÿÿþÿþý                                zFormat._get_align_propertiescCs(g}|js| d¡|jr$| d¡|S)N)r&r)r%r)r&r¢r%)rDZattribsrIrIrJÚ_get_protection_propertiesEs   z!Format._get_protection_propertiesc sNˆjdurHd ‡fdd„ˆ ¡ˆ ¡ˆ ¡ˆ ¡ˆjˆjˆjfDƒ¡ˆ_ˆjS)Nú:c3s|]}ˆ |¡VqdSr‡©Ú _to_string©Ú.0Úx©rDrIrJÚ Sóz)Format._get_format_key..) rCÚjoinÚ _get_font_keyÚ_get_border_keyÚ _get_fill_keyÚ_get_alignment_keyrr&r%r«rIr«rJÚ_get_format_keyPs ù zFormat._get_format_keycsPd ‡fdd„ˆjˆjˆjˆjˆjˆjˆjˆjˆj ˆj ˆj ˆj ˆj f Dƒ¡}|S)Nr¥c3s|]}ˆ |¡VqdSr‡r¦r¨r«rIrJr¬`r­z'Format._get_font_key..)r®rrrrrrrrrrrrr"©rDrErIr«rJr¯^s ó zFormat._get_font_keycsHd ‡fdd„ˆjˆjˆjˆjˆjˆjˆjˆjˆj ˆj ˆj f Dƒ¡}|S)Nr¥c3s|]}ˆ |¡VqdSr‡r¦r¨r«rIrJr¬sr­z)Format._get_border_key..) r®r0r1r2r3r4r5r6r7r8r9r:r´rIr«rJr°qsõ zFormat._get_border_keycs(d ‡fdd„ˆjˆjˆjfDƒ¡}|S)Nr¥c3s|]}ˆ |¡VqdSr‡r¦r¨r«rIrJr¬„r­z'Format._get_fill_key..)r®r.r-r,r´rIr«rJr±‚s ý zFormat._get_fill_keyc s8d ‡fdd„ˆjˆjˆjˆjˆjˆjˆjfDƒ¡}|S)Nr¥c3s|]}ˆ |¡VqdSr‡r¦r¨r«rIrJr¬Žr­z,Format._get_alignment_key..)r®r'r)r;r+r(r<r=r´rIr«rJr²‹sù zFormat._get_alignment_keycCsR|jdur|jS| ¡}||jvr,|j|Sdt|jƒ}||j|<||_|SdS)Nr)r r³r Úlen©rDrEÚindexrIrIrJÚ _get_xf_index™s    zFormat._get_xf_indexcCsN|jdur|jS| ¡}||jvr,|j|St|jƒ}||j|<||_|SdSr‡)rr³r rµr¶rIrIrJÚ_get_dxf_index­s     zFormat._get_dxf_indexcCs:ddddddddd d dd d d dddœ}||vr6||}|S)Nz#000000z#0000FFz#800000z#00FFFFz#808080z#008000z#00FF00z#FF00FFz#000080z#FF6600z#800080z#FF0000z#C0C0C0z#FFFFFFz#FFFF00)ZblackZblueZbrownZcyanZgrayZgreenZlimeZmagentaZnavyZorangeZpinkZpurpleZredZsilverZwhiteZyellowrI)rDr‚Z named_colorsrIrIrJrRÀs(ðzFormat._get_colorcCs,z t|ƒWSty&| d¡YS0dS)Nzutf-8)ÚstrÚUnicodeEncodeErrorÚencode)rDrFrIrIrJr§Üs  zFormat._to_string)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)r)T)T)KÚ__name__Ú __module__Ú __qualname__Ú__doc__r rMrPrTrUrVrWrXrYrZr[r\r]r^rkrlrmrqrrrsrtrurvrwr}rƒryr~r„r{r€r|rrzrr…r†rˆr‰rŠr‹rŒrrirjrr‘r’r“r”r•r–r—r™ršr›rœrržr£r¤r³r¯r°r±r²r¸r¹rRr§Ú __classcell__rIrIrGrJrsŽ ^   3                T  rN)ÚrÚwarningsrZ XMLwriterrrIrIrIrJÚ s