4i,SSKJr SSKJr SSKrSSKrSSKJrJrJ r J r J r SSK J r SSKJrJr \(aSSKJr SSKJrJrJrJr SS KJr "S S \ 5rg) ) annotations) defaultdictN) TYPE_CHECKINGAny DefaultDictcastoverload) ExcelWriter)combine_kwargsvalidate_freeze_panesOpenDocumentSpreadsheet)ExcelWriterIfSheetExistsFilePathStorageOptionsWriteExcelBuffer) ExcelCellc,^\rSrSrSrSrSSU4Sjjjr\SSj5r\SSj5r SSjr SSSjjr SS jr SS jr \SS j5r\SS j5rSS jrSSjrSrU=r$) ODSWriter!odf)z.odsc  >SSKJn US:Xa [S5e[X5nU "S0UD6Ul[ T U]UUUUUS9 0Ulg)Nrr az&Append mode is not supported with odf!)modestorage_optionsif_sheet_exists engine_kwargs)odf.opendocumentr ValueErrorr _booksuper__init__ _style_dict) selfpathengine date_formatdatetime_formatrrrrkwargsr __class__s \/var/www/html/dynamic-report/venv/lib/python3.13/site-packages/pandas/io/excel/_odswriter.pyr#ODSWriter.__init__%s_ = 3;EF F&}= ,=}=   ++'  ,.cUR$)z Book instance of class odf.opendocument.OpenDocumentSpreadsheet. This attribute can be used to access engine-specific features. )r!)r%s r,bookODSWriter.bookCszzr.cSSKJn URRU5Vs0sHnUR S5U_M nnU$s snf)z(Mapping of sheet names to sheet objects.r)Tablename) odf.tabler3r0getElementsByType getAttribute)r%r3sheetresults r,sheetsODSWriter.sheetsLsT $44U; ;   v & -;    sAcURR5H(nURRR U5 M* URR UR R5 g)z Save workbook to disk. N)r:valuesr0 spreadsheet addElementsave_handleshandle)r%r8s r,_saveODSWriter._saveWsM[['')E II ! ! , ,U 3* t}}++,r.cU(a [S5eSSKJnJnJn SSKJn URU5nUceX R;aURUn O+U"US9n URRRU 5 [U5(a.[[[[4U5nUR!X%5 [#U5Hn U RU "55 M [%U 5n [%[5n['USS9GH nXR((d4[#U5H%n XR(RU"55 M' [#UR*XR(- 5H;n XR(RU"55 XR(==S - ss'M= UR-U5unnXR(RU5 XR(==S - ss'U "US 9nURU5 GM [/U 5S:aA[#[1U R355S -5HnU RU U5 M gg) z! Write the frame cells using odf z%Autofilter is not supported with odf!r)r3 TableCellTableRow)PNr4c2URUR4$N)rowcol)cells r,(ODSWriter._write_cells..sDHHdhh3Gr.)key)text)r r5r3rFrGodf.textrH_get_sheet_namer:r0r>r?r rtupleint_create_freeze_panesrangersortedrLrM_make_table_celllenmaxkeys)r%cells sheet_namestartrowstartcol freeze_panesautofilter_ranger3rFrGrHwks_rows col_countrNpvaluetcprow_nrs r, _write_cellsODSWriter._write_cells_s DE E  ))*5 %%%  $++j)CZ(C II ! ! , ,S 1  . .c3h>L  % %j ?xA NN8: &!(1!,S!1 5&GHDXX&xAN--ik:)488i&99:XX)))+6((#q(#;..t4JFB N % %b ) hh 1 $ vA MM! I$ t9q=DIIK 01 45tF|,6 r.c0nURUR5nUbX2S'URb5URb([ SUR5US'URUS'U$)zConvert cell attributes to OpenDocument attributes Parameters ---------- cell : ExcelCell Spreadsheet cell data Returns ------- attributes : Dict[str, Union[int, str]] Dictionary with attributes and attribute values stylenamerRnumberrowsspannednumbercolumnsspanned)_process_stylestyle mergestartmergeendr])r%rN attributes style_names r,_make_table_cell_attributes%ODSWriter._make_table_cell_attributessi,. ((4  !&0{ # ?? &4==+D.1!T__.EJ* +15J- .r.cSSKJn URU5nURUR5upEU=pg[ U[ 5(a<[U5R5n[U5R5nUU"SUUS94$[ U[R5(a*UR5nURS5nUU"SXsS94$[ U[R5(aDURSURS SUR S 3nURS 5nUU"SXsS94$[ U[5(a UU"S UUS 94$UU"S UUS94$)zConvert cell data to an OpenDocument spreadsheet cell Parameters ---------- cell : ExcelCell Spreadsheet cell data Returns ------- pvalue, cell : Tuple[str, TableCell] Display value, Cell value r)rFboolean) valuetype booleanvaluerwz%cdate)r} datevaluerw-02dz%xstring)r} stringvaluerwfloat)r}valuerw)r5rFry_value_with_fmtval isinstanceboolstrlowerupperdatetime isoformatstrftimeryearmonthday)r%rNrFrwrfmtrirs r,r[ODSWriter._make_table_cellsp (55d; ''1 c4 HNN$EX^^%F'!&) X.. / /MMOE\\$'FFeS X]] + +xxj#))C#''#?E\\$'FFeS S ! !& %) %) r.cgrKrr%rts r,rsODSWriter._process_stylesUS n U R5H%upS S0n URU"SU 3X0S95 M' SU;a_USnURS5nU(aURU"US95 URS5nU(aURU"US95 URRRU5 U$)zConvert a style dictionary to an OpenDocument style sheet Parameters ---------- style : Dict Style dictionary Returns ------- style_key : str Unique style key for later reference in sheet r)ParagraphPropertiesStyleTableCellPropertiesTextPropertiesNpdrRz table-cell)r4familyfontboldF) fontweightbordersthinz0.75pt solid #000000border)rw alignment horizontal) textalignvertical) verticalalign) odf.stylerrrrjsondumpsr$r\getr?itemsr0styles)r%rtrrrr style_keyr4 odf_stylerrside thicknessthickness_translationrrrs r,rsrs   =JJu% (( (##I. .C(()A-./&*#tL9 U?=Dxx&&$$^v%FG  I&G#*==?)/1G(H%$$'&,TFO5J5U#V$3 % k*I"|4J$$%8:%NO }}Z0H$$%8x%PQ ##I. r.c SSKJnJnJnJnJn U"SS9nUR RRU5 U"SS9n URU 5 U"5n U RU 5 U"SS9n U RU 5 U"US9n U RU 5 U RU"SSS S 95 U RU"S SS S 95 U RU"S S [US5S 95 U RU"SS [US5S 95 U RU"SS [US5S 95 U RU"SS [US5S 95 g)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-settingsrIViewsTablesHorizontalSplitModeshort2)r4typerSVerticalSplitModeHorizontalSplitPositionrWVerticalSplitPositionrR PositionRightPositionBottomN) odf.configrrrrrr0settingsr?r) r%r`rcrrrrrconfig_item_setconfig_item_map_indexedconfig_item_map_entryconfig_item_map_nameds r,rXODSWriter._create_freeze_panes1sm  (-@A %%o6"6G"D""#:; 2 4**+@A 2 A(()>? 2 C(()>?(( 1c J  (( /gC H  (( .U\RS_AU  (( ,5sR S  (( ,5s->->- >-  >- - >-%>- >-@,@D?? 662h9 9 -<9 9 9 r.r) __future__r collectionsrrrtypingrrrrr pandas.io.excel._baser pandas.io.excel._utilr r rrpandas._typingrrrrpandas.io.formats.excelrrrr.r,rsJ"# . 82I I r.