+
    Ĝid%                         ^ RI t ^ RIt^ RIHtHt ^ RIHt ^ RIHtH	t	H
t
HtHtHtHtHtHt ^ RIHt ^ RIHtHt ^ RIHt ^ RIHtHtHt ^ R	IHt ^ R
IHt ^ RI H!t! ^ RI"H#t# ^RI$H%t%  ! R R4      t&R t'R# )    N)ZipFileZIP_DEFLATED)InvalidFileException)	ARC_ROOT_RELSARC_WORKBOOK_RELSARC_APPARC_CORE
ARC_CUSTOMCPROPS_TYPE	ARC_THEME	ARC_STYLEARC_WORKBOOK)SpreadsheetDrawing)tostring
fromstring)Manifest)get_rels_pathRelationshipListRelationship)CommentSheet)write_stylesheet)WorksheetWriter)WorkbookWriter)	theme_xmlc                   l   a  ] tR t^%t o RtR tR tR tR tR t	R t
R tR	 tR
 tR tR tR tRtV tR# )ExcelWriterz)Write a workbook object to an Excel file.c                    W n         Wn        \        4       V n        \	        4       V n        . V n        . V n        . V n        . V n	        . V n
        . V n        R # )N)_archiveworkbookr   manifestsetvba_modified_tables_charts_images	_drawings	_comments_pivots)selfr   archives   &&&^/Users/mibo/.openclaw/workspace/.venv-ak/lib/python3.14/site-packages/openpyxl/writer/excel.py__init__ExcelWriter.__init__(   sI      
E    c                n   ^ RI Hp  V P                  pV! 4       pVP                  \        \        VP                  4       4      4       VP                  \        \        V P                  P                  P                  4       4      4       V P                  P                  '       d,   VP                  \        V P                  P                  4       MVP                  \        \        4       \        V P                  P                  4      ^8  dn   VP                  \        \        V P                  P                  P                  4       4      4        ! R R4      pV! 4       pV P                   P#                  V4       V P%                  4        V P'                  4        V P)                  4        V P+                  4        V P-                  4        \/        V P                  4      pVP                  \0        \        V4      4       \3        V P                  4      pVP                  \4        VP7                  4       4       VP                  \8        VP;                  4       4       VP                  \<        VP?                  4       4       V PA                  4        V P                   PC                  W P                  4       R# )r   )ExtendedPropertiesc                   ,    ] tR t^FtR],           t]tRtR# ).ExcelWriter.write_data.<locals>.CustomOverride/ N)	__name__
__module____qualname____firstlineno__r
   pathr   	mime_type__static_attributes__r4   r.   r+   CustomOverrider2   F   s    Z''	r.   r<   N)"openpyxl.packaging.extendedr0   r   writestrr   r   to_treer	   r   
propertiesloaded_themer   r   lencustom_doc_propsr
   r    append_write_worksheets_write_chartsheets_write_images_write_charts_write_external_linksr   r   r   r   write_root_relsr   writer   
