U
    `»{j¬
  ã                   @   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ddddg¡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
   ú^/var/www/html/bwave/python/venv/lib/python3.8/site-packages/pandas/tests/io/excel/test_xlrd.pyÚread_ext_xlrd   s    r   c           	      C   sš   |}d}d}t  | ¡�z}| ||¡ t |¡�L}t||d��"}tj||dd�}t  ||¡ W 5 Q R X tj|||dd�}W 5 Q R X t  ||¡ W 5 Q R X 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   sv   | ddddƒ}t ddd�d k	}|sLtjtdd	d
�� t|d d� W 5 Q R X n&t d ¡� tj|dd d� W 5 Q R X d S )NÚioÚdataÚexcelú
test1.xlsxÚopenpyxlÚignore©ÚerrorsFz'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_file5   s    ýr(   c              	   C   sx   | ddddƒ}t ddd�d k	}|sNtjtdd	�� tj|d
d d� W 5 Q R X n&t d ¡� tj|d
d d� W 5 Q R X d S )Nr   r   r   r   r   r   r   zYour version of xlrd is )r!   r"   r   )r   ÚpytestZraisesÚ
ValueErrorr   r   r   r#   r%   r
   r
   r   Ú&test_read_excel_warning_with_xlsx_fileE   s    þr+   Úfile_headers   	    s   	    s   	    s   ÐÏà¡±ác                 C   s   t  | ¡}t|ƒdkst‚d S )NZxls)r   ÚBytesIOr   ÚAssertionError)r,   Úfr
   r
   r   Útest_read_old_xls_filesT   s    
r0   )r   r)   Zpandas.compat._optionalr   Zpandasr   Zpandas._testingZ_testingr   Zpandas.io.excelr   Zpandas.io.excel._baser   Zimportorskipr   r   ÚmarkÚfilterwarningsZ
pytestmarkÚextsZfixturer   r   r(   r+   Zparametrizer0   r
   r
   r
   r   Ú<module>   s4   

ÿ

	üþ	