B \%@s~dZddlmZddlZddlmZddlmZmZm Z m Z m Z m Z m Z mZmZmZmZmZmZmZmZmZmZddlTdZe e e e ee ee e e iZdZedd Zd Zeeeeeeeed Zd d ddddddddg ZddZ dddZ!Gddde"Z#Gdddee#Z$ddZ%d d!Z&Gd"d#d#ee#Z'd$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;dd?d@dAdBdCdDdEdFdGdH$Z(ddefddIe fdJdKefdLdMefdNdOe fdPdQefdRdRe fdSdSe fdTdUefdVdWe fdXdYe fdZd[efg Z)iZ*x6e)D].\Z+Z,Z-x e.e+e,dD]Z/e-e*e/<qWqW[+[,[-[/e0d\Z1iZ2xe1e13D]Z4d]e2e4<qdldmZ?dndoZ@dpdqZAdrdsZBdtduZCdvdwZDGdxdydyee#ZEGdzd{d{ee#ZFGd|d}d}ee#ZGGd~ddee#ZHGdddeZIdS)z$ Module for formatting information. )print_functionN)unpack)FDTFGEFNUFTXFUN XL_CELL_DATEXL_CELL_NUMBER XL_CELL_TEXT XL_FORMAT XL_FORMAT2 BaseObject XLRDErrorfprintf unpack_stringunpack_unicodeupkbitsupkbitsL)*)8)rrr)rr)rrr)rrr)rrr)rrr)rrr)rrr)rr)rrr)rrr)rrr)rrr)rrr)rr)rrr)rr)r3f)rr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)8)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)rrr)PF2-(NormalZ RowLevel_Z ColLevel_ZCommaZCurrencyZPercentz Comma [0]z Currency [0]Z HyperlinkzFollowed HyperlinkcCsi|_i|_|jsdSxtdD]}t||j|<q Wt|j}t|}x"t|D]}|||j|d<qRWd|j|d<d|j|dd<d|jd<d|jd<dS)NrQi) colour_mapcolour_indexes_usedformatting_infoxrangeexcel_default_palette_b8default_palette biff_versionlen)bookiZdpalZndpalr6.lib/python3.7/site-packages/xlrd/formatting.pyinitialise_colour_mapis  r8c Csd}d}xh|D]\\}}|dkr$qd}x*t||D]\}} ||| || 7}q4W||kr|}|}|dkrPqWdr|rtd|||||f|S)z General purpose function. Uses Euclidean distance. So far used only for pre-BIFF8 ``WINDOW2`` record. Doesn't have to be fast. Doesn't have to be fancy. irNz:nearest_colour_index for %r is %r -> %r; best_metric is %d)itemszipprint) r,ZrgbdebugZ best_metricZ best_colourxZcolourxZcand_rgbZmetricZv1Zv2r6r6r7nearest_colour_indexs"r=c@s eZdZdZddZddZdS) EqNeAttrsz This mixin class exists solely so that :class:`Format`, :class:`Font`, and :class:`XF` objects can be compared by value of their attributes. cCs |j|jkS)N)__dict__)selfotherr6r6r7__eq__szEqNeAttrs.__eq__cCs |j|jkS)N)r?)r@rAr6r6r7__ne__szEqNeAttrs.__ne__N)__name__ __module__ __qualname____doc__rBrCr6r6r6r7r>sr>c@sPeZdZdZdZdZdZdZdZdZ dZ dZ e dZ dZdZdZdZdZdZdS)Fontz An Excel "font" contains the details of not only what is normally considered a font, but also several other display attributes. Items correspond to those in the Excel UI's Format -> Cells -> Font tab. .. versionadded:: 0.6.1 riN)rDrErFrGbold character_set colour_index escapementfamily font_indexheightitalicUNICODE_LITERALname struck_outunderline_type underlinedweightoutlineshadowr6r6r6r7rHs  rHcCs$|js dStd|d|jd_dS)Nzt d|dd\|_}|_|_|_|_|_|_|d@|_|d@d?|_|d@d?|_|d @d ?|_|d @d?|_|d @d ?|_|dkr&t|ddd|_ nt|d|jdd|_ nR|dkrt d|dd\|_}|_|d@|_|d@d?|_|d@d?|_|d @d ?|_|d @d?|_|d @d ?|_t|d|jdd|_ ddg|j|_d|_|j|_d|_d|_nt d|dd\|_}d|_|d@|_|d@d?|_|d@d?|_|d @d ?|_d|_d|_t|d|jdd|_ ddg|j|_d|_|j|_d|_d|_|r|j|jd|j dddS)Nz Dummy Fontrr#z Cr"Gr+Zymdhsrcz$-+/(): #?ZGENERALZgeneralz \[[^]]*\]c Csd}d}x|D]}|dkrR|tdkr,d}qx|tdkr>d}qx|tkrHqx||7}n&|dkrl|tdkrxd}n |dkrxd}d|krdksntqW|jdkrtdt||jd td|}|tkrd Sd}d }d}d}}xH|D]@}|t kr|t |7}q|t kr|t |7}q||krd}qW|r:|s:d S|rJ|sJd S|rl|jrt |jd |||n|s|jrt |jd|||kS)NrrI"rz\_*r^r_z+is_date_format_string: reduced format is %s)fileF;Tz7WARNING *** is_date_format: ambiguous d=%d n=%d fmt=%r z/WARNING *** format %r produces constant result ) rRskip_char_dictAssertionErrorrlr;ZREPRrofmt_bracketed_subnon_date_formatsdate_char_dict num_char_dictr) r4fmtstatescZ separatorZgot_sepZ date_countZ num_countr6r6r7is_date_format_strings`              rcCsd}|j}|tkrt|d}|js*|d}|dkrNtd|ddd}n|j}|dkr`d}|jd7_|dkrt|d}nt|||jdd}|p|j d k}|rt |j d |j|||| |} t tg| } |d ks<|dks %r)r)r.rkrlrr2rror3rZpalette_recordrr/r,rmr;)r4r\rpZ n_coloursZexpected_n_coloursrZ expected_sizeZ actual_sizeZ toleranceZcoloursr5rZredZgreenZblueZold_rgbZnew_rgbr6r6r7handle_palette>s@      rcCsxr|jD]h}|jdkrq|j}|dkr(q||jkr>d|j|<q|jrtdt|j|jdt |jd|j|j |qW|jdkrt |j }td||jddS)Nr_irzSize of colour table:)rz2*** Font #%d (%r): colour index 0x%04x is unknown z Colour indexes used: %r ) r[rOrLr,r-rlr;r3rorrSsortedkeys)r4fontZcxZusedr6r6r7palette_epiloguebs     rc Csx|js dStp|jdk}|j}td|dd\}}}|d@}|dkrfd|jkrfd}d}d}d} d }n|d @rd}t|} d|krdkrnn| t|d7} nd}d}d}|d kryt|ddd } WnNt k rt d ||||f|j dt dt |dd|j dYnXnt |d|jdd } |rJ| sJt d|j d||f|j| <|rtt|j d||||| dS)Nr^zd?y|j(|j}t)|j*} Wnt+k rt,} YnX| |j-|j$<|j.r&|jr|j/r|j d@krdA}!t0|j'|!|j$|j t1|||j$|j|j(kr^dB}!|jrXt0|j'|!|j$|j|jd|_dS)CNrarr#r!z .check_samerz:WARNING *** XF[%d]: is_style=%d but parent_style_index=%d r&z/NOTE !!! XF[%d]: parent_style_index is also %d z>NOTE !!! XF[%d]: parent_style_index is %d; style flag not set z9NOTE !!! XF[%d]: parent_style_index is %d; out of order? rrrrz4NOTE !!! XF[%d] fmtk=%d, parent[%d] fmtk=%r %r / %r z.NOTE !!! XF[%d] fontx=%d, parent[%d] fontx=%r )_xf_epilogue_doner3rrkrlrror/rrvrrwrr rrr.rrr2_alignment_flag_background_flag _border_flag_protection_flag _format_flagrx _font_flagrO) r@Znum_xfsrpZblah1r Zxfxrrrparentr6r6r7 xf_epilogues            rc CsFt|d|_tttttttt t f }x|D]}t |j |j |q*WdS)Nr)r8r rtr]rrrrrrrrrrD)r4methodsmethodr6r6r7initialise_book>s rc@s@eZdZdZdZdZdZdZdZdZ dZ dZ dZ dZ dZdZdS)rao A collection of the border-related attributes of an ``XF`` record. Items correspond to those in the Excel UI's Format -> Cells -> Border tab. An explanations of "colour index" is given in :ref:`palette`. There are five line style attributes; possible values and the associated meanings are:: 0 = No line, 1 = Thin, 2 = Medium, 3 = Dashed, 4 = Dotted, 5 = Thick, 6 = Double, 7 = Hair, 8 = Medium dashed, 9 = Thin dash-dotted, 10 = Medium dash-dotted, 11 = Thin dash-dot-dotted, 12 = Medium dash-dot-dotted, 13 = Slanted medium dash-dotted. The line styles 8 to 13 appear in BIFF8 files (Excel 97 and later) only. For pictures of the line styles, refer to OOo docs s3.10 (p22) "Line Styles for Cell Borders (BIFF3-BIFF8)".

