o e@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 P/var/www/html/venv/lib/python3.10/site-packages/openpyxl/worksheet/_read_only.pyread_dimensions rc@seZdZdZdZdZZejZej Z ej Z ej Z ej Z ej Z ddZddZddZdd d Zdd d ZddZdddZddZddZeddZeddZeddZeddZdS) ReadOnlyWorksheetrNcCs8||_||_d|_d|_||_||_|t|_dS)Nvisible) parenttitle sheet_state _current_row_worksheet_path_shared_strings _get_sizer defined_names)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 rr.s zReadOnlyWorksheet._get_sizecCs|jj|jS)z0Parse xml source on demand, must close after use)r_archiveopenrrr r rr7szReadOnlyWorksheet._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) rr;r3r5r6 row_widthnew_rowcellr9r:r r rr2gs     zReadOnlyWorksheet._get_rowcCs*|||||D] }|r|dSqtS)z4Cells are returned by a generator which can be emptyr)r=r)rr;r?r r r _get_cells  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_columnr4)rforcer r rcalculate_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?r;r$r#)rr5rrDr r rrHs  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 rreset_dimensionssz"ReadOnlyWorksheet.reset_dimensionscC|jSr )r"r)r r rr4zReadOnlyWorksheet.min_rowcCrQr )r$r)r r rr.rRzReadOnlyWorksheet.max_rowcCrQr )r!r)r r rrJrRzReadOnlyWorksheet.min_columncCrQr )r#r)r r rr-rRzReadOnlyWorksheet.max_column)F)rNF)__name__ __module__ __qualname__r!r"r#r$rrD iter_rowsvaluesrM __getitem____iter__rrrr=r2rErLrHrPpropertyr4r.rJr-r r r rrs6   +     rN)__doc__ worksheetropenpyxl.cell.read_onlyrropenpyxl.utilsr_readerropenpyxl.workbook.defined_namerrobjectrr r r rs