Ȯ$i A ddlmZddlZddlmZddldZGddeZGdd e Z e d \Z Z ZZZe ZeZe d \ZZZZZZZd d ddddddddd ZddddddddZdZd xZZd Zd!xZ Z!dZ"d"Z#d#Z$d$Z%d%Z&d&Z'dZ(d'Z)d(Z*d Z+d)Z,d*Z-d+Z.d,Z/d-Z0d.Z1d/Z2d0Z3d1Z4d2Z5d3Z6d4Z7d5Z8d6Z9dZ:d7Z;d8Zd;Z?dZBd?ZCd@ZDdAZEd#ZFdBZGdCZHdDZIdEZJdFZKdGZLdHZMd"ZNdIZOdJZPdKZQdLZRdMZSdNZTdOZUdPZVdQZWdRZXdSZYdTZZdUZ[dVZ\dWZ]dXZ^dYZ_dZZ`d[Zad\Zbd]Zcd^Zdd_Zed`ZfdaZgdbZhdcZiddZjdeZkdfZldgZmdhZndiZodjZpdkZqdlZrdmZsdnZtdoZudpZvdqZwd ZxdrZydsZzdtZ{duZ|dvZ}dwZ~dxZdyZdzZd{Zd|Zd}ZerZd~ZdZdZdZdhd#d#dKdZdZdZe*eFeGeHePeSe`edeleog ZiZeD]Zdee< dZefdZeefdZddZddZddZddZddZdZiZej9D]"Zej=\ZZeeeed!<$[[[dejBdfdZdejBdfdZejBfdZdddddddddd Zy))print_functionN)unpack)*ceZdZdZy) XLRDErrorzK An exception indicating problems reading data from an Excel file. N)__name__ __module__ __qualname____doc__P/mnt/ssd/data/python-lab/Trading/venv/lib/python3.12/site-packages/xlrd/biffh.pyrrsrrceZdZdZgZddZy) BaseObjectzt Parent of almost all other classes in the package. Defines a common :meth:`dump` method for debugging. Nc |tj}t|dr1g}|jD]}|j |t ||f!n|j j}t|}d|z}| t||tg}ti} |D]\}} t | ddr9|dk7r4| j|||d| jjd|d z L||jvr?t| |s t| | r'td ||t| t!| fz|t#|d ||| |t||yy) 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__ filedumpbookz (z object):)headerindentz%s%s: %s, len = %dz %s%s: %r )sysstderrhasattrrappendgetattr__dict__itemssortedprinttyper __class__r _repr_these isinstancelenfprintf) selffrfooterralistattrpad list_type dict_typevalues rrzBaseObject.dumpsO 9 A 4 %E : dGD$$789 :MM'')Eu Fl  uV!4H H  ;KD%ufd+ 125tU__=U=UV!!8%d...eY/:eY3O*c4ec%j-QQXYZ<dE: ;  uV!4 r)NNNr)r r r r r'rr rrrrs K5rrz (not BIFF)z2.0z2.134S4W5788X) r(-2FPUz#NULL!z#DIV/0!z#VALUE!z#REF!z#NAME?z#NUM!z#N/A)rr5$*rDi!!i iViB} rIi<"i%rEiE #rGir/1i1ir?iii Diri_&r@')r=r>i]A+rJi~iiiiii676i^ii>>\CiCiC)rPi i  )rNr`r_c|tvSN)_cell_opcode_dict)cs ris_cell_opcoders " ""rc:|D]\}}}|||||z|z yrr )tgt_objsrcmanifest local_setattrnmaskr/s rupkbitsrs,!8 4gtcDjQ%678rc F|D]\}}}||||||z|z yrr )rrrr local_intrrr/s rupkbitsLrs3!C 4gtYd q/@%ABCrcltdd|dz z||||zd}||z }t||||z|SN<BHrrrunicode)dataposencodinglenlenncharss r unpack_stringrsL C$vax.($s3v:*> ? BF6MC 4CJ' 22rc~||}n#tdd|dz z||||zd}||z }||z}t|||||fSrr)rrrr known_lenrnewposs runpack_string_update_posrsad6!8n,d3s6z.BCAF v  6\F DV$h / 88rctdd|dz z||||zd}|s tdS||z }t||}|dz }|dzr|dz }|dzr|dz }|dzr|||d|zz}t|d }|St||||zd }|S) zReturn unicode_strgrrrrrxrMr utf_16_lelatin_1rUNICODE_LITERAL BYTES_ORDr)rrrroptionsrawstrgstrgs runpack_unicoders C$vax.($s3v:*> ? BF r""6MCS "G1HC~ q~ q~s3qx<(w , KtCF +Y7 Krc||}n#tdd|dz z||||zd}||z }|s||ds td|fSt||}|dz }|dz}|dz}|rtd |||d zd}|d z }|rtd |||dzd} |dz }|dzrt|||d |zzd } |d |zz }nt||||zd } ||z }|r|dzz }|r| z }| |fS)z+Return (unicode_strg, updated value of pos)NrrrrrrrxCCay G#Cc#i-)@ANBB   BqD"bd3 4 9 C  Jra 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 t||zt|}|}| }d} ||krt|dz|} ||| } | |z } | dks| t| k7r"ttjd|||||| | ydj d| D} d}| D]2}t t|}|dk(rd}nd|cxkrdksnd }||z }4|r d ||z|z z} t|d | | || }||kryy) NrrLrzS??? hex_char_dump: ofs=%d dlen=%d base=%d -> endpos=%d pos=%d endsub=%d substrg=%r c38K|]}dt|zyw)z%02x N)r).0rs r z hex_char_dump..s?!w1-?s~r?%5d: z%s %-48s %s )minr)r*rstdoutjoinchrr)rofsdlenbasefout unnumberedendposrnumbered num_prefixendsubsubstrglensubhexdchardrs r hex_char_dumpr s tSY 'F C~HJ ,S2Xv&s6"# Q;&CL0  fT4fg ? ww?w?? AIaL!ADyQo#o QJE    T#Xc\2J):tUC1 ,rc r|}||z}||z }d} | } d} ||z dk\rtd|||dz\} } | dk(r/| dk(r*||dd||z zk(r ||z } |}|}n| r| dz } n|}d} |dz }nj| r| rd|zz} t|d| | d} tj| d}| rd||zz} t|d | | || | |dz }t ||| ||z|||| z }||z dk\r| r| rd|zz} t|d| | ||kr.| rd||zz} t|d | t ||||z ||z||y||kDrt|d  yy) Nrrrz%s%04x %s len = %04x (%d) z%s---- Misc bytes at end ---- z5Last dumped record has length (%d) that is too large )rr*biff_rec_name_dictgetr)mem stream_offset stream_lenrrrr stream_endadjdummiesrrrclengthsavposrecnames r biff_dumpr(s C+J  CG~HJ s a E3s3q5>2 F 7v{34yEZ#%566$s* 1  1HC")S6\":JCZQXY(,,R=G$c 2 D7RRXZ` a 1HC #sFCGT: F 6MC5 s a 6 !S6\2J;ZQ Z  C#I.J7Dc3 3c 4L z NPVW rc||}||z}i}||z dk\rvtd|||dz\}}|dk(r|dk(r||dd||z zk(rnHd} ntj|d} | d|z} | |vr|| xxdz cc<nd|| <||dzz }||z dk\rvt|j } | D]\} } t d| | fz| y) NrrrrzzUnknown_0x%04Xrz%8d %sr)rrrr#r"r$) rrrrrrtallyrrrslistcounts rbiff_count_recordsrVs C+J E s a E3s3q5>2 F 7v{34yEZ#%566&G(,,R6G*R/ e  'Na NE'N vz s a  5;;= !E6 h%))56rr mac_roman mac_greek mac_cyrillic mac_latin2 mac_iceland mac_turkishcp1252) ii'i'i'i-'i_'ia'ii)r)rN)rM)rMN)rN) __future__rrstructr timemachineDEBUG ExceptionrobjectrrangeFUNFDTFNUFGEFTX DATEFORMAT NUMBERFORMAT XL_CELL_EMPTY XL_CELL_TEXTXL_CELL_NUMBER XL_CELL_DATEXL_CELL_BOOLEAN XL_CELL_ERROR XL_CELL_BLANKbiff_text_from_numerror_text_from_codeBIFF_FIRST_UNICODEXL_WORKBOOK_GLOBALS WBKBLOBALXL_WORKBOOK_GLOBALS_4W XL_WORKSHEETWRKSHEETXL_BOUNDSHEET_WORKSHEETXL_BOUNDSHEET_CHARTXL_BOUNDSHEET_VB_MODULEXL_ARRAY XL_ARRAY2XL_BLANK XL_BLANK_B2XL_BOF XL_BOOLERR XL_BOOLERR_B2 XL_BOUNDSHEETXL_BUILTINFMTCOUNTXL_CF XL_CODEPAGE XL_COLINFOXL_COLUMNDEFAULT XL_COLWIDTH XL_CONDFMT XL_CONTINUE XL_COUNTRY XL_DATEMODEXL_DEFAULTROWHEIGHTXL_DEFCOLWIDTH XL_DIMENSION XL_DIMENSION2XL_EFONTXL_EOF XL_EXTERNNAMEXL_EXTERNSHEET XL_EXTSST XL_FEAT11 XL_FILEPASSXL_FONT XL_FONT_B3B4 XL_FORMAT XL_FORMAT2 XL_FORMULA XL_FORMULA3 XL_FORMULA4XL_GCWXL_HLINK XL_QUICKTIPXL_HORIZONTALPAGEBREAKSXL_INDEX XL_INTEGERXL_IXFEXL_LABEL XL_LABEL_B2XL_LABELRANGES XL_LABELSST XL_LEFTMARGIN XL_TOPMARGINXL_RIGHTMARGINXL_BOTTOMMARGIN XL_HEADER XL_FOOTER XL_HCENTER XL_VCENTERXL_MERGEDCELLSXL_MSO_DRAWINGXL_MSO_DRAWING_GROUPXL_MSO_DRAWING_SELECTIONXL_MULRK XL_MULBLANKXL_NAMEXL_NOTE XL_NUMBER XL_NUMBER_B2XL_OBJ XL_PAGESETUP XL_PALETTEXL_PANEXL_PRINTGRIDLINESXL_PRINTHEADERSXL_RKXL_ROW XL_ROW_B2 XL_RSTRINGXL_SCL XL_SHEETHDR XL_SHEETPRXL_SHEETSOFFSET XL_SHRFMLAXL_SSTXL_STANDARDWIDTH XL_STRING XL_STRING_B2XL_STYLE XL_SUPBOOK XL_TABLEOP XL_TABLEOP2 XL_TABLEOP_B2XL_TXO XL_UNCALCED XL_UNKNOWNXL_VERTICALPAGEBREAKS XL_WINDOW2 XL_WINDOW2_B2XL_WRITEACCESS XL_WSBOOLXL_XFXL_XF2XL_XF3XL_XF4boflenbofcodesXL_FORMULA_OPCODES_cell_opcode_listr _cell_opcodersetattrrintrrrrrr _brecstrgr splitlines_buffsplit_numh_namerrrrencoding_from_codepager rrrs9 &    '5'5R (S#sC    !H                  "%%i x                                            !                                   Q1 5 +-     %(L&'l#(#3:84;cC3 9%N!F$_  B  ! ! #/E;;=LE5).s5"~&/ 5)() u>453::RW,X\=@JJ60          r