ZiB |SrSrSSKrSSKrSSKJr SSKr\RR\RR\RR\RR\ 5555r \ \R;a\RRS\ 5 C SSKJr \R"SS:a\rSrSrS r"S S \R.5r"S S \R25r"SS\5r"SS\R25r\"/SQ5r\"/SQ5r"SS\R@5r!"SS\!5r""SS\!5r#"SS\!5r$"SS\R@5r%"SS\%5r&S r'\(S!:Xa2\RR"\RT"\RVS"S\\55 gg)#zPParse xls up to some point Read storages, (sub-)streams, records from xls file z0.54N)unpack) record_basecFSn[U5nUR5H.n[U[5(dM UbUR 5 gg UbUR 5 g![ a [ R"SSS9 N5f=f!UbUR 5 ff=f)z determine whether a given file is an excel ole file returns True if given file is an ole file and contains a Workbook stream todo: could further check that workbook stream starts with a globals substream. See also: oleid.OleID.check_excel NTz/Ignoring exception in is_xls, assume is not xls)exc_infoF)XlsFile iter_streams isinstanceWorkbookStreamclose Exceptionloggingdebug)filenamexls_filestreams m/var/www/eduai.edurigo.com/question_generate/ques_gen_env/lib/python3.13/site-packages/oletools/xls_parser.pyis_xlsrQsH 8$++-F&.11   NN  .   NN   % G# %%   NN  s.1A%A%A%%BB BB B c[XUS-5S:HnU(a US-U-nXS-URS5U4$[XS-U5$)z%read_unicode_2byte..zsHF%(F3KKFs<Hc 3^># UH"n[[STXS-5S5v M$ g7f)?4''r!c[S4$)Cdetermine a class for given record type returns (clz, force_read) F) XlsRecordr9rMs rrecord_class_for_typeXlsStream.record_class_for_types %r!r=N) r>r?r@rArBrOrCrUrDr=r!rr8r8s7(  r!r8c(\rSrSrSr\S5rSrg)r z*Stream in excel file that holds most info cU[R:Xa[S4$U[R:Xa[S4$U[R:Xa[S4$[S4$rRTF) XlsRecordBofTYPE XlsRecordEofXlsRecordSupBookrSrTs rrU$WorkbookStream.record_class_for_types[ |(( (% % ** *& & ).. .#T) )e# #r!r=N)r>r?r@rArBrCrUrDr=r!rr r s5 $ $r!r c6\rSrSrSrSrSrSr\S5r Sr g) XlsbStreamz?binary stream of an xlsb file, usually have a record structure c[URRS55nXR-(aE[URRS55nXR-X R-S--nOUnSnSn[ S5HTn[URRS55nXAUR-U-- nUS- nXR-S:XdMT O X4S4$)rHrrrJN)rrrK HIGH_BIT_MASK LOW7_BIT_MASKr1)rLr(val2rMrNshift_s rrOXlsbStream.read_record_heads $++""1%& ## #t{{''*+D000 2 22q8:HHqAdkk&&q)*C t111e; ;H QJE(((Q.  4''r!cJU[R:Xa[S4$[S4$rZ)XlsbBeginSupBookr\ XlsbRecordrTs rrU XlsbStream.record_class_for_types) ',, ,#T) )u$ $r!r=N) r>r?r@rArBrgrhrOrCrUrDr=r!rraras(JMM(0%%r!ra)()BuiltInFnGroupCount)icBookExt)iCodeName)BCodePage)icDat)ij DataLabExt)ikDataLabExtContents)DBCell) DbOrParmQry)i DBQueryExt)ivDConn)# ExternName) ExternSheet)ExtSST)i ExtString)igFeatHdr)[ FileSharing)iFormat)1Font)i GUIDTypeLib)iHLink) InterfaceHdr) InterfaceEnd)i Index)Lbl)Mms)]Obj)i' ObjectLink)i  OleDbConn) OleObjectSize)iRichTextStream)ibSheetExt)iShrFmla)i  SxViewExt)iX SxViewLink)iWebPub)zXF (formatting))i}zXFExt (formatting))iStyle)iStyleExt))iL BrtEndSupBook)i BrtSupAddin)ic BrtSupBookSrc)iJBrtSupNameBits)iHBrtSupNameBool)iK BrtSupNameEnd)iE BrtSupNameErr)iIBrtSupNameFmla)iG BrtSupNameNil)iD BrtSupNameNum)iF BrtSupNameSt)iABrtSupNameStart)iCBrtSupNameValueEnd)iBBrtSupNameValueStart)if BrtSupSame)ie BrtSupSelf)ig BrtSupTabsc"\rSrSrSrSrSrSrg)rSi(z0basic building block of data in workbook stream i c[UR$![a SRUR5s$f=f):simplification for subclasses to create their own __str__ zXlsRecord type {0})FREQUENT_RECORDStypeKeyErrorformatrLs r _type_strXlsRecord._type_str.s: :#DII. . :'..tyy9 9 : %==r=Nr>r?r@rArBMAX_SIZErrDr=r!rrSrS(s;H:r!rSc@\rSrSrSrSrSr\"/SQ5rSr Sr Sr g ) r[i6z(record found at beginning of substreams i ))workbook)rzdialog/worksheet) chart)@macrocpURcSUlg[SURSS5SUlg)Nr.r#rJr)rdoctyperrLrks rfinish_constructing XlsRecordBof.finish_constructing>s3 99 DL dDIIaN3A6 r!cSRURUR;aURUR5$S5$)NzBOF Record ({0} substream)unknown)rrDOCTYPESrs rrXlsRecordBof._type_strEsA+22+/<<4==+HDMM$,, '  r!)rN) r>r?r@rArBr\SIZEdictrrrrDr=r!rr[r[6s(3 D D78H7r!r[c&\rSrSrSrSrSrSrSrg)r]iKz"record found at end of substreams rcg)Nz EOF Recordr=rs rrXlsRecordEof._type_strPsr!r=N) r>r?r@rArBr\rrrDr=r!rr]r]Ks- D Dr!r]cD\rSrSrSrSrSrSrSrSr Sr S r S r S r S rS rg)r^iTzThe SupBook record specifies a supporting link "... The collection of records specifies the contents of an external workbook, DDE data source, or OLE data source." (MS-XLS, paragraph 2.4.271) irzself-referencingzaddin-referencingunusedz same-sheetzole/dde data sourcezexternal workbookcSUlSUlSUlURUlUR cgUR S:a$[SRUR 55e[SUR SS5uUlUlSURs=:aS::a-O O*[UR SUR5uUlnO SuUlnURS:XaURUlgURS :Xa"URS :XaURUlgURS :XaURUlgURS :XaURUlgURS:Xa#UR(aURUlgURS:a$UR(aUR Ulggg) z>Finish constructing this record; called at end of constructor.NrJz+not enough data (size is {0} but need >= 4)rIrr)r0rJiri: )ctabcch virt_pathLINK_TYPE_UNKNOWNsupport_link_typersize ValueErrorrrr LINK_TYPE_SELFLINK_TYPE_ADDINLINK_TYPE_UNUSEDLINK_TYPE_SAMESHEETLINK_TYPE_OLE_DDELINK_TYPE_EXTERNALrs rr$XlsRecordSupBook.finish_constructingess !%!7!7 99   99q=J$fTYY/1 1$UDIIbqM: 48 txx 4  ,TYY488 D DNA & DNA 88u %)%8%8D " YY# $((f"4%)%9%9D " ^^y (%)%:%:D " ^^y (%)%=%=D " YY# $..%)%;%;D " YY]t~~%)%<%r?r@rArBr\rrrrrrrrrrDr=r!rr^r^TsB D!'N)O&-,"=HEr!r^c"\rSrSrSrSrSrSrg)roizilike an xls record, but from binary part of xlsb file has no MAX_SIZE and types have different meanings Nc[UR$![a SRUR5s$f=f)rzXlsbRecord type {0})FREQUENT_RECORDS_XLSBrrrrs rrXlsbRecord._type_strs: ;(3 3 ;(// : : ;rr=rr=r!rroros H;r!roc<\rSrSrSrSrSrSrSrSr Sr S r S r S r g ) rnizRecord beginning an external link in xlsb file contains information about the link itself (e.g. for DDE the link is string1 + ' ' + string2) ihrDDEOLE unexpectedrcURUlSUlSUlURcg[ SURSS5SUlUR S:XaURUlOUR S:XaURUlOeUR S:XaURUlOC[R"SRURS55 URUlSn[ SURX"S-5SnUS :Xa[R"S 5 OkURUS-U-S-:a0[R"S RX0R55 O"[URUS-U5uUln[ SURX"S-5SnUS :Xa[R"S 5 gURUS-U-S-:a3[R"S RX0R5S -5 g[URUS-U5uUlng) Nr0r.rr#rz$Unexpected link type {0} encounteredzr?r@rArBr\rrrrrrrrDr=r!rrnrns6 D#MM'!%:NCr!rnc# # Sn[XRU[R5nUR 5HnUv M UbUR 5 gg![ a ef=f!UbUR 5 ff=f7f)zBExcel xlsb files also have bin files with record structure. iter! N)rarr STGTY_STREAM iter_recordsr r ) file_streamrkr xlsb_streamrecords rparse_xlsb_partr sK   .>.>!,!9!9; !..0FL1  "     #    "     #s)BAAB A((A++BB__main__r),rB __version__sysos.pathosstructrrpathnormpathdirnameabspath__file__ PARENT_DIRinsertoletoolsr version_infochrr&rr r OleRecordFilerOleRecordStreamr8r rarrr OleRecordBaserSr[r]r^rornr r>exittestargvr=r!rr#sL " WW  bggoobggooGGOOH/ !  SXXHHOOAz" A! F2 > ' k'' ++ ($Y$&'%,,'%^))X* : )) :9*96Ey6Er ;** ; 7Cz7C~  ( zHH[  chhqrlG^ DEr!