U ®[ÖeTã@sPddlmZddlmZddlmZdd„ZGdd„deƒZGdd „d eƒZ d S) é)Ú SheetReader)Ú NEW_READERS)Ú OrderedDictc CsRi}i}ddddddddd g }|D]&}||kr<||||<q"||||<q"||fS) NZ start_rowZ row_limitZ start_columnZ column_limitZskip_column_funcZ skip_row_funcZskip_empty_rowsZ row_rendererZkeep_trailing_empty_cells©)ÚkeywordsZsheet_keywordsÚnative_sheet_keywordsZ args_listÚargrrúS/var/www/html/services/stratfitenv/lib/python3.8/site-packages/pyexcel_io/reader.pyÚclean_keywordss"÷ r c@sfeZdZddd„Zdd„Zdd„Zdd „Zd d „Zd d „Zdd„Z dd„Z dd„Z dd„Z dd„Z dS)ÚReaderNcCs||_||_d|_d|_dS©N)Ú file_typeÚlibraryrÚ reader_class)Úselfr rrrr Ú__init__szReader.__init__cKsH|jdkr tj|jd|jd|_t|ƒ\|_}|j||jf|Ž|_|jS)NÚfile©Úlocationr)rrÚ get_a_pluginr rr rÚreader)rÚ file_namerrrrr Úopen)s ÿÿÿz Reader.opencKsHt|ƒ\|_}|jdkr.tj|jd|jd|_|j||jf|Ž|_|jS)NÚcontentr©r rrrrr rr)rZ file_contentrrrrr Ú open_content4s ÿÿÿzReader.open_contentcKsHt|ƒ\|_}|jdkr.tj|jd|jd|_|j||jf|Ž|_|jS)NZmemoryrr)rZ file_streamrrrrr Ú open_stream?s ÿÿÿzReader.open_streamcCs|j ¡}| |¡}| |¡S)z; read a named sheet from a excel data book )rÚ sheet_namesÚindexÚread_sheet_by_index)rZ sheet_namerrrrr Úread_sheet_by_nameJs  zReader.read_sheet_by_namecCs4|j |¡}|j ¡}t|f|jŽ}||| ¡iSr )rZ read_sheetrÚEncapsulatedSheetReaderrZto_array)rÚ sheet_indexZ sheet_readerrÚsheetrrr rSs  zReader.read_sheet_by_indexcCs2tƒ}tt|jƒƒD]}| |¡}| |¡q|S©z8 read everything from a excel data book )rÚrangeÚlenrrÚupdate)rÚresultr"Z content_dictrrr Úread_allYs   zReader.read_allcCs@tƒ}|D]0}t|tƒr*| | |¡¡q | | |¡¡q |Sr$)rÚ isinstanceÚintr'rr )rZsheetsr(r#rrr Ú read_manycs  zReader.read_manycCs |j ¡Sr )rÚclose©rrrr r-osz Reader.closecCs|Sr rr.rrr Ú __enter__rszReader.__enter__cCs | ¡dSr )r-)rÚa_typeÚvalueÚ tracebackrrr Ú__exit__uszReader.__exit__)N)Ú__name__Ú __module__Ú __qualname__rrrrr rr)r,r-r/r3rrrr r s       r c@seZdZdd„Zdd„ZdS)r!ccs|j ¡EdHdSr )Ú _native_sheetÚ row_iteratorr.rrr r8zsz$EncapsulatedSheetReader.row_iteratorccs|j |¡EdHdSr )r7Úcolumn_iterator)rÚrowrrr r9}sz'EncapsulatedSheetReader.column_iteratorN)r4r5r6r8r9rrrr r!ysr!N) Zpyexcel_io.sheetrZpyexcel_io.pluginsrZpyexcel_io._compactrr Úobjectr r!rrrr Ús   ]