§
    Ò¬¸jÒZ  ã                  ó°  — U d dl mZ d dlmZmZ d dlmZ d dlmZ d dl	m
Z
 d dlmZmZmZmZ d dlmZ d dlmZ d d	lmZ d d
lmZmZmZmZmZ d dlmZmZ d dl m!Z! d dl"m#Z#m$Z$m%Z%m&Z& er>d dlm'Z' d dlm(Z( d dl)m*Z* d dl+m,Z, d dl-m.Z. d dlm/Z/m0Z0m1Z1 d dl2m3Z3m4Z4m5Z5m6Z6m7Z7m8Z8 d dl9m:Z: d†d‡d„Z;dZ<dZ=eded ed!iZ>d"e?d#<    G d$„ d%¦  «        Z@dˆd-„ZAd‰d0„ZBdŠd4„ZCd‹d>„ZDed?d@œdŒdF„¦   «         ZEed�dI„¦   «         ZEdJd@œdŽdL„ZEd�dM„ZFdNdNdOœd�dU„ZGd‘dX„ZHd’d[„ZI	 	 	 	 	 	 	 	 	 d“d”do„ZJd•dq„ZKed?drœd–dv„¦   «         ZLed—dw„¦   «         ZLdxdrœd˜dz„ZL	 d™dxd{œdšd‚„ZMd›d„„ZNdœd…„ZOdNS )�é    )Úannotations)ÚMappingÚSequence)ÚBytesIO)ÚPathLike)ÚPath)ÚIOÚTYPE_CHECKINGÚAnyÚoverload)Ú	functions)Újson)Úqualified_type_name)ÚDateÚDatetimeÚFloat64ÚInt64ÚTime)ÚFLOAT_DTYPESÚINTEGER_DTYPES)ÚDuplicateError)Ú_expand_selector_dictsÚ!_expand_selector_dicts_tuple_keysÚ_expand_selectorsÚnumeric)ÚIterable)ÚLiteral©ÚWorkbook©ÚFormat©Ú	Worksheet)Ú	DataFrameÚSchemaÚSeries)ÚColumnFormatDictÚColumnTotalsDefinitionÚConditionalFormatDictÚOneOrMoreDataTypesÚPolarsDataTypeÚRowTotalsDefinition)ÚExpré   ÚiterableúIterable[Any]ÚnÚintÚreturnc                ó<   — t          t          | ¦  «        g|z  ddiŽS )NÚstrictT)ÚzipÚiter)r/   r1   s     úr/root/private/project/pallet_detection_v2/.venv/lib/python3.11/site-packages/polars/io/spreadsheet/_write_utils.pyÚ_clusterr9   0   s#   € Ý•�h‘”Ð  1Ñ$Ð2¨TÐ2Ð2Ð2ó    z#,##0.000;[Red]-#,##0.000z#,##0;[Red]-#,##0zyyyy-mm-dd hh:mm:sszyyyy-mm-dd;@z
hh:mm:ss;@zdict[PolarsDataType, str]Ú_XL_DEFAULT_DTYPE_FORMATS_c                  ó:   — e Zd ZdZdd„Zedd
„¦   «         Zdd„ZdS )Ú_XLFormatCachezGCreate/cache only one Format object per distinct set of format options.Úwbr   r3   ÚNonec                ó"   — i | _         || _        d S ©N)Ú_cacher>   )Úselfr>   s     r8   Ú__init__z_XLFormatCache.__init__@   s   € Ø)+ˆŒØˆŒˆˆr:   Úfmtúdict[str, Any]Ústrc                ó:   — t          j        | dt          ¬¦  «        S )NT)Ú	sort_keysÚdefault)r   ÚdumpsrG   )rE   s    r8   Ú_keyz_XLFormatCache._keyD   s   € åŒz˜#¨µsÐ;Ñ;Ô;Ð;r:   údict[str, Any] | Formatr!   c                óà   — t          |t          ¦  «        s|}nU|                      |¦  «        }| j                             |¦  «        }|€$| j                             |¦  «        }|| j        |<   |S rA   )Ú
isinstanceÚdictrL   rB   Úgetr>   Ú
add_format)rC   rE   ÚwbfmtÚkeys       r8   rQ   z_XLFormatCache.getH   sh   € Ý˜#�tÑ$Ô$ð 	)ØˆEˆEà—)’)˜C‘.”.ˆCØ”K—O’O CÑ(Ô(ˆEØˆ}Øœ×*Ò*¨3Ñ/Ô/�Ø#(�”˜CÑ Øˆr:   N)r>   r   r3   r?   )rE   rF   r3   rG   )rE   rM   r3   r!   )Ú__name__Ú
__module__Ú__qualname__Ú__doc__rD   ÚstaticmethodrL   rQ   © r:   r8   r=   r=   =   sb   € € € € € ØQÐQðð ð ð ð ð<ð <ð <ñ „\ð<ð	ð 	ð 	ð 	ð 	ð 	r:   r=   Údfr$   ÚcolsúIterable[str]Úmin_maxrF   Úboolc           	     ó4  ‡ — t          ˆ fd„|D ¦   «         ¦  «        }|t          t          t          |¦  «        t          |¦  «        dz   ¦  «        ¦  «        k    rdS ‰ j        }|d         ||d                  dœ|d<   |d         ||d                  dœ|d<   d	S )
z>Indicate if the given columns are all adjacent to one another.c              3  óB   •K  — | ]}‰                      |¦  «        V — Œd S rA   )Úget_column_index)Ú.0Úcolr[   s     €r8   ú	<genexpr>z!_adjacent_cols.<locals>.<genexpr>V   s1   øè è € Ð;Ð;¨s�"×%Ò% cÑ*Ô*Ð;Ð;Ð;Ð;Ð;Ð;r:   é   Fr   )ÚidxÚnameÚminéÿÿÿÿÚmaxT)ÚsortedÚrangeri   rk   Úcolumns)r[   r\   r^   Úidxsrn   s   `    r8   Ú_adjacent_colsrp   T   sŸ   ø€ åÐ;Ð;Ð;Ð;°dÐ;Ñ;Ô;Ñ;Ô;€DØ�v•e�C ™IœI¥s¨4¡y¤y°1¡}Ñ5Ô5Ñ6Ô6Ò6Ð6Øˆuà”*ˆØ!% a¤°'¸$¸q¼'Ô2BÐCÐCˆ�‰Ø!% b¤°7¸4À¼8Ô3DÐEÐEˆ�‰Øˆtr:   Úschemar%   c                ó:   ‡— t          ˆfd„| D ¦   «         ¦  «        S )z4Indicate if the given columns are all integer-typed.c              3  óL   •K  — | ]}‰|                               ¦   «         V — Œd S rA   )Ú
is_integer)rc   rd   rq   s     €r8   re   z$_all_integer_cols.<locals>.<genexpr>b   s3   øè è € Ð8Ð8¨Cˆv�cŒ{×%Ò%Ñ'Ô'Ð8Ð8Ð8Ð8Ð8Ð8r:   )Úall)r\   rq   s    `r8   Ú_all_integer_colsrv   `   s&   ø€ åÐ8Ð8Ð8Ð8°4Ð8Ñ8Ô8Ñ8Ô8Ð8r:   Údú$dict[str | Sequence[str], Any] | Anyúdict[str, Any] | Anyc                óÚ   — t          | t          ¦  «        s| S i }|                      ¦   «         D ]<\  }}t          |t          ¦  «        st          |t          ¦  «        s|f}|D ]}|||<   ŒŒ=|S )zCUnpack multi-col dictionary into equivalent single-col definitions.)rO   rP   ÚitemsrG   r   )rw   ÚunpackedrT   ÚvalueÚks        r8   Ú_unpack_multi_column_dictr   e   s‰   € õ �a�ÑÔð ØˆØ!€HØ—g’g‘i”ið  ð  ‰
ˆˆUÝ�c�3ÑÔð 	¥z°#µxÑ'@Ô'@ð 	Ø�&ˆCØð 	 ð 	 ˆAØˆH�Q‰KˆKð	 à€Or:   Úwsr#   Úconditional_formatsr)   Útable_startútuple[int, int]Úinclude_headerÚformat_cacher?   c               óú  — ddl m} t          | |dd¬¦  «                             ¦   «         D �]M\  }}t	          |¦  «        dk    rt          t          |¦  «        ¦  «        n|}	t          |t          t          f¦  «        r|g}|D ]ô}
t          |
t          ¦  «        sd|
i}
t          |	t          ¦  «        rt          | ||	|¬¦  «        }nKt          | ||	|¬¦  «        }d	|v r4t          t          |	¦  «        ¦  «        }||
d
<   t          | |||¬¦  «        }d|
v rK|
d         }t          ||¦  «        r|n-|                     t          |t          ¦  «        rd|in|¦  «        |
d<   |                     ||
¦  «         Œõ�ŒOdS )zJTake all conditional formatting options and apply them to the table/range.r   r    TF©Úexpand_keysÚexpand_valuesrf   Útype©r„   ú Úmulti_rangeÚformatÚ
num_formatN)Úxlsxwriter.formatr!   r   r{   ÚlenÚnextr7   rO   rG   rP   Ú_xl_column_rangeÚ_xl_column_multi_rangerQ   Úconditional_format)r[   r€   r�   r‚   r„   r…   r!   r\   ÚformatsÚ_colsrE   Ú	col_rangerd   Úfs                 r8   Ú_xl_apply_conditional_formatsrš   t   sß  € ð )Ð(Ð(Ð(Ð(Ð(å:Ø
Ð¨TÀðñ ô ç‚e�g„gð"2ñ "2‰ˆˆgõ %(¨¡I¤I°¢N N••T˜$‘Z”ZÑ Ô Ð ¸ˆÝ�g¥¥T˜{Ñ+Ô+ð 	 Ø�iˆGàð 	2ð 	2ˆCÝ˜c¥4Ñ(Ô(ð $Ø˜s�m�Ý˜%¥Ñ%Ô%ð Ý,Ø˜ U¸>ðñ ô �	�	õ 3Ø˜ U¸>ðñ ô �	ð ˜)Ð#Ð#Ý�t E™{œ{Ñ+Ô+�CØ)2�C˜Ñ&Ý 0Ø˜K¨¸^ð!ñ !ô !�Ið ˜3ˆˆØ˜”M�õ " ! VÑ,Ô,ð�A�Aà%×)Ò)Ý-7¸½3Ñ-?Ô-?ÐF˜ qÐ)Ð)ÀQñô ð �H‘ð ×!Ò! )¨SÑ1Ô1Ð1Ð1ñ7	2ð"2ð "2r:   .)Úas_rangerd   ústr | tuple[int, int]r›   úLiteral[True]rG   c               ó   — d S rA   rZ   ©r[   r‚   rd   r„   r›   s        r8   r“   r“   ¥   s	   € ð ˆ#r:   úLiteral[False]útuple[int, int, int, int]c               ó   — d S rA   rZ   rŸ   s        r8   r“   r“   °   s	   € ð !$ r:   Tútuple[int, int, int, int] | strc               ó€  — |d         t          |¦  «        z   |d         t          |t          ¦  «        r|                      |¦  «        n|d         z   f}|d         | j        z   dz
  |d         t          |t          ¦  «        rdn|d         |d         z
  z   f}|r!d                     t          g |¢|¢R Ž ¦  «        S ||z   S )zKReturn the Excel sheet range of a named column, accounting for all offsets.r   rf   Ú )r2   rO   rG   rb   ÚheightÚjoinÚ_xl_rowcols_to_range)r[   r‚   rd   r„   r›   Ú	col_startÚ
col_finishs          r8   r“   r“   »   sÖ   € ð 	�AŒ�˜^Ñ,Ô,Ñ,Ø�AŒµjÀÅcÑ6JÔ6JÐV˜"×-Ò-¨cÑ2Ô2Ð2ÐPSÐTUÔPVÑWð€Ið
 	�!Œ�r”yÑ  1Ñ$Ø�!Œ�Z¨­SÑ1Ô1ÐH˜˜¸¸A¼ÀÀQÄ¹ÑIð€Jð ð &Ø�wŠwÕ+ÐD¨YÐD¸ÐDÐDÐDÑEÔEÐEà˜:Ñ%Ð%r:   c               óÐ   ‡ ‡‡— i }t          ‰ ||¬¦  «        r-t          ‰ ‰|d         d         |d         d         f‰¬¦  «        S d                     ˆ ˆˆfd„|D ¦   «         ¦  «        S )zNReturn column ranges as an xlsxwriter 'multi_range' string, or spanning range.©r^   ri   rg   rk   r‹   rŒ   c              3  ó>   •K  — | ]}t          ‰‰|‰¬ ¦  «        V — ŒdS )r‹   N)r“   )rc   rd   r[   r„   r‚   s     €€€r8   re   z)_xl_column_multi_range.<locals>.<genexpr>â   sH   øè è € ð ð àõ 	˜˜[¨#¸nÐMÑMÔMðð ð ð ð ð r:   )rp   r“   r§   )r[   r‚   r\   r„   Úms   `` ` r8   r”   r”   Ò   s£   øøø€ ð €AÝ�b˜$¨Ð*Ñ*Ô*ð 
ÝØØØˆuŒX�eŒ_˜a œh uœoÐ.Ø)ð	
ñ 
ô 
ð 	
ð �8Š8ð ð ð ð ð ð àðñ ô ñ ô ð r:   N)ÚdtypeÚexprÚcoldefsr¯   ú1dict[str, PolarsDataType] | PolarsDataType | Noner°   úExpr | Nonec               óâ  ‡‡‡‡— t          | j        ¦  «        Š| j                             ¦   «         }i Š|                     ¦   «         D ]ê\  }}|‰v rd|›d�}t	          |¦  «        ‚t          |t          ¦  «        s|                     |¦  «         ŒI|                     d¦  «        ‰|<   |                     d¦  «        }|                     d¦  «        }	|	€|€|                     |¦  «         Œ¥|€| 	                    |	¦  «        dz   n| 	                    |¦  «        }
| 
                    |
