a
    GBìjˆ  ã                   @   sd   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lmZ G d	d
„ d
eƒZdS )z;Write worksheets to xml representations in an optimized wayé    )Úisgenerator)ÚCellÚWriteOnlyCell)Ú_WorkbookChildé   )Ú	Worksheet©ÚWorkbookAlreadySaved)ÚWorksheetWriterc                       sÐ   e Zd ZdZdZdZdZejZej	Z	ej
Z
ejZejZejZejZejZejZejZejZejZejZejZejZejZ‡ fdd„Zedd„ ƒZdd	„ Zd
d„ Zdd„ Zdd„ Zdd„ Zdd„ Z dd„ Z!‡  Z"S )ÚWriteOnlyWorksheetzÊ
    Streaming worksheet. Optimised to reduce memory by writing rows just in
    time.
    Cells can be styled and have comments Styles for rows and columns
    must be applied before writing cells
    FNc                    s&   t ƒ  ||¡ d| _d| _|  ¡  d S )Nr   )ÚsuperÚ__init__Z_max_colZ_max_rowÚ_setup)ÚselfÚparentÚtitle©Ú	__class__© ú]/mnt/bigstor/www/usecases/.venv/lib/python3.9/site-packages/openpyxl/worksheet/_write_only.pyr   .   s    zWriteOnlyWorksheet.__init__c                 C   s   | j S ©N)Ú_WriteOnlyWorksheet__saved©r   r   r   r   Úclosed4   s    zWriteOnlyWorksheet.closedc              	   c   s²   z| j j d¡}W n ty,   |  ¡  Y n0 | d¡�X d}z0dV }|  ||¡}| j  |||¡ |d7 }q@W n ty€   Y n0 W d  ƒ n1 s–0    Y  | j j d¡ dS )z2
        Send rows to the writer's stream
        TZ	sheetDatar   N)	Ú_writerÚxfÚsendÚStopIterationÚ_already_savedÚelementÚ_values_to_rowZ	write_rowÚGeneratorExit)r   r   Úrow_idxÚrowr   r   r   Ú_write_rows9   s    $zWriteOnlyWorksheet._write_rowsc                 C   s"   | j d u rt| ƒ| _ | j  ¡  d S r   )r   r
   Z	write_topr   r   r   r   Ú_get_writerP   s    

zWriteOnlyWorksheet._get_writerc                 C   sT   | j r|  ¡  |  ¡  | jd u r,| j ¡  n
| j ¡  | j ¡  | j ¡  d| _ d S )NT)r   r   r%   Ú_rowsr   Z
write_rowsÚcloseZ
write_tailr   r   r   r   r'   V   s    



zWriteOnlyWorksheet.closec                 C   sX   t |ƒs"t|tttfƒs"|  |¡ |  ¡  | jdu rH|  ¡ | _t	| jƒ | j 
|¡ dS )z^
        :param row: iterable containing values to append
        :type row: iterable
        N)r   Ú
isinstanceÚlistÚtupleÚrangeÚ_invalid_rowr%   r&   r$   Únextr   )r   r#   r   r   r   Úappendg   s    ÿ



zWriteOnlyWorksheet.appendc              	   c   s–   t | ƒ}t|dƒD ]~\}}|du r$qz
||_W n& tyT   t|tƒrL|}nt‚Y n0 ||_||_|jdurv|j	|j_
|V  |jsˆ|jrt | ƒ}qdS )zW
        Convert whatever has been appended into a form suitable for work_rows
        r   N)r   Ú	enumerateÚvalueÚ
ValueErrorr(   r   Úcolumnr#   Z	hyperlinkZ
coordinateÚrefZ	has_style)r   Úvaluesr"   ÚcellZcol_idxr0   r   r   r   r    {   s"    




z!WriteOnlyWorksheet._values_to_rowc                 C   s   t dƒ‚d S )NzHWorkbook has already been saved and cannot be modified or saved anymore.r   r   r   r   r   r   ™   s    z!WriteOnlyWorksheet._already_savedc                 C   s   t d t|ƒ¡ƒ‚d S )NzGValue must be a list, tuple, range or a generator Supplied value is {0})Ú	TypeErrorÚformatÚtype)r   Úiterabler   r   r   r,   �   s    ÿzWriteOnlyWorksheet._invalid_row)#Ú__name__Ú
__module__Ú__qualname__Ú__doc__r   r   r&   r   Z	_rel_typeÚ_pathZ	mime_typeZ_add_rowZ_add_columnZ	add_chartZ	add_imageZ	add_tableZtablesZprint_titlesZprint_title_colsZprint_title_rowsZfreeze_panesZ
print_areaZ
sheet_viewr   r   Úpropertyr   r$   r%   r'   r.   r    r   r,   Ú__classcell__r   r   r   r   r      s<   
r   N)r=   Úinspectr   Zopenpyxl.cellr   r   Zopenpyxl.workbook.childr   Z	worksheetr   Zopenpyxl.utils.exceptionsr	   r   r
   r   r   r   r   r   Ú<module>   s   