,hvFddlmZddlmZGddejZy))warn) xmlwriterceZdZdZdIfd ZdZdJdZdZdKdZdKdZ dLdZ dKd Z dLd Z dKd Z dKd Zd ZdKdZdKdZdZdMdZdKdZdZdLdZdKdZdKdZdLdZdZdZdLdZdZdLdZdZdLdZ dLdZ!d Z"dLd!Z#d"Z$dLd#Z%d$Z&d%Z'dLd&Z(dKd'Z)dKd(Z*dKd)Z+dKd*Z,d+Z-d,Z.d-Z/d.Z0d/Z1d0Z2dNd1Z3d2Z4d3Z5d4Z6d5Z7d6Z8d7Z9d8Z:dKd9Z;d:Zd=Z?d>Z@d?ZAd@ZBdAZCdBZDdCZEdDZFdEZGdFZHdGZIdHZJxZKS)OFormatz; A class for writing the Excel XLSX Format file. c |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 S/var/www/html/Resume-Scraper/venv/lib/python3.12/site-packages/xlsxwriter/format.pyrzFormat.__init__s;  J !+"- # ! !  ""         !#     ! %**, /JC 'GD&3, ' . / c||_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. NrrUrs r\ set_font_namezFormat.set_font_name~s #r]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. NrrUrs r\ set_font_sizezFormat.set_font_size #r]c0|j||_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. N _get_colorrrUrs r\set_font_colorzFormat.set_font_color//*5r]c||_y)z Set the Format bold property. Args: bold: Default is True, turns property on. Returns: Nothing. N)r)rUrs r\set_boldzFormat.set_bold  r]c||_y)z Set the Format italic property. Args: italic: Default is True, turns property on. Returns: Nothing. N)r)rUrs r\ set_italiczFormat.set_italic  r]c||_y)z Set the Format underline property. Args: underline: Default is 1, single underline. Returns: Nothing. N)r)rUrs r\ set_underlinezFormat.set_underlinerfr]c||_y)z Set the Format font_strikeout property. Args: font_strikeout: Default is True, turns property on. Returns: Nothing. N)r )rUr s r\set_font_strikeoutzFormat.set_font_strikeouts -r]c||_y)z Set the Format font_script property. Args: font_script: Default is 1, superscript. Returns: Nothing. N)r#)rUr#s r\set_font_scriptzFormat.set_font_script 'r]c||_y)z Set the Format font_outline property. Args: font_outline: Default is True, turns property on. Returns: Nothing. N)r!)rUr!s r\set_font_outlinezFormat.set_font_outline )r]c||_y)z Set the Format font_shadow property. Args: font_shadow: Default is True, turns property on. Returns: Nothing. N)r")rUr"s r\set_font_shadowzFormat.set_font_shadowryr]c||_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)rUrs r\set_num_formatzFormat.set_num_format %r]c||_y)z Set the Format locked property. Args: locked: Default is True, turns property on. Returns: Nothing. N)r-)rUr-s r\ set_lockedzFormat.set_lockedrrr]c||_y)z Set the Format hidden property. Args: hidden: Default is True, turns property on. Returns: Nothing. N)r,)rUr,s r\ set_hiddenzFormat.set_hiddenrrr]c|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. rCrcentrer centerrEfilljustify center_across centre_across distributedjustify_distributedrGvcentrevcenterr>vjustify vdistributedN)lowerset_text_h_alignrMset_text_v_align)rU alignments r\ set_alignzFormat.set_align(sOO%     ! !! $   ! !! $   ! !! $    ! !! $    ! !! $  !  ! !! $  '  ! !! $  '  ! !! $  %  ! !! $ - -  ! !! $ - - !D     ! !! $  !  ! !! $  !  ! !! $   ! !! $  "  ! !! $  &  ! !! $ 'r]c&|jdy)z` Set the Format center_across property. Returns: Nothing. rN)r)rU align_types r\set_center_acrosszFormat.set_center_across[s a r]c||_y)z Set the Format text_wrap property. Args: text_wrap: Default is True, turns property on. Returns: Nothing. N)r/)rUr/s r\ set_text_wrapzFormat.set_text_wrapfrfr]ct|}|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)intrr2)rUr2s r\ set_rotationzFormat.set_rotationsscx= s?H! H " "!|$9r> !  F G   r]c||_y)z Set the Format indent property. Args: indent: Default is 1, first indentation level. Returns: Nothing. N)rI)rUrIs r\ set_indentzFormat.set_indentrrr]c||_y)z Set the Format shrink property. Args: shrink: Default is True, turns property on. Returns: Nothing. N)rJ)rUrJs r\ set_shrinkzFormat.set_shrinkrrr]c||_y)z Set the Format text_justlast property. Args: text_justlast: Default is True, turns property on. Returns: Nothing. N)r1)rUr1s r\set_text_justlastzFormat.set_text_justlast +r]c||_y)z Set the Format pattern property. Args: pattern: Default is 1, solid fill. Returns: Nothing. N)r5)rUr5s r\ set_patternzFormat.set_patterns  r]c0|j||_y)z Set the Format bg_color property. Args: bg_color: Background color. No default. Returns: Nothing. N)rir4)rUr4s r\ set_bg_colorzFormat.set_bg_color1 r]c0|j||_y)z Set the Format fg_color property. Args: fg_color: Foreground color. No default. Returns: Nothing. N)rir3)rUr3s r\ set_fg_colorzFormat.set_fg_colorrr]c|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)rUstyles r\ set_borderzFormat.set_borders4  U e ur]c|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)rUcolors r\set_border_colorzFormat.set_border_colors< e$ 5! E" U#r]c||_yr)r>)rUr>s r\rzFormat.set_bottomrrr]c0|j||_y)z Set the Format bottom_color property. Args: bottom_color: Color string. No default. Returns: Nothing. N)rir?)rUr?s r\rzFormat.set_bottom_color s!OOL9r]c||_y)z Set the Format diag_type property. Args: diag_type: Default is 1, border type 1. Returns: Nothing. N)rB)rUrBs r\ set_diag_typezFormat.set_diag_typerfr]c||_y)z Set the Format left property. Args: left: Default is 1, border type 1. Returns: Nothing. N)rC)rUrCs r\rzFormat.set_left#ror]c0|j||_y)z Set the Format left_color property. Args: left_color: Color string. No default. Returns: Nothing. N)rirD)rUrDs r\rzFormat.set_left_color0rlr]c||_y)z Set the Format right property. Args: right: Default is 1, border type 1. Returns: Nothing. N)rE)rUrEs r\rzFormat.set_right=  r]c0|j||_y)z Set the Format right_color property. Args: right_color: Color string. No default. Returns: Nothing. N)rirF)rUrFs r\rzFormat.set_right_colorJs ??;7r]c||_y)z Set the Format top property. Args: top: Default is 1, border type 1. Returns: Nothing. N)rG)rUrGs r\rzFormat.set_topWs r]c0|j||_y)z Set the Format top_color property. Args: top_color: Color string. No default. Returns: Nothing. N)rirH)rUrHs r\rzFormat.set_top_colords3r]c0|j||_y)z Set the Format diag_color property. Args: diag_color: Color string. No default. Returns: Nothing. N)rirA)rUrAs r\set_diag_colorzFormat.set_diag_colorqrlr]c||_y)z Set the Format diag_border property. Args: diag_border: Default is 1, border type 1. Returns: Nothing. N)r@)rUr@s r\set_diag_borderzFormat.set_diag_border~ryr]c||_y)z Set the Format quote prefix property. Args: quote_prefix: Default is True, turns property on. Returns: Nothing. N)rP)rUrPs r\set_quote_prefixzFormat.set_quote_prefixr|r]c||_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)rQ)rUrQs r\ set_checkboxzFormat.set_checkboxs ! r]c||_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)rUrs r\ set_has_fontzFormat.set_has_font ! r]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)r6)rUr6s r\ set_has_fillzFormat.set_has_fillrr]c||_y)z Set the unique font index property. Args: font_index: The unique font index. Returns: Nothing. N)r)rUrs r\set_font_indexzFormat.set_font_indexrr]c||_y)z Set the unique format index property. Args: xf_index: The unique Excel format index. Returns: Nothing. N)r)rUrs r\ set_xf_indexzFormat.set_xf_indexrr]c||_y)z Set the unique conditional format index property. Args: dxf_index: The unique Excel conditional format index. Returns: Nothing. N)r)rUrs r\ set_dxf_indexzFormat.set_dxf_indexrfr]c||_y)z Set the number format_index property. Args: num_format_index: The unique number format index. Returns: Nothing. N)r)rUrs r\set_num_format_indexzFormat.set_num_format_indexs !1r]c||_y)z Set the horizontal text alignment property. Args: text_h_align: Horizontal text alignment. Returns: Nothing. N)r.)rUr.s r\rzFormat.set_text_h_alignr|r]c||_y)z Set the vertical text alignment property. Args: text_h_align: Vertical text alignment. Returns: Nothing. N)r0)rUr0s r\rzFormat.set_text_v_align r|r]c||_y)z Set the reading order property. Args: direction: Default is 0, left to right. Returns: Nothing. N)rL)rU directions r\set_reading_orderzFormat.set_reading_orders 'r]c&|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)rUaligns r\ set_valignzFormat.set_valign's" ur]c||_y)z Set the font family property. Args: font_family: Font family number. Returns: Nothing. N)r$)rUr$s r\set_font_familyzFormat.set_font_family:ryr]c||_y)z Set the font character set property. Args: font_charset: The font character set number. Returns: Nothing. N)r%)rUr%s r\set_font_charsetzFormat.set_font_charsetGr|r]c||_y)z Set the font scheme property. Args: font_scheme: The font scheme. Returns: Nothing. N)r&)rUr&s r\set_font_schemezFormat.set_font_schemeTryr]c||_y)z Set the font condense property. Args: font_condense: The font condense property. Returns: Nothing. N)r')rUr's r\set_font_condensezFormat.set_font_condensearr]c||_y)z Set the font extend property. Args: font_extend: The font extend property. Returns: Nothing. N)r()rUr(s r\set_font_extendzFormat.set_font_extendnryr]c||_y)z Set the theme property. Args: theme: Format theme. Returns: Nothing. N)r))rUr)s r\ set_themezFormat.set_theme{rr]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+rtrr*)rUr*s r\ set_hyperlinkzFormat.set_hyperlinks,  1 r"r]c||_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)rN)rU color_indexs r\set_color_indexedzFormat.set_color_indexeds )r]c||_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)rO)rUrOs r\ set_font_onlyzFormat.set_font_onlyrfr]c||_y)z(Deprecated: Use set_font_name() instead.Nr_r`s r\set_fontzFormat.set_font "r]c||_y)z(Deprecated: Use set_font_size() instead.Nrcrds r\set_sizezFormat.set_sizerr]c0|j||_y)z)Deprecated: Use set_font_color() instead.Nrhrjs r\ set_colorzFormat.set_colors//*5r]c8d}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) horizontalrCr )r r)r rE)r r)r rrr )r r)justifyLastLiner)verticalrG)r r)r r)r r textRotationrI)wrapTextr) shrinkToFitr) readingOrderr)rr ) r.r0rIr2r/rJrLrMappend)rUchangedr continuouss r\_get_align_propertieszFormat._get_align_propertiess     {{}}~~{{!!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, -~r]c~g}|js|jd|jr|jd|S)N)r-r)r,r)r-rr,)rU attributess r\_get_protection_propertiesz!Format._get_protection_properties)s7 {{   m , ;;   m ,r]c R|jdjd|j|j|j |j |j |j|j|j|jf D|_|jS)N:c32K|]}t|ywNstr.0xs r\ z)Format._get_format_key..7s (A () rTjoin _get_font_key_get_border_key _get_fill_key_get_alignment_keyrr-rQrPr,)rUs r\_get_format_keyzFormat._get_format_key4s    #"xx (&&(((*&&(++-OOKKMM%%KK  ( D r]cTdjd|j|j|j|j|j |j |j|j|j|j|j|j|jf D}|S)Nrc32K|]}t|ywrrrs r\r z'Format._get_font_key..Js  F r!)r"rrr%r$r!r#r"r rrrrr)rUrYs r\r#zFormat._get_font_keyHshh  !!  !!    ##    & r]c(djd|j|j|j|j|j |j |j|j|j|j|jf D}|S)Nrc32K|]}t|ywrrrs r\r z)Format._get_border_key..as  F r!) r"r>r?r@rArBrCrDrErFrGrHr*s r\r$zFormat._get_border_key_s{hh  !!         " r]cxdjd|j|j|jfD}|S)Nrc32K|]}t|ywrrrs r\r z'Format._get_fill_key..vsT!s1vTr!)r"r5r4r3r*s r\r%zFormat._get_fill_keyts.hhT dmmT]]'STT r]c djd|j|j|j|j|j |j |jfD}|S)Nrc32K|]}t|ywrrrs r\r z,Format._get_alignment_key..}s   F  r!)r"r.r0rIr2r/rJrLr*s r\r&zFormat._get_alignment_keyzsahh  !!!!   ""    r]c|j |jS|j}||jvr|j|Sdt|jz}||j|<||_|S)Nr)rr'rlenrUrYindexs r\ _get_xf_indexzFormat._get_xf_indexsx == $== ""$ $(( ())#. .C..//&+s#  r]c|j |jS|j}||jvr|j|St|j}||j|<||_|Sr)rr'rr2r3s r\_get_dxf_indexzFormat._get_dxf_indexss >> %>> !""$ $)) )**3/ /D++,',$ r]ciddddddddd d d d d dddddddddddddddddddd d!}|j||S)"Nblackz#000000bluez#0000FFbrownz#800000cyanz#00FFFFgrayz#808080greenz#008000limez#00FF00magentaz#FF00FFnavyz#000080orangez#FF6600pinkpurplez#800080redz#FF0000silverz#C0C0C0whitez#FFFFFFyellowz#FFFF00 automatic Automatic)get)rUr named_colorss r\rizFormat._get_colors Y I  Y  I  I  Y   I  y  I  i  I  i  9  i  Y i! " # (u--r])NNN)r )T)rr)r)L__name__ __module__ __qualname____doc__rrarerkrnrqrtrvrxr{r~rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr'r#r$r%r&r5r7ri __classcell__)r[s@r\rrspY B # # 6   # - ' ) ' %  1%f ! #!2   +  2 2"$  : #  6  8  4 6 ' )!2 ! ! % ! # 1 ) ) '& ' ) ' + ' # ) #"##6^@  (.* $(&.r]rN)warningsrr XMLwriterrr]r\rVs!{.Y {.r]