o
    Û­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ƒ r4e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/CropPilot/venv/lib/python3.10/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 s*w   Y  tj|||dd
�}W d   ƒ n1 sBw   Y  t ||¡ d S )Nr   ÚSheet1ÚioÚdataÚexcelz	test1.xls©Úenginer   )Ú
sheet_nameÚ	index_col)r   r   r   )r   Úopen_workbookr   ÚpdÚ
read_excelÚtmÚassert_frame_equal)	r   Údatapathr   r   ÚpthÚbookÚxlÚresultÚexpectedr	   r	   r
   Útest_read_xlrd_book   s   ÿÿür   c                 C   s\   ddl m} | ddddƒ}tj|dd�� tj|d	d
� W d   ƒ d S 1 s'w   Y  d S )Nr   )Ú	XLRDErrorr   r   r   z
test1.xlsxzExcel xlsx file; not supported)Úmatchr   r   )Ú
xlrd.biffhr    ÚpytestÚ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   é   Úint64é   )r   r)   )Úheader)	r   Ú	DataFrameÚnpÚr_ÚastypeÚnanr   r   r   )r   r%   r   r   r	   r	   r
   Útest_nan_in_xls5   s   (r0   Úfile_header)s   	    s   	    s   	    s   ÐÏà¡±ác                 C   s   t  | ¡}t|ƒdksJ ‚d S )NÚxls)r   ÚBytesIOr   )r1   Úfr	   r	   r
   Útest_read_old_xls_files@   s   
r5   )r   Únumpyr,   r#   Úpandas.compatr   Úpandasr   Úpandas._testingÚ_testingr   Úpandas.io.excelr   Úpandas.io.excel._baser   Úimportorskipr   ÚmarkÚ
single_cpuÚ
pytestmarkÚfixturer   r   r&   r0   Úparametrizer5   r	   r	   r	   r
   Ú<module>   s*    

		þ	