o wh @s\dZddlmZddlmZddlmZGdddeZGdddeZ Gd d d eZ dS) z pyexcel_io.sheet ~~~~~~~~~~~~~~~~~~~ The io interface to file extensions :copyright: (c) 2014-2017 by Onni Software Ltd. :license: New BSD License, see LICENSE for more details )irange) _index_filterNc@seZdZdZddZdS) NamedContentz< Helper class for content that does not have a name cCs||_||_dSN)namepayload)selfrrr B/var/www/html/env/lib/python3.10/site-packages/pyexcel_io/sheet.py__init__s zNamedContent.__init__N)__name__ __module__ __qualname____doc__r r r r r rs rc@sbeZdZdZ        dddZdd Zd d Zd d ZddZddZ ddZ ddZ dS) SheetReaderz Generic sheet reader rNFc Ksd||_i|_|j| ||_||_||_||_t|_t|_ ||_ | |_ |r)||_|r0||_ dSdSr) _native_sheet _keywordsupdate _start_row _row_limit _start_column _column_limitr _skip_row _skip_column_skip_empty_rows _row_renderer) rsheet start_row row_limit start_column column_limit skip_row_funcskip_column_funcskip_empty_rows row_rendererkeywordsr r r r s    zSheetReader.__init__c cst|D]i\}}|||j|j}|tjkrq|tjkr"dSg}g}t||D]-\}}| ||j |j }|tjkr@q-|tjkrGn| ||durZ|dkrZ||7}g}q-|j ret|dkreq|jrm||}|VqdS)z42 dimentional representation of the content N) enumerate row_iteratorrrr constants SKIP_DATASTOP_ITERATIONcolumn_iteratorrrrappendrlenr) r row_indexrow row_position return_rowtmp_row column_index cell_valuecolumn_positionr r r to_array<s@         zSheetReader.to_arraycCs t|S)z iterate each row override this function in the sitation where number_of_rows() is difficult or costly to implement )rnumber_of_rowsrr r r r*es zSheetReader.row_iteratorccs&t|D] }|||VqdS)z iterate each column of a given row override this function in the sitation where number_of_columns() is difficult or costly to implement N)rnumber_of_columnsr7rr2columnr r r r.nszSheetReader.column_iteratorcCtd): implement this method for easy extension z!Please implement number_of_rows() Exceptionr;r r r r:xzSheetReader.number_of_rowscCr?)r@z$Please implement number_of_columns()rAr;r r r r<~rCzSheetReader.number_of_columnscCr?)r@zPlease implement cell_value()rAr=r r r r7rCzSheetReader.cell_valuecCsdSrr r;r r r closeszSheetReader.close)rrrrNNFN) r r rrr r9r*r.r:r<r7rDr r r r rs$ )   rc@s8eZdZdZddZddZddZdd Zd d Zd S) SheetWriterz Generic sheet writer cKs0|r|}ntj}||_||_||_||dSr)r+DEFAULT_SHEET_NAME _native_bookrrset_sheet_name)r native_book native_sheetrr& sheet_namer r r r szSheetWriter.__init__cCdS)z Set sheet name Nr )rrr r r rHzSheetWriter.set_sheet_namecCr?)z+ write a row into the file zPlease implement write_row())NotImplementedError)rarrayr r r write_rowrCzSheetWriter.write_rowcCs|D]}||qdS)z6 For standalone usage, write an array N)rP)rtabler2r r r write_arrays zSheetWriter.write_arraycCrL)z2 This call actually save the file Nr r;r r r rDrMzSheetWriter.closeN) r r rrr rHrPrRrDr r r r rEs  rE) rpyexcel_io._compactrpyexcel_io.utilsrpyexcel_io.constantsr+objectrrrEr r r r s   u