
    A>i	                         S SK r S SKrS SKrS SKJr  S SKJr  \R                  " S5      r\R                  S 5       r
\R                  S 5       rS rS r\R                  R                  S	S
S/5      S 5       rS rg)    N)	DataFrame)ExcelWriter
xlsxwriterc                      g)Nz.xlsx r       d/var/www/html/land-tabula/venv/lib/python3.13/site-packages/pandas/tests/io/excel/test_xlsxwriter.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                    [         R                  " S5      n[        SS/SS/S.5      n[        U 5       nUR	                  U5        SnUR
                  nUR                  5       S   nUR                  SU05      nUR                  SS U5        S S S 5        [        R                  " UR                  U 5      5       n US   n	S S S 5         W	S
   n
 U
R                  nUW:X  d   eg ! , (       d  f       N^= f! [         a    UR                  SS	9n	 NPf = f! , (       d  f       NZ= f! [         a    W	R                  S
5      n
 Ntf = f! [          a#    U
R"                  R                  R$                  n Nf = f)Nopenpyxli@ )ABz#,##0r   
num_formatzB:BSheet1)nameB2)pytestimportorskipr   r   to_excelbook
worksheets
add_format
set_column
contextlibclosingload_workbook	TypeErrorget_sheet_by_namecellnumber_formatAttributeErrorstyle_format_code)r   r   framewriterr   write_workbookwrite_worksheet
col_formatread_workbookread_worksheetr'   read_num_formats               r	   test_column_formatr4      sr    "":.HVV,FF3CDEE	Y	6v 
(335a8#..j/IJ
""5$
; 
  
		H229=	>-	L*84N 
?)d#
@,, j(((; 
 	  	L*<<(<KN	L 
?	>  )""4()  @**22??@sZ   AC%:D<C6
D& E %
C36DDDD
D#&EE*E43E4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 xlsxwriter!)matchr   a)enginemode)r   raises
ValueErrorr   )r   msgs     r	   test_write_append_mode_raisesr=   @   s-    
9C	z	-Il= 
.	-	-s   1
?nan_inf_to_errorsTFc                     SSU00n[        U SUS9 nUR                  R                  U:X  d   e S S S 5        g ! , (       d  f       g = f)Noptionsr>   r   )r8   engine_kwargs)r   r   r>   )r   r>   rA   r-   s       r	   test_engine_kwargsrB   G   sP     !46G HIM	,m
	{{,,0AAAA
 
 
s	   9
Ac                     [        U SS9 nUR                  0 :X  d   eUR                  R                  S5      nUR                  SU0:X  d   e S S S 5        g ! , (       d  f       g = f)Nr   )r8   	test_name)r   sheetsr   add_worksheet)r   r-   sheets      r	   test_book_and_sheets_consistentrH   Q   sW    	Y|	4}}"""))+6}}e 4444 
5	4	4s   AA
A%)r"   r   r   pandasr   pandas.io.excelr   r   r   fixturer
   r   r4   r=   markparametrizerB   rH   r   r   r	   <module>rN      s        '  .
    $)N> ,tUm<B =B5r   