a
    nÝEbÌ  ã                   @   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 d dlmZ d dlmZ e d¡Ze d¡Zej d	¡Ze
ed
ƒkr”dgZng d¢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)Úxlrd_version)ÚVersion)Ú	ExcelFile)Úinspect_excel_formatÚxlrdÚxlwtz@ignore:As the xlwt package is no longer maintained:FutureWarningÚ2ú.xls)r
   z.xlsxz.xlsm)Ú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   ú_/home/ja/django-apps/lartica_env/lib/python3.9/site-packages/pandas/tests/io/excel/test_xlrd.pyÚread_ext_xlrd   s    r   c           	   	   C   s¶   |}d}d}t  | ¡�Œ}| ||¡ t |¡}t||d��,}tj||dd�}t  ||¡ W d   ƒ n1 sl0    Y  tj|||dd�}t  ||¡ W d   ƒ n1 s¨0    Y  d S )Nr   ZSheetA©Úenginer   )Ú
sheet_nameÚ	index_col)r   r   r   )	ÚtmZensure_cleanZto_excelr   Zopen_workbookr   ÚpdÚ
read_excelZassert_frame_equal)	r   ÚframeZdfr   r   ÚpthÚbookZxlÚresultr   r   r   Útest_read_xlrd_book(   s    
*r   c                 C   sž   | ddddƒ}t ddd�d u}|s`tjtdd	d
�� t|d d� W d   ƒ qš1 sT0    Y  n:t d ¡�  tj|dd d� W d   ƒ n1 s�0    Y  d S )NÚioÚdataÚexcelú
test1.xlsxÚopenpyxlÚignore©ÚerrorsFú'The xlrd engine is no longer maintained©Zraise_on_extra_warningsÚmatchr   ÚSheet1)r   r   Úassert_produces_warningÚFutureWarningr   r   r   ©ÚdatapathÚpathZhas_openpyxlr   r   r   Ú&test_excel_file_warning_with_xlsx_file:   s    ý,r.   c                 C   sî   | ddddƒ}t ddd�d u}|s°ttdƒkrntjtd	d
��  tj|dd d� W d   ƒ q®1 sb0    Y  qêtj	t
ddd��  tj|dd d� W d   ƒ qê1 s¤0    Y  n:t 	d ¡�  tj|dd d� W d   ƒ n1 sà0    Y  d S )Nr   r   r   r    r!   r"   r#   r	   zYour version of xlrd is )r'   r(   r   Fr%   r&   )r   r   r   ÚpytestZraisesÚ
ValueErrorr   r   r   r)   r*   r+   r   r   r   Ú&test_read_excel_warning_with_xlsx_fileJ   s"    þ0ý0r1   Úfile_header)s   	    s   	    s   	    s   ÐÏà¡±ác                 C   s   t  | ¡}t|ƒdksJ ‚d S )NZxls)r   ÚBytesIOr   )r2   Úfr   r   r   Útest_read_old_xls_filesa   s    
r5   )r   r/   Zpandas.compat._optionalr   Zpandasr   Zpandas._testingZ_testingr   Zpandas.tests.io.excelr   Zpandas.util.versionr   Zpandas.io.excelr   Zpandas.io.excel._baser   Zimportorskipr   r   ÚmarkÚfilterwarningsZ
pytestmarkÚextsZfixturer   r   r.   r1   Zparametrizer5   r   r   r   r   Ú<module>   s4   

ÿ

	þ	