U
|
ý°df ã @ s d dl Z d dlZd dlZd dlmZ d dlmZ d dl m
|
Z
|
e d¡Z dgZ eje ddd Zd d
|
Zd d Zej d ddddg¡dd ZdS )é N)Ú ExcelFile)Úinspect_excel_formatÚxlrdz.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 úVd:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\pandas/tests/io/excel/test_xlrd.pyÚ read_ext_xlrd s r
|
c
|
C sv d}d}|dddd}t |¡@}t||d}tj||dd }W 5 Q R X tj|||dd
|
}W 5 Q R X t ||¡ d S ) Nr ZSheet1ÚioÚdataÚexcelz test1.xls©Úenginer )Ú
|
sheet_nameÚ index_col)r r r )r Z open_workbookr ÚpdÚ
|
read_excelÚtmZassert_frame_equal) r
|
Údatapathr r ÚpthZbookZxlÚresultÚexpectedr r r Útest_read_xlrd_book s ÿr c C sF ddl m} | dddd}tj|dd tj|d d
|
W 5 Q R X d S ) Nr )Ú XLRDErrorr r r z
|
test1.xlsxz Excel xlsx file; not supported)Úmatchr r )Z
|
xlrd.biffhr ÚpytestZraisesr r )r r Úpathr r r Útest_read_xlsx_fails( s r Ú file_headers s s s ÐÏࡱác C s t | ¡}t|dkstd S )NZxls)r ÚBytesIOr ÚAssertionError)r Úfr r r Útest_read_old_xls_files1 s
|
r# )r r Zpandasr Zpandas._testingZ_testingr Zpandas.io.excelr Zpandas.io.excel._baser Z importorskipr ÚextsZfixturer
|
r r ÚmarkZ parametrizer# r r r r Ú<module> s(
|
|
|
üþ
|
