o
    Û­jÕ
  ã                   @   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   úb/var/www/html/CropPilot/venv/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s¥J ‚W d   ƒ d S 1 s°w   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     

(
