Ë
|
dñúhÚ" ã ó d Z dZddlmZ ddlZddlZddlmZ ddlmZ ddl m
|
Z
|
ddl m Z m Z dd lmZ dd
|
lmZ dd lmZmZ dd lmZ ej ej. ej0 ej2 fZej e j6 ej. e j8 ej0 e j: ej2 e j< iZ e e!efZ"eez e"z e# e$d« fz Z% ejL d « Z'dZ(dZ)dZ*dZ+dZ,dZ-dZ.dZ/dZ0e)e*e+e,e-e.e/e0fZ1e2de3de de#diZ4d Z5d Z6 G d de« Z7 G d de« Z8d d Z9y) züManage 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)ÚnumbersÚis_date_format)ÚStyleableObject)Ú Hyperlink)ÚDataTableFormulaÚ ArrayFormula)Ú CellRichTextz#[\000-\010]|[\013-\014]|[\016-\037])z#NULL!z#DIV/0!z#VALUE!z#REF!z#NAME?z#NUM!ú#N/AÚsÚfÚnÚbÚ inlineStrÚeÚstrc ó¾ t |t « rd}n@t |t « rd}n-t |t « rd}nt |t t
|
f« rd}ny |t | < |S )Nr r Údr )Ú
|
isinstancer Ú STRING_TYPESÚ
|
TIME_TYPESr r Ú_TYPES)ÚtÚvalueÚdts úEH:\Change_password\venv_build\Lib\site-packages\openpyxl/cell/cell.pyÚget_typer A sU Ü% Ô'Ø Ü E<Ô (Ø Ü E:Ô &Ø Ü EÔ ,¬lÐ;Ô <Ø àØF1IØ Ió c óà t j | « }|r|S | j « dd D ]& }t j |« }|s|t | < |c S t dj |« « )Né z#Could not get time format for {0!r})Ú TIME_FORMATSÚgetÚmroÚ
|
ValueErrorÚformat)r r Úbases r Úget_time_formatr* P so Ü × Ñ QÓ EÙ Ø Ø ò Ü × Ñ Ó&Ú Ø #LOØLð ô
|
Ð:×AÑAÀ%ÓHÓ
|
IÐIr! c óT e Zd ZdZdZd fd Zed « Zed « Zed « Z ed « Z
|
ed « Z d Z d
|
Z d Zd Zed « Zej" d « Zed « Zed « Zej" d « Zed « ZddZed « Zej" d « Z xZS )ÚCellzpDescribes cell associated properties.
|
|
Properties of interest include style, type, value, and address.
|
|
)ÚrowÚcolumnÚ_valueÚ data_typeÚparentÚ
|
_hyperlinkÚ_commentc ó t | ||« || _ || _ d | _ d | _ d| _ ||| _ d | _ y )Nr ) ÚsuperÚ__init__r- r. r/ r2 r0 r r3 )ÚselfÚ worksheetr- r. r Ú style_arrayÚ __class__s r r6 z Cell.__init__l sO ø Ü Ñ KÔ0ØØ/Ø Ø2à Ø Ø Ø Ð Ø DJØ r! c óL t | j « }| | j S )z!This cell's coordinate (ex. 'A5'))r r. r- )r7 Úcols r Ú
|
coordinatezCell.coordinate{ s% ô § ¡ Ó,ØtxxjÐ!Ð!r! c ó | j S )z!The numerical index of the column)r. ©r7 s r Úcol_idxz Cell.col_idx ó ð {{Ðr! c ó, t | j « S ©N)r r. r? s r Ú column_letterzCell.column_letter s ä §¡Ó-Ð-r! c ó. | j j S rC )r1 Úencodingr? s r rF z Cell.encoding s à{{×#Ñ#Ð#r! c óB | j j j S rC )r1 Úepochr? s r Ú base_datezCell.base_date s à{{×!Ñ!×'Ñ'Ð'r! c ób dj | j j | j « S )Nz<Cell {0!r}.{1}>©r( r1 Útitler= r? s r Ú__repr__z Cell.__repr__ s# Ø!×(Ñ(¨¯©×):Ñ):¸D¿O¹OÓLÐLr! c óÒ |yt |t « st || j « }t |« }|dd }t t j |« d« rt | d« |S )z5Check string coding, length, and line break characterNiÿ z cannot be used in worksheets.)r r rF ÚnextÚILLEGAL_CHARACTERS_REÚfinditerr ©r7 r s r Ú check_stringzCell.check_string sh à =Ø ä%¤Ô%Üt}}Ó-EÜE
|
ð fu Ü Ô%×.Ñ.¨uÓ5°tÔ <Ü'¨5¨'Ð1OÐ(PÓQÐ QØ r! c ó8 t |« S # t $ r Y yw xY w)z Tries to convert Error" else N/Ar )r ÚUnicodeDecodeErrorrR s r Ú check_errorzCell.check_error¨ s# ð Üu:Ð øÜ!ò Ùð ús
|
c óø d| _ t |« } t | }| |t dj |« « |r|| _ |dk( r-t | j « s{t |« | _ || _ y|dk( r^t |t « sN| j |« }t |« dkD r |j d« rd| _ || _ y|t v rd | _ || _ y# t $ r t ||« }Y Ûw xY w)
|
z*Given a value, infer the correct data typer Nz Cannot convert {0!r} to Excelr r r# ú=r r )r0 Útyper ÚKeyErrorr r' r( r Ú number_formatr* r r rS ÚlenÚ
|
startswithÚ ERROR_CODESr/ )r7 r r r s r Ú _bind_valuezCell._bind_value° sù ð Ü Kð $ÜBð :%Ð+Ü Ð <× CÑ CÀEÓ JÓKÐ Ká Ø DNà 9Ü! $×"4Ñ"4Ô5Ü%4°QÓ%7Ô"ð ð 3Yz¨%´ Ô >Ø×%Ñ% eÓ,EÜ5zA~ %×"2Ñ"2°3Ô"7Ø!$ð ð +Ñ%Ø!$à øô) ò $Ü!UÓ#Bð $ús C! Ã!C9Ã8C9c ó | j S )zGet or set the value held in the cell.
|
|
:type: depends on the value (string, float, int or
|
:class:`datetime.datetime`)
|
©r/ r? s r r z
|
Cell.valueÎ s ð {{Ðr! c ó& | j |« y)z1Set the value and infer type and display options.N)r_ rR s r r z
|
Cell.value× s ð ×ÑÕ r! c ó | j S )z#Always returns the value for excel.ra r? s r Úinternal_valuezCell.internal_valueÜ rA r! c ó | j S )z.Return the hyperlink target or an empty string)r2 r? s r Ú hyperlinkzCell.hyperlinká s ð Ð r! c óÚ |d| _ yt |t « s t d|¬« }| j |_ || _ | j
|
|j xs |j | _ yy)a Set 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Ú )ÚrefÚtarget) r2 r r
|
r= ri r/ rj Úlocationr )r7 Úvals r rf zCell.hyperlinkç s[ ð ;Ø "DOä c¤9Ô-Ü B¨sÔ3ØooCGØ !DOØ{{Ð"Ø ZZÒ 7¨3¯<©<
|
ð #r! c óp | j dk( xs& | j dk( xr t | j « S )zFTrue if the value is formatted as a date
|
|
:type: bool
|
r r )r0 r r[ r? s r Úis_datez Cell.is_dateù s6 ð ~~ Ñ$ò Ø NNcÑ !Ò H¤n°T×5GÑ5GÓ&Hð r! c óx | j |z }| j |z }| j j ||¬« S )z÷Returns 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- r1 Úcell)r7 r- r. Ú offset_columnÚ
|
offset_rows r Úoffsetz Cell.offset s9 ð vÑ- ØXX ^
|
Ø{{× Ñ }¸*Ð ÓEÐEr! c ó | j S )zn Returns the comment associated with this cell
|
|
:type: :class:`openpyxl.comments.Comment`
|
)r3 r? s r Úcommentz Cell.comment s ð }}Ð r! c óÆ |0|j r t |« }|j | « || _ y|&| j r| j j « || _ y)z,
|
Assign a comment to a cell
|
N)r1 r Úbindr3 ÚunbindrR s r ru z Cell.comment sS ð Ð Ø||Ü U Ø JJtÔ ð ð ]t}}Ø MM× Ñ Ô "Ø r! )NNNN)r r )Ú__name__Ú
|
__module__Ú __qualname__Ú__doc__Ú __slots__r6 Úpropertyr= r@ rD rF rI rM rS rV r_ r Úsetterrd rf rn rs ru Ú __classcell__©r: s @r r, r, \ sA ø ñð
|
Iõ ð ñ"ó ð"ð ñó ðð
|
ñ.ó ð.ð ñ$ó ð$ð ñ(ó ð(òMò ò ò ð< ñó ðð \\ñ ó ð ð ñó ðð ñ ó ð ð
|
×Ññ8ó ð8ð" ñó ðó Fð ñ ó ð ð ^^ñ ó ô r! r, c ó^ e Zd ZdZdZdZdZdZdZd fd Z d Z
|
e j Z eZ eZ xZS )Ú
|
MergedCellz¥
|
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.
|
)r- r. Nr c ó@ t | |« || _ || _ y rC )r5 r6 r- r. )r7 r8 r- r. r: s r r6 zMergedCell.__init__= s ø Ü ÑÔ#ØØ r! c ób dj | j j | j « S )Nz<MergedCell {0!r}.{1}>rK r? s r rM zMergedCell.__repr__C s# Ø'×.Ñ.¨t¯{©{×/@Ñ/@À$Ç/Á/ÓRÐRr! ©NN)ry rz r{ r| r} r/ r0 ru rf r6 rM r, r= r3 r r r s @r r r , sC ø ñð "Ià FØIØGØIõ ò Sð JØHØ Er! r c ó t | dd|¬« S )Nr# )r8 r. r- r )r, )Úwsr s r Ú WriteOnlyCellr K s Ü " Q¨A°UÔ ;Ð;r! r ):r| Ú __docformat__r ÚdatetimeÚreÚopenpyxl.compatr Úopenpyxl.utils.exceptionsr Úopenpyxl.utilsr Úopenpyxl.stylesr r Úopenpyxl.styles.styleabler Ú openpyxl.worksheet.hyperlinkr
|
Úopenpyxl.worksheet.formular r Úopenpyxl.cell.rich_textr ÚdateÚtimeÚ timedeltar ÚFORMAT_DATE_DATETIMEÚFORMAT_DATE_YYYYMMDD2ÚFORMAT_DATE_TIME6ÚFORMAT_DATE_TIMEDELTAr$ r Úbytesr ÚboolrY Ú KNOWN_TYPESÚcompilerP r^ Ú TYPE_STRINGÚ TYPE_FORMULAÚ TYPE_NUMERICÚ TYPE_BOOLÚ TYPE_NULLÚ TYPE_INLINEÚ
|
TYPE_ERRORÚTYPE_FORMULA_CACHE_STRINGÚ VALID_TYPESÚintÚfloatr r r* r, r r © r! r ú<module>r¬ sp ðñð & õ Û Û õõ <å ,ß 3Ý 5Ý 2ß EÝ 0ð × Ñ § ¡ °· ± ¸x×?QÑ?QÐ R
|
à ×Ñg×2Ñ2Ø MM'×/Ñ/Ø MM'×+Ñ+Ø ×Ñw×4Ñ4ð ð ULÐ) ØjÑ(¨<Ñ7¸4ÁÀdÃÐ:LÑL à"
|
|
Ð#IÓJÐ ð ð Ø Ø Ø Ø Ø Ø
|
Ø !Ð àL¨,¸ Ø+ zÐ3LðN ð c5c # t¨CÐ 0ò ò JôM ?ô M ô` ô ô><r!
|
