
    bMh                        d dl mZm Z  d dlZd dlZd dlmZ d dlZd dlm	Z
 d dlmZ  ej        d          Z e            rej        j        Zej        d             Zd Zej                            ddd	d
ig          d             Zd Zej                            g ddddd e dddddd          dddf eddd          dddfg          d             ZdS )    )datedatetimeN)is_platform_windows)ExcelWriterodfc                      dS )Nz.ods r	       d/var/www/html/test/jupyter/venv/lib/python3.11/site-packages/pandas/tests/io/excel/test_odswriter.pyextr      s    6r
   c                     d}t          j        |           5 }t          j        t          |          5  t          |dd           d d d            n# 1 swxY w Y   d d d            d S # 1 swxY w Y   d S )Nz&Append mode is not supported with odf!matchr   a)enginemode)tmensure_cleanpytestraises
ValueErrorr   )r   msgfs      r   test_write_append_mode_raisesr      s    
2C			 3]:S111 	3 	3%c2222	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	3 	33 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3s4   A*AA*A	A*A	A**A.1A.engine_kwargskwarg   c                 n   t          j        |           5 }|Zt          j        d          }t	          j        t          |          5  t          |d|           d d d            n# 1 swxY w Y   n+t          |d|          5 }	 d d d            n# 1 swxY w Y   d d d            d S # 1 swxY w Y   d S )NzDOpenDocumentSpreadsheet() got an unexpected keyword argument 'kwarg'r   r   )r   r   )r   r   reescaper   r   	TypeErrorr   )r   r   r   error_s        r   test_engine_kwargsr$   #   s   
 
		 $IV E    J J Ae=IIII	J J J J J J J J J J J J J J J QuMJJJ a                               sY   2B*A&B*&A*	*B*-A*	.B*BB*B	B*B	B**B.1B.c                 f   t          j        |           5 }t          |          5 }|j        i k    sJ t          j                            d          }|j        j        	                    |           |j        d|ik    sJ 	 d d d            n# 1 swxY w Y   d d d            d S # 1 swxY w Y   d S )N	test_name)name)
r   r   r   sheetsr   tableTablebookspreadsheet
addElement)r   r   writerr)   s       r   test_book_and_sheets_consistentr/   7   s-   			 9^^ 	9v=B&&&&IOOO55EK#..u555=[%$888888		9 	9 	9 	9 	9 	9 	9 	9 	9 	9 	9 	9 	9 	9 	99 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9s5   B&ABB&B	B&B	B&&B*-B*)valuecell_value_typecell_value_attribute
cell_value)Tbooleanzboolean-valuetrue)test stringstringzstring-valuer6   )r   floatr0   1)g      ?r8   r0   z1.5i  
   r   z
date-valuez2010-10-10T10:10:10z
2010-10-10)	argvaluesc                 v   ddl m} ddlm}m}  |            j        t          j        |           5 }t          j	        |gg          
                    |dd           t          j        |          5 }	|	j                            d          }
|
                    |          }fd|d         j        D             }|d         }|j                            |df          |k    sJ |j                            ||f          |k    sJ 	 d d d            n# 1 swxY w Y   d d d            d S # 1 swxY w Y   d S )Nr   )OFFICENS)	TableCellTableRowF)headerindexc                 J    g | ]}t          |d           r|j        k    | S )qname)hasattrrC   ).0xtable_cell_names     r   
<listcomp>z(test_cell_value_type.<locals>.<listcomp>b   sD       1g&& ,-7o+E+E +E+E+Er
   z
value-type)odf.namespacesr=   	odf.tabler>   r?   rC   r   r   pd	DataFrameto_excel	ExcelFile_readerget_sheet_by_indexgetElementsByType
childNodes
attributesget)r   r0   r1   r2   r3   r=   r>   r?   r   wbsheet
sheet_rowssheet_cellscellrG   s                 @r   test_cell_value_typerZ   A   s   & ('''''       
  ikk'O			 W
ugY((5(FFF\!__ 	WJ11!44E00::J   #A1  K q>D?&&,'?@@OSSSS?&&2F'GHHJVVVVV	W 	W 	W 	W 	W 	W 	W 	W 	W 	W 	W 	W 	W 	W 	WW W W W W W W W W W W W W W W W W Ws7   AD.4BD
D.D	D.D	D..D25D2)r   r   r   r   pandas.compatr   pandasrK   pandas._testing_testingr   pandas.io.excelr   importorskipr   mark
single_cpu
pytestmarkfixturer   r   parametrizer$   r/   rZ   r	   r
   r   <module>rf      s          
			  - - - - - -           ' ' ' ' ' 'f%   ('J   3 3 3 4'1*>??  @?&9 9 9 FFF2@"&HT2r2r2..!		
 
dB		V\<@    W W!  W W Wr
   