o
    ä›eA  ã                   @   s‚  d dl mZ d dlZd dlmZ ddlT d ZG dd„ deƒZG dd	„ d	e	ƒZ
ed
ƒ\ZZZZZeZeZedƒ\ZZZZZZZdddddddddddœ
ZddddddddœZdZd
 ZZd Zd! Z Z!d Z"d"Z#d#Z$d$Z%d%Z&d&Z'dZ(d'Z)d(Z*d
Z+d)Z,d*Z-d+Z.d,Z/d-Z0d.Z1d/Z2d0Z3d1Z4d2Z5d3Z6d4Z7d5Z8d6Z9d Z:d7Z;d8Z<d9Z=d:Z>d;Z?d<Z@d=ZAd>ZBd?ZCd@ZDdAZEd#ZFdBZGdCZHdDZIdEZJdFZKdGZLdHZMd"ZNdIZOdJZPdKZQdLZRdMZSdNZTdOZUdPZVdQZWdRZXdSZYdTZZdUZ[dVZ\dWZ]dXZ^dYZ_dZZ`d[Zad\Zbd]Zcd^Zdd_Zed`ZfdaZgdbZhdcZiddZjdeZkdfZldgZmdhZndiZodjZpdkZqdlZrdmZsdnZtdoZudpZvdqZwdZxdrZydsZzdtZ{duZ|dvZ}dwZ~dxZdyZ€dzZd{Z‚d|Zƒd}Z„erZ…d~Z†dZ‡d€ZˆdZ‰dhd#d#dKd‚œZŠd‚Z‹dƒZŒe*eFeGeHePeSe`edeleog
Zi ZŽeD ]ZdeŽe< qLd„d…„ Ze‘fd†d‡„Z’e‘e“fdˆd‰„Z”d¥dŠd‹„Z•d¦dŒd„Z–d§dŽd„Z—d¨dd‘„Z˜d©d’d“„Z™d”Zši Z›eš œ¡ D ]Ze ž¡ \ZŸZ e e›e“eŸd!ƒ< q†[[ [šd ej¡d•fd–d—„Z¢d ej¡d•fd˜d™„Z£ej¡fdšd›„Z¤dœddždŸd d¡d¢dd£d¤œ	Z¥dS )ªé    )Úprint_functionN)Úunpacké   )Ú*c                   @   s   e Zd ZdZdS )Ú	XLRDErrorzK
    An exception indicating problems reading data from an Excel file.
    N)Ú__name__Ú
__module__Ú__qualname__Ú__doc__© r   r   ú=/var/www/html/venv/lib/python3.10/site-packages/xlrd/biffh.pyr      s    r   c                   @   s   e Zd ZdZg Zddd„ZdS )Ú
BaseObjectzt
    Parent of almost all other classes in the package. Defines a common
    :meth:`dump` method for debugging.
    Nr   c                 C   s.  |du rt j}t| dƒrg }| jD ]}| |t| |ƒf¡ qn| j ¡ }t|ƒ}d| }|dur6t	||d t
g ƒ}t
i ƒ}	|D ]H\}}
t|
ddƒr`|dkr`|
j|d|||
jjf |d d	 q@|| jvr€t|
|ƒsot|
|	ƒr€t	d
||t
|
ƒt|
ƒf |d q@t|d|||
ƒ q@|dur•t	||d dS dS )zù
        :param f: open file object, to which the dump is written
        :param header: text to write before the dump
        :param footer: text to write after the dump
        :param indent: number of leading spaces (for recursive calls)
        NÚ	__slots__ú ©ÚfileÚdumpÚbookz%s%s (%s object):é   )ÚheaderÚindentz%s%s: %s, len = %dz	%s%s: %r
)ÚsysÚstderrÚhasattrr   ÚappendÚgetattrÚ__dict__ÚitemsÚsortedÚprintÚtyper   Ú	__class__r   Ú_repr_theseÚ
isinstanceÚlenÚfprintf)ÚselfÚfr   Úfooterr   ÚalistÚattrÚpadÚ	list_typeÚ	dict_typeÚvaluer   r   r   r      s6   

ÿ
þ
ÿÿ"zBaseObject.dump)NNNr   )r   r   r	   r
   r"   r   r   r   r   r   r      s    r   é   é   z
