
    A>i(                         S SK r S SKrS SKrS SKrS SKJr  S SK	J
r
  S SKJr  \R                  " S5      r\R                  S 5       rS rS rS r\R(                  R+                  S	/ S
Q5      S 5       rg)    N)	ExcelFile)inspect_excel_formatxlrdc                      g)z
Valid extensions for reading Excel files with xlrd.

Similar to read_ext, but excludes .ods, .xlsb, and for xlrd>2 .xlsx, .xlsm
z.xls r       ^/var/www/html/land-tabula/venv/lib/python3.13/site-packages/pandas/tests/io/excel/test_xlrd.pyread_ext_xlrdr
      s     r   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_xlsr2   0   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   )r3   fs     r	   test_read_old_xls_filesr8   ;   s%     	

;A"e+++r   )r   numpyr.   r$   pandasr   pandas._testing_testingr   pandas.io.excelr   pandas.io.excel._baser   importorskipr   fixturer
   r   r'   r2   markparametrizer8   r   r   r	   <module>rC      s|    	     % 66"  ,+, ,,r   