Ë
|
dñúh¥: ã ó d dl m Z d dlmZ d dlmZ d dlmZ d dlmZ d dlm Z d dl
|
m Z m Z m Z mZ G d d e « Z G d
|
d e« Zy ) é )Úcopy)Ú
|
attrgetter)ÚStrict)ÚMinMax)ÚUniqueSequence)Ú Serialisable)Úrange_boundariesÚrange_to_tupleÚget_column_letterÚquote_sheetnamec ó¢ e Zd ZdZ edde¬« Z edde¬« Z edde¬« Z edde¬« Z d&dZ
|
e d « Z e d « Z e d
|
« Ze d « Ze d « Zd Zd Zd Zd Zd Zd'dZd Zd Zd ZeZd Zd Z d Z e Z d Z d Z d Z!d Z"e"Z#d Z$e$Z%d Z&d(d Z'd(d Z(e d! « Z)e d" « Z*e d# « Z+e d$ « Z,e d% « Z-y))Ú CellRangeaÜ
|
Represents a range in a sheet: title and coordinates.
|
|
This object is used to perform operations on ranges, like:
|
|
- shift, expand or shrink
|
- union/intersection with another sheet range,
|
|
We can check whether a range is:
|
|
- equal or not equal to another,
|
- disjoint of another,
|
- contained in another.
|
|
We can get:
|
|
- the size of a range.
|
- the range bounds (vertices)
|
- the coordinates,
|
- the string representation,
|
|
é ifG )ÚminÚmaxÚ expected_typei Nc ó* |(d|v rt |« \ }\ }}}}nt |« \ }}}}|| _ || _ || _ || _ || _ ||kD r d}t |j ||¬« « ||kD r d}t |j ||¬« « y )Nú!z({max_col} must be greater than {min_col})Úmin_colÚmax_colz({max_row} must be greater than {min_row})Úmin_rowÚmax_row) r
|
r r r r r ÚtitleÚ
|
ValueErrorÚformat)ÚselfÚ range_stringr r r r r Úfmts úPH:\Change_password\venv_build\Lib\site-packages\openpyxl/worksheet/cell_range.pyÚ__init__zCellRange.__init__0 s à Ð #ØlÑ"Ü>LÈ\Ó>ZÑ;Ñ; ¨'±7ä5EÀlÓ5SÑ2 '¨7à Ø Ø Ø Ø
|
à WÒ Ø<CÜ SZZ°ÀZÓ IÓJÐ JØ WÒ Ø<CÜ SZZ°ÀZÓ IÓJÐ Jð ó c ó^ | j | j | j | j fS )z2
|
Vertices of the range as a tuple
|
©r r r r ©r s r ÚboundszCellRange.boundsF s# ð
|
||T\\¨4¯<©<¸¿ ¹ ÐEÐEr! c ó d}| j | j k( r| j | j k( rd}|j t | j « | j t | j « | j ¬« S )z9
|
Excel-style representation of the range
|
z%{min_col}{min_row}:{max_col}{max_row}z{min_col}{min_row}r# )r r r r r r ©r r s r ÚcoordzCellRange.coordN sj ð
|
6Ø LLDLLÒ (Ø § ¡ Ò,Ø&CàzzÜ% d§l¡lÓ3ØLLÜ% d§l¡lÓ3ØLLð ó
|
ð
|
r! c # óÐ K t | j | j dz « D ]7 }t | j | j dz « D cg c] }||f c} 9 yc c}w w)z1
|
Return cell coordinates as rows
|
r N)Úranger r r r )r ÚrowÚcols r ÚrowszCellRange.rows_ óW è ø ô
|
t§|¡|°A¡~Ó6ò NCÜ).¨t¯|©|¸T¿\¹\È!¹^Ó)LÖM #C:ÒMÓ Mñ NùÚMùó A A&Á A!Á A&c # óÐ K t | j | j dz « D ]7 }t | j | j dz « D cg c] }||f c} 9 yc c}w w)z4
|
Return cell coordinates as columns
|
r N)r* r r r r )r r, r+ s r ÚcolszCellRange.colsh r. r/ c ó¤ ddl m} |t | j | j dz « t | j
|
| j dz « « S )Nr )Úproductr )Ú itertoolsr3 r* r r r r )r r3 s r ÚcellszCellRange.cellsq s= å%ÙuT\\¨4¯<©<¸©>Ó:¼EÀ$Ç,Á,ÐPT×P\ÑP\Ð]^ÑP^Ó<_Ó`Ð`r! c óÀ t |t « s t t t |« « « |j
|
r%| j
|
|j
|
k7 r t d« yy)z²
|
Check whether comparisons between ranges are possible.
|
Cannot compare ranges from different worksheets
|
Skip if the range passed in has no title.
|
z1Cannot work with ranges from different worksheetsN)Ú
|
isinstancer Ú TypeErrorÚreprÚtyper r ©r Úothers r Ú _check_titlezCellRange._check_titlew sK ô %¤Ô+ÜD¤ e£Ó -Ó.Ð .à ;;4::¨¯©Ò4Ü Ð PÓQÐ Qð 5;r! c ó d}| j rd}|j | j j | j | j ¬« S )Nz<{cls} {coord}>z<{cls} {title!r}!{coord}>)Úclsr r( )r r Ú __class__Ú__name__r( r' s r Ú__repr__zCellRange.__repr__ s: Ø Ø ::Ø.CØzzdnn× 5Ñ 5¸T¿Z¹ZÈtÏzÉzzÓZÐZr! c óp t | j | j | j | j f« S ©N)Úhashr r r r r$ s r Ú__hash__zCellRange.__hash__ s& ÜT\\ 4§<¡<°· ± ¸t¿|¹|ÐLÓMÐMr! c óv d}| j }|r d}t |« }|j || j ¬« S )Nz{coord}z{title}!{coord})r r( )r r r r( )r r r s r Ú__str__zCellRange.__str__ s9 ØØ
|
|
Ù Ø$CÜ# EÓ*EØzz ¨T¯Z©ZzÓ8Ð8r! c ó | j | j | j | j | j | j
|
¬« S )N©r r r r r )r@ r r r r r r$ s r Ú__copy__zCellRange.__copy__ s8 Ø~~ d§l¡l¸D¿L¹LØ&*§l¡l¸D¿L¹LØ$(§J¡Jð ó 0ð 0r! c ó* | j |z dk s| j |z dk rt dj ||« « | xj |z c_ | xj |z c_ | xj |z c_ | xj
|
|z c_ y)a{
|
Shift the focus of the range according to the shift values (*col_shift*, *row_shift*).
|
|
:type col_shift: int
|
:param col_shift: number of columns to be moved by, can be negative
|
:type row_shift: int
|
:param row_shift: number of rows to be moved by, can be negative
|
:raise: :class:`ValueError` if any row or column index < 1
|
r z1Invalid shift value: col_shift={0}, row_shift={1}N)r r r r r r )r Ú col_shiftÚ row_shifts r ÚshiftzCellRange.shift sy ð LL9Ñ $¨Ò )Ø||iÑ'¨1Ò,Ü Ð P× WÑ WÐXaÐclÓ mÓnÐ nØ Ñ! Ø Ñ! Ø Ñ! Ø Ñ! r! c ó | j |« |j | j k7 xsO | j |j k7 xs4 |j | j k7 xs | j
|
|j
|
k7 S # t $ r Y yw xY w)zÏ
|
Test whether the ranges are not equal.
|
|
:type other: openpyxl.worksheet.cell_range.CellRange
|
:param other: Other sheet range
|
:return: ``True`` if *range* != *other*.
|
T)r= r r r r r r; s r Ú__ne__zCellRange.__ne__² s ð Ø × Ñ eÔ $ð
|
MMT\\Ñ )ò -Ø||u}}Ñ,ò -à}} § ¡ Ñ,ò -ð ||u}}Ñ,ð
|
øô ò Ùð ús A= Á= B ÂB c ó& | j |« S )zË
|
Test whether the ranges are equal.
|
|
:type other: openpyxl.worksheet.cell_range.CellRange
|
:param other: Other sheet range
|
:return: ``True`` if *range* == *other*.
|
)rQ r; s r Ú__eq__zCellRange.__eq__Ç s ð ;;uÓ%Ð%Ð%r! c óF | j |« |j | « S )zâ
|
Test whether every cell in this range is also in *other*.
|
|
:type other: openpyxl.worksheet.cell_range.CellRange
|
:param other: Other sheet range
|
:return: ``True`` if *range* <= *other*.
|
©r= Ú_CellRange__supersetr; s r ÚissubsetzCellRange.issubsetÒ s# ð ×Ñ%Ô à× Ñ Ó%Ð%r! c óJ | j |« xr | j |« S )zé
|
Test whether *other* contains every cell of this range, and more.
|
|
:type other: openpyxl.worksheet.cell_range.CellRange
|
:param other: Other sheet range
|
:return: ``True`` if *range* < *other*.
|
)Ú__le__rQ r; s r Ú__lt__zCellRange.__lt__á ó! ð {{5Ó!Ò8 d§k¡k°%Ó&8Ð8r! c ó | j |j cxk xr! |j cxk xr | j k nc xr@ | j |j cxk xr! |j cxk xr | j k S c S rD )r r r r r; s r Ú
|
__supersetzCellRange.__supersetì s\ à \\U]]Ö K¨e¯m©mÖ K¸t¿|¹|Ô Kò Mà \\U]]Ö K¨e¯m©mÖ K¸t¿|¹|Ñ Kð
|
ñ Lð
|
r! c óF | j |« | j |« S )zõ
|
Test whether every cell in *other* is in this range.
|
|
:type other: openpyxl.worksheet.cell_range.CellRange
|
:param other: Other sheet range
|
:return: ``True`` if *range* >= *other* (or *other* in *range*).
|
rU r; s r Ú
|
issupersetzCellRange.issupersetô s! ð ×Ñ%Ô àuÓ%Ð%r! c óF | j |« }| j |« S )zO
|
Check whether the range contains a particular cell coordinate
|
)r@ rV ©r r( Úcrs r Ú __contains__zCellRange.__contains__ s! ð ^^EÓ "ØrÓ"Ð"r! c óJ | j |« xr | j |« S )zé
|
Test whether this range contains every cell in *other*, and more.
|
|
:type other: openpyxl.worksheet.cell_range.CellRange
|
:param other: Other sheet range
|
:return: ``True`` if *range* > *other*.
|
)Ú__ge__rQ r; s r Ú__gt__zCellRange.__gt__ r[ r! c óü | j |« | j |j kD r|| }} | j |j k xs4 | j |j
|
k xs |j | j
|
k S )aV
|
Return ``True`` if this range has no cell in common with *other*.
|
Ranges are disjoint if and only if their intersection is the empty range.
|
|
:type other: openpyxl.worksheet.cell_range.CellRange
|
:param other: Other sheet range.
|
:return: ``True`` if the range has no cells in common with other.
|
)r= r% r r r r r; s r Ú
|
isdisjointzCellRange.isdisjoint sl ð ×Ñ%Ô ð ;; Ò %Ø %Dà u}}Ñ,ò 0Ø<< %§-¡-Ñ/ò0à== 4§<¡<Ñ/ð 1r! c óx | j |« rt dj | |« « t | j |j « }t | j |j « }t | j |j « }t | j |j « }t ||||¬« S )aN
|
Return a new range with cells common to this range and *other*
|
|
:type other: openpyxl.worksheet.cell_range.CellRange
|
:param other: Other sheet range.
|
:return: the intersecting sheet range.
|
:raise: :class:`ValueError` if the *other* range doesn't intersect
|
with this range.
|
z Range {0} doesn't intersect {0}r# )
|
rh r r r r r r r r r ©r r< r r r r s r Ú intersectionzCellRange.intersection* s ð ??5Ô !Ü Ð >× EÑ EÀdÈEÓ RÓSÐ Sädll E§M¡MÓ2Üdll E§M¡MÓ2Üdll E§M¡MÓ2Üdll E§M¡MÓ2ä °'À7Ø!(ô*ð *r! c óX | j |« t | j |j « }t | j |j « }t | j
|
|j
|
« }t | j |j « }t ||||| j ¬« S )a
|
Return the minimal superset of this range and *other*. This new range
|
will contain all cells from this range, *other*, and any additional
|
cells required to form a rectangular ``CellRange``.
|
|
:type other: openpyxl.worksheet.cell_range.CellRange
|
:param other: Other sheet range.
|
:return: a ``CellRange`` that is a superset of this and *other*.
|
rJ ) r= r r r r r r r r rj s r ÚunionzCellRange.unionB s~ ð ×Ñ%Ô ädll E§M¡MÓ2Üdll E§M¡MÓ2Üdll E§M¡MÓ2Üdll E§M¡MÓ2Ü °'À7Ø!(°·
|
±
|
ô<ð <r! c # ó^ K | j D ] }|dk( r t | |« }||f yw)zC
|
For use as a dictionary elsewhere in the library.
|
r N)Ú __attrs__Úgetattr)r ÚxÚvs r Ú__iter__zCellRange.__iter__X s: è ø ð ò AØG|ØÜaÓ AØQ$Jñ ùs +-c ó¬ | xj |z c_ | xj |z c_ | xj |z c_ | xj |z c_ y)a¦
|
Expand the range by the dimensions provided.
|
|
:type right: int
|
:param right: expand range to the right by this number of cells
|
:type down: int
|
:param down: expand range down by this number of cells
|
:type left: int
|
:param left: expand range to the left by this number of cells
|
:type up: int
|
:param up: expand range up by this number of cells
|
Nr# )r ÚrightÚdownÚleftÚups r ÚexpandzCellRange.expandc s< ð Ñ Ø Ñ Ø Ñ Ø Ñ r! c ó¬ | xj |z c_ | xj |z c_ | xj |z c_ | xj |z c_ y)a¿
|
Shrink the range by the dimensions provided.
|
|
:type right: int
|
:param right: shrink range from the right by this number of cells
|
:type down: int
|
:param down: shrink range from the top by this number of cells
|
:type left: int
|
:param left: shrink range from the left by this number of cells
|
:type up: int
|
:param up: shrink range from the bottom by this number of cells
|
Nr# )r ru Úbottomrw Útops r ÚshrinkzCellRange.shrinkv s< ð Ñ Ø Ñ Ø Ñ Ø Ñ r! c ó| | j dz | j z
|
}| j dz | j z
|
}||dS )zC Return the size of the range as a dictionary of rows and columns. r )Úcolumnsr- )r r r r )r r1 r- s r ÚsizezCellRange.size s= ð ||aÑ $§,¡,Ñ.Ø||aÑ $§,¡,Ñ.Ø tÑ,Ð,r! c ó t | j | j dz « D cg c] }| j |f c}S c c}w )z=A list of cell coordinates that comprise the top of the ranger )r* r r r ©r r, s r r| z CellRange.top ó5 ô 05°T·\±\À4Ç<Á<ÐPQÁ>Ó/RÖS¨ sÒ#ÒSÐSùÒSó ¦>c ó t | j | j dz « D cg c] }| j |f c}S c c}w )z@A list of cell coordinates that comprise the bottom of the ranger )r* r r r r s r r{ zCellRange.bottom r r c ó t | j | j dz « D cg c] }|| j f c}S c c}w )zCA list of cell coordinates that comprise the left-side of the ranger )r* r r r ©r r+ s r rw zCellRange.left ó5 ô 05°T·\±\À4Ç<Á<ÐPQÁ>Ó/RÖS¨dllÒ#ÒSÐSùÒSr c ó t | j | j dz « D cg c] }|| j f c}S c c}w )zDA list of cell coordinates that comprise the right-side of the ranger )r* r r r r s r ru zCellRange.right£ r r )NNNNNN)r r )r r r r ).rA Ú
|
__module__Ú __qualname__Ú__doc__r Úintr r r r r Úpropertyr% r( r- r1 r5 r= rB rF rH rK rO rQ rS rW rY rZ rV r_ re rc rf rh rk Ú__and__rm Ú__or__rs ry r} r r| r{ rw ru © r! r r r s¬ ññ. °SÔ9GÙ °sÔ;GÙ °SÔ9GÙ °sÔ;Gð AEØ37óKð, ñFó ðFð ñ
|
ó ð
|
ð ñNó ðNð ñNó ðNð ñaó ðaò
|
|
Rò[òNò9ò0ó "ò(
|
ò*&ò
|
&ð Fò9ò
|
ò
|
&ð Fò#ò9ò1ò(*ð* Gò<ð& Fòó ó& ð& ñ-ó ð-ð ñTó ðTð
|
ñTó ðTð
|
ñTó ðTð
|
ñTó ñTr! r c ó e Zd Z ee¬« Z e« fdZd Zd Z d Z
|
d Z d Z d Z d Zd
|
Zd Zd Zd Zd Zd Zy)ÚMultiCellRange)r c ó t |t « r&|j « D cg c] }t |« }}t |« | _ y c c}w rD )r7 ÚstrÚsplitr ÚsetÚranges)r r Úrs r r zMultiCellRange.__init__¯ s9 Ü fcÔ "Ø,2¯L©L«NÖ; qi lÐ;FÐ;Ü&k ùò <s £Ac ój t |t « r t |« }| j D ] }||k s y y)NTF)r7 r r r )r r( r s r rc zMultiCellRange.__contains__µ s8 Ü eSÔ !Ü eÓ$EØò AØzÙð ð r! c ó² dj | j « D cg c] }t |« c}« }d| j j d| dS c c}w )Nú ú<z [z]>)ÚjoinÚsortedr r@ rA ©r r r s r rB zMultiCellRange.__repr__¾ sJ ب4¯;©;«=Ö9 a3q6Ò9Ó:Ø4>>×*Ñ*Ð+¨2¨f¨X°RÐ8Ð8ùò :s Ac ó| dj | j « D cg c] }t |« c}« }|S c c}w )Nr )r r r r s r rH zMultiCellRange.__str__à s/ بD¯K©K«MÖ: qC FÒ:Ó;Ø ùò ;s 9c ó* t t | « « S rD )rE r r$ s r rF zMultiCellRange.__hash__È s ÜCIÐ r! c óH t | j t dddd« ¬« S )z/
|
Return a sorted list of items
|
r r r r )Úkey)r r r r$ s r r zMultiCellRange.sortedÌ s! ô dkk¤z°)¸YÈ ÐS\Ó']Ô^Ð^r! c ó¶ |}t |t « r t |« }nt |t « s t d« || vr | j j |« yy)z4
|
Add a cell coordinate or CellRange
|
zYou can only add CellRangesN)r7 r r r r Úaddra s r r¦ zMultiCellRange.addÓ sO ð Ü eSÔ !Ü5Ó!BÜE¤9Ô-Ü Ð :Ó;Ð ;Ø T>Ø KKOOBÕ ð r! c ó( | j |« | S rD )r¦ ©r r( s r Ú__iadd__zMultiCellRange.__iadd__à s Ø Ø r! c óv t |t « r| j |« }| j |j k( S rD )r7 r r@ r r; s r rS zMultiCellRange.__eq__å s- Ü ucÔ "ØNN 5Ó)EØ{{ellÑ*Ð*r! c ó | |k( S rD r r; s r rQ zMultiCellRange.__ne__ë s Ø5=Ð Ð r! c ó, t | j « S rD )Úboolr r$ s r Ú__bool__zMultiCellRange.__bool__ï s ÜDKKÓ Ð r! c óp t |t « s t |« }| j j |« y rD )r7 r r Úremover¨ s r r° zMultiCellRange.removeó s( Ü%¤Ô+Ü eÓ$EØ ×Ñ5Õ!r! c # ó6 K | j D ] }| y wrD )r )r rb s r rs zMultiCellRange.__iter__ù s è ø Ø++ò BØHñ ùs c óf | j D ch c] }t |« }}t |« S c c}w rD )r r r r s r rK zMultiCellRange.__copy__þ s- Ø#'§;¡;Ö/a$q'Ð/Ð/Ü fÓ%Ð%ùò 0s .N)rA r r r r r r r rc rB rH rF r r¦ r© rS rQ r® r° rs rK r r! r r r © s\ ñ ¨)Ô 4Fñ "eó "ò ò9ò
|
ò
|
ò_ò
|
òò
|
+ò !ò!ò"ò ó
|
&r! r N)r Úoperatorr Úopenpyxl.descriptorsr r Ú openpyxl.descriptors.sequencer Ú!openpyxl.descriptors.serialisabler Úopenpyxl.utilsr r
|
r r r r r r! r ú<module>r¸ sB ðõ Ý å 'Ý 'Ý 8Ý :÷ó ôTT ô TTôn W&Võ W&r!
|
