| Server IP : 209.209.40.120 / Your IP : 216.73.217.112 Web Server : Microsoft-IIS/10.0 System : Windows NT NEWWWW 10.0 build 17763 (Windows Server 2019) i586 User : NEWWWW$ ( 0) PHP Version : 8.3.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Python312/Lib/site-packages/pandas/tests/io/excel/__pycache__/ |
Upload File : |
�
0 �g� � �@ � d dl Z d dlZd dlZd dlmZ d dlZd dlm Z
d dl m Z d dl
mZ ej d� Z e� rej" j$ Z ej( dg�� d� � Zd � Zd
� Zd � Zej" j3 d g d
�� d� � Zy)� N)�is_platform_windows)� ExcelFile)�inspect_excel_format�xlrdz.xls)�paramsc � � | 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)�requests �AC:\Python312\Lib\site-packages\pandas/tests/io/excel/test_xlrd.py�
read_ext_xlrdr s � � �=�=�� c �H � d}d} |dddd� }t j |� 5 }t ||�� 5 }t j ||d� � }d d d � t j |||d�
� }d d d � t j � y # 1 sw Y �AxY w# 1 sw Y �,xY 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 � � ddl m} | dddd� }t j |d�� 5 t j
|d �
� d d d � y # 1 sw Y y xY 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
�
Ac �& � | dddd� }t j t j d j d� t j dt 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_xlsr5 5 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 |� dk( sJ �y )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��v���6�"�������'�'�J� �� � ��x� �� !�� ,� +�,� ��������,��,r