o ˷e?@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 T/var/www/ideatree/venv/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)parenttitle sheet_state _current_row_worksheet_path_shared_strings _get_size)selfparent_workbookrworksheet_pathshared_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)r_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] } |VqdSdSdS)zt The source worksheet file may have columns or rows missing. Missing cells will be created. Nr) data_onlyepoch date_formats)r max_columnmax_rowrrrrr(r) _date_formatsparserange_get_rowr)rmin_colmin_rowmax_colr, values_onlyfiller empty_rowcounteridxr#r row_r r r _cells_by_row:sB   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) rr9r1r3r4 row_widthnew_rowcellr7r8r r r r0es     zReadOnlyWorksheet._get_rowcCs*|||||D] }|r|dSqtS)z4Cells are returned by a generator which can be emptyr)r;r)rr9r=r 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_columnr2)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. rr<N)rowsmaxr=r9r"r!)rr3rrBr r r rFs  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)r"r!r'r r r reset_dimensionssz"ReadOnlyWorksheet.reset_dimensionscC|jSr)r r'r r r r2zReadOnlyWorksheet.min_rowcCrOr)r"r'r r r r,rPzReadOnlyWorksheet.max_rowcCrOr)rr'r r r rHrPzReadOnlyWorksheet.min_columncCrOr)r!r'r r r r+rPzReadOnlyWorksheet.max_column)F)rNF)__name__ __module__ __qualname__rr r!r"rrB iter_rowsvaluesrK __getitem____iter__rrrr;r0rCrJrFrNpropertyr2r,rHr+r r r r rs6   +     rN) __doc__ worksheetropenpyxl.cell.read_onlyrropenpyxl.utilsr_readerrrobjectrr r r r s