Ë
|
dñúh´k ã ó d Z ddlmZ ddlmZ ddlmZ ddlmZ ddl m
|
Z
|
ddl m Z m Z mZmZ ddlmZmZ dd lmZ dd
|
lmZ dd lmZ dd lmZ dd lm Z ddl m Z ddl m Z m!Z!m"Z" ddl#m$Z$m%Z%m&Z&m'Z' ddl(m)Z) ddl*m+Z+ ddl,m-Z-m.Z.m/Z/ ddl0m1Z1m2Z2 ddl3m4Z4 ddl5m6Z6 ddl7m8Z8m9Z9 ddl:m;Z; ddl<m=Z= ddl>m?Z? dd l@mAZAmBZBmCZCmDZD G d d e« ZEd ZFy )!z.Worksheet is the 2nd-level container in Excel.é )Úchain)Ú
|
itemgetter)Ú isgenerator)Úwarn)Ú
|
deprecated)Úcolumn_index_from_stringÚget_column_letterÚrange_boundariesÚcoordinate_to_tuple)ÚCellÚ
|
MergedCell)ÚConditionalFormattingList)ÚRelationshipList)Ú_WorkbookChild)ÚDefinedNameDict)Ú
|
Translatoré )ÚDataValidationList)ÚPrintPageSetupÚ PageMarginsÚ PrintOptions)ÚColumnDimensionÚ RowDimensionÚDimensionHolderÚSheetFormatProperties)ÚSheetProtection)Ú
|
AutoFilter)ÚPaneÚ SelectionÚ SheetViewList)ÚMultiCellRangeÚ CellRange)ÚMergedCellRange)ÚWorksheetProperties)ÚRowBreakÚColBreak)Ú ScenarioList)Ú TableList)Ú ArrayFormula)Ú PrintTitlesÚColRangeÚRowRangeÚ PrintAreac óN e Zd ZdZdZdZdZdZdZdZ dZ
|
d Z d
|
Z d Z d Zd ZdZdZdZdZdZdZdZdZdZdZdUdZd Ze d « Z e d « Z e d « Z e d « Z e d « Z!e d « Z"e"jF dUd!« Z"dUd"Z$d# Z%d$ Z&d% Z'd& Z(d' Z)d( Z*e d) « Z+e d* « Z,e d+ « Z-e d, « Z.d- Z/e d. « Z0dVd/Z1dWd0Z2e d1 « Z3e d2 « Z4dVd3Z5dWd4Z6e d5 « Z7e d6 « Z8d7 Z9d8 Z:dUd9Z;dUd:Z<d; Z=e d< « Z>d= Z?dXd>Z@d? ZAe eBd@« dA « « ZCdXdBZDdC ZEdYdDZFdZdEZGdZdFZHdZdGZIdZdHZJd[dIZKdWdJZLdK ZMdL ZNdM ZOe dN « ZPePjF dO « ZPe dP « ZQeQjF dQ « ZQe dR « ZRe dS « ZSeSjF dT « ZSy)\Ú Worksheetz
Represents a worksheet.
|
|
Do not create worksheets yourself,
|
use :func:`openpyxl.workbook.Workbook.create_sheet` instead
|
|
Ú worksheetz/xl/worksheets/sheet{0}.xmlzIapplication/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xmlr r é ÚvisibleÚhiddenÚ
|
veryHiddenÚ1Ú2Ú3Ú4Ú5Ú6Ú7Ú8Ú9Ú10Ú11ÚportraitÚ landscapeNc óR t j | ||« | j « y ©N)r Ú__init__Ú_setup)ÚselfÚparentÚtitles úOH:\Change_password\venv_build\Lib\site-packages\openpyxl/worksheet/worksheet.pyrD zWorksheet.__init__i s Ü× Ñ f¨eÔ4Ø ó c ó< t | | j ¬« | _ t | | j ¬« | _ t « | _ t « | _ i | _ g | _
|
g | _ t « | _ d | _ g | _ t! « | _ t% « | _ g | _ t+ « | _ g | _ d| _ t3 | ¬« | _ t7 « | _ d | _ d | _ t? « | _ tC « | _" tG « | _$ tK « | _& tO « | _( d| _) tU « | _+ tY « | _- d | _. t_ « | _0 tc « | _2 tg « | _4 y )N)r0 Údefault_factoryr2 )r0 r )5r Ú_add_rowÚrow_dimensionsÚ _add_columnÚcolumn_dimensionsr% Ú
|
row_breaksr& Ú
|
col_breaksÚ_cellsÚ_chartsÚ_imagesr Ú_relsÚ_drawingÚ _commentsr! Ú merged_cellsr( Ú_tablesÚ_pivotsr Údata_validationsÚ _hyperlinksÚ sheet_stater Ú
|
page_setupr Ú print_optionsÚ _print_rowsÚ _print_colsr- Ú _print_arear Ú page_marginsr Úviewsr Ú
|
protectionr Ú defined_namesÚ _current_rowr Ú auto_filterr Úconditional_formattingÚlegacy_drawingr$ Úsheet_propertiesr Ú sheet_formatr' Ú scenarios©rF s rI rE zWorksheet._setupm sC Ü -¸Ø>B¿m¹mô MÔä!0¸4ØAE×AQÑAQô"SÔ ä"*Ü"*Ø Ø Ø Ü%Ó'
|
Ø ØÜ *Ó ,ÔÜ { Ø Ü 2Ó 4Ô Ø ÔØ$ÔÜ(°4Ô8Ü )^ÔØ ÔØ ÔÜ$;ÔÜ 'MÔÜ"_
|
Ü)Ó+Ü ,Ó .Ôà ÔÜ%<ÔÜ&?Ó&AÔ#Ø "ÔÜ 3Ó 5Ô Ü 1Ó 3ÔÜ% rJ c ó. | j j S rC )re Úactivero s rI Ú
|
sheet_viewzWorksheet.sheet_view s àzz× Ñ Ð rJ c óH | j j d j S ©Nr )rr Ú selectionÚsqrefro s rI Ú selected_cellzWorksheet.selected_cell s à×(Ñ(¨Ñ+×1Ñ1Ð1rJ c óH | j j d j S rt )rr ru Ú
|
activeCellro s rI Ú active_cellzWorksheet.active_cell s à×(Ñ(¨Ñ+×6Ñ6Ð6rJ c óä i }| j j « D ]P }|j dk( st |j t
|
« s.|j j ||j < R |S )zHReturns a dictionary of cells with array formulae and the cells in arrayÚf)rS ÚvaluesÚ data_typeÚ
|
isinstanceÚvaluer) ÚrefÚ
|
coordinate)rF ÚresultÚcs rI Úarray_formulaezWorksheet.array_formulae¢ s\ ð Ø×#Ñ#Ó%ò 7AØ{{cÓ!Ü agg¤|Õ4Ø+,¯7©7¯;©;F1<<Ò(ð 7ð rJ c ó. | j j S rC )rr Ú showGridLinesro s rI Úshow_gridlineszWorksheet.show_gridlines s à×,Ñ,Ð,rJ c óp | j j | j j j S y rC )rr ÚpaneÚ topLeftCellro s rI Ú freeze_paneszWorksheet.freeze_panes² s- à ??× Ñ Ð +Ø??×'Ñ'×3Ñ3Ð 3ð ,rJ c ó¾ t |t « r |j }|dk( rd }|sd | j _ y t |« \ }}| j }t |dd¬« |_ d|j d _ |dkD r|dz
|
|j _ |dkD rc|dz
|
|j _ d|j _
|
d|j d _ |dkD r%d|j d _ d|j _
|
|dkD r_|dkD rYt |j « }|j dt dd d ¬ « « |j dt dd d ¬ « « ||_ y y y )
|
NÚA1ÚtopRightÚfrozen)r Ú
|
activePaneÚstater r Ú
|
bottomLeftÚ bottomRight)r ry rv )r r r rr r r r ru ÚxSplitÚySplitr ÚlistÚinsertr )rF r ÚrowÚcolumnÚviewÚsels rI r zWorksheet.freeze_panes¸ s: ä k¤4Ô (Ø%×0Ñ0KØ $Ò Ø KáØ#'DOOÔ Ø ä)¨+Ó6 VàÜ [Ø#-Ø &ô( ð ",qÑÔ à A:Ø %¨zDIIÔ Ø 7Ø " QwDIIÔ Ø#/DIIÔ Ø%1DNN1Ñ Ô "ØzØ)6qÑ!Ô&Ø'4 Ô$à 7v zÜt~~Ó&CØ JJq)¨ÀÈDÔQÔ RØ JJq)¨ À$ÈdÔSÔ TØ DNð "7rJ c óf |dk s|dk r t d« | j ||« }|||_ |S )a
|
Returns a cell object based on the given coordinates.
|
|
Usage: cell(row=15, column=1, value=5)
|
|
Calling `cell` creates cells in memory when they
|
are first accessed.
|
|
:param row: row index of the cell (e.g. 4)
|
:type row: int
|
|
:param column: column index of the cell (e.g. 3)
|
:type column: int
|
|
:param value: value of the cell (e.g. 5)
|
:type value: numeric or time or string or bool or none
|
|
:rtype: openpyxl.cell.cell.Cell
|
r z'Row or column values must be at least 1)Ú
|
ValueErrorÚ _get_cellr )rF r r r Úcells rI r zWorksheet.cellÜ s? ð* 7fqjÜ Ð FÓGÐ Gà~~c 6Ó*Ø Ð Ø DJà rJ c ó¸ d|cxk rdk sn t d| « ||f}|| j vr t | ||¬« }| j |« | j | S )z
|
Internal method for getting a cell from a worksheet.
|
Will create a new cell if one doesn't already exist.
|
r i zCRow numbers must be between 1 and 1048576. Row number supplied was ©r r )r rS r Ú _add_cell)rF r r r r s rI r zWorksheet._get_cellû sd ð
|
3Ô Ô Ü Ð bÐcfÐbgÐ hÓiÐ iØ6]
|
ØT[[Ñ(Ü #¨fÔ5DØ NN4Ô Ø{{:Ñ&Ð&rJ c ó |j }|j }t || j « | _ || j ||f< y)z:
|
Internal method for adding cell objects.
|
N)Úcol_idxr Úmaxrh rS )rF r r r s rI r£ zWorksheet._add_cell s= ð ØhhÜ T×%6Ñ%6Ó 7ÔØ%) S&MÒ"rJ c ó² t |t « rat |j |j g« st dj |« « dj |j |j « }t |t « r t |« }t |« \ }}}}t ||||g« st dj |« « |'t | j ||« « }||k( r|d }|S |4t | j ||| j |¬« « }||k( r|d }|S d|vr| j ||« S t | j ||||¬« « S )al Convenience access by Excel style coordinates
|
|
The key can be a single cell coordinate 'A1', a range of cells 'A1:D25',
|
individual rows or columns 'A', 4 or ranges of rows or columns 'A:D',
|
4:10.
|
|
Single cells will always be created if they do not exist.
|
|
Returns either a single cell or a tuple of rows or columns.
|
z&{0} is not a valid coordinate or rangez{0}:{1}r )Úmin_colÚmin_rowÚmax_colÚmax_rowú:)r© r¨ r« rª )r ÚsliceÚallÚstartÚstopÚ
|
IndexErrorÚformatÚintÚstrr
|
ÚanyÚtupleÚ iter_colsÚ iter_rowsÚ
|
max_columnr )rF Úkeyr¨ r© rª r« ÚcolsÚrowss rI Ú __getitem__zWorksheet.__getitem__ s[ ô c5Ô !Ü 3§8¡8Ð,Ô-Ü Ð!I×!PÑ!PÐQTÓ!UÓVÐVØ×"Ñ" 3§9¡9¨c¯h©hÓ7Cä c3Ô Ücó Cä-=¸cÓ-BÑ*' 7äGW g¨wÐ7Ô8Ü Ð E× LÑ LÈSÓ QÓRÐ Rà ?Ü ¨°Ó9Ó:DØ'Ò!ØAwØKØ ?Ü °ÀØ04·±Èð (ó Ró SDà'Ò!ØAwØKØ c>Ø>> '¨7Ó3Ð 3ÜT^^¨G¸WØ,3¸Wð $ó Fó Gð GrJ c ó || | _ y rC ©r )rF rº r s rI Ú __setitem__zWorksheet.__setitem__< s Ø S rJ c ó" | j « S rC ©r¸ ro s rI Ú__iter__zWorksheet.__iter__@ s Ø~~Ó Ð rJ c ó` t |« \ }}||f| j v r| j ||f= y y rC )r rS )rF rº r r s rI Ú __delitem__zWorksheet.__delitem__D s5 Ü)¨#Ó. VØ =DKKÑ 'Ø S &MÑ*ð (rJ c óR d}| j rt | j « d }|S )zLThe minimum row index containing data (1-based)
|
|
:type: int
|
r r ©rS Úmin)rF r© s rI r© zWorksheet.min_rowJ ó( ð Ø ;;Ü$++Ó& qÑ)GØrJ c óR d}| j rt | j « d }|S )zLThe maximum row index containing data (1-based)
|
|
:type: int
|
r r ©rS r¦ )rF r« s rI r« zWorksheet.max_rowV rÉ rJ c óZ d}| j r t d | j D « « }|S )zOThe minimum column index containing data (1-based)
|
|
:type: int
|
r c 3 ó& K | ] }|d yw©r N© ©Ú.0r s rI ú <genexpr>z'Worksheet.min_column.<locals>.<genexpr>j ó è ø Ò4 1!A$Ñ4ùó rÇ )rF r¨ s rI Ú
|
min_columnzWorksheet.min_columnb ó) ð Ø ;;ÜÑ4¨¯ © Ô4Ó4GØrJ c óZ d}| j r t d | j D « « }|S )zOThe maximum column index containing data (1-based)
|
|
:type: int
|
r c 3 ó& K | ] }|d ywrÎ rÏ rÐ s rI rÒ z'Worksheet.max_column.<locals>.<genexpr>v rÓ rÔ rË )rF rª s rI r¹ zWorksheet.max_columnn rÖ rJ c óD | j rwt « }t « }| j D ]' \ }}|j |« |j |« ) t |« }t |« }t |« }t |« }nyt |« | dt |« | S )zoReturn the minimum bounding range for all cells containing data (ex. 'A1:M24')
|
|
:rtype: string
|
zA1:A1r¬ )rS ÚsetÚaddr¦ rÈ r ) rF r¼ r» r Úcolr« rª r¨ r© s rI Úcalculate_dimensionz Worksheet.calculate_dimensionz s ð
|
;;Ü5DÜ5DØ KKò SØ Ø ð ô $iGÜ$iGÜ$iGÜ$iGàä# GÓ,Ð-¨g¨Y°aÔ8IÈ'Ó8RÐ7SÐT[ÐS\Ð]Ð]rJ c ó" | j « S )z1Returns the result of :func:`calculate_dimension`)rÝ ro s rI Ú
|
dimensionszWorksheet.dimensions s ð ×'Ñ'Ó)Ð)rJ c óÖ | j dk( rt ||||g« s t d« S |xs d}|xs d}|xs | j }|xs | j }| j |||||« S )aï
|
Produces cells from the worksheet, by row. Specify the iteration range
|
using indices of rows and columns.
|
|
If no indices are specified the range starts at A1.
|
|
If no cells are in the worksheet an empty tuple will be returned.
|
|
:param min_col: smallest column index (1-based index)
|
:type min_col: int
|
|
:param min_row: smallest row index (1-based index)
|
:type min_row: int
|
|
:param max_col: largest column index (1-based index)
|
:type max_col: int
|
|
:param max_row: largest row index (1-based index)
|
:type max_row: int
|
|
:param values_only: whether only cell values should be returned
|
:type values_only: bool
|
|
:rtype: generator
|
r rÏ r )rh rµ Úiterr¹ r« Ú _cells_by_row)rF r© r« r¨ rª Ú values_onlys rI r¸ zWorksheet.iter_rows st ð6 × Ñ Ò !¬#¨w¸ÀÈ'Ð.SÔ*TÜ8Oð ,QØ,QØÒ,T__ØÒ)T\\à×!Ñ! '¨7°G¸WÀkÓRÐRrJ c # ó² K t ||dz « D ]? fdt ||dz « D « }|rt d |D « « 3t |« A y w)Nr c 3 óD K | ] }j |¬ « yw©r¢ N©r )rÑ r r rF s rI rÒ z*Worksheet._cells_by_row.<locals>.<genexpr>¾ s øè ø Òa¸6TYY 3¨vY×6Ñaùó c 3 ó4 K | ] }|j y wrC r¿ ©rÑ r s rI rÒ z*Worksheet._cells_by_row.<locals>.<genexpr>À ó è ø Ò9¨4DJJÑ9ùó ©Úranger¶ )rF r¨ r© rª r« rã Úcellsr s ` @rI râ zWorksheet._cells_by_row¼ sW ùè ø Ü '¨A¡+Ó.ò #CÜaÄUÈ7ÐT[Ð^_ÑT_ÓE`ÔaEÙÜÑ9°5Ô9Ó9Ó9äElÓ"ñ #ùó AAc ó" | j « S )zfProduces all cells in the worksheet, by row (see :func:`iter_rows`)
|
|
:type: generator
|
r ro s rI r¼ zWorksheet.rowsÅ s ð ~~Ó Ð rJ c # óB K | j d¬« D ] }| yw)zTProduces all cell values in the worksheet, by row
|
|
:type: generator
|
T)rã Nr )rF r s rI r} zWorksheet.valuesÎ s' è ø ð >>¨d>Ó3ò CØIñ ùs c óÖ | j dk( rt ||||g« s t d« S |xs d}|xs d}|xs | j }|xs | j }| j |||||« S )aò
|
Produces cells from the worksheet, by column. Specify the iteration range
|
using indices of rows and columns.
|
|
If no indices are specified the range starts at A1.
|
|
If no cells are in the worksheet an empty tuple will be returned.
|
|
:param min_col: smallest column index (1-based index)
|
:type min_col: int
|
|
:param min_row: smallest row index (1-based index)
|
:type min_row: int
|
|
:param max_col: largest column index (1-based index)
|
:type max_col: int
|
|
:param max_row: largest row index (1-based index)
|
:type max_row: int
|
|
:param values_only: whether only cell values should be returned
|
:type values_only: bool
|
|
:rtype: generator
|
r rÏ r )rh rµ rá r¹ r« Ú _cells_by_col)rF r¨ rª r© r« rã s rI r· zWorksheet.iter_colsØ sr ð6 × Ñ Ò !¬#¨w¸ÀÈ'Ð.RÔ*SÜ8Oà,QØ,QØÒ,T__ØÒ)T\\à×!Ñ! '¨7°G¸WÀkÓRÐRrJ c # ó² K t ||dz « D ]? fdt ||dz « D « }|rt d |D « « 3t |« A yw)z%
|
Get cells by column
|
r c 3 óD K | ] }j |¬ « ywræ rç )rÑ r r rF s rI rÒ z*Worksheet._cells_by_col.<locals>.<genexpr> s& øè ø ò >Ø ð YY 3¨vY×6ñ >ùrè c 3 ó4 K | ] }|j y wrC r¿ rê s rI rÒ z*Worksheet._cells_by_col.<locals>.<genexpr> rë rì Nrí )rF r¨ r© rª r« rã rï r s ` @rI rô zWorksheet._cells_by_colþ s[ ùè ø ô G W¨Q¡YÓ/ò #Fô>Ü#(¨°'¸!±)Ó#<ô>EáÜÑ9°5Ô9Ó9Ó9äElÓ"ñ #ùrð c ó" | j « S )zGProduces all cells in the worksheet, by column (see :func:`iter_cols`))r· ro s rI ÚcolumnszWorksheet.columns s ð ~~Ó Ð rJ c ó¾ | j j « D cg c]5 }|j s|j |j kD s*|j 7 c}S c c}w )zK
|
Return a list of column ranges where more than one column
|
)rP r} rÈ r¦ rî )rF Úcds rI Ú column_groupszWorksheet.column_groups sF ð
|
$(×#9Ñ#9×#@Ñ#@Ó#BÖaRÀbÇfÃfÐQS×QWÑQWÐZ\×Z`ÑZ`ÓQ`ÒaÐaùÒas A¯AÁ Ac óH || j _ || j _ y)zSet printer settings N)r_ Ú paperSizeÚ orientation)rF Ú
|
paper_sizerÿ s rI Úset_printer_settingsz Worksheet.set_printer_settings s ð %/Ô!Ø&1Õ#rJ c ó: | j j |« y)zÍ Add a data-validation object to the sheet. The data-validation
|
object defines the type of data-validation to be applied and the
|
cell or range of cells it should apply to.
|
N)r\ Úappend)rF Údata_validations rI Úadd_data_validationz Worksheet.add_data_validation s ð
|
× Ñ ×$Ñ$ _Õ5rJ c óL |||_ | j j |« y)zd
|
Add a chart to the sheet
|
Optionally provide a cell for the top-left anchor
|
N)ÚanchorrT r )rF Úchartr s rI Ú add_chartzWorksheet.add_chart( s# ð
|
Ð Ø!ELØ ×ÑEÕ"rJ c óL |||_ | j j |« y)zf
|
Add an image to the sheet.
|
Optionally provide a cell for the top-left anchor
|
N)r rU r )rF Úimgr s rI Ú add_imagezWorksheet.add_image2 s# ð
|
Ð Ø CJØ ×ÑCÕ rJ c óú | j j |j « r$t dj |j « « t | d« s t d« | j j |« y)zr
|
Check for duplicate name in definedNames and other worksheet tables
|
before adding table.
|
z"Table with name {0} already existsr z6In write-only mode you must add table columns manuallyN) rG Ú_duplicate_nameÚnamer r² Úhasattrr rZ rÛ )rF Útables rI Ú add_tablezWorksheet.add_table< sZ ð ;;× &Ñ & u§z¡zÔ 2Ü Ð A× HÑ HÈÏÉÓ TÓUÐ UÜt[Ô)Ü ÐIÔ JØ ×ÑÕ rJ c ó | j S rC )rZ ro s rI ÚtableszWorksheet.tablesI s à||ÐrJ c ó: | j j |« y rC )r[ r )rF Úpivots rI Ú add_pivotzWorksheet.add_pivotN s Ø ×ÑEÕ"rJ c ó° | t |||||¬« }|j }t | |« }| j j |« | j |« y)z@ Set merge on a cell range. Range is a cell range (e.g. A1:E1) N©Ú range_stringr¨ r© rª r« )r" Úcoordr# rY rÛ Ú_clean_merge_range)rF r Ú start_rowÚ start_columnÚend_rowÚ
|
end_columnÚcrÚmcrs rI Ú merge_cellszWorksheet.merge_cellsR sU à Рܨ ¸lÐT]Ø (°'ô;Bà 88LÜ d LÓ1Ø ×Ñ× Ñ cÔ"Ø × Ñ Õ$rJ c ó |j }t |« |D ]! \ }}t | ||« | j ||f< # |j « y)z¢
|
Remove all but the top left-cell from a range of merged cells
|
and recreate the lost border information.
|
Borders are then applied
|
N)rï Únextr rS r² )rF r" rï r rÜ s rI r z Worksheet._clean_merge_range] sK ð Ü U Ø ò ?HCÜ$.¨t°S¸#Ó$>DKKSÒ !ð ?à
|
|
rJ zUse ws.merged_cells.rangesc ó4 | j j dd S )z Return a copy of cell rangesN)rY Úrangesro s rI Úmerged_cell_rangesz Worksheet.merged_cell_rangesj s ð × Ñ ×'Ñ'©Ð*Ð*rJ c ó2 t |||||¬« }|j | j vr$t dj |j « « | j j |« |j }t |« |D ] \ }} | j || f= y)zC Remove merge on a cell range. Range is a cell range (e.g. A1:E1) r z Cell range {0} is not mergedN) r" r rY r r² Úremoverï r% rS )
|
rF r r r r r r! rï r rÜ s
|
rI Ú unmerge_cellszWorksheet.unmerge_cellsq s ä L¸,ÐPYØ (°'ô;ð 884×,Ñ,Ñ ,Ü Ð ;× BÑ BÀ2Ç8Á8Ó LÓMÐ Mà ×Ñ× Ñ Ô$àÜ U Ø ò (HCØ S #JÑ'ñ (rJ c ó | j dz }t |t t t f« s t |« rt |d« D ]s \ }}t |t « r>|}|j r|j | k7 r t d« | |_ ||_
|
||_ nt | |||¬« }|| j ||f< u || _ yt |t « r[|j « D ]@ \ }}t |t « r t! |« }t | |||¬« }|| j ||f< B || _ y| j# |« || _ y)aµ Appends a group of values at the bottom of the current sheet.
|
|
* If it's a list: all values are added in order, starting from the first column
|
* If it's a dict: values are assigned to the columns indicated by the keys (numbers or letters)
|
|
:param iterable: list, range or generator, or dict containing values to append
|
:type iterable: list|tuple|range|generator or dict
|
|
Usage:
|
|
* append(['This is A1', 'This is B1', 'This is C1'])
|
* **or** append({'A' : 'This is A1', 'C' : 'This is C1'})
|
* **or** append({1 : 'This is A1', 3 : 'This is C1'})
|
|
:raise: TypeError when iterable is neither a list/tuple nor a dict
|
|
r z,Cells cannot be copied from other worksheets)r r r N)rh r r r¶ rî r Ú enumerater rG r r r rS ÚdictÚitemsr´ r Ú _invalid_row)rF ÚiterableÚrow_idxr¥ Úcontentr s rI r zWorksheet.append s7 ð$ ×#Ñ# aÑ'ä x¤$¬¬uÐ!5Ô 6Ü8Ô$Ü$-¨h¸Ó$:ò 7Ñ Ü g¤tÔ,à"DØ{{ t§{¡{°dÒ':Ü (Ð)WÓ XÐXØ"&DKØ")DKØ &DHä ¨'¸'ÈÔQDØ26 W gÐ .Ò/ð 7ð. $Õô ¤$Ô 'Ø$,§N¡NÓ$4ò 7Ñ Ü g¤sÔ+Ü 6°wÓ ?GÜD g°gÀWÔMØ26 W gÐ .Ò/ð 7ð $Õð × Ñ hÔ 'à #ÕrJ c ó* |dkD }d}d}|dk( r| j |¬« }|}d} n| j |¬« }|}d} t |« }t | j t | « |¬« D ]) \ }
|
} |r|
|
|k r|r| |k r| j |
|
| ||« + y)zB
|
Move either rows or columns around by the offset
|
r r )r© )r¨ r )rº ÚreverseN)r¸ r· r ÚsortedrS r Ú
|
_move_cell) rF r© r¨ ÚoffsetÚ
|
row_or_colr5 Ú
|
row_offsetÚ
|
col_offsetrï rº r r s rI Ú _move_cellszWorksheet._move_cells± s¯ ð 1*Ø
|
Ø
|
ð Ò ØNN¨7NÓ3EØ JØCàNN¨7NÓ3EØ JØCÜU ä! $§+¡+´:¸c³?ÈGÔTò AKCÙ3 =ØÙV gÒ -Øà OOC ¨°ZÕ @ñ ArJ c óN | j ||d¬« | j | _ y)z4
|
Insert row or rows before row==idx
|
r ©r© r8 r9 N)r< r« rh ©rF ÚidxÚamounts rI Ú insert_rowszWorksheet.insert_rowsÍ s% ð ×Ñ ¨VÀÐÔFØ LLÕrJ c ó, | j ||d¬« y)z:
|
Insert column or columns before col==idx
|
r ©r¨ r8 r9 N)r< r? s rI Ú insert_colszWorksheet.insert_colsÕ s ð ×Ñ ¨VÀÐÕIrJ c óR t ||| j « }| j ||z | d¬« | j }| j dz }|D ]3 }t ||« D ]" }||f| j v s| j ||f= $ 5 | j | _ | j sd| _ yy)z2
|
Delete row or rows from row==idx
|
r r> r r N)Ú_gutterr« r< rÕ r¹ rî rS rh )rF r@ rA Ú remainderr¨ rª r rÜ s rI Ú delete_rowszWorksheet.delete_rowsÜ s± ô
|
C ¨¯ © Ó6 à ×Ñ V¡°V°GÈÐÔNð //Ø// AÑ%Ø ò .CÜ W gÓ.ò .Ø: §¡Ò,Ø C¨ HÑ-ñ .ð .ð !LLÔØ{{Ø !DÕ ð rJ c ó t ||| j « }| j ||z | d¬« | j }| j dz }|D ]3 }t ||« D ]" }||f| j v s| j ||f= $ 5 y)z8
|
Delete column or columns from col==idx
|
r rD r N)rG r¹ r< r© r« rî rS )rF r@ rA rH r© r« rÜ r s rI Ú delete_colszWorksheet.delete_colsñ s ô
|
C ¨¯ © Ó9 à ×Ñ V¡°V°GÈÐÔQð ,,Ø,, Ñ"Ø ò .CÜ W gÓ.ò .Ø: §¡Ò,Ø C¨ HÑ-ñ .ñ .rJ c óz t |t « r t |« }t |t « s t d« |s|sy|dkD }|dkD }|rt |j
|
|¬« }nt |j |¬« }t j |« D ] \ }} | j || |||« |j ||¬« y)a
|
Move a cell range by the number of rows and/or columns:
|
down if rows > 0 and up if rows < 0
|
right if cols > 0 and left if cols < 0
|
Existing cells will be overwritten.
|
Formulae and references will not be updated.
|
z#Only CellRange objects can be movedNr )r5 )Ú row_shiftÚ col_shift) r r´ r" r r6 r¼ r» r Ú from_iterabler7 Úshift)
|
rF Ú
|
cell_ranger¼ r» Ú translateÚdownÚrightrï r rÜ s
|
rI Ú
|
move_rangezWorksheet.move_range s² ô j¤#Ô &Ü" :Ó.JÜ*¤iÔ0Ü Ð BÓCÐ CÙDØ àaxØqá Ü:??°DÔ9Eä:??°EÔ:Eä ×+Ñ+¨EÓ2ò =HCØ OOC d¨D°)Õ <ð =ð ×Ñ 4°4ÐÕ8rJ c ó~ | j ||« }|j |z }|j |z }|| j ||f< | j |j |j f= ||_ ||_ |rI|j dk( r9t |j |j « } | j ||¬« |_ yyy)zn
|
Move a cell from one place to another.
|
Delete at old index
|
Rebase coordinate
|
r| )Ú row_deltaÚ col_deltaN) r r r rS r~ r r r Útranslate_formula)
|
rF r r r: r; rR r Únew_rowÚnew_colÚts
|
rI r7 zWorksheet._move_cell! sª ð ~~c 6Ó*Ø((ZÑ'Ø++
|
Ñ*Ø(, GWÐ$Ñ%Ø KK 4§;¡;Ð/Ð 0ØØ Ù ¨3Ò.Ü4:: t§¡Ó7AØ×,Ñ,°zÈZÐ,ÓXDJð /9rJ c óH t dj t |« « « )NzQValue must be a list, tuple, range or generator, or a dict. Supplied value is {0})Ú TypeErrorr² Útype)rF r1 s rI r0 zWorksheet._invalid_row3 s$ ÜÐk×rÑrÜ Nó ó ð rJ c ó t | « S )z(Dimension factory for column information)r ro s rI rO zWorksheet._add_column9 s ô tÓ$Ð$rJ c ó t | « S )z%Dimension factory for row information)r ro s rI rM zWorksheet._add_row> s ô DÓ!Ð!rJ c óF | j rt | j « S y)z7Rows to be printed at the top of every page (ex: '1:3')N)ra r´ ro s rI Úprint_title_rowszWorksheet.print_title_rowsD ó# ð × Ò Üt×'Ñ'Ó(Ð (ð rJ c ó* |t |« | _ yy)zV
|
Set rows to be printed on the top of every page
|
format `1:3`
|
N)r, ra )rF r¼ s rI rc zWorksheet.print_title_rowsK ó ð Ð Ü '¨~DÕ ð rJ c óF | j rt | j « S y)z@Columns to be printed at the left side of every page (ex: 'A:C')N)rb r´ ro s rI Úprint_title_colszWorksheet.print_title_colsU rd rJ c ó* |t |« | _ yy)zX
|
Set cols to be printed on the left of every page
|
format ``A:C`
|
N)r+ rb )rF r» s rI rh zWorksheet.print_title_cols\ rf rJ c óp t | j | j | j ¬« }t |« S )N)r» r¼ rH )r* rb ra rH r´ )rF Útitless rI Ú print_titleszWorksheet.print_titlesf s- ä $×"2Ñ"2¸×9IÑ9IÐQU×Q[ÑQ[Ô\Ü6{ÐrJ c ób | j | j _ t | j « S )z
|
The print area for the worksheet, or None if not set. To set, supply a range
|
like 'A1:D4' or a list of ranges.
|
)rH rc r´ ro s rI Ú
|
print_areazWorksheet.print_areal s' ð "&§¡×ÑÔ Ü4×#Ñ#Ó$Ð$rJ c óê |st « | _ yt |t « rt j |« | _ yt |d« r*t j dj |« « | _ yy)z
|
Range of cells in the form A1:D4 or list of ranges. Print area can be cleared
|
by passing `None` or an empty list
|
rà ú,N)r- rc r r´ Ú from_stringr Újoin)rF r s rI rn zWorksheet.print_areav sX ñ Ü ({DÕ Ü sÔ #Ü (× 4Ñ 4°UÓ ;DÕ Ü UJÔ 'Ü (× 4Ñ 4°S·X±X¸e³_Ó EDÕ ð (rJ rC )NNNNF)F)NNNNN)NNr r )r )r r F)TÚ__name__Ú
|
__module__Ú __qualname__Ú__doc__Ú _rel_typeÚ_pathÚ mime_typeÚ
|
BREAK_NONEÚ BREAK_ROWÚ BREAK_COLUMNÚSHEETSTATE_VISIBLEÚSHEETSTATE_HIDDENÚSHEETSTATE_VERYHIDDENÚPAPERSIZE_LETTERÚPAPERSIZE_LETTER_SMALLÚPAPERSIZE_TABLOIDÚPAPERSIZE_LEDGERÚPAPERSIZE_LEGALÚPAPERSIZE_STATEMENTÚPAPERSIZE_EXECUTIVEÚ PAPERSIZE_A3Ú PAPERSIZE_A4ÚPAPERSIZE_A4_SMALLÚ PAPERSIZE_A5ÚORIENTATION_PORTRAITÚORIENTATION_LANDSCAPErD rE Úpropertyrr rw rz r
r r Úsetterr r r£ r½ rÀ rà rÅ r© r« rÕ r¹ rÝ rß r¸ râ r¼ r} r· rô rù rü r r r r r r r r# r r r( r+ r r< rB rE rI rK rU r7 r0 rO rM rc rh rl rn rÏ rJ rI r/ r/ D s\ ñð IØ )EØ[IàJØIØLà"ÐØ ÐØ (Ðð ÐØ ÐØÐØÐØOØ ÐØ ÐØLØLØ ÐØLð &ÐØ 'Ðóò#(ðL ñ!ó ð!ð ñ2ó ð2ð ñ7ó ð7ð ñó ðð ñ-ó ð-ð ñ4ó ð4ð
|
×Ñò !ó ð !óF ò> 'ò *ò&GòR ò ò+ð ñó ðð ñó ðð ñó ðð ñó ðò^ð* ñ*ó ð*ó
|
$SóN#ð ñ ó ð ð ñó ðó#SóL
|
#ð ñ ó ð ð
|
ñbó ðbò2ò6ó#ó!ò
|
ð ñ ó ð ò#ó%ò
|
ð ÙÐ,Ó-ñ+ó .ó ð+ó
|
(ò -$ó`Aó8)óJó"ó*.ó$9ó<Yò$ò %ò
|
"ð ñ)ó ð)ð × Ñ ñ.ó ð.ð ñ)ó ð)ð × Ñ ñ.ó ð.ð ñó ðð
|
ñ%ó ð%ð ×Ññ
|
Fó ñ
|
FrJ r/ c ó^ t t |dz |z
|
| « t | |z |« dz « }|S )zÈ
|
When deleting rows and columns are deleted we rely on overwriting.
|
This may not be the case for a large offset on small set of cells:
|
range(cells_to_delete) > range(cell_to_be_moved)
|
r )rî r¦ rÈ )r@ r8 Úmax_valÚgutters rI rG rG s5 ô 3wqy Ñ'¨Ó-¬s°3°v±:¸wÓ/GÈÑ/IÓ JFØ MrJ N)Grv Ú itertoolsr Úoperatorr Úinspectr Úwarningsr Úopenpyxl.compatr Úopenpyxl.utilsr r r
|
r Ú openpyxl.cellr r Ú openpyxl.formatting.formattingr Ú openpyxl.packaging.relationshipr Úopenpyxl.workbook.childr Ú openpyxl.workbook.defined_namer Úopenpyxl.formula.translater Údatavalidationr Úpager r r rß r r r r rf r Úfiltersr re r r r rQ r! r" Úmerger# Ú
|
propertiesr$ Ú pagebreakr% r& Úscenarior' r r( Úformular) Úprint_settingsr* r+ r, r- r/ rG rÏ rJ rI ú<module>r§ s ðñ 5õ Ý Ý Ý õ÷
|
ó ÷ +Ý DÝ <Ý 2õõ 2å .÷ñ ÷
|
ó õ (Ý ÷ñ ÷
|
2Ý "Ý +ß )Ý "Ý Ý !÷ó ô} Fô } Fó@rJ
|
