li~bddlmZmZddlmZddlmZddlmZGddejZ y) )LiteralUnion)warn)Color) xmlwriterceZdZdZddfd ZdefdZddZddeddfdZ d e ee fddfd Z dd e ddfd Zdd e ddfdZddedddfdZdde ddfdZddedddfdZdde ddfdZdde ddfdZdeddfdZdde ddfdZdde ddfd Zd!ed"ddfd#Zddd$Zdd%e ddfd&Zd'eddfd(Zdd)eddfd*Zdd+e ddfd,Zdd-e ddfd.Zdd/eddfd0Z d1e ee fddfd2Z!d3e ee fddfd4Z"dd5eddfd6Z#d7e ee fddfd8Z$dd9eddfd:Z%d;e ee fddfd<Z&dd=ed>ddfd?Z'dd@eddfdAZ(dBe ee fddfdCZ)ddDeddfdEZ*dFe ee fddfdGZ+ddHeddfdIZ,dJe ee fddfdKZ-dLe ee fddfdMZ.ddNeddfdOZ/ddPe ddfdQZ0ddRe ddfdSZ1ddTe ddfdUZ2ddVe ddfdWZ3dXeddfdYZ4dZeddfd[Z5d\eddfd]Z6d^eddfd_Z7d`eddfdaZ8dbeddfdcZ9dddeddfdeZ:dfed"ddfdgZ;dheddfdiZdneddfdoZ?dpeddfdqZ@dreddfdsZAddte ddfduZBdvedwddfdxZCddye ddfdzZDd{eddfd|ZEdeddfd}ZFd e e efddfd~ZGdZHdZIdZJdZKdZLdZMdZNdZOdZPxZQS)Formatz; A class for writing the Excel XLSX Format file. Nreturnc |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|_?d|_@d|_Ad|_B|jD]\}}t|d |z|d|_Ey) 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 O/var/www/html/eduruby.in/venv/lib/python3.12/site-packages/xlsxwriter/format.pyrzFormat.__init__ s;  J !+"- # ! !  ""         !#      ! %**, /JC 'GD&3, ' . / ctd|jd|jd|jd|jd|jd|j d|j d|jd |jd |jd |jd |jd |jd|jdS)zH 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=))r!r"rr rr#rr2r4r7r8r9r1r0rYs r`__repr__zFormat.__repr__{s *+()II;kk]#()//*+//,- --./ --./ ' '||n%kk]#kk]! % rac||_y)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. Nr!rYr!s r` set_font_namezFormat.set_font_names #rar"c||_y)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"rYr"s r` set_font_sizezFormat.set_font_size #rar#c8tj||_y)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#rYr#s r`set_font_colorzFormat.set_font_color ++J7rarc||_y)z Set the Format bold property. Args: bold: Default is True, turns property on. Returns: Nothing. N)r)rYrs r`set_boldzFormat.set_bold  rar c||_y)z Set the Format italic property. Args: italic: Default is True, turns property on. Returns: Nothing. N)r )rYr s r` set_italiczFormat.set_italic  rar)rr!"c||_y)z Set the Format underline property. Args: underline: Default is 1, single underline. Returns: Nothing. N)r)rYrs r` set_underlinezFormat.set_underlinernrar$c||_y)z Set the Format font_strikeout property. Args: font_strikeout: Default is True, turns property on. Returns: Nothing. N)r$)rYr$s r`set_font_strikeoutzFormat.set_font_strikeouts -rar')rrc||_y)z Set the Format font_script property. Args: font_script: Default is 1, superscript. Returns: Nothing. N)r')rYr's r`set_font_scriptzFormat.set_font_script 'rar%c||_y)z Set the Format font_outline property. Args: font_outline: Default is True, turns property on. Returns: Nothing. N)r%)rYr%s r`set_font_outlinezFormat.set_font_outline )rar&c||_y)z Set the Format font_shadow property. Args: font_shadow: Default is True, turns property on. Returns: Nothing. N)r&)rYr&s r`set_font_shadowzFormat.set_font_shadow rrarc||_y)z Set the Format num_format property such as '#,##0'. Args: num_format: String representing the number format. No default. Returns: Nothing. N)r)rYrs r`set_num_formatzFormat.set_num_format %rar1c||_y)z Set the Format locked property. Args: locked: Default is True, turns property on. Returns: Nothing. N)r1)rYr1s r` set_lockedzFormat.set_locked'rzrar0c||_y)z Set the Format hidden property. Args: hidden: Default is True, turns property on. Returns: Nothing. N)r0)rYr0s r` set_hiddenzFormat.set_hidden4rzra alignment)rGcentrecenterrIfilljustify center_across centre_across distributedjustify_distributedrrKvcentrevcenterrBvjustify vdistributedc|j}|dk(r|jd|dk(r|jd|dk(r|jd|dk(r|jd|dk(r|jd |d k(r|jd |d k(r|jd |dk(r|jd |dk(r|jd|dk(r|jd|dk(rd|_|dk(r|jd|dk(r|jd|dk(r|jd|dk(r|jd|dk(r|jd |dk(r|jd yy)z Set the Format cell alignment. Args: alignment: String representing alignment. No default. Returns: Nothing. rGrrrrrIrrrrrrrKrrrBrrN)lowerset_text_h_alignrQset_text_v_align)rYrs r` set_alignzFormat.set_alignAs>OO%     ! !! $   ! !! $   ! !! $    ! !! $    ! !! $  !  ! !! $  '  ! !! $  '  ! !! $  %  ! !! $ - -  ! !! $ - - !D     ! !! $  !  ! !! $  !  ! !! $   ! !! $  "  ! !! $  &  ! !! $ 'rac&|jdy)z` Set the Format center_across property. Returns: Nothing. rN)r)rY align_types r`set_center_acrosszFormat.set_center_acrosss a rar3c||_y)z Set the Format text_wrap property. Args: text_wrap: Default is True, turns property on. Returns: Nothing. N)r3)rYr3s r` set_text_wrapzFormat.set_text_wraprnrar6ct|}|dk(r d}||_yd|cxkrdkrnn|dkr| dz}||_ytdy||_y)z Set the Format rotation property. Args: rotation: Rotation angle. No default. Returns: Nothing. iiZrz3Rotation rotation outside range: -90 <= angle <= 90N)intrr6)rYr6s r` set_rotationzFormat.set_rotationscx= s?H! H " "!|$9r> !  F G   rarMc||_y)z Set the Format indent property. Args: indent: Default is 1, first indentation level. Returns: Nothing. N)rM)rYrMs r` set_indentzFormat.set_indentrzrarNc||_y)z Set the Format shrink property. Args: shrink: Default is True, turns property on. Returns: Nothing. N)rN)rYrNs r` set_shrinkzFormat.set_shrinkrzrar5c||_y)z Set the Format text_justlast property. Args: text_justlast: Default is True, turns property on. Returns: Nothing. N)r5)rYr5s r`set_text_justlastzFormat.set_text_justlast +rar9c||_y)z Set the Format pattern property. Args: pattern: Default is 1, solid fill. Returns: Nothing. N)r9)rYr9s r` set_patternzFormat.set_patterns  rar8c8tj||_y)z Set the Format bg_color property. Args: bg_color: Background color. No default. Returns: Nothing. N)rrqr8)rYr8s r` set_bg_colorzFormat.set_bg_color))(3 rar7c8tj||_y)z Set the Format fg_color property. Args: fg_color: Foreground color. No default. Returns: Nothing. N)rrqr7)rYr7s r` set_fg_colorzFormat.set_fg_colorrrastylec|j||j||j||j|yz Set the Format bottom property. Args: bottom: Default is 1, border type 1. Returns: Nothing. N) set_bottomset_topset_left set_right)rYrs r` set_borderzFormat.set_border s4  U e uracolorc|j||j||j||j|y)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)rYrs r`set_border_colorzFormat.set_border_colors< e$ 5! E" U#rarBc||_yr)rB)rYrBs r`rzFormat.set_bottom*rzrarCc8tj||_y)z Set the Format bottom_color property. Args: bottom_color: Color string. No default. Returns: Nothing. N)rrqrC)rYrCs r`rzFormat.set_bottom_color7s"--l;rarF)rrrc||_y)z Set the Format diag_type property. Args: diag_type: Default is 1, border type 1. Returns: Nothing. N)rF)rYrFs r` set_diag_typezFormat.set_diag_typeDrnrarGc||_y)z Set the Format left property. Args: left: Default is 1, border type 1. Returns: Nothing. N)rG)rYrGs r`rzFormat.set_leftQrwrarHc8tj||_y)z Set the Format left_color property. Args: left_color: Color string. No default. Returns: Nothing. N)rrqrH)rYrHs r`rzFormat.set_left_color^rtrarIc||_y)z Set the Format right property. Args: right: Default is 1, border type 1. Returns: Nothing. N)rI)rYrIs r`rzFormat.set_rightk  rarJc8tj||_y)z Set the Format right_color property. Args: right_color: Color string. No default. Returns: Nothing. N)rrqrJ)rYrJs r`rzFormat.set_right_colorxs!,,[9rarKc||_y)z Set the Format top property. Args: top: Default is 1, border type 1. Returns: Nothing. N)rK)rYrKs r`rzFormat.set_tops rarLc8tj||_y)z Set the Format top_color property. Args: top_color: Color string. No default. Returns: Nothing. N)rrqrL)rYrLs r`rzFormat.set_top_colors**95rarEc8tj||_y)z Set the Format diag_color property. Args: diag_color: Color string. No default. Returns: Nothing. N)rrqrE)rYrEs r`set_diag_colorzFormat.set_diag_colorrtrarDc||_y)z Set the Format diag_border property. Args: diag_border: Default is 1, border type 1. Returns: Nothing. N)rD)rYrDs r`set_diag_borderzFormat.set_diag_borderrrarTc||_y)z Set the Format quote prefix property. Args: quote_prefix: Default is True, turns property on. Returns: Nothing. N)rT)rYrTs r`set_quote_prefixzFormat.set_quote_prefixrrarUc||_y)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)rU)rYrUs r` set_checkboxzFormat.set_checkboxs ! rarc||_y)z Set the property to indicate the format has a font. Args: has_font: Default is True, turns property on. Returns: Nothing. N)r)rYrs r` set_has_fontzFormat.set_has_font ! rar:c||_y)z Set the property to indicate the format has a fill. Args: has_fill: Default is True, turns property on. Returns: Nothing. N)r:)rYr:s r` set_has_fillzFormat.set_has_fillrrarc||_y)z Set the unique font index property. Args: font_index: The unique font index. Returns: Nothing. N)r)rYrs r`set_font_indexzFormat.set_font_indexrrarc||_y)z Set the unique format index property. Args: xf_index: The unique Excel format index. Returns: Nothing. N)r)rYrs r` set_xf_indexzFormat.set_xf_indexrrarc||_y)z Set the unique conditional format index property. Args: dxf_index: The unique Excel conditional format index. Returns: Nothing. N)r)rYrs r` set_dxf_indexzFormat.set_dxf_indexrnrarc||_y)z Set the number format_index property. Args: num_format_index: The unique number format index. Returns: Nothing. N)r)rYrs r`set_num_format_indexzFormat.set_num_format_index s !1rar2c||_y)z Set the horizontal text alignment property. Args: text_h_align: Horizontal text alignment. Returns: Nothing. N)r2)rYr2s r`rzFormat.set_text_h_align-rrar4c||_y)z Set the vertical text alignment property. Args: text_h_align: Vertical text alignment. Returns: Nothing. N)r4)rYr4s r`rzFormat.set_text_v_align:rra directionc||_y)z Set the reading order property. Args: direction: Default is 0, left to right. Returns: Nothing. N)rP)rYrs r`set_reading_orderzFormat.set_reading_orderGs 'raalignc&|j|y)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)rYrs r` set_valignzFormat.set_valignUsL urar(c||_y)z Set the font family property. Args: font_family: Font family number. Returns: Nothing. N)r()rYr(s r`set_font_familyzFormat.set_font_family}rrar)c||_y)z Set the font character set property. Args: font_charset: The font character set number. Returns: Nothing. N)r))rYr)s r`set_font_charsetzFormat.set_font_charsetrrar*c||_y)z Set the font scheme property. Args: font_scheme: The font scheme. Returns: Nothing. N)r*)rYr*s r`set_font_schemezFormat.set_font_schemerrar+c||_y)z Set the font condense property. Args: font_condense: The font condense property. Returns: Nothing. N)r+)rYr+s r`set_font_condensezFormat.set_font_condenserrar,c||_y)z Set the font extend property. Args: font_extend: The font extend property. Returns: Nothing. N)r,)rYr,s r`set_font_extendzFormat.set_font_extendrrar-c||_y)z Set the theme property. Args: theme: Format theme. Returns: Nothing. N)r-)rYr-s r` set_themezFormat.set_themerrar.cdd|_|jd|jd||_y)z Set the properties for the hyperlink style. Args: hyperlink: Default is True, turns property on. Returns: Nothing. r N)r/r~rr.)rYr.s r` set_hyperlinkzFormat.set_hyperlinks,  1 r"ra color_index)rrc||_y)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)rR)rYrs r`set_color_indexedzFormat.set_color_indexeds )rarSc||_y)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)rS)rYrSs r` set_font_onlyzFormat.set_font_onlyrnrar!c||_y)z(Deprecated: Use set_font_name() instead.Nrgrhs r`set_fontzFormat.set_font "rac||_y)z(Deprecated: Use set_font_size() instead.Nrkrls r`set_sizezFormat.set_sizer rac8tj||_y)z)Deprecated: Use set_font_color() instead.Nrprrs r` set_colorzFormat.set_colors++J7rac8d}g}|jsH|js<|js0|js$|js|j s |j rd}n||fS|jra|jdk7rR|jdk7rC|jdk7r4|jdk7r%|jdk7r|jdk7rd|_|jrd|_|jdk(rd|_|jdk(rd|_|jdk(rd|_|jdk7rd|_|jrd|_d}|jdk(r|jd|jd k(r|jd |jdk(r|jd |jdk(r|jd |jdk(r|jd |jdk(r|jd|f|jdk(r|jd|jr|jd|jdk(r|jd|jd k(r|jd|jdk(r|jd|jdk(r|jd|jr|jd|jf|jr|jd|jf|jr|jd|j r|jd|j dk(r|jd|j d k(r|jd||fS)NrrrrrrcenterContinuous) horizontalrGr)rr)rrI)rr)rrrr)rr)justifyLastLiner)verticalrK)rr)rr)rr textRotationrM)wrapTextr) shrinkToFitr) readingOrderr)rr) r2r4rMr6r3rNrPrQappend)rYchangedr continuouss r`_get_align_propertieszFormat._get_align_properties s     {{}}~~{{!!GE> ! 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, -~rac~g}|js|jd|jr|jd|S)N)r1r)r0r)r1rr0)rY attributess r`_get_protection_propertiesz!Format._get_protection_propertiesls7 {{   m , ;;   m ,rac R|jdjd|j|j|j |j |j |j|j|j|jf D|_|jS)N:c32K|]}t|ywNstr.0xs r` z)Format._get_format_key..zs (A () rXjoin _get_font_key_get_border_key _get_fill_key_get_alignment_keyrr1rUrTr0rds r`_get_format_keyzFormat._get_format_keyws    #"xx (&&(((*&&(++-OOKKMM%%KK  ( D racTdjd|j|j|j|j|j |j |j|j|j|j|j|j|jf D}|S)Nr"c32K|]}t|ywr$r%r's r`r*z'Format._get_font_key..s  F r+)r,rr#r)r(r%r'r&r$r!r r"rr-rYr]s r`r-zFormat._get_font_keyshh  !!  !!    ##    & rac(djd|j|j|j|j|j |j |j|j|j|j|jf D}|S)Nr"c32K|]}t|ywr$r%r's r`r*z)Format._get_border_key..s  F r+) r,rBrCrDrErFrGrHrIrJrKrLr4s r`r.zFormat._get_border_keys{hh  !!         " racxdjd|j|j|jfD}|S)Nr"c32K|]}t|ywr$r%r's r`r*z'Format._get_fill_key..sT!s1vTr+)r,r9r8r7r4s r`r/zFormat._get_fill_keys.hhT dmmT]]'STT rac djd|j|j|j|j|j |j |jfD}|S)Nr"c32K|]}t|ywr$r%r's r`r*z,Format._get_alignment_key..s   F  r+)r,r2r4rMr6r3rNrPr4s r`r0zFormat._get_alignment_keysahh  !!!!   ""    rac|j |jS|j}||jvr|j|Sdt|jz}||j|<||_|S)Nr)rr1rlenrYr]indexs r` _get_xf_indexzFormat._get_xf_indexsx == $== ""$ $(( ())#. .C..//&+s#  rac|j |jS|j}||jvr|j|St|j}||j|<||_|Sr$)rr1rr<r=s r`_get_dxf_indexzFormat._get_dxf_indexss >> %>> !""$ $)) )**3/ /D++,',$ ra)NNN)r N)r)T)rr$)rNr N)r)R__name__ __module__ __qualname____doc__rr&rerirrmrrrsboolrvryrr~rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr r rrrr r1r-r.r/r0r?rA __classcell__)r_s@r`r r s/Y v # 8 # #s #D # 8sEz): 8t 8 T T     #w|'< #T # - - - '74= ' ' )T )T ) '4 '4 ' % % %      F%  F%* +F%P ! #t #t #!S!T!2  T     +t +t + 3 t  4U3:%6 44 4 4U3:%6 44 4D"$eCJ&7$D$  T   <4 < #ww'7 # # S   8sEz): 8t 8 s 4  :5e+< : : 3 t  6uS%Z'8 6T 6 8sEz): 8t 8 '3 't ' )T )T )!T!T!2 !T !T ! !T !T ! % % % !S !T ! #s #t # 1S 1T 1 )S )T ) )S )T ) '3 't '&  &* +&P '3 '4 ' )S )T ) '3 '4 ' +s +t + '3 '4 ' s t #t#t# )WT] )t ) #t #t #"###$####$#8E%*$58$8^@  (.* $(rar N) typingrrwarningsrxlsxwriter.colorrr XMLwriterr rar`rNs'""aY ara