d)ddlmZddlmZddlZddlmZmZmZm Z m Z ddl m Z ddl mZmZmZddlmZddlmZmZerdd lmZGd d eZdS) ) annotations) defaultdictN) TYPE_CHECKINGAny DefaultDictTuplecast)json)FilePathStorageOptionsWriteExcelBuffer) ExcelWriter)combine_kwargsvalidate_freeze_panes) ExcelCellceZdZdZdZ d*d+fd ZedZed,dZd-dZ d.d/d!Z d0d#Z d1d%Z d2d'Z d3d)ZxZS)4 ODSWriterodf)z.odsNwpath)FilePath | WriteExcelBuffer | ExcelWriterengine str | None date_formatmodestrstorage_optionsr if_sheet_exists engine_kwargsdict[str, Any] | NonereturnNonec  ddlm} |dkrtdt|| }| di||_t |||||i|_dS)Nr)OpenDocumentSpreadsheetaz&Append mode is not supported with odf!)rrrr)odf.opendocumentr$ ValueErrorr_booksuper__init__ _style_dict) selfrrrdatetime_formatrrrrkwargsr$ __class__s V/var/www/html/t/fyr/venv311/lib/python3.11/site-packages/pandas/io/excel/_odswriter.pyr+zODSWriter.__init__"s =<<<<< 3;;EFF 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 r1bookzODSWriter.book@s zr2dict[str, Any]cZddlm}d|j|D}|S)z(Mapping of sheet names to sheet objects.r)Tablec:i|]}|d|Sname) getAttribute).0sheets r1 z$ODSWriter.sheets..Ns8      v & &   r2) odf.tabler7r4getElementsByType)r-r7results r1sheetszODSWriter.sheetsIsK $#####  44U;;    r2c|jD]!}|jj|"|j|jjdS)z( Save workbook to disk. N)rBvaluesr4 spreadsheet addElementsave_handleshandle)r-r=s r1_savezODSWriter._saveTs\['')) 4 4E I ! , ,U 3 3 3 3 t}+,,,,,r2rcellslist[ExcelCell] sheet_namestartrowintstartcol freeze_panestuple[int, int] | Nonec<ddlm}m}m}ddlm} ||}|J||jvr|j|} n+||} |jj | t|r=ttttf|}|||t!|D]} | | t#|} t#t} t%|dD]}| |js:t!|D]*} | |j |+t!|j| |jz D]?} | |j || |jxxdz cc<@||\}}| |j || |jxxdz cc<| | }| |t-| dkrOt!t/| dzD]}| | |dSdS) z1 Write the frame cells using odf r)r7 TableCellTableRow)PNr9c|j|jfS)N)rowcol)cells r1z(ODSWriter._write_cells..sDHdh3Gr2)key)text)r?r7rTrUodf.textrV_get_sheet_namerBr4rErFrr rrO_create_freeze_panesrangersortedrXrY_make_table_celllenmaxkeys)r-rKrMrNrPrQr7rTrUrVwks_rows col_countrZpvaluetcprow_nrs r1 _write_cellszODSWriter._write_cells\s          ))*55 %%%  $ $+j)CC%Z(((C I ! , ,S 1 1 1  . . @c3h>>L  % %j, ? ? ?x ' 'A NN88:: & & & &'11!,S!1!1 5&G&GHHH  DTX& ;x;;AN--iikk::::48i&99:: ) )TX))))++666$(###q(####..t44JFB N % %b ) ) ) dh   1 $   vA MM!     t99q==DIIKK 0 01 455 - -tF|,,,, = - -r2dict[str, int | str]ci}||j}|||d<|j)|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 N stylenamer]numberrowsspannednumbercolumnsspanned)_process_stylestyle mergestartmergeendrf)r-rZ attributes style_names r1_make_table_cell_attributesz%ODSWriter._make_table_cell_attributessg,. ((44  !&0J{ # ? &4=+D.1!T_.E.EJ* +15J- .r2tuple[object, Any]cddlm}||}||j\}}|x}}t |t rBt|}t| }t |tj r9| }| d}||d||fSt |tj r@|jd|jdd|jd}| d}||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)rTz%cdate) valuetype datevaluerz-02dz%xstringfloatboolean)rvaluerz)r?rTr|_value_with_fmtval isinstanceboolrlowerupperdatetime isoformatstrftimeryearmonthdayrOrtype) r-rZrTrzrfmtrlrclass_to_cell_types r1rdzODSWriter._make_table_cells ('''''55d;; ''11S c4  &HHNN$$EXX^^%%F c8, - - MMOOE\\$''F Fe SSS X] + + x??#)???#'???E\\$''F Fe SSS  XWwi "  0c;) r2rwc4ddlm}m}m}m}|dSt j|}||jvr |j|Sdt|jdz}||j|<||d}d|vr=|d} | d d r| |d d |vrP|d } | D]3\} } d di} | |d| | | i4d|vrt|d}| d}|r| ||| d}|r| |||j j ||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)ParagraphPropertiesStyleTableCellPropertiesTextPropertiesNpdr]z table-cell)r:familyfontboldF) fontweightbordersthinz0.75pt solid #000000border)rz alignment horizontal) textalignvertical) verticalalign) odf.stylerrrrr dumpsr,regetrFitemsr4styles)r-rwrrrr style_keyr: odf_stylerrside thicknessthickness_translationrrrs r1rvzODSWriter._process_styles.             =4Ju%% ( ( (#I. .-C())!+--&*#EtL999 U??=Dxx&& H$$^^v%F%F%FGGG   I&G#*==??  i)/1G(H%$$''$3TOO5J95U#V %  k*I"|44J P$$%8%8:%N%N%NOOO }}Z00H R$$%8%8x%P%P%PQQQ ##I... r2tuple[int, int]c ddlm}m}m}m}m}|d}|jj||d} || |} | | |d} | | ||} | | | |ddd | |d dd | |d d t|d | |dd t|d | |dd t|d | |dd t|d dS)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-settingsr9ViewsTablesHorizontalSplitModeshort2)r:rr^VerticalSplitModeHorizontalSplitPositionrOVerticalSplitPositionr] PositionRightPositionBottomN) odf.configrrrrrr4settingsrFr) r-rMrQrrrrrconfig_item_setconfig_item_map_indexedconfig_item_map_entryconfig_item_map_nameds r1razODSWriter._create_freeze_panessu              (--@AAA %%o666"6"6G"D"D"D""#:;;; 2 2 4 4**+@AAA 2 2 A A A(()>??? 2 2 C C C(()>???(( J1c J J J    (( J/gC H H H    (( J.U\RS_AUAU      (( J,5sR>R S S S    (( J,5srsT""""""###### .----- 2111111s s s s s s s s s s r2