EfqdZddlZddlmZddlmZmZddlmZm Z dZ Gdde Z Gd d e Z Gd d e Zd ZdS)z pyexcel_io.book ~~~~~~~~~~~~~~~~~~~ The io interface to file extensions :copyright: (c) 2014-2022 by Onni Software Ltd. :license: New BSD License, see LICENSE for more details N) OrderedDictisstream)MESSAGE_ERROR_03MESSAGE_WRONG_IO_INSTANCEzxDeprecated since v0.6.0! Although backward compatibility is preserved, it is recommended to upgrade to get new features.cFeZdZdZdZdZdZdZdZdZ dZ d Z d Z dS) RWInterfacez7 The common methods for book reader and writer NcFtjtd|_dSN)warningswarnDEPRECATED_SINCE_0_6_0 _file_typeselfs Q/var/www/ffwdstore.be/apps/py-env/lib/python3.11/site-packages/pyexcel_io/book.py__init__zRWInterface.__init__s ,---c td)zopen a file for read or writePlease implement this methodNotImplementedErrorr file_namekeywordss ropenzRWInterface.open#!"@AAArc td)z$open a file stream for read or writerrr file_streamrs r open_streamzRWInterface.open_stream'rrc td)%open a file content for read or writerrrs r open_contentzRWInterface.open_content+rrc||_dS)z set the file type for the instance file type is needed when a third party library could handle more than one file typeN)r)r file_types rset_typezRWInterface.set_type/s $rcdS)z4 close the file handle if necessary Nrs rclosezRWInterface.close7s  rc|Sr r)rs r __enter__zRWInterface.__enter__?s rc.|dSr )r*)ra_typevalue tracebacks r__exit__zRWInterface.__exit__Bs r) __name__ __module__ __qualname____doc__ stream_typerrr!r$r'r*r,r1r)rrr r sKBBBBBBBBB$$$   rr cReZdZdZfdZdZdZdZdZdZ dZ d Z d Z xZ S) BookReaderz Standard book reader ctt|d|_d|_d|_d|_dSr )superr8r _file_name _file_stream _keywords _native_bookr __class__s rrzBookReader.__init__KsC j$((***  rc "||_||_dS)zk open a file with unlimited keywords keywords are passed on to individual readers N)r;r=rs rrzBookReader.openRs $!rc t|r_ddlm} |dn2#|$r*t ||j}YnwxYw||_||_dStt)zw open a file with unlimited keywords for reading keywords are passed on to individual readers r)UnsupportedOperationN) riorCseek_convert_content_to_streamreadrr<r=IOErrorr)rr rrCs rr!zBookReader.open_stream[s K  5 / / / / / /   ####'   8$$&&   !,D %DNNN344 4s-,AAc Lt||j}|j|fi|dS)z read file content as if it is a file stream with unlimited keywords for reading keywords are passed on to individual readers N)rFrr!)r file_contentrr s rr$zBookReader.open_contentqs61tOO 1111111rcfd|jD}t|dkr(|dj||diSt dz)z; read a named sheet from a excel data book c*g|]}|jk |Sr))name).0content sheet_names r z1BookReader.read_sheet_by_name..s0   |z)) )))rrrzCannot find sheet %s)r>lenrM read_sheet ValueError)rrPnamed_contentss ` rread_sheet_by_namezBookReader.read_sheet_by_name{s}    ,    ~  ! # #"1%*DOON1 read an indexed sheet from a excel data book )r>rMrS IndexErrorr*)r sheet_indexsheets rread_sheet_by_indexzBookReader.read_sheet_by_indexsX %k2EJ 6 67 7    JJLLL  s (+ A cpt}|jD]}||||j< |Sz8 read everything from a excel data book )rr>rSrM)rresultrZs rread_allzBookReader.read_alls?& 8 8E!%!7!7F5:   rct}|D]h}t|tr)|||@|||i|Sr])r isinstanceintupdater[rV)rsheetsr^rZs r read_manyzBookReader.read_manysy > >E%%% > d66u==>>>> d55e<<==== rc td)zE Return a context specific sheet from a native sheet rr)r native_sheets rrSzBookReader.read_sheets""@AAAr)r2r3r4r5rrr!r$rVr[r_rerS __classcell__r@s@rr8r8Fs!!!!!"""555,222 B B B      BBBBBBBrr8c@eZdZdZfdZdZdZdZdZdZ xZ S) BookWriterz Standard book writer crtt|d|_d|_dSr )r:rkr_file_alike_objectr=r?s rrzBookWriter.__init__s2 j$((***"&rc "||_||_dS)zw open a file with unlimited keywords for writing keywords are passed on to individual writers N)rmr=rs rrzBookWriter.opens #,!rc ht|stt|j|fi|dS)z~ open a file stream with unlimited keywords for writing keywords are passed on to individual writers N)rrHrrrs rr!zBookWriter.open_streamsC  $$ ,*++ + +*******rc td)r#z+Normal writer would not need this interface) Exceptionrs rr$zBookWriter.open_contentsEFFFrc|D]W}||}|r0||||ItddS)z7 write a dictionary into an excel file zCannot create a sheet writer!N) create_sheet write_arrayr*rq)r incoming_dictrP sheet_writers rwritezBookWriter.writesz( A AJ,,Z88L A((z)BCCC""$$$$ ?@@@  A Arc td)z: implement this method for easy extension zPlease implement create_sheet()r)rrPs rrszBookWriter.create_sheets""CDDDr) r2r3r4r5rrr!r$rwrsrhris@rrkrks """ + + +GGG A A AEEEEEEErrkcvtj|}tj|}|dkot|t }|dkot|t}|r|d}n|r|d}|||d|S)Nbytesstringzutf-8r) managerget_io get_io_typerarzencodedecoderwrE)rJr&streamtarget_content_type needs_encode needs_decodes rrFrFs ^I & &F!-i88&'1*e;;7L'(2ze88L4#**733 4#**733  LL KKNNN Mr)r5r pyexcel_io.managerr|pyexcel_io._compactrr constantsrrrobjectr r8rkrFr)rrrs$$$$$$55555555BBBBBBBB:+++++&+++\iBiBiBiBiBiBiBiBX2E2E2E2E2E2E2E2Ejr