3
Êb_G  ã               @   sP   d dl m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)ÚFilePathOrBufferÚScalar)Úimport_optional_dependencyN)Ú_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‡  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-build-jkwsxyiy/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>/   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_index1   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_name7   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 )z0Parse 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   R   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_dataB   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   r4   z   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?   )r@   r>   rA   rB   rC   )r   Úcellr>   r   r   r   r1   ƒ   s    z_ODFReader._get_column_repeatc             C   s&   x |j D ]}t|j ƒdkrdS qW dS )z+Helper function to find empty rows
        r   FT)r/   r3   )r   r<   Úcolumnr   r   r   r5   ˆ   s    z_ODFReader._is_empty_rowc             C   s0  ddl m} |jj|dfƒ}|dkr8t|ƒdkr4dS dS |d krF| jS |dkrŽt|jj|d	fƒƒ}|d
krrt|ƒS |rŠt|ƒ}||krŠ|S |S |dkr®|jj|d	fƒ}t|ƒS |dkr¾t|ƒS |dkrÞ|jj|d	fƒ}t|ƒS |dk�r|jj|dfƒ}tj	|ƒS |dk�rtj	t|ƒƒj
ƒ S td|› �ƒ‚d S )Nr   )ÚOFFICENSz
value-typeÚbooleanÚTRUETFÚfloatr:   g        Ú
percentageÚstringÚcurrencyÚdatez
date-valueÚtimezUnrecognized type )r@   rF   rB   rC   Ústrr   rI   rA   ÚpdZto_datetimerN   r$   )r   rD   r'   rF   Z	cell_typeZ
cell_valueÚvalr   r   r   r0   ‘   s>    


z_ODFReader._get_cell_value)Ú__name__Ú
__module__Ú__qualname__Ú__doc__r   r
   Úpropertyr   r   rO   r   r   r!   rA   r#   r&   Úboolr   r=   r4   r1   r5   r0   Ú__classcell__r   r   )r   r   r      s   8		r   )Útypingr   Zpandas._typingr   r   Zpandas.compat._optionalr   ZpandasrP   Zpandas.io.excel._baser   r   r   r   r   r   Ú<module>   s
   