
    A[g
                         d dl Z d dlZd dlmZ d dlmZ d dlmZ d dl	m
Z
  ej                  d      Z e       rej                  j                  Zej                   d        Zd Zd Zej                  j)                  d	d
dg      d        Zd Zy)    N)is_platform_windows)	DataFrame)ExcelWriter
xlsxwriterc                       y)Nz.xlsx r       `/var/www/html/bid-api/venv/lib/python3.12/site-packages/pandas/tests/io/excel/test_xlsxwriter.pyextr      s    r	   c                 *   t        j                  d      }t        j                  |       5 }t	        ddgddgd      }t        |      5 }|j                  |       d}|j                  }|j                         d   }|j                  d|i      }|j                  dd |       d d d        t        j                  |j                  |            5 }		 |	d   }
d d d        	 
d
   }	 |j"                  }|k(  sJ 	 d d d        y # 1 sw Y   `xY w# t        $ r |	j                  d	      }
Y Uw xY w# 1 sw Y   ZxY w# t        $ r 
j!                  d
      }Y sw xY w# t$        $ r# |j&                  j"                  j(                  }Y w xY w# 1 sw Y   y xY w)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	D.DF	D:$E0F	D
	F	D+(D.*D++D..D7	3F	:EF	EF	)FF	FF		Fc                     d}t        j                  |       5 }t        j                  t        |      5  t        |dd       d d d        d d d        y # 1 sw Y   xY w# 1 sw Y   y xY w)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                     dd|ii}t        j                  |       5 }t        |d|      5 }|j                  j                  |k(  sJ 	 d d d        d d d        y # 1 sw Y   xY w# 1 sw Y   y xY w)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%%A.c                    t        j                  |       5 }t        |d      5 }|j                  i k(  sJ |j                  j                  d      }|j                  d|ik(  sJ 	 d d d        d d d        y # 1 sw Y   xY w# 1 sw Y   y xY w)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A?	;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      -   ' V  .
''J  %-P: ,tUm<F =F9r	   