
    Mh                        S SK JrJ r   S SKrS SKrS SKJr  S SKrS SKJ	r
  S SKJr  \R                  " S5      r\" 5       (       a  \R                  R                   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)is_platform_windows)ExcelWriterodfc                      g)Nz.ods r	       V/var/www/html/env/lib/python3.13/site-packages/pandas/tests/io/excel/test_odswriter.pyextr      s    r
   c                     Sn[         R                  " U 5       n[        R                  " [        US9   [        USSS9  S S S 5        S S S 5        g ! , (       d  f       N= f! , (       d  f       g = f)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      sL    
2C		]]:S1%c2 2 
	11 
	s!   A!AA!
A	A!!
A/engine_kwargskwarg   c                 `   [         R                  " U 5       nUbD  [        R                  " S5      n[        R
                  " [        US9   [        USUS9  S S S 5        O[        USUS9 n S S S 5        S S S 5        g ! , (       d  f       N= f! , (       d  f       N(= f! , (       d  f       g = f)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    
 
	$IIVE  Ae=I	  QuMJa K 
	
  KJ 
	s;   3B
A=B*B,B=
B	B
B	B
B-c                    [         R                  " U 5       n[        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        S S S 5        g ! , (       d  f       N= f! , (       d  f       g = f)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    		^v==B&&&IIOOO5EKK##..u5==[%$8888	  
	^ 
	s#   B/A)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           	         SSK Jn  SSKJnJn  U" 5       R
                  n[        R                  " U 5       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        S S S 5        g s  snf ! , (       d  f       N= f! , (       d  f       g = f)Nr   )OFFICENS)	TableCellTableRowF)headerindexqnamez
value-type)odf.namespacesr=   	odf.tabler>   r?   rB   r   r   pd	DataFrameto_excel	ExcelFile_readerget_sheet_by_indexgetElementsByType
childNodeshasattr
attributesget)r   r0   r1   r2   r3   r=   r>   r?   table_cell_namer   wbsheet
sheet_rowsxsheet_cellscells                   r   test_cell_value_typerW   A   s3   & (
  k''O		
ugY((5(F\\!_JJ11!4E00:J $A111A1g& +,77o+E 1   q>D??&&,'?@OSSS??&&'GHJVVV  
	 _ 
	sB   >E4>E2EEE#AE0EE
E	E
E%)r   r   r   r   pandas.compatr   pandasrE   pandas._testing_testingr   pandas.io.excelr   importorskipr   mark
single_cpu
pytestmarkfixturer   r   parametrizer$   r/   rW   r	   r
   r   <module>rc      s   
  -   '% ''J  3 4'1*>? @&9 F2@"&T2r2r2.!		
 
dB	V\<@   W! Wr
   