Ë
    ž…j(  ã                   óê   — d dl Z d dlZd dlZd dlZd dlmZ d dl	m
Z
 d dlmZ  ej                  d«      Zej                  d„ «       Zd„ Zd„ Zd„ Zej(                  j+                  d	g d
¢«      d„ «       Zy)é    N)Ú	ExcelFile)Úinspect_excel_formatÚxlrdc                   ó   — y)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   ó    ú`/root/aria/tools/markitdown-venv/lib/python3.12/site-packages/pandas/tests/io/excel/test_xlrd.pyÚread_ext_xlrdr
      s   € ð r   c                 óH  — d}d} |dddd«      }t         j                  |«      5 }t        ||¬«      5 }t        j                  ||d¬	«      }d d d «       t        j                  |||d¬
«      }d d d «       t        j                  «       y # 1 sw Y   ŒAxY w# 1 sw Y   Œ,xY w)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˜ ¨+Ó
6€CÜ	×	Ñ	˜CÓ	 ð 
 DÜ�t FÔ+ð 	K¨rÜ—]‘] 2°*ÈÔJˆF÷	Kô —=‘=Ø˜Z°À!ô
ˆ÷	
ô ×Ñ˜& (Õ+÷	Kð 	Kú÷
ð 
ús"   ¥B³BÁ!BÂB	ÂBÂB!c                 ó¬   — ddl m}  | dddd«      }t        j                  |d¬«      5  t	        j
                  |d	¬
«       d d d «       y # 1 sw Y   y xY w)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'   '   sG   € å$á�D˜& '¨<Ó8€DÜ	�‰�yÐ(HÔ	Iñ +Ü
�‰�d 6Õ*÷+÷ +ñ +ús   ©A
Á
Ac                 ó&  —  | dddd«      }t        j                  t        j                  d   j	                  d«      t        j                  dt        j
                  f   dœ«      }t        j                  |d ¬	«      }t        j                  ||«       y )
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   si   € á�D˜& '¨;Ó7€Dä�|‰|¤§¡ d¡× 2Ñ 2°7Ó ;ÄÇÁÀaÌÏÉÀiÑ@PÑQÓR€Hä�]‰]˜4¨Ô-€Fä×Ñ˜& (Õ+r   Úfile_header)s   	    s   	    s   	    s   ÐÏà¡±ác                 óN   — t        j                  | «      }t        |«      dk(  sJ ‚y )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à€v×Ñ˜6Ó"€ð ‡�ñó ðò,ò+ò,ð ‡�×ÑØòóñ,óñ,r   