
    Mh
                     *   S SK r S SKrS SKJr  S SKJ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S r\R                  R)                  S	S
S/5      S 5       rS rg)    N)is_platform_windows)	DataFrame)ExcelWriter
xlsxwriterc                      g)Nz.xlsx r       W/var/www/html/env/lib/python3.13/site-packages/pandas/tests/io/excel/test_xlsxwriter.pyextr      s    r	   c                 P   [         R                  " S5      n[        R                  " U 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 S S S 5        g ! , (       d  f       Ng= f! [         a    U	R                  SS	9n
 NYf = f! , (       d  f       Nc= f! [         a    W
R!                  S
5      n N}f = f! [$         a#    UR&                  R"                  R(                  n Nf = f! , (       d  f       g = f)Nopenpyxli@ )ABz#,##0r   
num_formatzB:BSheet1)nameB2)pytestimportorskiptmensure_cleanr   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   pathframewriterr   write_workbookwrite_worksheet
col_formatread_workbookread_worksheetr"   read_num_formats                r
   test_column_formatr0      s    "":.H		 07GHI&NN6" !J#[[N,779!<O'22L*3MNJ&&udJ?   6 6t <=P!.x!8 >	-!$'D
	D"00O *,,,A 
	   P!.!@!@h!@!OP >=  	-!&&t,D	-  	D"jj66CCO	D; 
	s   FAD$-FD5DF!E'E'3F
D	FD2/D51D22D55
E	?FE$!F#E$$F'*FFFF
F%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 xlsxwriter!)matchr   a)enginemode)r   r   r   raises
ValueErrorr   )r   msgfs      r
   test_write_append_mode_raisesr:   ?   sL    
9C		]]:S1,S9 2 
	11 
	s!   A!AA!
A	A!!
A/nan_inf_to_errorsTFc                     SSU00n[         R                  " U 5       n[        USUS9 nUR                  R                  U:X  d   e S S S 5        S S S 5        g ! , (       d  f       N= f! , (       d  f       g = f)Noptionsr;   r   )r4   engine_kwargs)r   r   r   r   r;   )r   r;   r>   r9   r)   s        r
   test_engine_kwargsr?   G   si     !46G HIM		<}MQW;;004EEEE N 
	MM 
	s"   A)AA)
A&	"A))
A7c                 0   [         R                  " U 5       n[        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        S S S 5        g ! , (       d  f       N= f! , (       d  f       g = f)Nr   )r4   	test_name)r   r   r   sheetsr   add_worksheet)r   r9   r)   sheets       r
   test_book_and_sheets_consistentrE   P   sv    		<0F==B&&&KK--k:E==[%$8888 1 
	00 
	s#   BAA6%B6
B	 B
B)r   r   pandas.compatr   pandasr   pandas._testing_testingr   pandas.io.excelr   r   r   mark
single_cpu
pytestmarkfixturer   r0   r:   parametrizer?   rE   r   r	   r
   <module>rP      s      -   '  .
''J  %-P: ,tUm<F =F9r	   