(not BIFF)z2.0z2.1Ú3Ú4SÚ4WÚ5Ú7Ú8Ú8X)
r   é   é   é   é(   é-   é2   éF   éP   éU   z#NULL!z#DIV/0!z#VALUE!z#REF!z#NAME?z#NUM!z#N/A)r   r0   é   é   é   é$   é*   r?   é   é   é   é   i!  é!   i  é	  i  é…   éV   i±  éB   é}   é    rD   i°  é<   éŒ   é"   i%  r@   i   éE   é
   é#   rB   éÿ   ir  é/   é1   i1  i  r:   é  é  é«   i¸  i   é   i  éD   i  r   i_  éý   é&   r;   é'   é)   r8   r9   éƒ   é„   éå   éì   éë   éí   é½   é¾   é   é   i  é   é]   é¡   é’   éA   é+   rE   i~  i  é   éÖ   é    é   é   éŽ   i¼  éü   é™   i  i“  i®  i6  é7   é6   i¶  é^   iÿÿ  é   i>  é>   é\   éà   éC   iC  iC  )rK   i	  i	  é	   )rI   r[   rZ   c                 C   s   | t v S ©N)Ú_cell_opcode_dict)Úcr   r   r   Úis_cell_opcodeì   s   r‡   c                 C   s(   |D ]\}}}|| |||@ |? ƒ qd S r„   r   )Útgt_objÚsrcÚmanifestÚlocal_setattrÚnÚmaskr*   r   r   r   Úupkbitsï   s   ÿrŽ   c                 C   s,   |D ]\}}}|| ||||@ |? ƒƒ qd S r„   r   )rˆ   r‰   rŠ   r‹   Ú	local_intrŒ   r   r*   r   r   r   ÚupkbitsLó   s   ÿr   c                 C   sD   t dd|d   | ||| … ƒd }||7 }t| ||| … |ƒS ©Nú<ÚBHr   r   ©r   Úunicode)ÚdataÚposÚencodingÚlenlenÚncharsr   r   r   Úunpack_string÷   s   &r›   c                 C   sZ   |d ur|}nt dd|d   | ||| … ƒd }||7 }|| }t| ||… |ƒ|fS r‘   r”   )r–   r—   r˜   r™   Ú	known_lenrš   Únewposr   r   r   Úunpack_string_update_posü   s   &rž   c                 C   s²   t dd|d   | ||| … ƒd }|stdƒS ||7 }t| | ƒ}|d7 }|d@ r/|d7 }|d@ r7|d7 }|d@ rL| ||d|  … }t|d	ƒ}|S t| ||| … d
ƒ}|S )zReturn unicode_strgr’   r“   r   r   Ú rs   rH   r   Ú	utf_16_leÚlatin_1©r   ÚUNICODE_LITERALÚ	BYTES_ORDr•   )r–   r—   r™   rš   ÚoptionsÚrawstrgÚstrgr   r   r   Úunpack_unicode  s    &
ùr¨   c                 C   s:  |dur|}nt dd|d   | ||| … ƒd }||7 }|s,| |d… s,tdƒ|fS t| | ƒ}|d7 }|d@ }|d@ }|rQt d	| ||d
 … ƒd }|d