.. versionadded:: 0.6.1 rN)rDrErFrGrrrrrrrrrrrrr6r6r6r7rOsrc@seZdZdZdZdZdZdS)ra A collection of the background-related attributes of an ``XF`` record. Items correspond to those in the Excel UI's Format -> Cells -> Patterns tab. An explanations of "colour index" is given in :ref:`palette`. .. versionadded:: 0.6.1 rN)rDrErFrGrrrr6r6r6r7rsrc@s,eZdZdZdZdZdZdZdZdZ dZ dS)rz A collection of the alignment and similar attributes of an ``XF`` record. Items correspond to those in the Excel UI's Format -> Cells -> Alignment tab. .. versionadded:: 0.6.1 rN) rDrErFrGrrrrrrrr6r6r6r7rsrc@seZdZdZdZdZdS)rad A collection of the protection-related attributes of an ``XF`` record. Items correspond to those in the Excel UI's Format -> Cells -> Protection tab. Note the OOo docs include the "cell or style" bit in this bundle of attributes. This is incorrect; the bit is used in determining which bundles to use. .. versionadded:: 0.6.1 rN)rDrErFrGrrr6r6r6r7rs rc@sLeZdZdZdZdZdZdZdZdZ dZ dZ dZ dZ dZdZdZdZdZdS)ra eXtended Formatting information for cells, rows, columns and styles. Each of the 6 flags below describes the validity of a specific group of attributes. In cell XFs: - ``flag==0`` means the attributes of the parent style ``XF`` are used, (but only if the attributes are valid there); - ``flag==1`` means the attributes of this ``XF`` are used. In style XFs: - ``flag==0`` means the attribute setting is valid; - ``flag==1`` means the attribute should be ignored. .. note:: the API provides both "raw" XFs and "computed" XFs. In the latter case, cell XFs have had the above inheritance mechanism applied. .. versionadded:: 0.6.1 rN)rDrErFrGrrrrr r r rrrOrvrrrrr6r6r6r7rs  r)r)JrGZ __future__rreZstructrZbiffhrrrrr r r r r rrrrrrrrZ timemachinerkrZexcel_default_palette_b5Zexcel_default_palette_b2r0r1rr8r=objectr>rHr]rtrurZfmt_code_rangesrlohiryr/rrRZ date_charsrupperZ_crrrcompilesubrrrrrrrrrrrrrrrrr6r6r6r7 s  L   XI!    ? 4$+  >IC"