o ϩZhM@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 T/var/www/html/lang_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) parenttitleZ sheet_stateZ _current_row_worksheet_path_shared_strings _get_sizerZ defined_names)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 rr.s zReadOnlyWorksheet._get_sizecCs|jj|jS)z0Parse xml source on demand, must close after use)rZ_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_onlyepochZ date_formatsZtimedelta_formats)r max_columnmax_rowrrrrr#r$Z _date_formatsZ_timedelta_formatsparserange_get_row)rmin_colmin_rowmax_colr& values_onlyZfillerZ empty_rowcounteridxrr 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) rr0r*r,r-Z row_widthZnew_rowcellr.r/r r rr)is     zReadOnlyWorksheet._get_rowcCs*|||||D] }|r|dSqtS)z4Cells are returned by a generator which can be emptyr)r2r)rr0r4r 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_columnr+)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. rr3N)rowsmaxr4r0rr)rr,rr7r r rr;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 rreset_dimensionssz"ReadOnlyWorksheet.reset_dimensionscC|jSr )rr"r r rr+zReadOnlyWorksheet.min_rowcCrDr )rr"r r rr&rEzReadOnlyWorksheet.max_rowcCrDr )rr"r r rr=rEzReadOnlyWorksheet.min_columncCrDr )rr"r r rr%rEzReadOnlyWorksheet.max_column)F)rNF)__name__ __module__ __qualname__rrrrrr7Z iter_rowsvaluesr@ __getitem____iter__rrrr2r)r8r?r;rCpropertyr+r&r=r%r r r rrs6   -     rN)__doc__Z worksheetrZopenpyxl.cell.read_onlyrrZopenpyxl.utilsr_readerrZopenpyxl.workbook.defined_namerrrr r r rs