write_rels
_merge_vba_write)r)   r0   r*   propsr<   custom_override
stylesheetwriters   &       r+   
write_dataExcelWriter.write_data5   s   B?--"$(5==?";<8DMM,D,D,L,L,N#OP==%%%Y(B(BCY	2t}}--.!3Z$--2P2P2X2X2Z)[\( ( -.OMM  1 !""$%dmm4
HZ$89.(>(>(@Av||~6*F,=,=,?@Wmm4r.   c                   \         P                  ! RP                  R4      4      pV P                  P                  '       d   \        V P                  P                  P                  4       4      V P                  ,
           FZ  pVP                  V4      '       g   K  V P                  P                  W P                  P                  P                  V4      4       K\  	  R# R# )ze
If workbook contains macros then extract associated files from cache
of old file and add to archive
|N)zxl/vbazxl/drawings/.*vmlDrawing\d\.vmlzxl/ctrlPropscustomUIz
xl/activeXzxl/media/.*\.emf)recompilejoinr   vba_archiver!   namelistr"   matchr   r>   read)r)   ARC_VBAnames   &  r+   rM   ExcelWriter._merge_vba`   s    
 **SXXL
  ==$$$DMM55>>@ADDUDUUU==&&MM**41J1J1O1OPT1UV V %r.   c                    V P                    F>  pV P                  P                  VP                  R ,          VP	                  4       4       K@  	  R#    NNN)r%   r   r>   r9   _data)r)   imgs   & r+   rG   ExcelWriter._write_imagesq   s2    <<CMM""388B<=  r.   c                l   \        V P                  4      \        \        V P                  4      4      8w  d   \        R 4      hV P                   Fb  pV P                  P                  VP                  R,          \        VP                  4       4      4       V P                  P                  V4       Kd  	  R# )z8The same chart cannot be used in more than one worksheetrd   N)rB   r$   r!   r   r   r>   r9   r   rN   r    rD   )r)   charts   & r+   rH   ExcelWriter._write_chartsw   st    t||C$5 66&'abb\\EMM""5::b>8ELLN3KLMM  ' "r.   c                   V P                   P                  V4       \        V P                   4      Vn        VP                   F8  pV P
                  P                  V4       \        V P
                  4      Vn        K:  	  VP                   F8  pV P                  P                  V4       \        V P                  4      Vn        K:  	  \        VP                  4      R,          pV P                  P                  VP                  R,          \        VP                  4       4      4       V P                  P                  V\        VP                  4       4      4       V P                  P                  V4       R# )z
Write a drawing
rd   N)r&   rD   rB   _idchartsr$   imagesr%   r   r9   r   r>   r   rN   _write_relsr    )r)   drawingrj   rg   	rels_paths   &&   r+   _write_drawingExcelWriter._write_drawing   s     	g&$..)^^ELL&DLL)EI $ >>CLL$$,,'CG " "',,/3	w||B/'..:J1KLy(73F3F3H*IJW%r.   c                   \        V P                  P                  ^4       EF)  w  rWn        \	        VP                  4       4      pV P                  P                  VP                  R,          V4       V P                  P                  V4       VP                  '       g   K  V P                  VP                  4       \        RVP                  P                  R7      p\        4       pVP                  V4       VP                  4       p\        VP                  R,          4      pV P                  P                  V\	        V4      4       EK,  	  R# )re   rd   rq   )typeTargetN)	enumerater   chartsheetsrm   r   r?   r   r>   r9   r    rD   _drawingrs   r   r   r   )r)   idxsheetxmlrelrelstreerr   s   &       r+   rF   ExcelWriter._write_chartsheets   s    #DMM$=$=qAJCI5==?+CMM""5::b>37MM  '~~~##ENN3"	%..:M:MN')C ||~)%**R.9	&&y(4.A# Br.   c                   \         P                  ! VP                  4      pV P                  P                  V4       \	        V P                  4      Vn        V P                  P                  VP                  R ,          \        VP                  4       4      4       V P                  P                  V4       VP                  e   V P                  P                  f$   RP                  VP
                  4      Vn        RpM8\!        V P                  P                  P#                  VP                  4      4      pVP%                  V4      pV P                  P                  VP                  V4       V P&                  P)                  VP                  4       \+        RVP,                  VP                  R7      pVP.                  P                  V4       R# )rd   Nz"xl/drawings/commentsDrawing{0}.vmlcomments)Idrv   rw   )r   from_commentsr'   rD   rB   rm   r   r>   r9   r   r?   r    legacy_drawingr   r[   formatr   r^   write_shapesr"   addr   	_rel_type_rels)r)   wscsvmlcomment_rels   &&   r+   _write_commentExcelWriter._write_comment   s5   ''5b!T^^$rwwr{HRZZ\,BCR $(A(A(I D K KBFF SBCT]]66;;B<M<MNOCooc"r00#6b//0"jr||BGGT