|¦  «         Œë‰€t          j        d¦  «        n‰Š|                      ˆˆˆˆfd„|D ¦   «         ¦  «        } | S )	zHInsert dummy frame columns in order to create empty/named table columns.zcannot create a second z columnÚreturn_dtypeÚinsert_beforeÚinsert_afterNrf   c           
   3  ó.  •K  — | ]�}|‰v r|n„‰s‰                      |¦  «        �Y‰                     ‰                      |t          ‰t          ¦  «        r‰                      |t          ¦  «        n‰¦  «        ¦  «        n‰                     |¦  «        V — Œ�d S rA   )rQ   ÚcastrO   rP   r   Úalias)rc   rd   Úcast_lookupÚdf_original_columnsr¯   r°   s     €€€€r8   re   z1_xl_inject_dummy_table_columns.<locals>.<genexpr>
  sÉ   øè è € ð ð ð ð Ð)Ð)Ð)ð ˆCð ðð )Ÿ_š_¨SÑ1Ô1Ð=ð —	’	Ø—O’OØÝ3=¸eÅTÑ3JÔ3JÐU˜Ÿ	š	 #¥wÑ/Ô/Ð/ÐPUñô ñô ð ð ßŠe�C‰jŒjðð ð ð ð ð r:   )Úsetrn   Úcopyr{   r   rO   rP   ÚappendrQ   ÚindexÚinsertÚFÚlitÚselect)r[   r±   r¯   r°   Údf_select_colsrd   Ú
