o
    i
                     @   s   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dZejdZdgZejed	d
d Zdd Zdd Zdd Zejdg ddd ZdS )    N)import_optional_dependency)	ExcelFile)inspect_excel_formatxlrdxlwtz@ignore:As the xlwt package is no longer maintained:FutureWarningz.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
   Z/var/www/edux/Edux_v2/venv/lib/python3.10/site-packages/pandas/tests/io/excel/test_xlrd.pyread_ext_xlrd   s   r   c           	   
   C   s   |}d}d}t | W}||| t|5}t||d}tj||dd}t || W d    n1 s7w   Y  tj|||dd}W d    n1 sOw   Y  t || W d    d S 1 sew   Y  d S )Nr   SheetAenginer   )
sheet_name	index_col)r   r   r   )	tmensure_cleanto_excelr   open_workbookr   pd
read_excelassert_frame_equal)	r   framedfr   r   pthbookxlresultr
   r
   r   test_read_xlrd_book"   s    "r   c                 C   s   | dddd}t dddd u}|s2tjtdd	d
 t|d d W d    d S 1 s+w   Y  d S td  tj|dd d W d    d S 1 sKw   Y  d S )Niodataexcel
test1.xlsxopenpyxlignoreerrorsFz'The xlrd engine is no longer maintained)raise_on_extra_warningsmatchr   Sheet1)r   r   assert_produces_warningFutureWarningr   r   r   datapathpathhas_openpyxlr
   r
   r   &test_excel_file_warning_with_xlsx_file5   s   ""r1   c                 C   s   | dddd}t dddd u}|s3tjtdd	 tj|d
d d W d    d S 1 s,w   Y  d S td  tj|d
d d W d    d S 1 sLw   Y  d S )Nr    r!   r"   r#   r$   r%   r&   zYour version of xlrd is )r)   r*   r   )r   pytestraises
ValueErrorr   r   r   r+   r-   r
   r
   r   &test_read_excel_warning_with_xlsx_fileE   s   ""r5   file_header)s   	    s   	    s   	    s   ࡱc                 C   s   t | }t|dksJ d S )Nxls)r    BytesIOr   )r6   fr
   r
   r   test_read_old_xls_filesT   s   
r:   )r    r2   pandas.compat._optionalr   pandasr   pandas._testing_testingr   pandas.io.excelr   pandas.io.excel._baser   importorskipr   r   markfilterwarnings
pytestmarkextsfixturer   r   r1   r5   parametrizer:   r
   r
   r
   r   <module>   s.    



		