3
®yb¸  ã               @   s\   d dl mZmZ d dlZd dlmZmZ d dlm	Z	 d dl
Zd dlmZ G dd„ deƒZdS )é    )ÚListÚcastN)ÚFilePathOrBufferÚScalar)Úimport_optional_dependency)Ú_BaseExcelReaderc                   sä   e Zd ZdZedœ‡ fdd„Zedd„ ƒZedœdd„Zee	d	œd
d„ƒZ
eee	 d	œdd„ƒZedœdd„Ze	dœdd„Zeeee  dœdd„Zed	œdd„Zed	œdd„Zed	œdd„Zeedœdd„Ze	d	œdd „Z‡  ZS )!Ú
_ODFReaderz¯
    Read tables out of OpenDocument formatted files.

    Parameters
    ----------
    filepath_or_buffer: string, path to be parsed or
        an open readable stream.
    )Úfilepath_or_bufferc                s   t dƒ tƒ j|ƒ d S )NZodf)r   ÚsuperÚ__init__)Úselfr	   )Ú	__class__© ú>/tmp/pip-install-4cy230dp/pandas/pandas/io/excel/_odfreader.pyr      s    z_ODFReader.__init__c             C   s   ddl m} |S )Nr   )ÚOpenDocument)Úodf.opendocumentr   )r   r   r   r   r   Ú_workbook_class   s    z_ODFReader._workbook_classc             C   s   ddl m} ||ƒS )Nr   )Úload)r   r   )r   r	   r   r   r   r   Úload_workbook!   s    z_ODFReader.load_workbook)Úreturnc             C   s   dS )z'Property for compat with other readers.Ú r   )r   r   r   r   Úempty_value&   s    z_ODFReader.empty_valuec             C   s&   ddl m} | jj|ƒ}dd„ |D ƒS )z4Return a list of sheet names present in the documentr   )ÚTablec             S   s   g | ]}|j d ƒ‘qS )Úname)ÚgetAttribute)Ú.0Útr   r   r   ú
<listcomp>1   s    z*_ODFReader.sheet_names.<locals>.<listcomp>)Ú	odf.tabler   ÚbookÚgetElementsByType)r   r   Útablesr   r   r   Úsheet_names+   s    z_ODFReader.sheet_names)Úindexc             C   s    ddl m} | jj|ƒ}|| S )Nr   )r   )r   r   r   r    )r   r#   r   r!   r   r   r   Úget_sheet_by_index3   s    z_ODFReader.get_sheet_by_index)r   c             C   sL   ddl m} | jj|ƒ}x|D ]}|jdƒ|kr|S qW td|› d�ƒ‚d S )Nr   )r   r   zsheet z
 not found)r   r   r   r    r   Ú
ValueError)r   r   r   r!   Útabler   r   r   Úget_sheet_by_name9   s    
z_ODFReader.get_sheet_by_name)Úconvert_floatr   c                s˜  ddl m}m}m} |ƒ j}|ƒ j}||h‰ |j|ƒ}d}	d}
g }�xt|ƒD �]\}}‡ fdd„|jD ƒ}d}g }xvt|ƒD ]j\}}|j|krž| j||ƒ}n| j	}| j
|ƒ}|| j	krÂ||7 }q~|j| j	g| ƒ d}|j|g| ƒ q~W |
t|ƒk �rt|ƒ}
| j|ƒ}| j|ƒ�r"|	|7 }	qN|j| j	gg|	 ƒ d}	xt|ƒD ]}|j|ƒ �qDW qNW x6|D ].}t|ƒ|
k �rb|j| j	g|
t|ƒ  ƒ �qbW |S )z9
        Parse an ODF Table into a list of lists
        r   )ÚCoveredTableCellÚ	TableCellÚTableRowc                s   g | ]}|j ˆ kr|‘qS r   )Úqname)r   Úx)Ú