7 }|rdt d| ||d … ƒd }	|d7 }|d@ r|t| ||d
|  … dƒ}
|d
| 7 }nt| ||| … dƒ}
||7 }|r“|d| 7 }|r™||	7 }|
|fS )z+Return (unicode_strg, updated value of pos)Nr’   r“   r   r   rŸ   r   rs   ú<HrH   z<ir    r¡   r¢   )r–   r—   r™   rœ   rš   r¥   ÚphoneticÚrichtextÚrtÚszr§   r   r   r   Úunpack_unicode_update_pos-  s4   &r®   c                 C   s”   |dv sJ ‚t d|||d … ƒ\}|d7 }|rH|dkrd}nd}t|ƒD ]"}t ||||| … ƒ\}}	}
}|  ||	d |
|d f¡ ||7 }q%|S )N)rI   rs   r©   rH   rI   z<HHBBz<HHHHr   )r   Úxranger   )Úoutput_listr–   r—   Úbiff_versionÚ	addr_sizerŒ   ÚfmtÚ_unusedÚraÚrbÚcaÚcbr   r   r   Ú)unpack_cell_range_address_list_update_posP  s   
r¹   a	  0000 DIMENSIONS_B2
0001 BLANK_B2
0002 INTEGER_B2_ONLY
0003 NUMBER_B2
0004 LABEL_B2
0005 BOOLERR_B2
0006 FORMULA
0007 STRING_B2
0008 ROW_B2
0009 BOF_B2
000A EOF
000B INDEX_B2_ONLY
000C CALCCOUNT
000D CALCMODE
000E PRECISION
000F REFMODE
0010 DELTA
0011 ITERATION
0012 PROTECT
0013 PASSWORD
0014 HEADER
0015 FOOTER
0016 EXTERNCOUNT
0017 EXTERNSHEET
0018 NAME_B2,5+
0019 WINDOWPROTECT
001A VERTICALPAGEBREAKS
001B HORIZONTALPAGEBREAKS
001C NOTE
001D SELECTION
001E FORMAT_B2-3
001F BUILTINFMTCOUNT_B2
0020 COLUMNDEFAULT_B2_ONLY
0021 ARRAY_B2_ONLY
0022 DATEMODE
0023 EXTERNNAME
0024 COLWIDTH_B2_ONLY
0025 DEFAULTROWHEIGHT_B2_ONLY
0026 LEFTMARGIN
0027 RIGHTMARGIN
0028 TOPMARGIN
0029 BOTTOMMARGIN
002A PRINTHEADERS
002B PRINTGRIDLINES
002F FILEPASS
0031 FONT
0032 FONT2_B2_ONLY
0036 TABLEOP_B2
0037 TABLEOP2_B2
003C CONTINUE
003D WINDOW1
003E WINDOW2_B2
0040 BACKUP
0041 PANE
0042 CODEPAGE
0043 XF_B2
0044 IXFE_B2_ONLY
0045 EFONT_B2_ONLY
004D PLS
0051 DCONREF
0055 DEFCOLWIDTH
0056 BUILTINFMTCOUNT_B3-4
0059 XCT
005A CRN
005B FILESHARING
005C WRITEACCESS
005D OBJECT
005E UNCALCED
005F SAVERECALC
0063 OBJECTPROTECT
007D COLINFO
007E RK2_mythical_?
0080 GUTS
0081 WSBOOL
0082 GRIDSET
0083 HCENTER
0084 VCENTER
0085 BOUNDSHEET
0086 WRITEPROT
008C COUNTRY
008D HIDEOBJ
008E SHEETSOFFSET
008F SHEETHDR
0090 SORT
0092 PALETTE
0099 STANDARDWIDTH
009B FILTERMODE
009C FNGROUPCOUNT
009D AUTOFILTERINFO
009E AUTOFILTER
00A0 SCL
00A1 SETUP
00AB GCW
00BD MULRK
00BE MULBLANK
00C1 MMS
00D6 RSTRING
00D7 DBCELL
00DA BOOKBOOL
00DD SCENPROTECT
00E0 XF
00E1 INTERFACEHDR
00E2 INTERFACEEND
00E5 MERGEDCELLS
00E9 BITMAP
00EB MSO_DRAWING_GROUP
00EC MSO_DRAWING
00ED MSO_DRAWING_SELECTION
00EF PHONETIC
00FC SST
00FD LABELSST
00FF EXTSST
013D TABID
015F LABELRANGES
0160 USESELFS
0161 DSF
01AE SUPBOOK
01AF PROTECTIONREV4
01B0 CONDFMT
01B1 CF
01B2 DVAL
01B6 TXO
01B7 REFRESHALL
01B8 HLINK
01BC PASSWORDREV4
01BE DV
01C0 XL9FILE
01C1 RECALCID
0200 DIMENSIONS
0201 BLANK
0203 NUMBER
0204 LABEL
0205 BOOLERR
0206 FORMULA_B3
0207 STRING
0208 ROW
0209 BOF
020B INDEX_B3+
0218 NAME
0221 ARRAY
0223 EXTERNNAME_B3-4
0225 DEFAULTROWHEIGHT
0231 FONT_B3B4
0236 TABLEOP
023E WINDOW2
0243 XF_B3
027E RK
0293 STYLE
0406 FORMULA_B4
0409 BOF
041E FORMAT
0443 XF_B4
04BC SHRFMLA
0800 QUICKTIP
0809 BOF
0862 SHEETLAYOUT
0867 SHEETPROTECTION
0868 RANGEPROTECTION
Fc              
   C   s  t || t| ƒƒ}|}| }d}	||k r‡t |d |ƒ}
