
    Mh                     D   S SK r S SKrS SKrS SKJr  S SKrS SKJ	r
  S SKJr  S SKJr  \R                  " S5      r\" 5       (       a  \R"                  R$                  r\R(                  " S/S9S 5       rS	 rS
 rS r\R"                  R3                  S/ SQ5      S 5       rg)    N)is_platform_windows)	ExcelFile)inspect_excel_formatxlrdz.xls)paramsc                     U R                   $ )z
Valid extensions for reading Excel files with xlrd.

Similar to read_ext, but excludes .ods, .xlsb, and for xlrd>2 .xlsx, .xlsm
)param)requests    Q/var/www/html/env/lib/python3.13/site-packages/pandas/tests/io/excel/test_xlrd.pyread_ext_xlrdr      s     ==    c                 J   SnSnU" SSSS5      n[         R                  U5       n[        XRS9 n[        R                  " XcSS	9nS S S 5        [        R                  " XSUSS
9nS S S 5        [
        R                  " WW5        g ! , (       d  f       ND= f! , (       d  f       N7= f)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expecteds	            r   test_read_xlrd_bookr"      s    FJ
4+
6C			C	 Dt+r]]2JF , ==!
	 
! &(+ ,+ 
!	 s"   
BBB
B	B
B"c                     SSK Jn  U " SSSS5      n[        R                  " USS9   [        R
                  " US	S
9  S S S 5        g ! , (       d  f       g = f)Nr   )	XLRDErrorr   r   r   z
test1.xlsxzExcel xlsx file; not supported)matchr   r   )
xlrd.biffhr$   pytestraisesr   r   )r   r$   paths      r   test_read_xlsx_failsr*   ,   s?    $D&'<8D	y(H	I
d6* 
J	I	Is   A
Ac                 $   U " SSSS5      n[         R                  " [        R                  S   R	                  S5      [        R                  S[        R
                  4   S.5      n[         R                  " US S	9n[        R                  " X25        g )
Nr   r   r   z	test6.xls)r      int64   )r   r.   )header)	r   	DataFramenpr_astypenanr   r   r   )r   r)   r!   r    s       r   test_nan_in_xlsr5   5   sg    D&';7D||d 2 27 ;ai@PQRH]]4-F&+r   file_header)s   	    s   	    s   	    s   ࡱc                 R    [         R                  " U 5      n[        U5      S:X  d   eg )Nxls)r   BytesIOr   )r6   fs     r   test_read_old_xls_filesr;   @   s%     	

;A"e+++r   )r   numpyr1   r'   pandas.compatr   pandasr   pandas._testing_testingr   pandas.io.excelr   pandas.io.excel._baser   importorskipr   mark
single_cpu
pytestmarkfixturer   r"   r*   r5   parametrizer;    r   r   <module>rJ      s    	   -   % 66"''J x  !,+, ,,r   