cell_namesr   r   r   U   s    z-_ODFReader.get_sheet_data.<locals>.<listcomp>)r   r)   r*   r+   r,   r    Ú	enumerateÚ
childNodesÚ_get_cell_valuer   Ú_get_column_repeatÚextendÚlenÚ_get_row_repeatÚ_is_empty_rowÚrangeÚappend)r   Zsheetr(   r)   r*   r+   Zcovered_cell_nameZtable_cell_nameZ
sheet_rowsZ
empty_rowsZmax_row_lenr&   ÚiZ	sheet_rowZsheet_cellsZempty_cellsZ	table_rowÚjZ
sheet_cellÚvalueZcolumn_repeatZ
row_repeatÚ_Úrowr   )r.   r   Úget_sheet_dataD   sF    







 z_ODFReader.get_sheet_datac             C   s"   ddl m} t|jj|dfdƒƒS )z«
        Return number of times this row was repeated
        Repeating an empty row appeared to be a common way
        of representing sparse rows in the table.
        r   )ÚTABLENSznumber-rows-repeatedé   )Úodf.namespacesr?   ÚintÚ
attributesÚget)r   r=   r?   r   r   r   r5   }   s    z_ODFReader._get_row_repeatc             C   s"   ddl m} t|jj|dfdƒƒS )Nr   )r?   znumber-columns-repeatedr@   )rA   r?   rB   rC   rD   )r   Úcellr?   r   r   r   r2   ‡   s    z_ODFReader._get_column_repeatc             C   s&   x |j D ]}t|j ƒdkrdS qW dS )z4
        Helper function to find empty rows
        r   FT)r0   r4   )r   r=   Úcolumnr   r   r   r6   Œ   s    z_ODFReader._is_empty_rowc             C   sD  ddl m} t|ƒdkrtjS |jj|dfƒ}|dkrJt|ƒdkrFdS dS |d krX| jS |d	kr�t|jj|d
fƒƒ}|rŒt	|ƒ}||krŒ|S |S |dkr°|jj|d
fƒ}t|ƒS |dkrÂ| j
|ƒS |dkrâ|jj|d
fƒ}t|ƒS |dk�r|jj|dfƒ}tj|ƒS |dk�r2tjt|ƒƒ}ttj|ƒ}|jƒ S td|› �ƒ‚d S )Nr   )ÚOFFICENSz#N/Az
value-typeÚbooleanÚTRUETFÚfloatr;   Ú
percentageÚstringÚcurrencyÚdatez
date-valueÚtimezUnrecognized type )rA   rG   ÚstrÚnpÚnanrC   rD   r   rJ   rB   Ú_get_cell_string_valueÚpdZto_datetimer   Z	TimestamprO   r%   )r   rE   r(   rG   Z	cell_typeZ
cell_valueÚvalÚresultr   r   r   r1   –   sB    



z_ODFReader._get_cell_valuec       	      C   s¤   ddl m} ddlm} ddlm} |ƒ j}g }xh|jD ]^}t||ƒrˆ|j|krvt	|j
j|dfdƒƒ}|jd| ƒ q–|j| j|ƒƒ q8|jt|ƒƒ q8W dj|ƒS )	z„
        Find and decode OpenDocument text:s tags that represent
        a run length encoded sequence of space characters.
        r   )ÚElement)ÚTEXTNS)ÚSÚcr@   ú r   )Zodf.elementrW   rA   rX   Zodf.textrY   r,   r0   Ú
isinstancerB   rC   rD   r8   rS   rP   Újoin)	r   rE   rW   rX   rY   Ztext_sr;   ÚfragmentÚspacesr   r   r   rS   ½   s    

z!_ODFReader._get_cell_string_value)Ú__name__Ú
__module__Ú__qualname__Ú__doc__r   r   Úpropertyr   r   rP   r   r   r"   rB   r$   r'   Úboolr   r>   r5   r2   r6   r1   rS   Ú__classcell__r   r   )r   r   r      s    9

'r   )Útypingr   r   ZnumpyrQ   Zpandas._typingr   r   Zpandas.compat._optionalr   ZpandasrT   Zpandas.io.excel._baser   r   r   r   r   r   Ú<module>   s   