definitionÚmsgr¶   r·   Ú
insert_idxr»   r¼   s     ``       @@r8   Ú_xl_inject_dummy_table_columnsrÉ   è   s®  øøøø€ õ ˜bœj™/œ/ÐØ”Z—_’_Ñ&Ô&€NØ€Kà"Ÿ=š=™?œ?ð 7ð 7‰ˆˆZØÐ%Ð%Ð%Ø:¨CÐ:Ð:Ð:ˆCÝ  Ñ%Ô%Ð%Ý˜J­Ñ-Ô-ð 	7Ø×!Ò! #Ñ&Ô&Ð&Ð&à)Ÿ~š~¨nÑ=Ô=ˆK˜ÑØ&ŸNšN¨?Ñ;Ô;ˆMØ%Ÿ>š>¨.Ñ9Ô9ˆLàÐ#¨Ð(=Ø×%Ò% cÑ*Ô*Ð*Ð*ð %Ð,ð #×(Ò(¨Ñ6Ô6¸Ñ:Ð:à'×-Ò-¨mÑ<Ô<ð ð
 ×%Ò% j°#Ñ6Ô6Ð6Ð6à˜,�1Œ5�‰;Œ;ˆ;¨D€DØ	�Šð ð ð ð ð ð ð ð "ðñ ô ñ 
ô 
€Bð" €Ir:   ÚparamsúSequence[str] | dict[str, Any]c               óº  — ddl m} i }t          |t          ¦  «        r|                     d¦  «        n|}|sd}	t          |	¦  «        ‚t          |||¬¦  «        sd}	t          |	¦  «        ‚t          ||||d¬¦  «        \  }
}}}|d	         |d
         d         z   }|d	         |d         d         z   }t          |t          ¦  «        si }n<d„ | 	                    ¦   «         D ¦   «         }d|vr|                     d¦  «        dv |d<   t          |j        ¦  «        D ]@} ||
