3
Ud                 @   sb   d dl Z d dlZd dljZd dlmZ e jdZ	e jdZ
e jdddd Zd	d
 Zdd ZdS )    N)	ExcelFilexlrdxlwtT)Zautousec             C   s(   | dkrt jd | dkr$t jd d S )Nz.odszNot valid for xlrdz.xlsb)pytestskip)read_ext r   S/var/www/html/virt/lib64/python3.6/site-packages/pandas/tests/io/excel/test_xlrd.pyskip_ods_and_xlsb_files   s    
r
   c       	      C   s   |}d}d}t j| n}|j|| tj|}t||d"}tj||dd}t j|| W d Q R X tj|||dd}t j|| W d Q R X d S )Nr   ZSheetA)enginer   )
sheet_name	index_col)r   r   r   )	tmZensure_cleanZto_excelr   Zopen_workbookr   pd
read_excelZassert_frame_equal)	r   framedfr   r   pthZbookZxlresultr   r   r	   test_read_xlrd_book   s    
r   c             C   sT   | dddd| }t j|,}tjtj t j|dd W d Q R X W d Q R X d S )NiodataexcelZtest1Zasdf)r   )r   r   r   Zraisesr   Z	XLRDErrorr   )Zdatapathr   pathr   r   r   r	   test_excel_table_sheet_by_index'   s    r   )r   Zpandasr   Zpandas._testingZ_testingr   Zpandas.io.excelr   Zimportorskipr   r   Zfixturer
   r   r   r   r   r   r	   <module>   s   


