o ]i~@sJddlmZmZddlmZddlmZddlmZGdddej Z dS) )LiteralUnion)warn)Color) xmlwritercsFeZdZdZddՇfdd ZdefddZddd Zdd eddfd d Z de ee fddfddZ dde ddfddZdde ddfddZddedddfddZdde ddfddZdd ed!ddfd"d#Zdd$e ddfd%d&Zdd'e ddfd(d)Zd*eddfd+d,Zdd-e ddfd.d/Zdd0e ddfd1d2Zd3ed4ddfd5d6Zddd8d9Zdd:e ddfd;d<Zd=eddfd>d?Zdd@eddfdAdBZddCe ddfdDdEZddFe ddfdGdHZddIeddfdJdKZ dLe ee fddfdMdNZ!dOe ee fddfdPdQZ"ddReddfdSdTZ#dUe ee fddfdVdWZ$ddXeddfdYdZZ%d[e ee fddfd\d]Z&dd^ed_ddfd`daZ'ddbeddfdcddZ(dee ee fddfdfdgZ)ddheddfdidjZ*dke ee fddfdldmZ+ddneddfdodpZ,dqe ee fddfdrdsZ-dte ee fddfdudvZ.ddweddfdxdyZ/ddze ddfd{d|Z0dd}e ddfd~dZ1dde ddfddZ2dde ddfddZ3deddfddZ4deddfddZ5deddfddZ6deddfddZ7deddfddZ8deddfddZ9ddeddfddZ:ded4ddfddZ;deddfddZdeddfddZ?deddfddZ@deddfddZAdde ddfddZBdedddfddZCdde ddfddZDdeddfddZEd eddfddZFde e efddfddZGddÄZHddńZIddDŽZJddɄZKdd˄ZLdd̈́ZMddτZNddфZOddӄZPZQS)Formatz; A class for writing the Excel XLSX Format file. Nreturncs|duri}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|CD] \}}tD|d ||qd|_EdS) 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__V/var/www/html/stock_analysis/be/venv/lib/python3.10/site-packages/xlsxwriter/format.pyr s  zFormat.__init__cCsvd|jd|jd|jd|jd|jd|jd|jd|jd |jd |j d |j d |j d |j d|j dS)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=))rrrrrr rr/r1r4r5r6r.r-rVr^r^r___repr__{s<     zFormat.__repr__cC ||_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. NrrVrr^r^r_ set_font_name zFormat.set_font_namer rcCrc)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. NrrVrr^r^r_ set_font_size zFormat.set_font_sizer cCt||_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. Nr _from_valuer rVr r^r^r_set_font_color zFormat.set_font_colorTrcCrc)z Set the Format bold property. Args: bold: Default is True, turns property on. Returns: Nothing. N)r)rVrr^r^r_set_boldrkzFormat.set_boldrcCrc)z Set the Format italic property. Args: italic: Default is True, turns property on. Returns: Nothing. N)r)rVrr^r^r_ set_italicrkzFormat.set_italicrr)rr !"cCrc)z Set the Format underline property. Args: underline: Default is 1, single underline. Returns: Nothing. N)r)rVrr^r^r_ set_underlinerkzFormat.set_underliner!cCrc)z Set the Format font_strikeout property. Args: font_strikeout: Default is True, turns property on. Returns: Nothing. N)r!)rVr!r^r^r_set_font_strikeoutrkzFormat.set_font_strikeoutr$)rr cCrc)z Set the Format font_script property. Args: font_script: Default is 1, superscript. Returns: Nothing. N)r$)rVr$r^r^r_set_font_scriptrkzFormat.set_font_scriptr"cCrc)z Set the Format font_outline property. Args: font_outline: Default is True, turns property on. Returns: Nothing. N)r")rVr"r^r^r_set_font_outlinerkzFormat.set_font_outliner#cCrc)z Set the Format font_shadow property. Args: font_shadow: Default is True, turns property on. Returns: Nothing. N)r#)rVr#r^r^r_set_font_shadow rkzFormat.set_font_shadowrcCrc)z Set the Format num_format property such as '#,##0'. Args: num_format: String representing the number format. No default. Returns: Nothing. N)r)rVrr^r^r_set_num_formatrkzFormat.set_num_formatr.cCrc)z Set the Format locked property. Args: locked: Default is True, turns property on. Returns: Nothing. N)r.)rVr.r^r^r_ set_locked'rkzFormat.set_lockedr-cCrc)z Set the Format hidden property. Args: hidden: Default is True, turns property on. Returns: Nothing. N)r-)rVr-r^r^r_ set_hidden4rkzFormat.set_hidden alignment)rDcentrecenterrFfilljustify center_across centre_across distributedjustify_distributedrrHvcentrevcenterr?vjustify vdistributedcCs>|}|dkr |d|dkr|d|dkr|d|dkr(|d|dkr1|d |d kr:|d |d krC|d |dkrL|d |dkrU|d|dkr^|d|dkred|_|dkrn|d|dkrw|d|dkr|d|dkr|d|dkr|d |dkr|d dSdS)z Set the Format cell alignment. Args: alignment: String representing alignment. No default. Returns: Nothing. rDrrr rrFrrrrrrrHrrr?rrN)lowerset_text_h_alignrNset_text_v_align)rVr~r^r^r_ set_alignAsH               zFormat.set_align align_typecCs|ddS)z` Set the Format center_across property. Returns: Nothing. rN)r)rVrr^r^r_set_center_acrosss zFormat.set_center_acrossr0cCrc)z Set the Format text_wrap property. Args: text_wrap: Default is True, turns property on. Returns: Nothing. N)r0)rVr0r^r^r_ set_text_wraprkzFormat.set_text_wrapr3cCsXt|}|dkr d}nd|krdkr!nn |dkr | d}ntddS||_dS)z Set the Format rotation property. Args: rotation: Rotation angle. No default. Returns: Nothing. iiZrz3Rotation rotation outside range: -90 <= angle <= 90N)intrr3)rVr3r^r^r_ set_rotations   zFormat.set_rotationrJcCrc)z Set the Format indent property. Args: indent: Default is 1, first indentation level. Returns: Nothing. N)rJ)rVrJr^r^r_ set_indentrkzFormat.set_indentrKcCrc)z Set the Format shrink property. Args: shrink: Default is True, turns property on. Returns: Nothing. N)rK)rVrKr^r^r_ set_shrinkrkzFormat.set_shrinkr2cCrc)z Set the Format text_justlast property. Args: text_justlast: Default is True, turns property on. Returns: Nothing. N)r2)rVr2r^r^r_set_text_justlastrkzFormat.set_text_justlastr6cCrc)z Set the Format pattern property. Args: pattern: Default is 1, solid fill. Returns: Nothing. N)r6)rVr6r^r^r_ set_patternrkzFormat.set_patternr5cCrl)z Set the Format bg_color property. Args: bg_color: Background color. No default. Returns: Nothing. N)rrnr5)rVr5r^r^r_ set_bg_colorrqzFormat.set_bg_colorr4cCrl)z Set the Format fg_color property. Args: fg_color: Foreground color. No default. Returns: Nothing. N)rrnr4)rVr4r^r^r_ set_fg_colorrqzFormat.set_fg_colorstylecC,||||||||dSz Set the Format bottom property. Args: bottom: Default is 1, border type 1. Returns: Nothing. N) set_bottomset_topset_left set_right)rVrr^r^r_ set_border   zFormat.set_bordercolorcCr)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)rVrr^r^r_set_border_colorrzFormat.set_border_colorr?cCrcr)r?)rVr?r^r^r_r*rkzFormat.set_bottomr@cCrl)z Set the Format bottom_color property. Args: bottom_color: Color string. No default. Returns: Nothing. N)rrnr@)rVr@r^r^r_r7rqzFormat.set_bottom_colorrC)rr rcCrc)z Set the Format diag_type property. Args: diag_type: Default is 1, border type 1. Returns: Nothing. N)rC)rVrCr^r^r_ set_diag_typeDrkzFormat.set_diag_typerDcCrc)z Set the Format left property. Args: left: Default is 1, border type 1. Returns: Nothing. N)rD)rVrDr^r^r_rQrkzFormat.set_leftrEcCrl)z Set the Format left_color property. Args: left_color: Color string. No default. Returns: Nothing. N)rrnrE)rVrEr^r^r_r^rqzFormat.set_left_colorrFcCrc)z Set the Format right property. Args: right: Default is 1, border type 1. Returns: Nothing. N)rF)rVrFr^r^r_rkrkzFormat.set_rightrGcCrl)z Set the Format right_color property. Args: right_color: Color string. No default. Returns: Nothing. N)rrnrG)rVrGr^r^r_rxrqzFormat.set_right_colorrHcCrc)z Set the Format top property. Args: top: Default is 1, border type 1. Returns: Nothing. N)rH)rVrHr^r^r_rrkzFormat.set_toprIcCrl)z Set the Format top_color property. Args: top_color: Color string. No default. Returns: Nothing. N)rrnrI)rVrIr^r^r_rrqzFormat.set_top_colorrBcCrl)z Set the Format diag_color property. Args: diag_color: Color string. No default. Returns: Nothing. N)rrnrB)rVrBr^r^r_set_diag_colorrqzFormat.set_diag_colorrAcCrc)z Set the Format diag_border property. Args: diag_border: Default is 1, border type 1. Returns: Nothing. N)rA)rVrAr^r^r_set_diag_borderrkzFormat.set_diag_borderrQcCrc)z Set the Format quote prefix property. Args: quote_prefix: Default is True, turns property on. Returns: Nothing. N)rQ)rVrQr^r^r_set_quote_prefixrkzFormat.set_quote_prefixrRcCrc)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)rR)rVrRr^r^r_ set_checkboxs zFormat.set_checkboxrcCrc)z Set the property to indicate the format has a font. Args: has_font: Default is True, turns property on. Returns: Nothing. N)r)rVrr^r^r_ set_has_fontrkzFormat.set_has_fontr7cCrc)z Set the property to indicate the format has a fill. Args: has_fill: Default is True, turns property on. Returns: Nothing. N)r7)rVr7r^r^r_ set_has_fillrkzFormat.set_has_fillrcCrc)z Set the unique font index property. Args: font_index: The unique font index. Returns: Nothing. N)r)rVrr^r^r_set_font_indexrkzFormat.set_font_indexrcCrc)z Set the unique format index property. Args: xf_index: The unique Excel format index. Returns: Nothing. N)r)rVrr^r^r_ set_xf_indexrkzFormat.set_xf_indexrcCrc)z Set the unique conditional format index property. Args: dxf_index: The unique Excel conditional format index. Returns: Nothing. N)r)rVrr^r^r_ set_dxf_indexrkzFormat.set_dxf_indexrcCrc)z Set the number format_index property. Args: num_format_index: The unique number format index. Returns: Nothing. N)r)rVrr^r^r_set_num_format_index rkzFormat.set_num_format_indexr/cCrc)z Set the horizontal text alignment property. Args: text_h_align: Horizontal text alignment. Returns: Nothing. N)r/)rVr/r^r^r_r-rkzFormat.set_text_h_alignr1cCrc)z Set the vertical text alignment property. Args: text_h_align: Vertical text alignment. Returns: Nothing. N)r1)rVr1r^r^r_r:rkzFormat.set_text_v_alignr directioncCrc)z Set the reading order property. Args: direction: Default is 0, left to right. Returns: Nothing. N)rM)rVrr^r^r_set_reading_orderGrgzFormat.set_reading_orderaligncCs||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)r)rVrr^r^r_ set_valignUs&zFormat.set_valignr%cCrc)z Set the font family property. Args: font_family: Font family number. Returns: Nothing. N)r%)rVr%r^r^r_set_font_family}rkzFormat.set_font_familyr&cCrc)z Set the font character set property. Args: font_charset: The font character set number. Returns: Nothing. N)r&)rVr&r^r^r_set_font_charsetrkzFormat.set_font_charsetr'cCrc)z Set the font scheme property. Args: font_scheme: The font scheme. Returns: Nothing. N)r')rVr'r^r^r_set_font_schemerkzFormat.set_font_schemer(cCrc)z Set the font condense property. Args: font_condense: The font condense property. Returns: Nothing. N)r()rVr(r^r^r_set_font_condenserkzFormat.set_font_condenser)cCrc)z Set the font extend property. Args: font_extend: The font extend property. Returns: Nothing. N)r))rVr)r^r^r_set_font_extendrkzFormat.set_font_extendr*cCrc)z Set the theme property. Args: theme: Format theme. Returns: Nothing. N)r*)rVr*r^r^r_ set_themerkzFormat.set_themer+cCs$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,rvrr+)rVr+r^r^r_ set_hyperlinks   zFormat.set_hyperlink color_index)rrcCrc)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)rO)rVrr^r^r_set_color_indexedrgzFormat.set_color_indexedrPcCrc)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)rP)rVrPr^r^r_ set_font_onlyrkzFormat.set_font_onlyrcCrc)z(Deprecated: Use set_font_name() instead.Nrdrer^r^r_set_font zFormat.set_fontcCrc)z(Deprecated: Use set_font_size() instead.Nrhrir^r^r_set_sizerzFormat.set_sizecCrl)z)Deprecated: Use set_font_color() instead.Nrmror^r^r_ set_colorszFormat.set_colorcCsZd}g}|js|js|js|js|js|js|jrd}n||fS|jrD|jdkrD|jdkrD|jdkrD|jdkrD|jdkrD|jdkrDd|_|jrJd|_|jdkrRd|_|jdkrZd|_|jdkrbd|_|jdkrjd|_|jrpd|_d}|jdkr||d|jd kr|d |jdkr|d |jdkr|d |jdkr|d |jdkr|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|jdkr|d|jd kr)|d||fS)NrrrrrrcenterContinuous) horizontalrDr )rr)rrF)rr)rrrr)rr)justifyLastLiner)verticalrH)rr)rr)rr textRotationrJ)wrapTextr) shrinkToFitr) readingOrderr)rr ) r/r1rJr3r0rKrMrNappend)rVchangedr continuousr^r^r__get_align_properties s                                  zFormat._get_align_propertiescCs(g}|js |d|jr|d|S)N)r.r)r-r)r.rr-)rV attributesr^r^r__get_protection_propertiesls   z!Format._get_protection_propertiesc CsR|jdur&ddd|||||j|j|j|j |j f D|_|jS)N:cs|]}t|VqdSNstr.0xr^r^r_ z  z)Format._get_format_key..) rUjoin _get_font_key_get_border_key _get_fill_key_get_alignment_keyrr.rRrQr-rar^r^r__get_format_keyws   zFormat._get_format_keycCsLddd|j|j|j|j|j|j|j|j|j |j |j |j |j f D}|S)Nrcsrrrrr^r^r_rrz'Format._get_font_key..)rrr r&r%r"r$r#r!rrrrr*rVrZr^r^r_rs" zFormat._get_font_keycCsDddd|j|j|j|j|j|j|j|j|j |j |j f D}|S)Nrcsrrrrr^r^r_rrz)Format._get_border_key..) rr?r@rArBrCrDrErFrGrHrIrr^r^r_rs zFormat._get_border_keycCs$ddd|j|j|jfD}|S)Nrcsrrrrr^r^r_rsz'Format._get_fill_key..)rr6r5r4rr^r^r_rs zFormat._get_fill_keyc Cs4ddd|j|j|j|j|j|j|jfD}|S)Nrcsrrrrr^r^r_rrz,Format._get_alignment_key..)rr/r1rJr3r0rKrMrr^r^r_rs  zFormat._get_alignment_keycCsN|jdur|jS|}||jvr|j|Sdt|j}||j|<||_|S)Nr)rrrlenrVrZindexr^r^r_ _get_xf_indexs    zFormat._get_xf_indexcCsJ|jdur|jS|}||jvr|j|St|j}||j|<||_|Sr)rrrrrr^r^r__get_dxf_indexs     zFormat._get_dxf_index)NNN)r N)r )T)rr)rNr N)r)R__name__ __module__ __qualname____doc__rrrbrfrrjrrrpboolrrrsrrvrwrxryrzr{r|r}rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr __classcell__r^r^r\r_rs [              H                            (       ` rN) typingrrwarningsrxlsxwriter.colorrr XMLwriterrr^r^r^r_s