|¦  «        } ||
|¦  «        }|› d|› �|d<   |                      |
||¦  «         |
d	z  }
ŒAdS )z@Inject sparklines into (previously-created) empty table columns.r   ©Úxl_rowcol_to_cellrn   z;supplying 'columns' param value is mandatory for sparklinesr¬   z.sparkline data range/cols must all be adjacentF)r„   r›   rf   ri   rg   rk   c                ó"   — i | ]\  }}|d v¯	||“ŒS ))rn   r·   r¶   rZ   )rc   rh   Úvals      r8   ú
<dictcomp>z)_xl_inject_sparklines.<locals>.<dictcomp>=  s4   € ð 
ð 
ð 
á��cØÐGÐGÐGð �#àGÐGÐGr:   Únegative_pointsrŠ   )ÚcolumnÚwin_lossú:rm   N)Úxlsxwriter.utilityrÎ   rO   rP   rQ   Ú
ValueErrorrp   ÚRuntimeErrorr“   r{   rm   r¦   Úadd_sparkline)r€   r[   r‚   rd   r„   rÊ   rÎ   r®   Ú	data_colsrÇ   Úspk_rowÚspk_colÚ_Údata_start_colÚdata_end_colÚoptionsÚ
data_startÚdata_ends                     r8   Ú_xl_inject_sparklinesrã     sÅ  € ð 5Ð4Ð4Ð4Ð4Ð4à€AÝ)3°F½DÑ)AÔ)AÐM�—
’
˜9Ñ%Ô%Ð%Àv€IØð  ØKˆÝ˜‰oŒoÐÝ˜B 	°1Ð5Ñ5Ô5ð  Ø>ˆÝ˜3ÑÔÐå-Ø
ˆK˜¨^Àeðñ ô Ñ€GˆW�a˜ð ! ”^ a¨¤h¨u¤oÑ5€NØ˜q”> A e¤H¨U¤OÑ3€Lå�f�dÑ#Ô#ð 
WØˆˆð
ð 
à#Ÿ\š\™^œ^ð
ñ 
ô 
ˆð
  GÐ+Ð+Ø)0¯ª°VÑ)<Ô)<Ð@VÐ)VˆGÐ%Ñ&å�2”9ÑÔð ð ˆØ&Ð& w°Ñ?Ô?ˆ
