Ë
|
dñúh ã ó d dl Z d dlmZ d dlmZmZ d dlmZ d dlm Z ddl
|
m Z G d d e « Z G d
|
d e« Z G d d e « Zy)é N)Ú Serialisable)ÚIntegerÚSequence)Ú
|
MergedCell)ÚBorderé )Ú CellRangec óH e Zd ZdZej
|
ZdZ d fd Zd Z xZ
|
S )Ú MergeCellÚ mergeCell)Úrefc ó$ t | |« y ©N)ÚsuperÚ__init__)Úselfr Ú __class__s úKH:\Change_password\venv_build\Lib\site-packages\openpyxl/worksheet/merge.pyr zMergeCell.__init__ s ø ô ÑÕ ó c ó8 | j | j « S r )r r ©r s r Ú__copy__zMergeCell.__copy__ s Ø~~dhhÓ'Ð'r r ) Ú__name__Ú
|
__module__Ú __qualname__Útagnamer Úcoordr Ú __attrs__r r Ú __classcell__©r s @r r r s% ø àGØ
|
//CàIð õ ö (r r c óX e Zd ZdZ ed¬« Z ee¬« ZdZ dZ
|
d
|
dZ e d « Zy) Ú
|
MergeCellsÚ
|
mergeCellsT)Ú
|
allow_none)Ú expected_type©r )ÚcountNc ó || _ y r r& )r r' r s r r zMergeCells.__init__- s ð #r c ó, t | j « S r )Úlenr r s r r' zMergeCells.count4 s ä4>>Ó"Ð"r )N© ) r r r r r r' r r r Ú __elements__r r Úpropertyr+ r r r" r" # sF àGá tÔ $EÙ yÔ3Ià!LØIð Ø ó#ð ñ#ó ñ#r r" c ó: e Zd ZdZ fdZd Zd Zd Zd Z xZ S )ÚMergedCellRangea
|
MergedCellRange stores the border information of a merged cell in the top
|
left cell of the merged cell.
|
The remaining cells in the merged cell are stored as MergedCell objects and
|
get their border information from the upper left cell.
|
c ób || _ t | |¬« d | _ | j « y )N)Ú range_string)Úwsr r Ú
|
start_cellÚ _get_borders)r Ú worksheetr r s r r zMergedCellRange.__init__B s- ø ØÜ Ñ eÐÔ,Ø Ø ×ÑÕr c ó( | j j j | j | j f« | _ | j
|
6| j j | j | j ¬« | _ | j j j | j | j f« }|S| j
|
xj t |j j |j j ¬« z c_ yy)a
|
If the upper left cell of the merged cell does not yet exist, it is
|
created.
|
The upper left cell gets the border information of the bottom and right
|
border from the bottom right cell of the merged cell, if available.
|
N©ÚrowÚcolumn)ÚrightÚbottom) r2 Ú_cellsÚgetÚmin_rowÚmin_colr3 ÚcellÚmax_rowÚmax_colÚborderr r: r; )r Úend_cells r r4 z MergedCellRange._get_bordersI s¾ ð ''..×,Ñ,¨d¯l©l¸D¿L¹LÐ-IÓJØ ??Ð "Ø "ggll¨t¯|©|ÀDÇLÁLlÓ QDOð 77>>×%Ñ% t§|¡|°T·\±\Ð&BÓCØ Ð Ø OO× "Ò "¤f°8·?±?×3HÑ3HØ4<·O±O×4JÑ4Jô'Lñ LÖ "ð r c óf g d¢}|D ]× }t | j j |« }|r |j 2t di ||i¤}t | |« D ] }| j
|
j j |« }|L|\ }}t | j
|
||¬« }|| j
|
j |j |j f< |xj |z c_ Ù | j j du} | r)t j | j j « }
|
| j D ] }| j
|
j j |« }|L|\ }}t | j
|
||¬« }|| j
|
j |j |j f< | sy
|
|_ y)a
|
Each cell of the merged cell is created as MergedCell if it does not
|
already exist.
|
|
The MergedCells at the edge of the merged cell gets its borders from
|
the upper left cell.
|
|
- The top MergedCells get the top border from the top left cell.
|
- The bottom MergedCells get the bottom border from the top left cell.
|
- The left MergedCells get the left border from the top left cell.
|
- The right MergedCells get the right border from the top left cell.
|
)ÚtopÚleftr: r; Nr7 r+ )Úgetattrr3 rC Ústyler r2 r< r= r r8 r9 Ú
|
protectionÚcopyÚcells) r ÚnamesÚnameÚsiderC r r@ r8 ÚcolÚ protectedrJ s r ÚformatzMergedCellRange.format] sn ò 3àò &DÜ4??×1Ñ1°4Ó8DÙ
|
|
Ð*ØÜÑ*t DkÑ*FÜ tÓ,ò &Øww~~×)Ñ)¨%Ó0Ø<Ø $HCÜ% d§g¡g°3¸sÔCDØ>BDGGNN D§H¡H¨d¯k©kÐ#:Ñ;Ø vÑ% ñ &ð &ð OO×.Ñ.°dÐ: Ù Ü 4§?¡?×#=Ñ#=Ó>JØZZò -EØ77>>×%Ñ% eÓ,DØ|Ø SÜ! $§'¡'¨s¸3Ô?Ø:> §¡¨$¯+©+Ð 6Ñ7âØ",ñ -r c ó0 |t | j « v S r )r r )r r s r Ú __contains__z MergedCellRange.__contains__ s Ø $§*¡*Ó-Ð-Ð-r c óN | j | j | j « S r )r r2 r r s r r zMergedCellRange.__copy__ s Ø~~dgg t§z¡zÓ2Ð2r )
|
r r r Ú__doc__r r4 rR rT r r r s @r r/ r/ 9 s# ø ñô òLò((-òV.ö3r r/ )rK Ú!openpyxl.descriptors.serialisabler Úopenpyxl.descriptorsr r Úopenpyxl.cell.cellr Úopenpyxl.styles.bordersr Ú
|
cell_ranger r r" r/ r+ r r ú<module>r\ sC ðó å :÷õ
|
*Ý *å !ô( ô (ô$# ô #ô,T3iõ T3r
|