| ||
… }|
| }|dks/|t|ƒkr>ttjd||||||
|ƒ	 d S d dd„ |D ƒ¡}d}|D ] }tt|ƒƒ}|dkr[d}nd	|  kredkshn d
}||7 }qL|rwd|| |  }	t|d|	||ƒ |
}||k sd S d S )NrŸ   rG   r   zS??? hex_char_dump: ofs=%d dlen=%d base=%d -> endpos=%d pos=%d endsub=%d substrg=%r
c                 s   s    | ]	}d t |ƒ V  qdS )z%02x N)r¤   )Ú.0r†   r   r   r   Ú	<genexpr>  s   € z hex_char_dump.<locals>.<genexpr>ú ú~r   ú?ú%5d: z%s     %-48s %s
)Úminr$   r%   r   ÚstdoutÚjoinÚchrr¤   )r§   ÚofsÚdlenÚbaseÚfoutÚ
unnumberedÚendposr—   ÚnumberedÚ
num_prefixÚendsubÚsubstrgÚlensubÚhexdÚchardr†   r   r   r   Úhex_char_dump	  s:   ý
èrÑ   c                 C   sª  |}|| }|| }d}	| }
d}|| dkr•t d| ||d … ƒ\}}|dkrQ|dkrQ| |d … d||  krA|| }	|}|}nT|	rH|	d7 }	n|}d}	|d7 }n>|	rd|
r[d||  }t|d||	ƒ d}	t |d¡}|
rrd||  }t|d	|||||ƒ |d7 }t| |||| ||ƒ ||7 }|| dks|	r¦|
rŸd||  }t|d||	ƒ ||k rÇ|
r²d||  }t|d
|ƒ t| ||| || ||ƒ d S ||krÓt|d|ƒ d S d S )Nr   rŸ   r   ú<HHó    r¿   z"%s---- %d zero bytes skipped ----
z	<UNKNOWN>z%s%04x %s len = %04x (%d)
z%s---- Misc bytes at end ----
z5Last dumped record has length (%d) that is too large
)r   r%   Úbiff_rec_name_dictÚgetrÑ   )ÚmemÚstream_offsetÚ
stream_lenrÆ   rÇ   rÈ   r—   Ú
stream_endÚadjÚdummiesrÊ   rË   ÚrcÚlengthÚsavposÚrecnamer   r   r   Ú	biff_dump(  sX   

æÿrà   c                 C   sî   |}|| }i }|| dkr^t d| ||d … ƒ\}}|dkr3|dkr3| |d … d||  kr0n.d}	nt |d ¡}	|	d u rAd| }	|	|v rN||	  d7  < nd||	< ||d 7 }|| dkst| ¡ ƒ}
|
D ]\}	}td||	f |d	 qfd S )
Nr   rÒ   r   rÓ   z<Dummy (zero)>zUnknown_0x%04Xr   z%8d %sr   )r   rÔ   rÕ   r   r   r   )rÖ   r×   rØ   rÇ   r—   rÙ   ÚtallyrÜ   rÝ   rß   ÚslistÚcountr   r   r   Úbiff_count_recordsV  s*   òÿrä   r    Ú	mac_romanÚ	mac_greekÚmac_cyrillicÚ
mac_latin2Úmac_icelandÚmac_turkishÚcp1252)	i°  i'  i'  i'  i-'  i_'  ia'  i €  i€  )r   )r   N)rH   )rH   N)rI   )¦Ú
__future__r   r   Ústructr   ÚtimemachineÚDEBUGÚ	Exceptionr   Úobjectr   ÚrangeÚFUNÚFDTÚFNUÚFGEÚFTXÚ
DATEFORMATÚNUMBERFORMATÚXL_CELL_EMPTYÚXL_CELL_TEXTÚXL_CELL_NUMBERÚXL_CELL_DATEÚXL_CELL_BOOLEANÚXL_CELL_ERRORÚXL_CELL_BLANKÚbiff_text_from_numÚerror_text_from_codeÚBIFF_FIRST_UNICODEÚXL_WORKBOOK_GLOBALSÚ	WBKBLOBALÚXL_WORKBOOK_GLOBALS_4WÚXL_WORKSHEETÚWRKSHEETÚXL_BOUNDSHEET_WORKSHEETÚXL_BOUNDSHEET_CHARTÚXL_BOUNDSHEET_VB_MODULEÚXL_ARRAYÚ	XL_ARRAY2ÚXL_BLANKÚXL_BLANK_B2ÚXL_BOFÚ
XL_BOOLERRÚXL_BOOLERR_B2ÚXL_BOUNDSHEETÚXL_BUILTINFMTCOUNTÚXL_CFÚXL_CODEPAGEÚ
XL_COLINFOÚXL_COLUMNDEFAULTÚXL_COLWIDTHÚ
XL_CONDFMTÚXL_CONTINUEÚ
XL_COUNTRYÚXL_DATEMODEÚXL_DEFAULTROWHEIGHTÚXL_DEFCOLWIDTHÚXL_DIMENSIONÚXL_DIMENSION2ÚXL_EFONTÚXL_EOFÚXL_EXTERNNAMEÚXL_EXTERNSHEETÚ	XL_EXTSSTÚ	XL_FEAT11ÚXL_FILEPASSÚXL_FONTÚXL_FONT_B3B4Ú	XL_FORMATÚ
XL_FORMAT2Ú
XL_FORMULAÚXL_FORMULA3ÚXL_FORMULA4ÚXL_GCWÚXL_HLINKÚXL_QUICKTIPÚXL_HORIZONTALPAGEBREAKSÚXL_INDEXÚ
XL_INTEGERÚXL_IXFEÚXL_LABELÚXL_LABEL_B2ÚXL_LABELRANGESÚXL_LABELSSTÚXL_LEFTMARGINÚXL_TOPMARGINÚXL_RIGHTMARGINÚXL_BOTTOMMARGINÚ	XL_HEADERÚ	XL_FOOTERÚ
XL_HCENTERÚ
XL_VCENTERÚXL_MERGEDCELLSÚXL_MSO_DRAWINGÚXL_MSO_DRAWING_GROUPÚXL_MSO_DRAWING_SELECTIONÚXL_MULRKÚXL_MULBLANKÚXL_NAMEÚXL_NOTEÚ	XL_NUMBERÚXL_NUMBER_B2ÚXL_OBJÚXL_PAGESETUPÚ
XL_PALETTEÚXL_PANEÚXL_PRINTGRIDLINESÚXL_PRINTHEADERSÚXL_RKÚXL_ROWÚ	XL_ROW_B2Ú
XL_RSTRINGÚXL_SCLÚXL_SHEETHDRÚ
XL_SHEETPRÚXL_SHEETSOFFSETÚ
XL_SHRFMLAÚXL_SSTÚXL_STANDARDWIDTHÚ	XL_STRINGÚXL_STRING_B2ÚXL_STYLEÚ
XL_SUPBOOKÚ
XL_TABLEOPÚXL_TABLEOP2ÚXL_TABLEOP_B2ÚXL_TXOÚXL_UNCALCEDÚ
XL_UNKNOWNÚXL_VERTICALPAGEBREAKSÚ
XL_WINDOW2ÚXL_WINDOW2_B2ÚXL_WRITEACCESSÚ	XL_WSBOOLÚXL_XFÚXL_XF2ÚXL_XF3ÚXL_XF4ÚboflenÚbofcodesÚXL_FORMULA_OPCODESÚ_cell_opcode_listr…   Ú_cell_opcoder‡   ÚsetattrrŽ   Úintr   r›   rž   r¨   r®   r¹   Ú	_brecstrgrÔ   Ú
splitlinesÚ_buffÚsplitÚ_numhÚ_namerÁ   rÑ   rà   rä   Úencoding_from_codepager   r   r   r   Ú<module>   s~  )
øöù
ö




'
# ".
÷