
    Pi                        d dl mZm Z  d dlZd dlZd dlZd dlZd dlmZ  ej	        d          Z
ej        d             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)ExcelWriterodfc                      dS )Nz.ods r       x/home/jaya/work/projects/VOICE-AGENT/VIET/agent-env/lib/python3.11/site-packages/pandas/tests/io/excel/test_odswriter.pyextr      s    6r	   c                 |    |t          j                     |  z  }|                                 t          |          S )N)uuiduuid4touchstr)r   tmp_pathtmps      r
   	tmp_excelr      s5    

+c++
+CIIKKKs88Or	   c                     d}t          j        t          |          5  t          | dd           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)pytestraises
ValueErrorr   )r   msgs     r
   test_write_append_mode_raisesr      s    
2C	z	-	-	- 7 7Ie#66667 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7s   >AAengine_kwargskwarg   c                    |\t          j        d          }t          j        t          |          5  t          | d|           d d d            d S # 1 swxY w Y   d S t          | d|          5 }	 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   )reescaper   r   	TypeErrorr   )r   r   error_s       r
   test_engine_kwargsr(   $   sH   
  	R
 
 ]
 
 
 	N 	N 	%}MMMM		N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 	N 5NNN 	RS	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	 	s#   AAA1B  BBc                    t          |           5 }|j        i k    sJ t          j                            d          }|j        j                            |           |j        d|ik    sJ 	 d d d            d S # 1 swxY w Y   d S )N	test_name)name)r   sheetsr   tableTablebookspreadsheet
addElement)r   writerr-   s      r
   test_book_and_sheets_consistentr3   7   s    	Y		 56}""""	[11**5111}e 444444	5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5s   AA::A>A>)valuecell_value_typecell_value_attribute
cell_value)Tbooleanzboolean-valuetrue)test stringstringzstring-valuer:   )r!   floatr4   1)g      ?r<   r4   z1.5i  
   r   z
date-valuez2010-10-10T10:10:10z
2010-10-10)	argvaluesc                    ddl m} ddlm}m}  |            j        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            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)hasattrrG   ).0xtable_cell_names     r
   
<listcomp>z(test_cell_value_type.<locals>.<listcomp>b   sD     
 
 
q'""
 ()w/'A'A 'A'A'Ar	   z
value-type)odf.namespacesrA   	odf.tablerB   rC   rG   pd	DataFrameto_excel	ExcelFile_readerget_sheet_by_indexgetElementsByType
childNodes
attributesget)r   r4   r5   r6   r7   rA   rB   rC   wbsheet
sheet_rowssheet_cellscellrK   s                @r
   test_cell_value_typer^   @   s   * ('''''       
  ikk'OL5'$$YuE$JJJ	i	 	  SB
--a00,,X66

 
 
 
]-
 
 
 1~""Hl#;<<OOOO""H.B#CDD
RRRRRS S S S S S S S S S S S S S S S S Ss   BDD	D)r   r   r#   r   r   pandasrO   pandas.io.excelr   importorskipr   fixturer   r   r   markparametrizer(   r3   r^   r   r	   r
   <module>re      s          
			       ' ' ' ' ' 'f%        7 7 7 4'1*>??  @?$5 5 5 FFF2@"&HT2r2r2..!		
 
dB		V\<@    S S!  S S Sr	   