o gM@s^dZddlmZddlmZmZddlmZddlm Z ddl m Z dd Z Gd d d Z d S) z Read worksheets on-demand ) Worksheet) ReadOnlyCell EMPTY_CELL)get_column_letter)WorkSheetParser)DefinedNameDictcCst|g}|SN)rparse_dimensions)sourceparserr W/var/www/html/api-tag/env/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_sourceFc cs6t}|rd}|p |j}|p|j}g}|dur |f|d|}|}d} |P} t| |j|jj|jj|jj |jj d} | D]0\} } |durN| |krNn#t || D] } |d7}|VqS|| krp| | |||} |d7}| Vq@Wdn1s{wY|dur|| krt ||dD] } |VqdSdSdS)zt The source worksheet file may have columns or rows missing. Missing cells will be created. Nr) data_onlyepoch date_formatstimedelta_formats)r max_columnmax_rowrrrrr*r+ _date_formats_timedelta_formatsparserange_get_row)rmin_colmin_rowmax_colr/ values_onlyfiller empty_rowcounteridxr%r row_r r r _cells_by_row<sH   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=r5r7r8 row_widthnew_rowcellr;r<r r rr4is     zReadOnlyWorksheet._get_rowcCs*|||||D] }|r|dSqtS)z4Cells are returned by a generator which can be emptyr)r?r)rr=rAr 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_columnr6)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)rowsmaxrAr=r$r#)rr7rrFr r rrJs  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 rr6zReadOnlyWorksheet.min_rowcCrSr )r$r)r r rr/rTzReadOnlyWorksheet.max_rowcCrSr )r!r)r r rrLrTzReadOnlyWorksheet.min_columncCrSr )r#r)r r rr.rTzReadOnlyWorksheet.max_column)F)rNF)__name__ __module__ __qualname__r!r"r#r$rrF iter_rowsvaluesrO __getitem____iter__rrrr?r4rGrNrJrRpropertyr6r/rLr.r r r rrs6   -     rN)__doc__ worksheetropenpyxl.cell.read_onlyrropenpyxl.utilsr_readerropenpyxl.workbook.defined_namerrrr r r rs