
    .i(                         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       ]/var/www/app/trading-bot/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+
6C			C	  
DtF+ 	Kr]]2*JF	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&'<8D	y(H	I +
d6*+ + +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&';7D||d 2 27 ;ai@PQRH]]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   