aVg*ddlmZddlmZddlZddlmZmZmZm Z m Z ddl m cm Z ddlmZmZmZddlmZddlmZmZer ddlmZdd lmZGd d eZy) ) annotations) defaultdictN) TYPE_CHECKINGAny DefaultDictTuplecast)FilePathStorageOptionsWriteExcelBuffer) ExcelWriter)combine_kwargsvalidate_freeze_panesOpenDocumentSpreadsheet) ExcelCellceZdZdZdZ d dfd ZedZejddZeddZ ddZ d ddZ dd Z dd Z dd Z dd ZxZS) ODSWriterodf)z.odsc  ddlm} |dk(r tdt ||||||t || }| di||_i|_y)Nrraz&Append mode is not supported with odf!)modestorage_optionsif_sheet_exists engine_kwargs)odf.opendocumentr ValueErrorsuper__init__r_book _style_dict) selfpathengine date_formatdatetime_formatrrrrkwargsr __class__s [/var/www/html/hubwallet-dev/venv/lib/python3.12/site-packages/pandas/io/excel/_odswriter.pyr zODSWriter.__init__$sa = 3;EF F  ++'  '}f= ,=}= +-c|jS)z Book instance of class odf.opendocument.OpenDocumentSpreadsheet. This attribute can be used to access engine-specific features. )r!)r#s r*bookzODSWriter.bookBszzr+c2|j||_y)zO Set book instance. Class type will depend on the engine used. N)_deprecate_set_bookr!)r#others r*r-zODSWriter.bookKs   " r+cddlm}|jj|Dcic]}|j d|}}|Scc}w)z(Mapping of sheet names to sheet objects.r)Tablename) odf.tabler2r-getElementsByType getAttribute)r#r2sheetresults r*sheetszODSWriter.sheetsSsQ $44U;    v & -    sAc|jjD]'}|jjj |)|jj |j jy)z( Save workbook to disk. N)r9valuesr- spreadsheet addElementsave_handleshandle)r#r7s r*_savezODSWriter._save^sR[['') 4E II ! ! , ,U 3 4 t}}++,r+cddlm}m}m}ddlm} |j |}|J||jvr|j|} n.||} |jjj| t|r/ttttf|}|j||t!|D]} | j|t#|} t#t} t%|dD] }| |j&s3t!|D]%} | |j&j|'t!|j(| |j&z D]<} | |j&j|| |j&xxdz cc<>|j+|\}}| |j&j|| |j&xxdz cc<| | }|j|t-| dkDr?t!t/| j1dzD]}| j| |yy) z1 Write the frame cells using odf r)r2 TableCellTableRow)PNr3c2|j|jfS)N)rowcol)cells r*z(ODSWriter._write_cells..sDHHdhh3Gr+)key)text)r4r2rCrDodf.textrE_get_sheet_namer9r-r<r=rr rint_create_freeze_panesrangersortedrHrI_make_table_celllenmaxkeys)r#cells sheet_namestartrowstartcol freeze_panesr2rCrDrEwks_rows col_countrJpvaluetcprow_nrs r* _write_cellszODSWriter._write_cellsfs   ))*5 %%%  $++j)CZ(C II ! ! , ,S 1  .c3h>L  % %j, ?x 'A NN8: & '(1!,S!1 5&GH DTXX&x;AN--ik:;488i&99: )TXX)))+6$((#q(# )..t4JFB N % %b ) dhh 1 $ vA MM!  $ t9q=DIIK 01 45 -tF|, - r+ci}|j|j}|||d<|j4|j(t d|j|d<|j|d<|S)a*Convert cell attributes to OpenDocument attributes Parameters ---------- cell : ExcelCell Spreadsheet cell data Returns ------- attributes : Dict[str, Union[int, str]] Dictionary with attributes and attribute values stylenamerMnumberrowsspannednumbercolumnsspanned)_process_stylestyle mergestartmergeendrW)r#rJ attributes style_names r*_make_table_cell_attributesz%ODSWriter._make_table_cell_attributessk,. ((4  !&0J{ # ?? &4==+D.1!T__.EJ* +15J- .r+cddlm}|j|}|j|j\}}|x}}t |t r2t|j}t|j}t |tjr.|j}|jd}||d||fSt |tjrH|jd|jdd|j d}|jd}||d||fStd t"d t$d t d i}|||t'||| fS) aConvert cell data to an OpenDocument spreadsheet cell Parameters ---------- cell : ExcelCell Spreadsheet cell data Returns ------- pvalue, cell : Tuple[str, TableCell] Display value, Cell value r)rCz%cdate) valuetype datevaluero-02dz%xstringfloatboolean)rtvaluero)r4rCrq_value_with_fmtval isinstanceboolstrlowerupperdatetime isoformatstrftimersyearmonthdayrQrytype) r#rJrCror}fmtrbr{class_to_cell_types r*rUzODSWriter._make_table_cellsI (55d; ''1S c4 HNN$EX^^%F c8,, -MMOE\\$'FFe S X]] +xxj#))C#''#?E\\$'FFe S  XWwi " 0c;) r+cddlm}m}m}m}|yt j |}||jvr|j|Sdt|jdz}||j|<||d}d|vr/|d} | jd d r|j|d d |vrA|d } | jD])\} } d di} |j|d| | | i+d|vr[|d}|jd}|r|j|||jd}|r|j|||jjj||S)a Convert a style dictionary to a OpenDocument style sheet Parameters ---------- style : Dict Style dictionary Returns ------- style_key : str Unique style key for later reference in sheet r)ParagraphPropertiesStyleTableCellPropertiesTextPropertiesNpdrMz table-cell)r3familyfontboldF) fontweightbordersthinz0.75pt solid #000000border)ro alignment horizontal) textalignvertical) verticalalign) odf.stylerrrrjsondumpsr"rVgetr=itemsr-styles)r#rlrrrr style_keyr3 odf_stylerrside thicknessthickness_translationrrrs r*rkzODSWriter._process_styles   =JJu% (( (##I. .C(()!+,-&*#tL9 U?=Dxx&$$^v%FG  I&G#*==? i)/1G(H%$$'&,TFO5J95U#V  % k*I"|4J$$%8:%NO }}Z0H$$%8x%PQ ##I. r+c ddlm}m}m}m}m}|d}|j jj||d} |j| |} | j| |d} | j| ||} | j| | j|ddd | j|d dd | j|d d t|d | j|dd t|d | j|dd t|d | j|dd t|d y)z Create freeze panes in the sheet. Parameters ---------- sheet_name : str Name of the spreadsheet freeze_panes : tuple of (int, int) Freeze pane location x and y r) ConfigItemConfigItemMapEntryConfigItemMapIndexedConfigItemMapNamed ConfigItemSetzooo:view-settingsrFViewsTablesHorizontalSplitModeshort2)r3rrNVerticalSplitModeHorizontalSplitPositionrQVerticalSplitPositionrM PositionRightPositionBottomN) odf.configrrrrrr-settingsr=r) r#rZr]rrrrrconfig_item_setconfig_item_map_indexedconfig_item_map_entryconfig_item_map_nameds r*rRzODSWriter._create_freeze_panes"sm  (-@A %%o6"6G"D""#:; 2 4**+@A 2 A(()>? 2 C(()>?(( 1c J  (( /gC H  (( .U\RS_AU  (( ,5sR S  (( ,5srsM"#!  . 81{ { r+