a
    GBìjM  ã                   @   s^   d Z ddlmZ ddlmZmZ ddlmZ ddlm	Z	 ddl
mZ dd	„ ZG d
d„ dƒZdS )z Read worksheets on-demand
é   )Ú	Worksheeté    )ÚReadOnlyCellÚ
EMPTY_CELL)Úget_column_letter)ÚWorkSheetParser)ÚDefinedNameDictc                 C   s   t | g ƒ}| ¡ S ©N)r   Úparse_dimensions)ÚsourceÚparser© r   ú\/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/openpyxl/worksheet/_read_only.pyÚread_dimension   s    
r   c                   @   s¾   e Zd ZdZdZd ZZejZej	Z	ej
Z
ejZejZejZdd„ Zdd„ Zdd„ Zdd
d„Zddd„Zdd„ Zd dd„Zdd„ Zdd„ Zedd„ ƒZedd„ ƒZedd„ ƒZedd„ ƒZdS )!ÚReadOnlyWorksheetr   Nc                 C   s8   || _ || _d| _d | _|| _|| _|  ¡  tƒ | _d S )NÚvisible)	ÚparentÚtitleZsheet_stateZ_current_rowÚ_worksheet_pathÚ_shared_stringsÚ	_get_sizer   Zdefined_names)ÚselfZparent_workbookr   Zworksheet_pathZshared_stringsr   r   r   Ú__init__#   s    zReadOnlyWorksheet.__init__c                 C   sB   |   ¡ }t|g ƒ}| ¡ }| ¡  |d ur>|\| _| _| _| _d S r	   )Ú_get_sourcer   r
   ÚcloseÚ_min_columnÚ_min_rowÚ_max_columnÚ_max_row)r   Úsrcr   Ú
dimensionsr   r   r   r   .   s    
zReadOnlyWorksheet._get_sizec                 C   s   | j j | j¡S )z0Parse xml source on demand, must close after use)r   Z_archiveÚopenr   ©r   r   r   r   r   7   s    zReadOnlyWorksheet._get_sourceFc              	   c   s2  t }|rd}|p| j}|p| j}g }|dur>|f|d |  }|}d}	|  ¡ � }
t|
| j| jj| jj| jj	| jj
d�}| ¡ D ]`\}	}|durš|	|krš qàt||	ƒD ]}|d7 }|V  q¤||	kr~|  ||||¡}|d7 }|V  q~W d  ƒ n1 sô0    Y  |du�r.||	k �r.t||d ƒD ]}|V  �q dS )zt
        The source worksheet file may have columns or rows missing.
        Missing cells will be created.
        Nr   )Ú	data_onlyÚepochZdate_formatsZtimedelta_formats)r   Ú
max_columnÚmax_rowr   r   r   r   r#   r$   Z_date_formatsZ_timedelta_formatsÚparseÚrangeÚ_get_row)r   Úmin_colÚmin_rowÚmax_colr&   Úvalues_onlyZfillerZ	empty_rowÚcounterÚidxr   r   ÚrowÚ_r   r   r   Ú_cells_by_row<   s>    


û&zReadOnlyWorksheet._cells_by_rowc           
      C   sž   |s|sdS |p|d d }|d | }t g| }|r@dg| }|D ]P}|d }||  krd|krDn qD|| }	|d ||	< |sDt| fi |¤Ž||	< qDt|ƒS )zT
        Make sure a row contains always the same number of cells or values
        r   éÿÿÿÿÚcolumnr   NÚvalue)r   r   Útuple)
r   r0   r*   r,   r-   Z	row_widthZnew_rowÚcellr.   r/   r   r   r   r)   i   s    

zReadOnlyWorksheet._get_rowc                 C   s*   |   ||||¡D ]}|r|d   S qtS )z4Cells are returned by a generator which can be emptyr   )r2   r   )r   r0   r4   r   r   r   Ú	_get_cell‚   s    zReadOnlyWorksheet._get_cellc                 C   sL   t | j| jgƒs&|r|  ¡  ntdƒ‚t| jƒ› | j› dt| jƒ› | j› �S )Nz9Worksheet is unsized, use calculate_dimension(force=True)ú:)Úallr%   r&   Ú_calculate_dimensionÚ
ValueErrorr   Ú
min_columnr+   )r   Úforcer   r   r   Úcalculate_dimensionŠ   s
    
z%ReadOnlyWorksheet.calculate_dimensionc                 C   s<   d}| j D ]}|sq
|d }t||jƒ}q
|j| _|| _dS )z€
        Loop through all the cells to get the size of a worksheet.
        Do this only if it is explicitly requested.
        r   r3   N)ÚrowsÚmaxr4   r0   r   r   )r   r,   Úrr7   r   r   r   r;   “   s    
z&ReadOnlyWorksheet._calculate_dimensionc                 C   s   d | _ | _dS )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_dimensions¤   s    z"ReadOnlyWorksheet.reset_dimensionsc                 C   s   | j S r	   )r   r"   r   r   r   r+   ­   s    zReadOnlyWorksheet.min_rowc                 C   s   | j S r	   )r   r"   r   r   r   r&   ²   s    zReadOnlyWorksheet.max_rowc                 C   s   | j S r	   )r   r"   r   r   r   r=   ·   s    zReadOnlyWorksheet.min_columnc                 C   s   | j S r	   )r   r"   r   r   r   r%   ¼   s    zReadOnlyWorksheet.max_column)F)r   NF)F)Ú__name__Ú
__module__Ú__qualname__r   r   r   r   r   r7   Z	iter_rowsÚvaluesr@   Ú__getitem__Ú__iter__r   r   r   r2   r)   r8   r?   r;   rC   Úpropertyr+   r&   r=   r%   r   r   r   r   r      s4   	
-

		


r   N)Ú__doc__Z	worksheetr   Zopenpyxl.cell.read_onlyr   r   Zopenpyxl.utilsr   Z_readerr   Zopenpyxl.workbook.defined_namer   r   r   r   r   r   r   Ú<module>   s   