Ø$Ð$ W¨lÑ;Ô;ˆØ(Ð5Ð5¨8Ð5Ð5ˆ�ÑØ
×Ò˜ '¨7Ñ3Ô3Ð3Ø�1‰ˆˆðð r:   Úrow_col_pairsú	list[str]c                 óx   ‡— ddl mŠ ˆfd„t          | ¦  «        D ¦   «         }d„ t          |¦  «        D ¦   «         S )z@Return list of "A1:B2" range refs from pairs of row/col indexes.r   rÍ   c              3  ó6   •K  — | ]\  }} ‰||¦  «        V — Œd S rA   rZ   )rc   Úrowrd   rÎ   s      €r8   re   z'_xl_rowcols_to_range.<locals>.<genexpr>Q  s5   øè è € ÐUÐU±°°cÐ"Ð" 3¨Ñ,Ô,ÐUÐUÐUÐUÐUÐUr:   c                ó"   — g | ]\  }}|› d |› �‘ŒS )rÕ   rZ   )rc   Ú
cell_startÚcell_ends      r8   ú
<listcomp>z(_xl_rowcols_to_range.<locals>.<listcomp>R  s+   € ÐWÐWÐWÑ+?¨:°xˆzÐ&Ð&˜HÐ&Ð&ÐWÐWÐWr:   )rÖ   rÎ   r9   )rä   Ú	cell_refsrÎ   s     @r8   r¨   r¨   M  sR   ø€ à4Ð4Ð4Ð4Ð4Ð4àUÐUÐUÐU½XÀmÑ=TÔ=TÐUÑUÔU€IØWÐWÅ8ÈIÑCVÔCVÐWÑWÔWÐWr:   é   Úcolumn_totalsúColumnTotalsDefinition | NoneÚcolumn_formatsúColumnFormatDict | NoneÚdtype_formatsú$dict[OneOrMoreDataTypes, str] | NoneÚheader_formatúdict[str, Any] | NoneÚ
sparklinesú0dict[str, Sequence[str] | dict[str, Any]] | NoneÚformulasú&dict[str, str | dict[str, str]] | NoneÚ
row_totalsúRowTotalsDefinition | NoneÚfloat_precisionÚtable_styleúdict[str, Any] | str | NoneúHtuple[list[dict[str, Any]], dict[str | tuple[str, ...], str], DataFrame]c                ó¤  ‡ ‡‡‡‡‡ ‡!‡"‡#— d$d„Šˆfd„‰ j                              ¦   «         D ¦   «         }|r‰                      |¦  «        Š t          t	          ‰ ‰dd¬¦  «        ¦  «        Š|sd	}i Š"�n2‰ j         Š#d
„ ‰#                     ¦   «         D ¦   «         Š!t          |t          ¦  «        s£t          ‰!‰#¦  «        rt          nt          }|du r‰!n4t          |t          ¦  «        r|hnt          t          ‰ |¦  «        ¦  «        }t          d„ ‰ j        D ¦   «         ¦  «        }|‰ j        dz  k    rdnd› d�}|t!          ‰ |d¦  «        iŠ"|g}nUt#          ‰ |dd¬¦  «        }ˆ!ˆ#fd„|                     ¦   «         D ¦   «         }ˆ ˆ!fd„|                     ¦   «         D ¦   «         Š"|du r.t%          ¦   «         dit&                               |pdd¦  «        ¥}nVt          |t          ¦  «        rA|                     ¦   «         }t%          ¦   «         |it&                               |pd|¦  «        ¥}t          t          |t&          ¦  «        rt#          ‰ |dd¬¦  «        nt          ‰ |¦  «        ¦  «        }t          |t,          ¦  «        rt&                               |d¦  «        n*t          |t&          ¦  «        r|                     ¦   «         ni Š d„ |pi                      ¦   «         D ¦   «         Št'          ‰pi ¦  «        Št'          |pi ¦  «        }t1          |¦  «        D ]a}t          |t2          t4          f¦  «        rCt&                               ||                     |¦  «        ¦  «        }|                     |¦  «         Œb|                     ¦   «         D ]<}t          |t          ¦  «        s%d|›dt=          |¦  «        ›d�}t?          |¦  «        ‚Œ=|rtA          ‰ |¦  «        Š ‰rtA          ‰ ‰¦  «        Š |rtA          ‰ ‰"|¬¦  «        Š | !                    ddi¦  «        }|
€tD          }tF          }nBtD           $                    dd¦  «        d         }tF           $                    dd¦  «        d         }tJ          D ]}|tL          |<   Œd|	z  }|s|n| '                    dd |› �¦  «        }tL                               ¦   «         D ]\  }}| (                    ||¦  «         ŒtR          D ]}| (                    ||¦  «         Œ‰ j                              ¦   «         D ]X\  }}| *                    ¦   «         }||v r2| !                    |||         ¦  «        }‰ (                    ||¦  «         |‰vr|‰|<   ŒY‰                     ¦   «         D ]™\  }}t          |t          ¦  «        r| !                    |dd!œ¦  «        ‰|<   Œ6t          |t&          ¦  «        rNd"|vr)‰ j          !                    |¦  «        }||v r||         |d"<   d|vrd|d<   | !                    |¦  «        ‰|<   Œš|r| !                    |¦  «        nd	Šˆˆˆˆ ˆ"fd#„‰ j        D ¦   «         }|‰‰ fS )%z7Setup and unify all column-related formatting/defaults.Úsr&   r3   c                óp   — |                       | j        d„ |                      ¦   «         D ¦   «         ¦  «        S )Nc                ó4   — g | ]}|€d nt          |¦  «        ‘ŒS rA   )rG   )rc   Úvs     r8   rì   z=_xl_setup_table_columns.<locals>._map_str.<locals>.<listcomp>g  s&   € ÐJÐJÐJ¸˜a˜i�d�d­S°©V¬VÐJÐJÐJr:   )Ú	__class__rh   Úto_list)r  s    r8   Ú_map_strz)_xl_setup_table_columns.<locals>._map_stre  s6   € Ø�{Š{ØŒFÐJÐJ¸a¿iºi¹k¼kÐJÑJÔJñ
ô 
ð 	
r:   c                óÚ   •— g | ]g\  }}|                      ¦   «         s|                     ¦   «         ¯-t          j        |¦  «                             ‰¦  «                             |¦  «        ‘ŒhS rZ   )Ú	is_nestedÚ	is_objectrÂ   rd   Úmap_batchesrº   )rc   rd   Útpr  s      €r8   rì   z+_xl_setup_table_columns.<locals>.<listcomp>j  sq   ø€ ð ð ð áˆC�Ø�<Š<‰>Œ>ðð  Ÿ\š\™^œ^ðÝ	Œˆc‰
Œ
×Ò˜xÑ(Ô(×.Ò.¨sÑ3Ô3ðð ð r:   TFr‡   Nc                ó@   — h | ]\  }}|                      ¦   «         ¯|’ŒS rZ   )Ú
is_numeric)rc   rd   r  s      r8   ú	<setcomp>z*_xl_setup_table_columns.<locals>.<setcomp>  s)   € ÐMÐMÐM¡  R¸R¿]º]¹_¼_ÐM˜ÐMÐMÐMr:   c              3  óR   K  — | ]"}|r|d          nd                      ¦   «         V — Œ#dS )r   r¥   N)Úisupper©rc   Úcs     r8   re   z*_xl_setup_table_columns.<locals>.<genexpr>�  s;   è è € ÐLÐL¸A 1Ð,˜1˜Qœ4˜4¨"×5Ò5Ñ7Ô7ÐLÐLÐLÐLÐLÐLr:   r.   ÚTÚtÚotalÚsumc                ó`   •— i | ]*\  }}|t          |d u r‰n|‰¦  «        rt          nt          “Œ+S )T)rv   r   r   )rc   Únmr\   Únumeric_colsrq   s      €€r8   rÑ   z+_xl_setup_table_columns.<locals>.<dictcomp>•  sU   ø€ ð  ð  ð  ñ �B˜ð å(¸À¸¸¨¨È4ÐQWÑXÔXð!•E�Eå ð	 ð  ð  r:   c                óF   •— i | ]\  }}|t          ‰|d u r‰n|d¦  «        “ŒS )Tr  )Ú_xl_table_formula)rc   rh   r\   r[   r  s      €€r8   rÑ   z+_xl_setup_table_columns.<locals>.<dictcomp>�  sO   ø€ ð ð ð ñ �D˜$ð Õ'Ø¨°¨¨˜˜¸4À%ñô ðð ð r:   rZ   c                óL   — i | ]!\  }}|t          |t          ¦  «        rd |in|“Œ"S )Úformula)rO   rG   )rc   rd   rà   s      r8   rÑ   z+_xl_setup_table_columns.<locals>.<dictcomp>·  sG   € ð ð ð áˆC�ð 	¥Z°½Ñ%=Ô%=ÐJˆi˜Ð!Ð!À7ðð ð r:   zinvalid dtype_format value: z (expected format string, got ú))r¯   ÚvalignÚvcenterú;rf   r   Ú0z.000ú.)r�   r!  r�   c                ó  •— g | ]{}d „ |‰|         ‰‰                      |¦  «        ‰                      |¦  «        p(‰                      |i ¦  «                              d¦  «        dœ                     ¦   «         D ¦   «         ‘Œ|S )c                ó   — i | ]
\  }}|®||“ŒS rA   rZ   )rc   r~   r  s      r8   rÑ   z6_xl_setup_table_columns.<locals>.<listcomp>.<dictcomp>
  s/   € ð 	
ð 	
ð 	
á��1ð ˆ}ð ˆqð ˆ}ˆ}r:   r  )ÚheaderrŽ   rõ   Útotal_functionr  )rQ   r{   )rc   rd   Úcol_header_formatrñ   Úcolumn_formulasÚcolumn_total_funcsÚrow_total_funcss     €€€€€r8   rì   z+_xl_setup_table_columns.<locals>.<listcomp>	  s­   ø€ ð ð ð ð ð	
ð 	
ð Ø(¨Ô-Ø!2Ø"4×"8Ò"8¸Ñ"=Ô"=à#×'Ò'¨Ñ,Ô,ð CØ&×*Ò*¨3°Ñ3Ô3×7Ò7¸	ÑBÔBð	ð 	÷ Še‰gŒgð	
ñ 	
ô 	
ðð ð r:   )r  r&   r3   r&   )+rq   r{   Úwith_columnsr   r   rO   r   rv   r   r   rG   r½   r   r  rn   Úwidthr  r   r   rP   ÚfromkeysÚlowerr   r¾   ÚlistÚtupleÚ	frozensetÚpopÚupdateÚvaluesr   Ú	TypeErrorrÉ   rQ   Ú_XL_DEFAULT_INTEGER_FORMAT_Ú_XL_DEFAULT_FLOAT_FORMAT_Úsplitr   r;   ÚreplaceÚ
setdefaultr   Ú	base_type)$r[   r…   rï   rñ   ró   rõ   r÷   rù   rû   rý   rþ   Ú	cast_colsÚrow_totals_dtypeÚsum_colsÚn_ucaseÚtotalÚfnr  ÚupdatesrE   rÇ   Úfmt_defaultÚint_base_fmtÚflt_base_fmtÚzerosÚ	fmt_floatrd   r>  Útable_columnsr  r*  r+  r,  r  r-  rq   s$   `  `                         @@@@@@@r8   Ú_xl_setup_table_columnsrL  U  s˜  øøøøøøøøø€ ð 
ð 
ð 
ð 
ð
ð ð ð à”y—’Ñ(Ô(ðñ ô €Ið
 ð (Ø�_Š_˜YÑ'Ô'ˆõ /Ý)Ø�¨DÀð	
ñ 	
ô 	
ñô €Nð ð (ØNRÐØˆ‰à”ˆØMÐM¨6¯<ª<©>¬>ÐMÑMÔMˆÝ˜*¥gÑ.Ô.ð "	å*¨<¸Ñ@Ô@ÐM•�Ågð ð
  Ð%Ð%ð �õ " *­cÑ2Ô2ð@�Z�L�LåÕ.¨r°:Ñ>Ô>Ñ?Ô?ð õ ÐLÐLÀÄÐLÑLÔLÑLÔLˆGØ&¨¬°Q©Ò6Ð6�s�s¸SÐFÐFÐFˆEØ$Õ&7¸¸HÀeÑ&LÔ&LÐMˆOØ˜ˆJˆJå/Ø�J¨EÀðñ ô ˆJð ð  ð  ð  ð  ð !+× 0Ò 0Ñ 2Ô 2ð ñ  ô  Ððð ð ð ð ð #-×"2Ò"2Ñ"4Ô"4ð	ñ ô ˆOð ˜ÐÐÝ ™œ EÐT­T¯]ª]¸:Ð;KÈÈUÑ-SÔ-SÐTˆˆÝ	�M¥3Ñ	'Ô	'ð OØ× Ò Ñ"Ô"ˆÝ ™œ BÐN­$¯-ª-¸
Ð8HÀbÈ"Ñ*MÔ*MÐNˆå-å�m¥TÑ*Ô*ð	2Õ˜r =¸dÐRWÐXÑXÔXÐXå˜r =Ñ1Ô1ñô €Mõ �m¥XÑ.Ô.ð	O��Š�m UÑ+Ô+Ð+å&0°ÅÑ&EÔ&EÐMˆm× Ò Ñ"Ô"Ð"È2ð ðð à%˜^¨×2Ò2Ñ4Ô4ðñ ô €Oõ ˜.Ð.¨BÑ/Ô/€NÝ˜Ð,¨"Ñ-Ô-€Må�=Ñ!Ô!ð *ð *ˆÝ�b�5¥)Ð,Ñ-Ô-ð 	*Ý59·]²]Ø�M×%Ò% bÑ)Ô)ñ6ô 6ˆGð × Ò  Ñ)Ô)Ð)øØ×#Ò#Ñ%Ô%ð !ð !ˆÝ˜#�sÑ#Ô#ð 	!Øs°ÐsÐsÕViÐjmÑVnÔVnÐsÐsÐsˆCÝ˜C‘.”.Ð ð	!ð
 ð <Ý+¨B°
Ñ;Ô;ˆØð AÝ+¨B°Ñ@Ô@ˆØð YÝ+¨B°ÐGWÐXÑXÔXˆð ×"Ò" H¨iÐ#8Ñ9Ô9€KàÐå2ˆÝ0ˆˆõ 3×8Ò8¸¸aÑ@Ô@ÀÔCˆÝ0×6Ò6°s¸AÑ>Ô>¸qÔAˆåð 6ð 6ˆØ)5Õ" 2Ñ&Ð&à�/Ñ!€EØ$)ÐX��¨|×/CÒ/CÀFÈKÐPUÈKÈKÑ/XÔ/X€Iõ .×3Ò3Ñ5Ô5ð *ð *‰ˆˆCØ× Ò   SÑ)Ô)Ð)Ð)Ýð 0ð 0ˆØ× Ò   YÑ/Ô/Ð/Ð/ð ”9—?’?Ñ$Ô$ð .ð .‰ˆˆRØ—L’L‘N”Nˆ	Ø˜Ð%Ð%Ø×#Ò# B¨°iÔ(@ÑAÔAˆCØ×%Ò% c¨3Ñ/Ô/Ð/Ø�nÐ$Ð$Ø"-ˆN˜3Ñøð #×(Ò(Ñ*Ô*ð 8ð 8‰ˆˆSÝ�c�3ÑÔð 	8Ø".×"2Ò"2Ø"¨iÐ8Ð8ñ#ô #ˆN˜3ÑÐõ ˜�TÑ"Ô"ð 		8Ø 3Ð&Ð&ð ”Y—]’] 3Ñ'Ô'�Ø˜Ð&Ð&Ø(5°bÔ(9�C˜Ñ%Ø˜sÐ"Ð"Ø )��H‘Ø".×"2Ò"2°3Ñ"7Ô"7ˆN˜3Ñøð <IÐR˜×(Ò(¨Ñ7Ô7Ð7ÈdÐðð ð ð ð ð ð ð ð ”:ðñ ô €Mð" ˜.¨"Ð,Ð,r:   ú2tuple[dict[str, Any] | str | None, dict[str, Any]]c                óÌ   — t          | t          ¦  «        rJd}| D ]}||vrd|›�}t          |¦  «        ‚Œ|                      ¦   «         }|                     dd¦  «        } ni }| |fS )zESetup table options, distinguishing style name from other formatting.)ÚstyleÚbanded_columnsÚbanded_rowsÚfirst_columnÚlast_columnzinvalid table style key: rO  N)rO   rP   r×   r¾   r5  )rþ   Úvalid_optionsrT   rÇ   Útable_optionss        r8   Ú_xl_setup_table_optionsrV    s‘   € õ �+�tÑ$Ô$ð ð
ˆð ð 	&ð 	&ˆCØ˜-Ð'Ð'Ø9°#Ð9Ð9�Ý  ‘o”oÐ%ð (ð $×(Ò(Ñ*Ô*ˆØ#×'Ò'¨°Ñ6Ô6ˆˆàˆà˜Ð%Ð%r:   ©Úreturn_worksheetr>   r   rX  c               ó   — d S rA   rZ   ©r>   r€   rX  s      r8   Ú_xl_worksheet_in_workbookr[  6  s	   € ð ˆ3r:   c               ó   — d S rA   rZ   rZ  s      r8   r[  r[  :  s	   € ð �r:   Fúbool | Worksheetc               ó¬   ‡— t          ˆfd„|                      ¦   «         D ¦   «         ¦  «        r|r‰ndS d| j        ›d‰j        ›�}t	          |¦  «        ‚)Nc              3  ó    •K  — | ]}‰|u V — Œ	d S rA   rZ   )rc   Úsheetr€   s     €r8   re   z,_xl_worksheet_in_workbook.<locals>.<genexpr>C  s'   øè è € Ð
4Ð
4˜5ˆ2�ˆ;Ð
4Ð
4Ð
4Ð
4Ð
4Ð
4r:   Tzthe given workbook object z  is not the parent of worksheet )ÚanyÚ
worksheetsÚfilenamerh   r×   )r>   r€   rX  rÇ   s    `  r8   r[  r[  @  sh   ø€ õ Ð
4Ð
4Ð
4Ð
4 B§M¢M¡O¤OÐ
4Ñ
4Ô
4Ñ4Ô4ð 0Ø%Ð/ˆrˆr¨4Ð/Ø
a r¤{Ð
aÐ
aÐVXÔV]Ð
aÐ
a€CÝ
�S‰/Œ/Ðr:   )Ú	use_zip64Úworkbookú(Workbook | IO[bytes] | Path | str | NoneÚ	worksheetústr | Worksheet | Nonerd  ú tuple[Workbook, Worksheet, bool]c               ó>  — ddl m} ddlm} t	          | |¦  «        r>| d}}t	          ||¦  «        rt          ||¦  «        r|n|                     |¬¦  «        }�nt	          ||¦  «        rd| ›�}t          |¦  «        ‚|ddt          t                   dœ}	t	          | t          ¦  «        r || |	¦  «        d	d}}}n£| €t          d
¦  «        }
n't	          | t          ¦  «        rt          | ¦  «        }
n| }
t	          |
t          ¦  «        rD|
j        r|
n|
                     d¦  «                             ¦   «                              d¬¦  «        }
 ||
