hvRSSKJr SSKJr SSKJr "SS\R 5rg))warn)Color) xmlwritercL^\rSrSrSrSKU4SjjrSrSrSLSjrSr SMSjr SMS jr SNS jr SMS jr SNS jrSMS jrSMSjrSrSMSjrSMSjrSrSOSjrSMSjrSrSNSjrSMSjrSMSjrSNSjrSrSrSNSjrSrSNSjr Sr!SNS jr"SNS!jr#S"r$SNS#jr%S$r&SNS%jr'S&r(S'r)SNS(jr*SMS)jr+SMS*jr,SMS+jr-SMS,jr.S-r/S.r0S/r1S0r2S1r3S2r4SPS3jr5S4r6S5r7S6r8S7r9S8r:S9r;S:rSMS=jr?S>r@S?rAS@rBSArCSBrDSCrESDrFSErGSFrHSGrISHrJSIrKSJrLU=rM$)QFormatz3 A class for writing the Excel XLSX Format file. c >Uc0n[TU]5 X lX0lSUlSUlSUlSUlSUlSUl SUl SUl SUl SUl SUlSUlSUlSUlSUlSUlSUlSUlSUlSUlSUlSUlSUlSUlSUlSUlS UlSUlSUl SUl!SUl"SUl#SUl$SUl%SUl&SUl'SUl(SUl)SUl*SUl+SUl,SUl-SUl.SUl/SUl0SUl1SUl2SUl3SUl4SUl5SUl6SUl7SUl8SUl9SUl:SUl;SUl<SUl=SUl>SUl?SUl@SUlASUlBUR5HupE[US U-5"U5 M SUlEg) 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__s dC:\Users\julio\OneDrive\Documentos\Trabajo\Ideas Frescas\venv\Lib\site-packages\xlsxwriter/format.pyrFormat.__init__s.  J !+"- # ! !  ""         !#      ! %**,JC D&3, ' .- cxSUR<SURSURSURSURSUR SUR <SURS URS URS URS URS URSURS3$)z8 Return a string representation of the Format instance. zFormat(font_name=z , font_size=z, bold=z , italic=z , underline=z , font_color=z , num_format=z, text_h_align=z, text_v_align=z , fg_color=z , bg_color=z , pattern=z , locked=z , hidden=))rr rrrr!rr0r2r5r6r7r/r.rWs r^__repr__Format.__repr__zs *+()II;kk]#()//*+//,- --./ --./ ' '||n%kk]#kk]! % r`cXlg)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. NrrWrs r^ set_font_nameFormat.set_font_names #r`cXlg)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. Nr rWr s r^ set_font_sizeFormat.set_font_size #r`c:[R"U5Ulg)z Set the Format font_color property. The Excel default is black. Args: font_color: String with the font color. No default. Returns: Nothing. Nr _from_valuer!rWr!s r^set_font_colorFormat.set_font_color ++J7r`cXlg)zl Set the Format bold property. Args: bold: Default is True, turns property on. Returns: Nothing. N)r)rWrs r^set_boldFormat.set_bold  r`cXlg)zp Set the Format italic property. Args: italic: Default is True, turns property on. Returns: Nothing. N)r)rWrs r^ set_italicFormat.set_italic  r`cXlg)zr Set the Format underline property. Args: underline: Default is 1, single underline. Returns: Nothing. N)r)rWrs r^ set_underlineFormat.set_underlinerpr`cXlg)z Set the Format font_strikeout property. Args: font_strikeout: Default is True, turns property on. Returns: Nothing. N)r")rWr"s r^set_font_strikeoutFormat.set_font_strikeouts -r`cXlg)zq Set the Format font_script property. Args: font_script: Default is 1, superscript. Returns: Nothing. N)r%)rWr%s r^set_font_scriptFormat.set_font_script 'r`cXlg)z| Set the Format font_outline property. Args: font_outline: Default is True, turns property on. Returns: Nothing. N)r#)rWr#s r^set_font_outlineFormat.set_font_outline )r`cXlg)zz Set the Format font_shadow property. Args: font_shadow: Default is True, turns property on. Returns: Nothing. N)r$)rWr$s r^set_font_shadowFormat.set_font_shadow rr`cXlg)z Set the Format num_format property such as '#,##0'. Args: num_format: String representing the number format. No default. Returns: Nothing. N)r)rWrs r^set_num_formatFormat.set_num_format %r`cXlg)zp Set the Format locked property. Args: locked: Default is True, turns property on. Returns: Nothing. N)r/)rWr/s r^ set_lockedFormat.set_locked&rr`cXlg)zp Set the Format hidden property. Args: hidden: Default is True, turns property on. Returns: Nothing. N)r.)rWr.s r^ set_hiddenFormat.set_hidden3rr`c UR5nUS:XaURS5 US:XaURS5 US:XaURS5 US:XaURS5 US:XaURS 5 US :XaURS 5 US :XaURS 5 US:XaURS 5 US:XaURS5 US:XaURS5 US:XaSUlUS:XaURS5 US:XaURS5 US:XaURS5 US:XaURS5 US:XaURS 5 US:XaURS 5 gg)zx Set the Format cell alignment. Args: alignment: String representing alignment. No default. Returns: Nothing. rErcentrercenterrGfilljustify center_across centre_across distributedjustify_distributedrIvcentrevcenterr@vjustify vdistributedN)lowerset_text_h_alignrOset_text_v_align)rW alignments r^ set_alignFormat.set_align@sOO%     ! !! $   ! !! $   ! !! $    ! !! $    ! !! $  !  ! !! $  '  ! !! $  '  ! !! $  %  ! !! $ - -  ! !! $ - - !D     ! !! $  !  ! !! $  !  ! !! $   ! !! $  "  ! !! $  &  ! !! $ 'r`c&URS5 g)z@ Set the Format center_across property. Returns: Nothing. rN)r)rW align_types r^set_center_acrossFormat.set_center_acrossss a r`cXlg)zv Set the Format text_wrap property. Args: text_wrap: Default is True, turns property on. Returns: Nothing. N)r1)rWr1s r^ set_text_wrapFormat.set_text_wrap~rpr`c[U5nUS:XaSnO)SUs=::aS::aO O US:aU*S-nO [S5 gXlg)zl Set the Format rotation property. Args: rotation: Rotation angle. No default. Returns: Nothing. iiZrz3Rotation rotation outside range: -90 <= angle <= 90N)intrr4)rWr4s r^ set_rotationFormat.set_rotationsLx= s?H H " "!|$9r> F G  r`cXlg)zs Set the Format indent property. Args: indent: Default is 1, first indentation level. Returns: Nothing. N)rK)rWrKs r^ set_indentFormat.set_indentrr`cXlg)zp Set the Format shrink property. Args: shrink: Default is True, turns property on. Returns: Nothing. N)rL)rWrLs r^ set_shrinkFormat.set_shrinkrr`cXlg)z~ Set the Format text_justlast property. Args: text_justlast: Default is True, turns property on. Returns: Nothing. N)r3)rWr3s r^set_text_justlastFormat.set_text_justlast +r`cXlg)zh Set the Format pattern property. Args: pattern: Default is 1, solid fill. Returns: Nothing. N)r7)rWr7s r^ set_patternFormat.set_patterns  r`c:[R"U5Ulg)zn Set the Format bg_color property. Args: bg_color: Background color. No default. Returns: Nothing. N)rrsr6)rWr6s r^ set_bg_colorFormat.set_bg_color))(3 r`c:[R"U5Ulg)zn Set the Format fg_color property. Args: fg_color: Foreground color. No default. Returns: Nothing. N)rrsr5)rWr5s r^ set_fg_colorFormat.set_fg_colorrr`cURU5 URU5 URU5 URU5 gzi Set the Format bottom property. Args: bottom: Default is 1, border type 1. Returns: Nothing. N) set_bottomset_topset_left set_right)rWstyles r^ set_borderFormat.set_borders4  U e ur`cURU5 URU5 URU5 URU5 g)ze Set the Format bottom property. Args: color: Color string. No default. Returns: Nothing. N)set_bottom_color set_top_colorset_left_colorset_right_color)rWcolors r^set_border_colorFormat.set_border_colors< e$ 5! E" U#r`cXlgr)r@)rWr@s r^rFormat.set_bottomrr`c:[R"U5Ulg)zr Set the Format bottom_color property. Args: bottom_color: Color string. No default. Returns: Nothing. N)rrsrA)rWrAs r^rFormat.set_bottom_color!s"--l;r`cXlg)zo Set the Format diag_type property. Args: diag_type: Default is 1, border type 1. Returns: Nothing. N)rD)rWrDs r^ set_diag_typeFormat.set_diag_type.rpr`cXlg)ze Set the Format left property. Args: left: Default is 1, border type 1. Returns: Nothing. N)rE)rWrEs r^rFormat.set_left;r{r`c:[R"U5Ulg)zn Set the Format left_color property. Args: left_color: Color string. No default. Returns: Nothing. N)rrsrF)rWrFs r^rFormat.set_left_colorHrwr`cXlg)zg Set the Format right property. Args: right: Default is 1, border type 1. Returns: Nothing. N)rG)rWrGs r^rFormat.set_rightU  r`c:[R"U5Ulg)zp Set the Format right_color property. Args: right_color: Color string. No default. Returns: Nothing. N)rrsrH)rWrHs r^rFormat.set_right_colorbs!,,[9r`cXlg)zc Set the Format top property. Args: top: Default is 1, border type 1. Returns: Nothing. N)rI)rWrIs r^rFormat.set_topos r`c:[R"U5Ulg)zl Set the Format top_color property. Args: top_color: Color string. No default. Returns: Nothing. N)rrsrJ)rWrJs r^rFormat.set_top_color|s**95r`c:[R"U5Ulg)zn Set the Format diag_color property. Args: diag_color: Color string. No default. Returns: Nothing. N)rrsrC)rWrCs r^set_diag_colorFormat.set_diag_colorrwr`cXlg)zs Set the Format diag_border property. Args: diag_border: Default is 1, border type 1. Returns: Nothing. N)rB)rWrBs r^set_diag_borderFormat.set_diag_borderrr`cXlg)z| Set the Format quote prefix property. Args: quote_prefix: Default is True, turns property on. Returns: Nothing. N)rR)rWrRs r^set_quote_prefixFormat.set_quote_prefixrr`cXlg)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)rS)rWrSs r^ set_checkboxFormat.set_checkboxs ! r`cXlg)z Set the property to indicate the format has a font. Args: has_font: Default is True, turns property on. Returns: Nothing. N)r)rWrs r^ set_has_fontFormat.set_has_font ! r`cXlg)z Set the property to indicate the format has a fill. Args: has_fill: Default is True, turns property on. Returns: Nothing. N)r8)rWr8s r^ set_has_fillFormat.set_has_fillrr`cXlg)zk Set the unique font index property. Args: font_index: The unique font index. Returns: Nothing. N)r)rWrs r^set_font_indexFormat.set_font_indexrr`cXlg)zs Set the unique format index property. Args: xf_index: The unique Excel format index. Returns: Nothing. N)r)rWrs r^ set_xf_indexFormat.set_xf_indexrr`cXlg)z Set the unique conditional format index property. Args: dxf_index: The unique Excel conditional format index. Returns: Nothing. N)r)rWrs r^ set_dxf_indexFormat.set_dxf_indexrpr`cXlg)z| Set the number format_index property. Args: num_format_index: The unique number format index. Returns: Nothing. N)r)rWrs r^set_num_format_indexFormat.set_num_format_index s !1r`cXlg)zy Set the horizontal text alignment property. Args: text_h_align: Horizontal text alignment. Returns: Nothing. N)r0)rWr0s r^rFormat.set_text_h_alignrr`cXlg)zu Set the vertical text alignment property. Args: text_h_align: Vertical text alignment. Returns: Nothing. N)r2)rWr2s r^rFormat.set_text_v_align$rr`cXlg)zl Set the reading order property. Args: direction: Default is 0, left to right. Returns: Nothing. N)rN)rW directions r^set_reading_orderFormat.set_reading_order1s 'r`c&URU5 g)z 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)rWaligns r^ set_valignFormat.set_valign?s" ur`cXlg)zc Set the font family property. Args: font_family: Font family number. Returns: Nothing. N)r&)rWr&s r^set_font_familyFormat.set_font_familyRrr`cXlg)zv Set the font character set property. Args: font_charset: The font character set number. Returns: Nothing. N)r')rWr's r^set_font_charsetFormat.set_font_charset_rr`cXlg)z` Set the font scheme property. Args: font_scheme: The font scheme. Returns: Nothing. N)r()rWr(s r^set_font_schemeFormat.set_font_schemelrr`cXlg)zo Set the font condense property. Args: font_condense: The font condense property. Returns: Nothing. N)r))rWr)s r^set_font_condenseFormat.set_font_condenseyrr`cXlg)zi Set the font extend property. Args: font_extend: The font extend property. Returns: Nothing. N)r*)rWr*s r^set_font_extendFormat.set_font_extendrr`cXlg)zQ Set the theme property. Args: theme: Format theme. Returns: Nothing. N)r+)rWr+s r^ set_themeFormat.set_themerr`cbSUlURS5 URS5 Xlg)z Set the properties for the hyperlink style. Args: hyperlink: Default is True, turns property on. Returns: Nothing. r N)r-rr4r,)rWr,s r^ set_hyperlinkFormat.set_hyperlinks*  1 r"r`cXlg)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)rP)rW color_indexs r^set_color_indexedFormat.set_color_indexeds )r`cXlg)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)rQ)rWrQs r^ set_font_onlyFormat.set_font_onlyrpr`cXlg)z(Deprecated: Use set_font_name() instead.Nrgrhs r^set_fontFormat.set_font"r`cXlg)z(Deprecated: Use set_font_size() instead.Nrlrms r^set_sizeFormat.set_sizerDr`c:[R"U5Ulg)z)Deprecated: Use set_font_color() instead.Nrrrts r^ set_colorFormat.set_colors++J7r`cSn/nUR(dfUR(dUUR(dDUR(d3UR(d"UR (dUR (aSnOX4$UR(agURS:waWURS:waGURS:wa7URS:wa'URS:waURS:waSUlUR(aSUlURS:XaSUlURS:XaSUlURS:XaSUlURS:waSUlUR(aSUlSnURS:XaURS5 URS :XaURS 5 URS:XaURS 5 URS:XaURS 5 URS:XaURS 5 URS:XaURSU45 URS:XaURS5 UR(aURS5 URS:XaURS5 URS :XaURS5 URS:XaURS5 URS:XaURS5 UR(aURSUR45 UR(aURSUR45 UR(aURS5 UR (aURS5 UR S:XaURS5 UR S :XaURS5 X4$)NrrrrrrcenterContinuous) horizontalrEr)rMr)rMrG)rMr)rMrrrM)rMr)justifyLastLiner)verticalrI)rOr)rOr)rOr textRotationrK)wrapTextr) shrinkToFitr) readingOrderr)rSr) r0r2rKr4r1rLrNrOappend)rWchangedr! continuouss r^_get_align_propertiesFormat._get_align_propertiess     {{}}~~{{!!G> ! KK!!Q&!!Q&!!Q&!!Q&!!Q&!!Q& !D  >>DK    !DK    !DK    !DK    ! !D  ;; !D '    ! LL/ 0    ! LL1 2    ! LL0 1    ! LL/ 0    ! LL2 3    ! LL, 3 4    ! LL6 7    LL/ 0    ! LL, -    ! LL/ 0    ! LL0 1    ! LL4 5 == LL.$--8 9 ;; LL(DKK0 1 >> LL ) ;; LL+ ,    " LL, -    " LL, -~r`c/nUR(dURS5 UR(aURS5 U$)N)r/r)r.r)r/rTr.)rW attributess r^_get_protection_properties!Format._get_protection_propertiesAs7 {{   m , ;;   m ,r`c TURcSRSUR5UR5UR 5UR 5UR URURURUR4 55UlUR$)N:c38# UHn[U5v M g7fNstr.0xs r^ )Format._get_format_key..Os! ( AA ) rVjoin _get_font_key_get_border_key _get_fill_key_get_alignment_keyrr/rSrRr.rcs r^_get_format_keyFormat._get_format_keyLs    #"xx (&&(((*&&(++-OOKKMM%%KK  ( D r`cTSRSURURURURUR UR URURURURURURUR4 55nU$)Nr^c38# UHn[U5v M g7fr`rarcs r^rf'Format._get_font_key..bs!  FFrh)rirr!r'r&r#r%r$r"rrr rr+rWr[s r^rjFormat._get_font_key`shh  !!  !!    ##    & r`c(SRSURURURURUR UR URURURURUR4 55nU$)Nr^c38# UHn[U5v M g7fr`rarcs r^rf)Format._get_border_key..ys!   FF rh) rir@rArBrCrDrErFrGrHrIrJrss r^rkFormat._get_border_keyws{hh  !!         " r`cxSRSURURUR455nU$)Nr^c38# UHn[U5v M g7fr`rarcs r^rf'Format._get_fill_key..sT'S!s1vv'Srh)rir7r6r5rss r^rlFormat._get_fill_keys.hhT dmmT]]'STT r`c SRSURURURURUR UR UR455nU$)Nr^c38# UHn[U5v M g7fr`rarcs r^rf,Format._get_alignment_key..s!   FFrh)rir0r2rKr4r1rLrNrss r^rmFormat._get_alignment_keysahh  !!!!   ""    r`cURb UR$UR5nXR;aURU$S[UR5-nX RU'X lU$)Nr)rrnrlenrWr[indexs r^ _get_xf_indexFormat._get_xf_indexsr == $== ""$ (( ())#. .C..//&+s#  r`cURb UR$UR5nXR;aURU$[UR5nX RU'X lU$r`)rrnrrrs r^_get_dxf_indexFormat._get_dxf_indexsm >> %>> !""$ )) )**3/ /D++,',$ r`)BrVr6rr?r<r@rArSrPrBrCrDrrr5r;r:r'r!r)r*r&rrrQr#r(r%r$r r"r=r>r9rr8rr.r,rKrrOrErFr/rMrrr7rRrNrGrHr4rLr0r3r2r1r+rIrJrrr-r)NNN)r )T)rr`)r)N__name__ __module__ __qualname____firstlineno____doc__rrdrirnruryr}rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr r rrrrrrr"r%r(r+r.r1r4r8r<r?rBrFrIrWr[rnrjrkrlrmrr__static_attributes__ __classcell__)r]s@r^rrsuY v 8 # # 8   # - ' ) ' %  1%f ! #!2   +  4 4"$  < #  8  :  6 8 ' )!2 ! ! % ! # 1 ) ) '& ' ) ' + ' # ) #"##8^@  (.* $(r`rN)warningsrxlsxwriter.colorrr XMLwriterrr`r^rs$"wY wr`