U qd@s`dZddlmZddlmZmZddlmZddlm Z ddl m Z dd Z Gd d d e Zd S) z Read worksheets on-demand ) Worksheet) ReadOnlyCell EMPTY_CELL)get_column_letter)WorkSheetParser)DefinedNameDictcCst|g}|SN)rparse_dimensions)sourceparserr A/tmp/pip-unpacked-wheel-ggkges9p/openpyxl/worksheet/_read_only.pyread_dimensions rc@seZdZdZdZdZZejZej Z ej Z ej Z ej Z ej Z ddZddZddZdd d Zdd d ZddZd ddZddZddZeddZeddZeddZeddZdS)!ReadOnlyWorksheetrNcCs8||_||_d|_d|_||_||_|t|_dS)NZvisible) parenttitleZ sheet_stateZ _current_row_worksheet_path_shared_strings _get_sizerZ defined_names)selfZparent_workbookrZworksheet_pathZshared_stringsr r r__init__#szReadOnlyWorksheet.__init__cCsB|}t|g}|}||dk r>|\|_|_|_|_dSr ) _get_sourcerr close _min_column_min_row _max_column_max_row)rsrcr Z dimensionsr r rr.s  zReadOnlyWorksheet._get_sizecCs|jj|jS)z0Parse xml source on demand, must close after use)rZ_archiveopenrrr r rr7szReadOnlyWorksheet._get_sourceFccst}|r d}|p|j}|p|j}g}|dk r>|f|d|}|}d} |} t| |j|jj|jj|jj d} | D]`\} } |dk r| |krqt || D]} |d7}|Vq|| krv| | |||} |d7}| Vqv| |dk r|| krt ||dD] } |VqdS)zt The source worksheet file may have columns or rows missing. Missing cells will be created. Nr) data_onlyepochZ date_formats)r max_columnmax_rowrrrrr!r"Z _date_formatsparserange_get_rowr)rmin_colmin_rowmax_colr$ values_onlyZfillerZ empty_rowcounteridxrr row_r r r _cells_by_row<s<  zReadOnlyWorksheet._cells_by_rowc Cs|s |s dS|p|dd}|d|}tg|}|r@dg|}|D]L}|d}||krd|krDnqD||} |d|| <|sDt|f||| <qDt|S)zT Make sure a row contains always the same number of cells or values r columnrNvalue)rrtuple) rr.r(r*r+Z row_widthZnew_rowcellr,r-r r rr'gs    zReadOnlyWorksheet._get_rowcCs*|||||D]}|r|dSqtS)z4Cells are returned by a generator which can be emptyr)r0r)rr.r2r r r _get_cellszReadOnlyWorksheet._get_cellcCsLt|j|jgs&|r|ntdt|j|jdt|j|jS)Nz9Worksheet is unsized, use calculate_dimension(force=True):)allr#r$_calculate_dimension ValueErrorr min_columnr))rforcer r rcalculate_dimensions  z%ReadOnlyWorksheet.calculate_dimensioncCs<d}|jD]}|sq |d}t||j}q |j|_||_dS)z Loop through all the cells to get the size of a worksheet. Do this only if it is explicitly requested. rr1N)rowsmaxr2r.rr)rr*rr5r r rr9s z&ReadOnlyWorksheet._calculate_dimensioncCsd|_|_dS)z Remove worksheet dimensions if these are incorrect in the worksheet source. NB. This probably indicates a bug in the library or application that created the workbook. N)rrr r r rreset_dimensionssz"ReadOnlyWorksheet.reset_dimensionscCs|jSr )rr r r rr)szReadOnlyWorksheet.min_rowcCs|jSr )rr r r rr$szReadOnlyWorksheet.max_rowcCs|jSr )rr r r rr;szReadOnlyWorksheet.min_columncCs|jSr )rr r r rr#szReadOnlyWorksheet.max_column)F)rNF)F)__name__ __module__ __qualname__rrrrrr5Z iter_rowsvaluesr> __getitem____iter__rrrr0r'r6r=r9rApropertyr)r$r;r#r r r rrs4   +      rN)__doc__Z worksheetrZopenpyxl.cell.read_onlyrrZopenpyxl.utilsrZ_readerrZopenpyxl.workbook.defined_namerrobjectrr r r rs