U
    >vf)                     @   s   d dl Z d dlZd dlZd dlmZ d dlmZ d dl	m
Z
 edZdgZejeddd Zd	d
 Zdd Zejdddddgdd ZdS )    N)	ExcelFile)inspect_excel_formatxlrdz.xls)paramsc                 C   s   | j S )z
    Valid extensions for reading Excel files with xlrd.

    Similar to read_ext, but excludes .ods, .xlsb, and for xlrd>2 .xlsx, .xlsm
    )param)request r   C/tmp/pip-unpacked-wheel-vdrwu74i/pandas/tests/io/excel/test_xlrd.pyread_ext_xlrd   s    r
   c           	   
   C   sv   d}d}|dddd}t |@}t||d}tj||dd	}W 5 Q R X tj|||dd
}W 5 Q R X t|| d S )Nr   ZSheet1iodataexcelz	test1.xlsenginer   )
sheet_name	index_col)r   r   r   )r   Zopen_workbookr   pd
read_exceltmZassert_frame_equal)	r
   datapathr   r   pthZbookZxlresultexpectedr   r   r	   test_read_xlrd_book   s       r   c              	   C   sF   ddl m} | dddd}tj|dd tj|d	d
 W 5 Q R X d S )Nr   )	XLRDErrorr   r   r   z
test1.xlsxzExcel xlsx file; not supported)matchr   r   )Z
xlrd.biffhr   pytestZraisesr   r   )r   r   pathr   r   r	   test_read_xlsx_fails(   s    r   file_headers   	    s   	    s   	    s   ࡱc                 C   s   t | }t|dkstd S )NZxls)r   BytesIOr   AssertionError)r   fr   r   r	   test_read_old_xls_files1   s    
r#   )r   r   Zpandasr   Zpandas._testingZ_testingr   Zpandas.io.excelr   Zpandas.io.excel._baser   Zimportorskipr   extsZfixturer
   r   r   markZparametrizer#   r   r   r   r	   <module>   s(   


			