o
    _~#g
                     @   s   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dZe r,ejjZejdd Zdd	 Zd
d Zejdddgdd Zdd ZdS )    N)is_platform_windows)	DataFrame)ExcelWriter
xlsxwriterc                   C   s   dS )Nz.xlsx r   r   r   /var/www/static.ux5.de/https/Moving-Object-Detection-with-OpenCV/env/lib/python3.10/site-packages/pandas/tests/io/excel/test_xlsxwriter.pyext   s   r   c              
   C   sn  t d}t| }tddgddgd}t|&}|| d}|j}| d }|	d|i}|
dd | W d    n1 sCw   Y  t||}	z|	d }
W n tyf   |	jdd	}
Y nw W d    n1 sqw   Y  z|
d
 }W n ty   |
d
}Y nw z|j}W n ty   |jjj}Y nw ||ksJ W d    d S 1 sw   Y  d S )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_formatr   r   r   test_column_format   s>   




"r,   c              	   C   s   d}t | /}tjt|d t|ddd W d    n1 s!w   Y  W d    d S W d    d S 1 s9w   Y  d S )Nz-Append mode is not supported with xlsxwriter!)matchr   a)enginemode)r   r   r   raises
ValueErrorr   )r   msgfr   r   r   test_write_append_mode_raises?   s   "r5   nan_inf_to_errorsTFc              	   C   s   dd|ii}t | 0}t|d|d}|jj|ksJ W d    n1 s&w   Y  W d    d S W d    d S 1 s>w   Y  d S )Noptionsr6   r   )r/   engine_kwargs)r   r   r   r   r6   )r   r6   r8   r4   r%   r   r   r   test_engine_kwargsG   s   "r9   c              	   C   s   t | =}t|dd}|ji ksJ |jd}|jd|iks#J W d    n1 s-w   Y  W d    d S W d    d S 1 sEw   Y  d S )Nr   )r/   	test_name)r   r   r   sheetsr   add_worksheet)r   r4   r%   sheetr   r   r   test_book_and_sheets_consistentP   s   "r>   )r   r   pandas.compatr   pandasr   pandas._testing_testingr   pandas.io.excelr   r   r   mark
single_cpu
pytestmarkfixturer   r,   r5   parametrizer9   r>   r   r   r   r   <module>   s     

(
