
    A>i                        S SK JrJ r   S SKrS SKrS SKrS SKrS SKJr  \R                  " S5      r
\R                  S 5       r\R                  S 5       rS r\R                  R!                  SSS	S
0/5      S 5       rS r\R                  R!                  / SQSSSS\ " SSSSSS5      SSS4\" SSS5      SSS4/S9S 5       rg)    )datedatetimeN)ExcelWriterodfc                      g)Nz.ods r       c/var/www/html/land-tabula/venv/lib/python3.13/site-packages/pandas/tests/io/excel/test_odswriter.pyextr      s    r	   c                 p    U[         R                  " 5        U  3-  nUR                  5         [        U5      $ )N)uuiduuid4touchstr)r   tmp_pathtmps      r
   	tmp_excelr      s-    


~cU+
+CIIKs8Or	   c                     Sn[         R                  " [        US9   [        U SSS9  S S S 5        g ! , (       d  f       g = f)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	-Ie#6 
.	-	-s   1
?engine_kwargskwarg   c                     UbD  [         R                  " S5      n[        R                  " [        US9   [        U SUS9  S S S 5        g [        U SUS9 n S S S 5        g ! , (       d  f       g = f! , (       d  f       g = f)NzDOpenDocumentSpreadsheet() got an unexpected keyword argument 'kwarg'r   r   )r   r   )reescaper   r   	TypeErrorr   )r   r   error_s       r
   test_engine_kwargsr(   $   sy    
  		R
 ]]
 	%}M	
 
 5NRS ON
 
 ONs   AA/
A,/
A=c                     [        U 5       nUR                  0 :X  d   e[        R                  R	                  SS9nUR
                  R                  R                  U5        UR                  SU0:X  d   e S S S 5        g ! , (       d  f       g = f)N	test_name)name)r   sheetsr   tableTablebookspreadsheet
addElement)r   writerr-   s      r
   test_book_and_sheets_consistentr3   7   sm    	Y	6}}"""		[1**51}}e 4444	 
 		s   A)A??
B)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                 p   SSK Jn  SSKJnJn  U" 5       R
                  n[        R                  " U//5      R                  U SSS9  [        R                  " U 5       n	U	R                  R                  S5      n
U
R                  U5      nUS   R                   Vs/ s H*  n[        US5      (       d  M  UR
                  U:X  d  M(  UPM,     nnUS   nUR                  R!                  US45      U:X  d   eUR                  R!                  XS45      U:X  d   e S S S 5        g s  snf ! , (       d  f       g = f)Nr   )OFFICENS)	TableCellTableRowF)headerindexqnamez
value-type)odf.namespacesrA   	odf.tablerB   rC   rF   pd	DataFrameto_excel	ExcelFile_readerget_sheet_by_indexgetElementsByType
childNodeshasattr
attributesget)r   r4   r5   r6   r7   rA   rB   rC   table_cell_namewbsheet
sheet_rowsxsheet_cellscells                  r
   test_cell_value_typer[   @   s   * (
  k''OLL5'$$YuE$J	i	 B

--a0,,X6
  ]--
-q'" '(ww/'A - 	 
 1~""Hl#;<OOO""H#CD
RRR 
!	 
 
!	 s+   >D'D"4D"D"AD'"D''
D5)r   r   r#   r   r   pandasrI   pandas.io.excelr   importorskipr   fixturer   r   r   markparametrizer(   r3   r[   r   r	   r
   <module>rb      s	   
    '%     7 4'1*>? @$5 F2@"&T2r2r2.!		
 
dB	V\<@   S! Sr	   