$r.   c                B   \        4       Vn        VP                  VP                  n        VP                  VP                  n        V P                  P                  '       d0   VP                  '       g   VP                  4        VP                  pM\        V4      pVP                  4        VP                  Vn        V P                  P                  VP                  VP                   R ,          4       V P"                  P%                  V4       VP'                  4        R# rc   )r   rz   r$   rn   r%   ro   r   
write_onlyclosedclose_writerr   rK   r   r   outr9   r    rD   cleanup)r)   r   rR   s   && r+   write_worksheetExcelWriter.write_worksheet   s    (*ZZZZ==###999
ZZF$R(FLLN<<FJJ4R r.   c                   \        4       p\        V P                  P                  ^4       EF=  w  r#W#n        V P                  V4       VP                  '       d]   V P                  VP                  4       VP                   F1  pRVP                  9   g   K  VP                  P                  Vn        K3  	  VP                  '       d   V P                  V4       VP                  e;   \        RRRVP                  ,           R7      pVP                  P!                  V4       VP"                  P%                  4        F  pV P"                  P!                  V4       \'        V P"                  4      Vn        VP+                  V P,                  4       V P.                  P!                  V4       VP                  VP                  P1                  VP2                  4      n        K  	  VP4                   EF  pVP6                  V9  d6   VP9                  VP6                  4       \'        V4      VP6                  n        V P4                  P!                  V4       \'        V P4                  4      Vn        VP+                  V P,                  V P.                  4       V P                  P4                  P!                  V4       \        VP:                  VP                  R7      pVP                  P!                  V4       EK	  	  VP                  '       g   EK  VP                  P=                  4       p\?        VP                  4      R,          p	V P,                  PA                  V	\C        V4      4       EK@  	  R# )	re   rq   N
vmlDrawinganysvmlr3   )rv   r   rw   )Typerw   rd   )"r!   rx   r   
worksheetsrm   r   rz   rs   r   r   r9   rw   r'   r   r   r   rD   r#   valuesrB   idrN   r   r    get_rel_idr(   cacher   rel_typer?   r   r>   r   )
r)   pivot_cachesr{   r   r	shape_reltpr   rr   s
   &         r+   rE   ExcelWriter._write_worksheets   sD   u !9!91=GCF  ${{{##BKK0A AFF*#%;;#3#3 " |||##B'  ,(ly03b6G6G0GI		*ZZ&&(##A&4<<('$$Q'12QYY'. ) ZZ77,. $$QWW-"%l"3AGGK##A&DLL)6%%,,Q/ ajj@"   xxxxx''))"''226	&&y(4.AU >r.   c                   V P                   p\        VP                  ^4       F  w  r#W#n        \	        VP
                  R,          4      pVP                  4       pV P                  P                  VP
                  R,          \        V4      4       \        4       pVP                  VP                  4       V P                  P                  V\        VP                  4       4      4       V P                  P                  V4       K  	  R# )z!Write links to external workbooksrd   N)r   rx   _external_linksrm   r   r9   r?   r   r>   r   r   rD   	file_linkr    )r)   wbr{   linkrr   r}   r   s   &      r+   rI   !ExcelWriter._write_external_links  s     ]]"2#5#5q9ICH%diim4I,,.CMM""499R=(3-@#%DKK'MM""9ht||~.FGMM  & :r.   c                Z    V P                  4        V P                  P                  4        R# )zWrite data into the archive.N)rS   r   r   )r)   s   &r+   saveExcelWriter.save  s    r.   )
r   r$   r'   r&   r%   r(   r#   r    r"   r   N)r5   r6   r7   r8   __doc__r,   rS   rM   rG   rH   rs   rF   r   r   rE   rI   r   r;   __classdictcell__)__classdict__s   @r+   r   r   %   sN     3
)5VW">(&$B*%.$.Bb'  r.   r   c                   \        VR\        RR7      p\        P                  P                  \        P                  P
                  R7      P                  RR7      V P                  n        \        W4      pVP                  4        R# )zSave the given workbook on the filesystem under the name filename.

:param workbook: the workbook to save
:type workbook: :class:`openpyxl.workbook.Workbook`

:param filename: the path to which save the workbook
:type filename: string

:rtype: bool

wT)
allowZip64)tzN)tzinfo)r   r   datetimenowtimezoneutcreplacer@   modifiedr   r   )r   filenamer*   rR   s   &&  r+   save_workbookr     sg     h\dCG#+#4#4#8#8H<M<M<Q<Q#8#R#Z#Zbf#Z#gH +F
KKMr.   )(r   rX   zipfiler   r   openpyxl.utils.exceptionsr   openpyxl.xml.constantsr   r   r   r	   r
   r   r   r   r   $openpyxl.drawing.spreadsheet_drawingr   openpyxl.xml.functionsr   r   openpyxl.packaging.manifestr   openpyxl.packaging.relationshipr   r   r   openpyxl.comments.comment_sheetr   openpyxl.styles.stylesheetr   openpyxl.worksheet._writerr   openpyxl.workbook._writerr   themer   r   r   r4   r.   r+   <module>r      s]   
  	 ) ;
 
 
 D 7 0 
 9 7 6 4 o odr.   