+ i"RtRt^RIHt^RIt^RIt^RIHt^RIHt^RI H t ^RI H t H t ^RIHt^R IHt^R IHtHt^R IHt]P]P.]P0]P23t]P] P6]P.] P8]P0] P:]P2] P</t] ]!]3t"]],]",]#]$!R43,t%]PL!R 4t'Rt(R t)Rt*Rt+Rt,Rt-Rt.Rt/Rt0])]*]+],]-].]/]03t1]2R]3R] R ]#R/t4Rt5Rt6!RR]4t7!RR]4t8RRlt9R#)zManage individual cells in a spreadsheet. The Cell class is required to know its value and type, display options, and any other features of an Excel cell. Utilities for referencing cells using Excel's 'A1' column/row nomenclature are also provided. zrestructuredtext en)copyN) NUMERIC_TYPES)IllegalCharacterError)get_column_letter)numbersis_date_format)StyleableObject) Hyperlink)DataTableFormula ArrayFormula) CellRichTextz#[\000-\010]|[\013-\014]|[\016-\037]sfnb inlineStrestrc\V\4'dRpMS\V\4'dRpM:\V\4'dRpM!\V\\ 34'dRpMR#V\ V&V#)rr drN) isinstancer STRING_TYPES TIME_TYPESr r _TYPES)tvaluedts&& Y/Users/agent/.openclaw/workspace/.venv/lib/python3.14/site-packages/openpyxl/cell/cell.pyget_typerAsa%''  E< ( (  E: & &  E,l; < < F1I Ic\PV4pV'dV#VP4R,F-p\PV4pV'gK"V\V&Vu# \RP V44h):NNz#Could not get time format for {0!r}) TIME_FORMATSgetmro ValueErrorformat)rrbases& rget_time_formatr(Psl   Q E     & 5#LOL  :AA%H IIrclaa]tRt^\toRtRtRV3Rllt]R4t]R4t ]R4t ]R4t ]R4t Rt R tR tR t]R 4t]P$R 4t]R4t]R4t]P$R4t]R4tRRlt]R4t]P$R4tRtVtV;t#)CellzhDescribes cell associated properties. Properties of interest include style, type, value, and address. c<\SV`W4W nW0nRVnRVnRVnVeW@nRVnR#)Nr) super__init__rowcolumn_value _hyperlink data_typer_comment)self worksheetr.r/r style_array __class__s&&&&&&rr- Cell.__init__lsG 0/ 2   J rc L\VP4pV VP 2#)z!This cell's coordinate (ex. 'A5'))rr/r.)r4cols& r coordinateCell.coordinate{s%  ,txxj!!rc VP#)z!The numerical index of the column)r/r4s&rcol_idx Cell.col_idx{{rc,\VP4#N)rr/r>s&r column_letterCell.column_letters --rc.VPP#rC)parentencodingr>s&rrH Cell.encodings{{###rcBVPPP#rC)rGepochr>s&r base_dateCell.base_dates{{!!'''rcbRPVPPVP4#)zr&rGtitler;r>s&r__repr__ Cell.__repr__s#!(():):DOOLLrc VfR#\V\4'g\WP4p\V4pVR,p\\P V4R4'd\ V R24hV#)z5Check string coding, length, and line break characterN:NiNz cannot be used in worksheets.)rrrHnextILLEGAL_CHARACTERS_REfinditerrr4rs&&r check_stringCell.check_stringsj = %%%}}-EE f  %..u5t < <'5'1O(PQ Q rc >\V4# \dR#i;i)z Tries to convert Error" else N/A#N/A)rUnicodeDecodeErrorrWs&&r check_errorCell.check_errors# u: !  s c .RVn\V4p\V,pVfVe\ RP V44hV'dW0nVR8Xd-\VP4'g\V4VnMoVR8Xdi\V\4'gSVPV4p\V4^8d VPR4'd RVnMV\9dRVnWnR# \d\ Y!4pLi;i) z*Given a value, infer the correct data typerNzCannot convert {0!r} to Excelrr =rr)r2typerKeyErrorrr%r&r number_formatr(rr rXlen startswith ERROR_CODESr0)r4rrrs&& r _bind_valueCell._bind_values K $B :%+<CCEJK K N 9!$"4"455%4Q%7" 3Yz%>>%%e,E5zA~%"2"23"7"7!$+%!$ ) $!#B $s C;;DDc VP#)z{Get or set the value held in the cell. :type: depends on the value (string, float, int or :class:`datetime.datetime`) r0r>s&rr Cell.values{{rc (VPV4R#)z1Set the value and infer type and display options.N)rgrWs&&rrrks rc VP#)z#Always returns the value for excel.rjr>s&rinternal_valueCell.internal_valuerArc VP#)z.Return the hyperlink target or an empty string)r1r>s&r hyperlinkCell.hyperlinksrc Vf RVnR#\V\4'g\RVR7pVPVnWnVP f(VP ;'g VPVnR#R#)zSet value and display for hyperlinks in a cell. Automatically sets the `value` of the cell with link text, but you can modify it afterwards by setting the `value` property, and the hyperlink will remain. Hyperlink is removed if set to ``None``.N)reftarget) r1rr r;rur0rvlocationr)r4vals&&rrqrrs_ ;"DOc9--Bs3ooCG!O{{" ZZ773<< #rc VPR8H;'g-VPR8H;'d\VP4#)z6True if the value is formatted as a date :type: bool rr)r2rrcr>s&ris_date Cell.is_dates> ~~$ NNc ! H HnT5G5G&H rc VPV,pVPV,pVPPW4R7#)zReturns a cell location relative to this cell. :param row: number of rows to offset :type row: int :param column: number of columns to offset :type column: int :rtype: :class:`openpyxl.cell.Cell` r/r.)r?r.rGcell)r4r.r/ offset_column offset_rows&&& roffset Cell.offsets7 v- XX^ {{}EErc VP#)zYReturns the comment associated with this cell :type: :class:`openpyxl.comments.Comment` )r3r>s&rcomment Cell.comments }}rc Ve0VP'd \V4pVPV4M0Vf-VP'dVPP 4WnR#)z Assign a comment to a cell N)rGrbindr3unbindrWs&&rrrsJ  |||U  JJt  ]t}}} MM " r)r3r1r0r/r2rcr.r)r.r/r0r2rGr1r3)NNNN)r)__name__ __module__ __qualname____firstlineno____doc__ __slots__r-propertyr;r?rDrHrLrQrXr]rgrsetterrnrqrzrr__static_attributes____classdictcell__ __classcell__r7 __classdict__s@@rr*r*\sH I ""  ..$$((M < \\   88" F  ^^   rr*ctaa]tRtRtoRtRtRtRtRtRt R V3Rllt Rt ] Pt ]t]tRtVtV;t#) MergedCelli,z Describes the properties of a cell in a merged cell and helps to display the borders of the merged cell. The value of a MergedCell is always None. Nrc><\SV`V4W nW0nR#rC)r,r-r.r/)r4r5r.r/r7s&&&&rr-MergedCell.__init__=s # rcbRPVPPVP4#)zrOr>s&rrQMergedCell.__repr__Cs#'..t{{/@/@$//RRrr})r.r/NN)rrrrrrr0r2rrqr-rQr*r;r3rrrrrs@@rrr,sG"I FIGI SJH EErrc \V^^VR7#)r!)r5r/r.r)r*)wsrs&&r WriteOnlyCellrKs "QAU ;;r)z#NULL!z#DIV/0!z#VALUE!z#REF!z#NAME?z#NUM!r[r):r __docformat__rdatetimereopenpyxl.compatropenpyxl.utils.exceptionsropenpyxl.utilsropenpyxl.stylesrropenpyxl.styles.styleableropenpyxl.worksheet.hyperlinkr openpyxl.worksheet.formular r openpyxl.cell.rich_textr datetime timedeltarFORMAT_DATE_DATETIMEFORMAT_DATE_YYYYMMDD2FORMAT_DATE_TIME6FORMAT_DATE_TIMEDELTAr"rbytesrboolra KNOWN_TYPEScompilerUrf TYPE_STRING TYPE_FORMULA TYPE_NUMERIC TYPE_BOOL TYPE_NULL TYPE_INLINE TYPE_ERRORTYPE_FORMULA_CACHE_STRING VALID_TYPESintfloatrrr(r*rrrrrsn&  <,352E0 x?Q?Q R  g22 MM'// MM'++ w44  UL) j(<74d:LL  #IJ        !L, +z3LN  c5c#tC 0  JM?M`>