a
    é´«j¹  ã                   @   s´   d dl Z d dlZd dlZd dlmZ d dlZd dlm	Z
 d dlmZ d dlmZ e d¡Zeƒ rhejjZejdgd�dd	„ ƒZd
d„ Zdd„ Zdd„ Zej dg d¢¡dd„ ƒZdS )é    N)Úis_platform_windows)Ú	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	   ú^/var/www/html/laksyashrimp/venv/lib/python3.9/site-packages/pandas/tests/io/excel/test_xlrd.pyÚread_ext_xlrd   s    r   c           	   	   C   sž   d}d}|ddddƒ}t  |¡�^}t||d�� }tj||dd	�}W d   ƒ n1 sT0    Y  tj|||dd
�}W d   ƒ n1 s„0    Y  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ÚtmÚassert_frame_equal)	r   Údatapathr   r   ÚpthÚbookZxlÚresultÚexpectedr	   r	   r
   Útest_read_xlrd_book   s    .ÿ$r   c                 C   sZ   ddl m} | ddddƒ}tj|dd�� tj|d	d
� W d   ƒ n1 sL0    Y  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!   c                 C   sT   | ddddƒ}t  tjd  d¡tjdtjf dœ¡}t j|d d	�}t ||¡ d S )
Nr   r   r   z	test6.xls)r   é   Zint64é   )r   r#   )Úheader)	r   Z	DataFrameÚnpZr_ZastypeÚnanr   r   r   )r   r    r   r   r	   r	   r
   Útest_nan_in_xls5   s    (r'   Úfile_header)s   	    s   	    s   	    s   ÐÏà¡±ác                 C   s   t  | ¡}t|ƒdksJ ‚d S )NZxls)r   ÚBytesIOr   )r(   Úfr	   r	   r
   Útest_read_old_xls_files@   s    
r+   )r   Únumpyr%   r   Zpandas.compatr   Zpandasr   Zpandas._testingZ_testingr   Zpandas.io.excelr   Zpandas.io.excel._baser   Zimportorskipr   ÚmarkZ
single_cpuZ
pytestmarkZfixturer   r   r!   r'   Zparametrizer+   r	   r	   r	   r
   Ú<module>   s(   

		þ	