|	¦  «        }d\  }}|€9t	          ||¦  «        rt          ||d¬¦  «        }n|                     |¬¦  «        }|||fS )z2Establish the target Excel workbook and worksheet.r   r   r"   F)rh   zEworksheet object requires the parent workbook object; found workbook=T)rd  Únan_inf_to_errorsÚstrings_to_formulasÚdefault_date_formatNzdataframe.xlsxz.xlsx)r5   )NTrW  )Ú
xlsxwriterr   Úxlsxwriter.worksheetr#   rO   r[  Úget_worksheet_by_namer8  r;   r   r   r   rG   r   ÚsuffixÚwith_suffixÚ
expanduserÚresolveÚadd_worksheet)re  rg  rd  r   r#   r>   Ú	can_closer€   rÇ   Úworkbook_optionsÚfiles              r8   Ú_xl_setup_workbookry  I  s  € ð $Ð#Ð#Ð#Ð#Ð#Ø.Ð.Ð.Ð.Ð.Ð.å�(˜HÑ%Ô%ð *'Ø  %ˆIˆõ ˜9 iÑ0Ô0ð	õ .¨b°)Ñ<Ô<ð	ˆIˆIð ×)Ò)Øð *ñ ô ð 	‰õ 
�I˜yÑ	)Ô	)ð 'ØbÐV^ÐbÐbˆÝ˜‰nŒnÐð #Ø!%Ø#(Ý#=½dÔ#Cð	
ð 
Ðõ �h¥Ñ(Ô(ð 	'Ø ( ¨Ð3CÑ DÔ DÀdÈD�I�ˆBˆBð ÐÝÐ,Ñ-Ô-��Ý˜H¥cÑ*Ô*ð  Ý˜H‘~”~��à�å˜$¥Ñ)Ô)ð à!œ[ÐG�T�T¨d×.>Ò.>¸wÑ.GÔ.Gß’Z‘\”\ß’W E�WÑ*Ô*ð ð
 �˜$Ð 0Ñ1Ô1ˆBØ&‰MˆB�	à	€zÝ�i Ñ+Ô+ð 	2Ý*¨2¨yÈ4ÐPÑPÔPˆBˆBà×!Ò! yÐ!Ñ1Ô1ˆBØˆr�9ÐÐr:   Úfuncc                ó:  — i }t          |t          ¦  «        r|g}t          | ||¬¦  «        r6d|                     ¦   «         › d|d         d         › d|d         d         › d�S d	                     d
