o
    _~#g                     @   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/static.ux5.de/https/Moving-Object-Detection-with-OpenCV/env/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*    

			