o b@sTdZddlmZddlmZmZddlmZddlm Z ddZ Gd d d e Z d S) z Read worksheets on-demand ) Worksheet) ReadOnlyCell EMPTY_CELL)get_column_letter)WorkSheetParsercCst|g}|SN)rparse_dimensions)sourceparserr \/var/www/secure340b-portal/env/lib/python3.10/site-packages/openpyxl/worksheet/_read_only.pyread_dimension s rc@seZdZdZdZdZZejZej Z ej Z ej Z ej Z ej Z ddZddZddZdd d Zdd d ZddZdddZddZddZeddZeddZeddZeddZdS) ReadOnlyWorksheetrNcCs0||_||_d|_d|_||_||_|dS)Nvisible)parenttitleZ sheet_stateZ _current_row_worksheet_path_shared_strings _get_size)selfZparent_workbookrZworksheet_pathZshared_stringsr r r __init__"s zReadOnlyWorksheet.__init__cCsF|}t|g}|}||dur!|\|_|_|_|_dSdSr) _get_sourcerr close _min_column_min_row _max_column_max_row)rsrcr dimensionsr r r r,s zReadOnlyWorksheet._get_sizecCs|jj|jS)z0Parse xml source on demand, must close after use)rZ_archiveopenrrr r r r5szReadOnlyWorksheet._get_sourceFccst}|rd}|p |j}|p|j}g}|dur |f|d|}|}d} |} t| |j|jj|jj|jj d} | D]0\} } |durJ| |krJn#t || D] } |d7}|VqO|| krl| | |||} |d7}| Vq<|dur|| krt ||dD]} |Vq|| dS)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|sdS|p |dd}|d|}tg|}|r dg|}|D](}|d}||kr2|krJnq"||} |d|| <|sJt|fi||| <q"t|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 r r(es     zReadOnlyWorksheet._get_rowcCs*|||||D] }|r|dSqtS)z4Cells are returned by a generator which can be emptyr)r1r)rr/r3r r r _get_cell~s  zReadOnlyWorksheet._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 r calculate_dimensions  &z%ReadOnlyWorksheet.calculate_dimensioncCs<d}|jD]}|s q|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. rr2N)rowsmaxr3r/rr)rr+rr6r r r r:s  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 r reset_dimensionssz"ReadOnlyWorksheet.reset_dimensionscC|jSr)rr!r r r r*zReadOnlyWorksheet.min_rowcCrCr)rr!r r r r%rDzReadOnlyWorksheet.max_rowcCrCr)rr!r r r r<rDzReadOnlyWorksheet.min_columncCrCr)rr!r r r r$rDzReadOnlyWorksheet.max_column)F)rNF)__name__ __module__ __qualname__rrrrrr6Z iter_rowsvaluesr? __getitem____iter__rrrr1r(r7r>r:rBpropertyr*r%r<r$r r r r rs6   +     rN) __doc__Z worksheetrZopenpyxl.cell.read_onlyrrZopenpyxl.utilsr_readerrrobjectrr r r r s