uj2cddlmZddlZddlmZmZddlZddlm Z ddl m Z m Z ddl mZmZer"ddlmZddlmZdd lmZdd lmZmZmZmZmZmZGd d e d ZGdde d Zy)) annotationsN) TYPE_CHECKINGAny)import_optional_dependency)BaseExcelReader ExcelWriter)combine_kwargsvalidate_freeze_panesWorkbook) Serialisable)Fill)ExcelWriterIfSheetExistsFilePath ReadBufferScalarStorageOptionsWriteExcelBufferceZdZdZdZ d dfd ZeddZeddZddZ e ddZ e dZ e d Z e d Ze dd Ze d Ze d Ze dZe dZe dZ d ddZ ddZ ddZxZS)OpenpyxlWriteropenpyxl)z.xlsxz.xlsmc  ddlm} t|| }t ||||||d|j vrOddlm}  | |jjfi||_ |jjjdy | di||_ |jjr3|jj!|jjdyy#t$r&|jjjwxYw#t$r&|jjjwxYw)Nrr )modestorage_optionsif_sheet_exists engine_kwargsr+ load_workbook)openpyxl.workbookr r super__init___moderr_handleshandle_book TypeErrorcloseseekbook worksheetsremove) selfpathengine date_formatdatetime_formatrrrrkwargsr r __class__s d/var/www/html/python-recuperauto-other/env/lib/python3.12/site-packages/pandas/io/excel/_openpyxl.pyr#zOpenpyxlWriter.__init__)s /&}f=   ++'   4::  . *4==+?+?Q=Q  MM % %a (  %6 6 yy##   !5!5a!89$  $$**,   $$**, s"C D/D /D>c|jS)z Book instance of class openpyxl.workbook.Workbook. This attribute can be used to access engine-specific features. )r'r.s r5r+zOpenpyxlWriter.bookZszzcr|jjDcic]}||j|}}|Scc}w)z(Mapping of sheet names to sheet objects.)r+ sheetnames)r.nameresults r5sheetszOpenpyxlWriter.sheetscs959II4H4HID$ $'II Js4c&|jj|jjd|jvrTt |jjt j s%|jjjyyy)z( Save workbook to disk. rN)r+saver%r&r$ isinstancemmaptruncater7s r5_savezOpenpyxlWriter._saveis` t}}++, 4:: j1E1Etyy&Q MM ) ) +'R r8cddi}i}|jD]8\}}|j||}t|d|d}||}|s4|||<:|S)a Convert a style_dict to a set of kwargs suitable for initializing or updating-on-copy an openpyxl v2 style object. Parameters ---------- style_dict : dict A dict with zero or more of the following keys (or their synonyms). 'font' 'fill' 'border' ('borders') 'alignment' 'number_format' 'protection' Returns ------- style_kwargs : dict A dict with the same, normalized keys as ``style_dict`` but each value has been replaced with a native openpyxl style object of the appropriate class. bordersborder _convert_to_cyNr )xs r5z9OpenpyxlWriter._convert_to_style_kwargs..sr8)itemsgetgetattr)cls style_dict_style_key_map style_kwargskv _conv_to_xnew_vs r5_convert_to_style_kwargsz'OpenpyxlWriter._convert_to_style_kwargsrss4$X.02 $$& (DAq""1a(A  QC&8.IJqME"' Q  (r8cNddlm}t|tr||S|di|S)a Convert ``color_spec`` to an openpyxl v2 Color object. Parameters ---------- color_spec : str, dict A 32-bit ARGB hex string, or a dict with zero or more of the following keys. 'rgb' 'indexed' 'auto' 'theme' 'tint' 'index' 'type' Returns ------- color : openpyxl.styles.Color r)Colorr )openpyxl.stylesrYr@str)rO color_specrYs r5_convert_to_colorz OpenpyxlWriter._convert_to_colors*, * j# &$ $&:& &r8cddlm}ddddddd }i}|jD]2\}}|j||}|d k(r|j |}|||<4|d i|S) a Convert ``font_dict`` to an openpyxl v2 Font object. Parameters ---------- font_dict : dict A dict with zero or more of the following keys (or their synonyms). 'name' 'size' ('sz') 'bold' ('b') 'italic' ('i') 'underline' ('u') 'strikethrough' ('strike') 'color' 'vertAlign' ('vertalign') 'charset' 'scheme' 'family' 'outline' 'shadow' 'condense' Returns ------- font : openpyxl.styles.Font r)Fontsizebolditalic underline strikethrough vertAlign)szbiustrike vertaligncolorr )rZr_rLrMr])rO font_dictr_ _font_key_map font_kwargsrSrTs r5_convert_to_fontzOpenpyxlWriter._convert_to_fonts8 )%$   OO% DAq!!!Q'AG|))!,KN   "k""r8c.t|j|S)a Convert ``stop_seq`` to a list of openpyxl v2 Color objects, suitable for initializing the ``GradientFill`` ``stop`` parameter. Parameters ---------- stop_seq : iterable An iterable that yields objects suitable for consumption by ``_convert_to_color``. Returns ------- stop : list of openpyxl.styles.Color )mapr])rOstop_seqs r5_convert_to_stopzOpenpyxlWriter._convert_to_stops 3(((33r8crddlm}m}ddddddd}ddi}i}i}|jD]l\}} |j |} |j |} | dvr|j | } | d k(r|j | } | r| || <[| r| || <c| ||<| ||<n |d i|S#t$r |d i|cYSwxYw) a Convert ``fill_dict`` to an openpyxl v2 Fill object. Parameters ---------- fill_dict : dict A dict with one or more of the following keys (or their synonyms), 'fill_type' ('patternType', 'patterntype') 'start_color' ('fgColor', 'fgcolor') 'end_color' ('bgColor', 'bgcolor') or one or more of the following keys (or their synonyms). 'type' ('fill_type') 'degree' 'left' 'right' 'top' 'bottom' 'stop' Returns ------- fill : openpyxl.styles.Fill r) GradientFill PatternFill fill_type start_color end_color) patternType patterntypefgColorfgcolorbgColorbgcolortype)ryrzstopr )rZrvrwrLrMr]rtr() rO fill_dictrvrw_pattern_fill_key_map_gradient_fill_key_map pfill_kwargs gfill_kwargsrSrTpkgks r5_convert_to_fillzOpenpyxlWriter._convert_to_fills2 '&$$"" ! #.v!6  OO% $DAq&**1-B'++A.B11))!,V|((+#$ R #$ R "# Q"# Q $ 0.. . 0/,/ / 0sB""B65B6cddlm}ddi}t|tr ||Si}|j D]2\}}|j ||}|dk(r|j |}|||<4|di|S)a Convert ``side_spec`` to an openpyxl v2 Side object. Parameters ---------- side_spec : str, dict A string specifying the border style, or a dict with zero or more of the following keys (or their synonyms). 'style' ('border_style') 'color' Returns ------- side : openpyxl.styles.Side r)Side border_stylestyle)rrlr )rZrr@r[rLrMr])rO side_specr _side_key_map side_kwargsrSrTs r5_convert_to_sidezOpenpyxlWriter._convert_to_side6s" )'1 i %i( ( OO% DAq!!!Q'AG|))!,KN   "k""r8cddlm}ddd}i}|jD]G\}}|j||}|dk(r|j |}|dvr|j |}|||<I|di|S) aq Convert ``border_dict`` to an openpyxl v2 Border object. Parameters ---------- border_dict : dict A dict with zero or more of the following keys (or their synonyms). 'left' 'right' 'top' 'bottom' 'diagonal' 'diagonal_direction' 'vertical' 'horizontal' 'diagonalUp' ('diagonalup') 'diagonalDown' ('diagonaldown') 'outline' Returns ------- border : openpyxl.styles.Border r)Border diagonalUp diagonalDown) diagonalup diagonaldownrl)leftrighttopbottomdiagonalr )rZrrLrMr]r)rO border_dictr_border_key_map border_kwargsrSrTs r5_convert_to_borderz!OpenpyxlWriter._convert_to_borderWs2 +)5~V %%' !DAq##Aq)AG|))!,BB((+ M!   !& &&r8cddlm}|di|S)a Convert ``alignment_dict`` to an openpyxl v2 Alignment object. Parameters ---------- alignment_dict : dict A dict with zero or more of the following keys (or their synonyms). 'horizontal' 'vertical' 'text_rotation' 'wrap_text' 'shrink_to_fit' 'indent' Returns ------- alignment : openpyxl.styles.Alignment r) Alignmentr )rZr)rOalignment_dictrs r5_convert_to_alignmentz$OpenpyxlWriter._convert_to_alignments& .*>**r8c |dS)aO Convert ``number_format_dict`` to an openpyxl v2.1.0 number format initializer. Parameters ---------- number_format_dict : dict A dict with zero or more of the following keys. 'format_code' : str Returns ------- number_format : str format_coder )rOnumber_format_dicts r5_convert_to_number_formatz(OpenpyxlWriter._convert_to_number_formats "-00r8cddlm}|di|S)a' Convert ``protection_dict`` to an openpyxl v2 Protection object. Parameters ---------- protection_dict : dict A dict with zero or more of the following keys. 'locked' 'hidden' Returns ------- r) Protectionr )rZr)rOprotection_dictrs r5_convert_to_protectionz%OpenpyxlWriter._convert_to_protections /,O,,r8c |j|}i}||jvr|jdk7rd|jvr|jdk(rT|j|}|jj |} |j|=|jj || } n|jdk(rtd|d|jdk(r|j|} nJtd|jd |j|} n!|jj } || _|jjr|j|| |||||y|j|| |||||y) NnewrreplaceerrorzSheet 'z7' already exists and if_sheet_exists is set to 'error'.overlay'z^' is not valid for if_sheet_exists. Valid options are 'error', 'new', 'replace' and 'overlay'.) _get_sheet_namer=_if_sheet_existsr$r+index create_sheet ValueErrortitle write_only_write_cells_write_only_write_cells_normal) r.cells sheet_namestartrowstartcol freeze_panesautofilter_range _style_cacheold_wks target_indexwkss r5 _write_cellszOpenpyxlWriter._write_cellss}))*5 ;=  $)>)>%)Gtzz!((I5"kk*5G#'99??7#;L *-))00\JC**g5$!*.=>**i7++j1C$D1123UU kk*-))((*C"CI 99    ( (    $ $  r8cddlm}ddlm} t |r| |ddz} | |ddz|_i} g} d} |D]x}||j z}||jz}|| kDr|} ||dd}|j|j\|_ }|r||_ i}|jrHt|j}|j|}| |j|j}|||<|r%|j!D]\}}t#||||| j%|i|<|j&|j( | ||jzdz}| ||j(zdz}|||j zdzd|||j&zdz}| j+|{| rpt-| }t/|dzD]T}|| vr|j+g| |}dg| dzz}|j!D] \}}|||< |j+|V| D]}|j0j3||r||j4_yy)Nr)Cell)get_column_letterrowcolumn:)openpyxl.cell.cellropenpyxl.utilsrr rrcol_value_with_fmtvalvalue number_formatrr[rMrWrLsetattr setdefault mergestartmergeendappendmaxrange merged_cellsadd auto_filterref)r.rrrrrrrrr col_letterrows merge_rangesmax_colcellrow_idxcol_idxxcellfmtrRkeyattrrstart_col_letterend_col_letter merge_rangemax_rowrow_data row_cellss r5rz&OpenpyxlWriter._write_cells_write_onlys ,4  .*<?Q+>?J",l1o.A-BCC ,."$ " 1D)G)G !!A.E#33DHH= EK&)#;=Lzz$**o+//4 '#'#@#@#LL(4L%#/#5#5#70KD%E4/05:DOOGR ( 1*t}}/H$5X5H15L#M !28dmm3Ka3O!P'(DHH)3 >3  >3 - >3%>39>3 >3r8rr ceZdZ d d fd Zed dZ d dZed dZddZddZ ddZ d ddZ xZ S)OpenpyxlReaderc@tdt| |||y)a Reader using openpyxl engine. Parameters ---------- filepath_or_buffer : str, path object or Workbook Object to be parsed. storage_options : dict, optional Extra options that make sense for a particular storage connection, e.g. host, port, username, password, etc. For HTTP(S) URLs the key-value pairs are forwarded to ``urllib.request.Request`` as header options. For other URLs (e.g. starting with "s3://", and "gcs://") the key-value pairs are forwarded to ``fsspec.open``. Please see ``fsspec`` and ``urllib`` for more details, and for more examples on storage options refer `here `_. engine_kwargs : dict, optional Arbitrary keyword arguments passed to excel engine. r)rrN)rr"r#)r.filepath_or_bufferrrr4s r5r#zOpenpyxlReader.__init__s(2 #:.  +'  r8cddlm}|S)Nrr )rr )r.r s r5_workbook_classzOpenpyxlReader._workbook_classs %r8c2ddlm}dddd}||fi||zS)NrrTF) read_only data_only keep_links)rr)r.rrrdefault_kwargss r5rzOpenpyxlReader.load_workbooks0 +'+$eT   -  r8ch|jjDcgc]}|jc}Scc}wrI)r+r,r)r.sheets r5 sheet_nameszOpenpyxlReader.sheet_namess$)-)=)=> >>>s/cB|j||j|SrI)raise_if_bad_sheet_by_namer+)r.r;s r5get_sheet_by_namez OpenpyxlReader.get_sheet_by_names ''-yyr8cV|j||jj|SrI)raise_if_bad_sheet_by_indexr+r,)r.rs r5get_sheet_by_indexz!OpenpyxlReader.get_sheet_by_indexs% ((/yy##E**r8cddlm}m}|jy|j|k(rt j S|j|k(r;t|j}||jk(r|St|jS|jS)Nr) TYPE_ERROR TYPE_NUMERIC) rr&r'r data_typenpnanrfloat)r.rr&r'rs r5 _convert_cellzOpenpyxlReader._convert_cellsn ::  ^^z )66M ^^| +djj/Cdjj  $ $zzr8cd}|jjr(|j|jf}|j g}d} t |j D]p\}}|Dcgc]}|j|} }| r#| ddk(r| j| r | ddk(r| r|}|j| |at||k\spn||\|_ |_ |d|dz}t|dkDrKtd|D} td|D| kr$dg} |D cgc]} | | t| z | zz}} |Scc}w#||\|_ |_ wwxYwcc} w)Nrr(rrc32K|]}t|ywrIlen.0data_rows r5 z0OpenpyxlReader.get_sheet_data..s?hCM?c32K|]}t|ywrIr0r2s r5r5z0OpenpyxlReader.get_sheet_data..s6X3x=6r6)r+rr max_columnreset_dimensions enumeraterr-poprr1_max_row _max_columnrmin) r.rfile_rows_neededsaved_dimensionsdatalast_row_with_data row_numberrr converted_row max_width empty_cellr4s r5get_sheet_datazOpenpyxlReader.get_sheet_datasBF 99  !& u/?/?@   " " $#% E#,UZZ#8  CFI Jd!3!3D!9 J J# b(9R(?!%%'$ b(9R(?!)3& M*#/CIAQ4Q  +4D1 1,(1,- t9q=?$??I666B,.4 %)  CM 9ZGG  7!K +4D1 1,s6E%E=&E$E<E E$EEE)NN)rFilePath | ReadBuffer[bytes]rrrrrr)rztype[Workbook])rrHrr )rz list[str])r;r[)rr)rrrI)r?z int | Nonerzlist[list[Scalar]]) rr r r#r rrrr!r$r-rGrrs@r5rrs26/3  8 / -    @  ">    ??+&59*'1* *r8r) __future__rrAtypingrrnumpyr*pandas.compat._optionalrpandas.io.excel._baserrpandas.io.excel._utilr r rr !openpyxl.descriptors.serialisabler rZrpandas._typingrrrrrrrrr r8r5rQsa"  > !>$b 3[,b 3J{_Z0{r8