„ |D ¦   «         ¦  «        }d|                     ¦   «         › d|› d�S )zIReturn a formula using structured references to columns in a named table.r¬   ú=z([@[ri   rh   z]:[rk   z]])ú,c              3  ó"   K  — | ]
}d |› d�V — ŒdS )z[@[z]]NrZ   r  s     r8   re   z$_xl_table_formula.<locals>.<genexpr>�  s*   è è € Ð5Ð5¨1˜; ˜;˜;˜;Ð5Ð5Ð5Ð5Ð5Ð5r:   ú(r   )rO   rG   rp   Úupperr§   )r[   r\   rz  r®   Úcolrefss        r8   r  r  ‡  s³   € à€AÝ�$�ÑÔð ØˆvˆÝ�b˜$¨Ð*Ñ*Ô*ð -ØO�4—:’:‘<”<ÐOÐO Q u¤X¨fÔ%5ÐOÐO¸!¸E¼(À6Ô:JÐOÐOÐOÐOà—(’(Ð5Ð5°Ð5Ñ5Ô5Ñ5Ô5ˆØ,�4—:’:‘<”<Ð,Ð, 'Ð,Ð,Ð,Ð,r:   c                óò   ‡— dŠt          ¦   «         }|                      ¦   «         D ](}|                     ˆfd„|j        D ¦   «         ¦  «         Œ)t	          |¦  «        }‰› |› �}||v r|dz  }‰› |› �}||v °|S )z4Establish a unique (per-workbook) table object name.ÚFramec              3  ó^   •K  — | ]'}|d                                ‰¦  «        ¯|d          V — Œ(dS )rh   N)Ú
startswith)rc   ÚtblÚtable_prefixs     €r8   re   z(_xl_unique_table_name.<locals>.<genexpr>˜  sR   øè è € ð 
ð 
Ø°°F´×0FÒ0FÀ|Ñ0TÔ0Tð
Ø�ŒKð
ð 
ð 
ð 
ð 
ð 
r:   rf   )r½   rb  r6  Útablesr‘   )r>   Úpolars_tablesr€   r1   Ú
table_namer‡  s        @r8   Ú_xl_unique_table_namer‹  “  sÅ   ø€ à€LÝ!™eœe€MØ�mŠm‰oŒoð 
ð 
ˆØ×Òð 
ð 
ð 
ð 
Ø#%¤9ð
ñ 
ô 
ñ 	
ô 	
ð 	
ð 	
õ 	ˆMÑÔ€AØ Ð% !Ð%Ð%€JØ
˜Ð
%Ð
%Ø	ˆQ‰ˆØ$Ð) aÐ)Ð)ˆ
ð ˜Ð
%Ð
%ð Ðr:   )r.   )r/   r0   r1   r2   r3   r0   )r[   r$   r\   r]   r^   rF   r3   r_   )r\   r]   rq   r%   r3   r_   )rw   rx   r3   ry   )r[   r$   r€   r#   r�   r)   r‚   rƒ   r„   r_   r…   r=   r3   r?   )r[   r$   r‚   rƒ   rd   rœ   r„   r_   r›   r�   r3   rG   )r[   r$   r‚   rƒ   rd   rœ   r„   r_   r›   r    r3   r¡   )r[   r$   r‚   rƒ   rd   rœ   r„   r_   r›   r_   r3   r£   )
r[   r$   r‚   rƒ   r\   r]   r„   r_   r3   rG   )
r[   r$   r±   rF   r¯   r²   r°   r³   r3   r$   )r€   r#   r[   r$   r‚   rƒ   rd   rG   r„   r_   rÊ   rË   r3   r?   )rä   r2   r3   rå   )	NNNNNNNrî   N)r[   r$   r…   r=   rï   rð   rñ   rò   ró   rô   rõ   rö   r÷   rø   rù   rú   rû   rü   rý   r2   rþ   rÿ   r3   r   )rþ   rÿ   r3   rM  )r>   r   r€   r#   rX  r    r3   r_   )r>   r   r€   r#   rX  r�   r3   r#   )r>   r   r€   r#   rX  r_   r3   r]  rA   )re  rf  rg  rh  rd  r_   r3   ri  )r[   r$   r\   r]   rz  rG   r3   rG   )r>   r   r3   rG   )PÚ
__future__r   Úcollections.abcr   r   Úior   Úosr   Úpathlibr   Útypingr	   r
   r   r   Úpolarsr   rÂ   Úpolars._dependenciesr   Úpolars._utils.variousr   Úpolars.datatypesr   r   r   r   r   Úpolars.datatypes.groupr   r   Úpolars.exceptionsr   Úpolars.selectorsr   r   r   r   r   r   rn  r   r�   r!   ro  r#   r$   r%   r&   Úpolars._typingr'   r(   r)   r*   r+   r,   Úpolars.exprr-   r9   r:  r9  r;   Ú__annotations__r=   rp   rv   r   rš   r“   r”   rÉ   rã   r¨   rL  rV  r[  ry  r  r‹  rZ   r:   r8   ú<module>rœ     s   ðØ "Ð "Ð "Ð "Ð "Ð "Ð "à -Ð -Ð -Ð -Ð -Ð -Ð -Ð -Ø Ð Ð Ð Ð Ð Ø Ð Ð Ð Ð Ð Ø Ð Ð Ð Ð Ð Ø 3Ð 3Ð 3Ð 3Ð 3Ð 3Ð 3Ð 3Ð 3Ð 3Ð 3Ð 3à !Ð !Ð !Ð !Ð !Ð !Ø %Ð %Ð %Ð %Ð %Ð %Ø 5Ð 5Ð 5Ð 5Ð 5Ð 5ðð ð ð ð ð ð ð ð ð ð ð ð ð ð @Ð ?Ð ?Ð ?Ð ?Ð ?Ð ?Ð ?Ø ,Ð ,Ð ,Ð ,Ð ,Ð ,ðð ð ð ð ð ð ð ð ð ð ð ð ð !Ø(Ð(Ð(Ð(Ð(Ð(ØÐÐÐÐÐà#Ð#Ð#Ð#Ð#Ð#Ø(Ð(Ð(Ð(Ð(Ð(Ø.Ð.Ð.Ð.Ð.Ð.à0Ð0Ð0Ð0Ð0Ð0Ð0Ð0Ð0Ð0ðð ð ð ð ð ð ð ð ð ð ð ð ð ð ð ð !Ð Ð Ð Ð Ð ð3ð 3ð 3ð 3ð 3ð 8Ð Ø1Ð àÐ#Øˆ.Øˆ,ð9Ð ð ð ð ñ ðð ð ð ð ñ ô ð ð.	ð 	ð 	ð 	ð9ð 9ð 9ð 9ð
ð ð ð ð.2ð .2ð .2ð .2ðb 
ð "ðð ð ð ð ñ 
„ðð 
ð$ð $ð $ñ 
„ð$ð  ð&ð &ð &ð &ð &ð &ð.ð ð ð ð4 @DØð3ð 3ð 3ð 3ð 3ð 3ðl,ð ,ð ,ð ,ð^Xð Xð Xð Xð 48Ø.2Ø:>Ø+/ØCGØ7;Ø-1ØØ/3ðE-ð E-ð E-ð E-ð E-ðP&ð &ð &ð &ð2 
àGJðð ð ð ð ñ 
„ðð 
ðð ð ñ 
„ðð >Cðð ð ð ð ð ð )-ð;ð ð	;ð ;ð ;ð ;ð ;ð ;ð|	-ð 	-ð 	-ð 	-ðð ð ð ð ð r:   