hkSrSSKJr SSKJr SSKJr SSKJr SSK J r SSK J r J r JrJr SSKJrJr SS KJr SS KJr SS KJr SS KJr SS KJr SSKJr SSKJ r J!r!J"r" SSK#J$r$J%r%J&r&J'r' SSK(J)r) SSK*J+r+ SSK,J-r-J.r.J/r/ SSK0J1r1J2r2 SSK3J4r4 SSK5J6r6 SSK7J8r8J9r9 SSK:J;r; SSKJ?r? SSK@JArAJBrBJCrCJDrD "SS\5rESrFg )!z.Worksheet is the 2nd-level container in Excel.)chain) itemgetter) isgenerator)warn) deprecated)column_index_from_stringget_column_letterrange_boundariescoordinate_to_tuple)Cell MergedCell)ConditionalFormattingList)RelationshipList)_WorkbookChild)DefinedNameDict) Translator)DataValidationList)PrintPageSetup PageMargins PrintOptions)ColumnDimension RowDimensionDimensionHolderSheetFormatProperties)SheetProtection) AutoFilter)Pane Selection SheetViewList)MultiCellRange CellRange)MergedCellRange)WorksheetProperties)RowBreakColBreak) ScenarioList) TableList) ArrayFormula) PrintTitlesColRangeRowRange PrintAreacz\rSrSrSrSrSrSrSrSr Sr S r S r S r S rS rSrSrSrSrSrSrSrSrSrSrSrSWSjrSr\S5r\S5r\S5r \S5r!\S 5r"\S!5r#\#RHSWS"j5r#SWS#jr%S$r&S%r'S&r(S'r)S(r*S)r+\S*5r,\S+5r-\S,5r.\S-5r/S.r0\S/5r1SXS0jr2SYS1jr3\S25r4\S35r5SXS4jr6SYS5jr7\S65r8\S75r9S8r:S9r;SWS:jr\S=5r?S>r@SZS?jrAS@rB\\C"SA5SB55rDSZSCjrESDrFS[SEjrGS\SFjrHS\SGjrIS\SHjrJS\SIjrKS]SJjrLSYSKjrMSLrNSMrOSNrP\SO5rQ\QRHSP5rQ\SQ5rR\RRHSR5rR\SS5rS\ST5rT\TRHSU5rTSVrUg)^ WorksheetDzyRepresents 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+xmlrrvisiblehidden veryHidden1234567891011portrait landscapeNcR[R"XU5 UR5 gN)r__init___setup)selfparenttitles N/var/www/html/env/lib/python3.13/site-packages/openpyxl/worksheet/worksheet.pyrEWorksheet.__init__ise4 c*[UURS9Ul[UURS9Ul[ 5Ul[5Ul0Ul /Ul /Ul [5Ul SUl/Ul[!5Ul[%5Ul/Ul[+5Ul/UlSUl[3US9Ul[75UlSUlSUl[?5Ul [C5Ul"[G5Ul$[K5Ul&[O5Ul(SUl)[U5Ul+[Y5Ul-SUl.[_5Ul0[c5Ul2[g5Ul4g)N)r1default_factoryr3)r1r)5r_add_rowrow_dimensions _add_columncolumn_dimensionsr% row_breaksr& col_breaks_cells_charts_imagesr_rels_drawing _commentsr! merged_cellsr(_tables_pivotsrdata_validations _hyperlinks sheet_stater page_setupr print_options _print_rows _print_colsr- _print_arear page_marginsr viewsr protectionr defined_names _current_rowr auto_filterrconditional_formattinglegacy_drawingr$sheet_propertiesr sheet_formatr' scenariosrGs rJrFWorksheet._setupmsC->BmmM!04AEAQAQ"S"*"*   %'  *, {  2 4$(48)^$;'M"_ )+,.%<&?&A#" 3 513%rLc.URR$rD)rgactiverqs rJ sheet_viewWorksheet.sheet_viewszz   rLcHURRSR$Nr)ru selectionsqrefrqs rJ selected_cellWorksheet.selected_cells((+111rLcHURRSR$rx)rury activeCellrqs rJ active_cellWorksheet.active_cells((+666rLc0nURR5HXnURS:XdM[UR[ 5(dM6URR XR'MZ U$)zHReturns a dictionary of cells with array formulae and the cells in arrayf)rUvalues data_type isinstancevaluer)ref coordinate)rGresultcs rJarray_formulaeWorksheet.array_formulaesX##%A{{c!agg|44+,77;;F<<(& rLc.URR$rD)ru showGridLinesrqs rJshow_gridlinesWorksheet.show_gridliness,,,rLcrURRb URRR$grD)rupane topLeftCellrqs rJ freeze_panesWorksheet.freeze_paness- ??   +??''33 3 ,rLc [U[5(a URnUS:XaSnU(dSURlg[ U5up#URn[ USSS9UlSURSlUS:aUS- URlUS:adUS- URl SURl SURSlUS:a%SURSlSURl US:aYUS:aR[UR5nURS[SSSS 95 URS[SSSS 95 XTlggg) NA1topRightfrozen)r activePanestaterr bottomLeft bottomRight)rr~rz)rr rrurr rryxSplitySplitrlistinsertr)rGrrowcolumnviewsels rJrrs9 k4 ( (%00K $ K#'DOO )+6 [#-&( ",q A:%zDII  7"QwDII #/DII %1DNN1  "z)6q!&'4 $ 7vzt~~&C JJq)DQ R JJq)$dS T N "7rLchUS:dUS:a [S5eURX5nUbX4lU$)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 rz'Row or column values must be at least 1) ValueError _get_cellr)rGrrrcells rJrWorksheet.cells;* 7fqjFG G~~c*  J rLcSUs=:aS:dO [SU35eX4nX0R;a[XUS9nURU5 URU$)zk Internal method for getting a cell from a worksheet. Will create a new cell if one doesn't already exist. rizCRow numbers must be between 1 and 1048576. Row number supplied was rr)rrUr _add_cell)rGrrrrs rJrWorksheet._get_cells^ 3  bcfbghi i] [[(f5D NN4 {{:&&rLcURnURn[X0R5UlXRX24'g)z* Internal method for adding cell objects. N)col_idxrmaxrjrU)rGrrrs rJrWorksheet._add_cell s7hh%6%67%) SM"rLc [U[5(af[URUR/5(d[ SR U55eSR URUR5n[U[5(a [U5n[U5up#pE[X#XE/5(d[ SR U55eUc&[URX$55nX$:XaUSnU$Uc0[URX#URUS95nX5:XaUSnU$SU;aURX25$[URX2XTS95$)a<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_colmin_rowmax_colmax_row:)rrrr)rsliceallstartstop IndexErrorformatintstrr anytuple iter_cols iter_rows max_columnr)rGkeyrrrrcolsrowss rJ __getitem__Worksheet.__getitem__sQ c5 ! ! 388,-- !I!P!PQT!UVV""399chh7C c3  cC-=c-B*'Gg788ELLSQR R ?9:D!AwK ?04(RSD!AwK c>>>'3 3T^^G,3$FG GrLcX UlgrDr)rGrrs rJ __setitem__Worksheet.__setitem__<s S rLc"UR5$rDrrqs rJ__iter__Worksheet.__iter__@s~~rLc^[U5up#X#4UR;aURX#4 ggrD)r rU)rGrrrs rJ __delitem__Worksheet.__delitem__Ds/)#.  =DKK ' SM* (rLc\SnUR(a[UR5SnU$)z'Worksheet.min_column..j4 1A$ r)rGrs rJ min_columnWorksheet.min_columnb)  ;;4 44GrLcdSnUR(a[SUR55nU$)z?The maximum column index containing data (1-based) :type: int rc3*# UH oSv M g7frrrs rJr'Worksheet.max_column..vrrr)rGrs rJrWorksheet.max_columnnrrLcPUR(ax[5n[5nURH'up4URU5 URU5 M) [U5n[U5n[ U5n[ U5nOg[ U5US[ U5U3$)z_Return the minimum bounding range for all cells containing data (ex. 'A1:M24') :rtype: string zA1:A1r)rUsetaddrrr ) rGrrrcolrrrrs rJcalculate_dimensionWorksheet.calculate_dimensionzs ;;5D5D KK  ($iG$iG$iG$iG#G,-gYa8I'8R7ST[S\]]rLc"UR5$)z1Returns the result of :func:`calculate_dimension`)rrqs rJ dimensionsWorksheet.dimensionss''))rLcURS:Xa[X1XB/5(d [S5$U=(d SnU=(d SnU=(d URnU=(d URnUR X1XBU5$)ao 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 rrr)rjriterrr _cells_by_row)rGrrrr values_onlys rJrWorksheet.iter_rowsso6    !#w.S*T*T8O,Q,Q,T__)T\\!!'GkRRrLc#^^# [X$S-5HFmUU4Sj[XS-55nU(a[SU55v M9[U5v MH g7f)Nrc3D># UHnTRTUS9v M g7frNr)rrrrGs rJr*Worksheet._cells_by_row..s aE`6TYY3vY6E` c38# UHoRv M g7frDrrrs rJrr954JJ5ranger)rGrrrrrcellsrs` @rJrWorksheet._cells_by_rowsLA+.CaU7^_T_E`aE95999El" /AAc"UR5$)zVProduces all cells in the worksheet, by row (see :func:`iter_rows`) :type: generator rrqs rJrWorksheet.rowss ~~rLc#@# URSS9HnUv M g7f)zDProduces all cell values in the worksheet, by row :type: generator T)rNr)rGrs rJrWorksheet.valuess! >>d>3CI4scURS:Xa[XX$/5(d [S5$U=(d SnU=(d SnU=(d URnU=(d URnUR XX$U5$)ar 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 rrr)rjrrrr _cells_by_col)rGrrrrrs rJrWorksheet.iter_colssm6    !#w.R*S*S8O,Q,Q,T__)T\\!!'GkRRrLc#^^# [XS-5HFmUU4Sj[X$S-55nU(a[SU55v M9[U5v MH g7f)z Get cells by column rc3D># UHnTRUTS9v M g7frr)rrrrGs rJr*Worksheet._cells_by_col..s%>##(!)#<>E95999El" 0r c"UR5$)zGProduces all cells in the worksheet, by column (see :func:`iter_cols`))rrqs rJcolumnsWorksheet.columns s~~rLcURR5Vs/sH=oR(dMURUR:dM1URPM? sn$s snf)z; Return a list of column ranges where more than one column )rRrrrr)rGcds rJ column_groupsWorksheet.column_groupssN $(#9#9#@#@#Ba#BRffQSQWQWZ\Z`Z`Q`#BaaasA$A$A$cDXRlX Rlg)zSet printer settings N)ra paperSize orientation)rG paper_sizer!s rJset_printer_settingsWorksheet.set_printer_settingss%/!&1#rLc:URRU5 g)zAdd 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)rGdata_validations rJadd_data_validationWorksheet.add_data_validation s $$_5rLcLUbX!lURRU5 g)zL Add a chart to the sheet Optionally provide a cell for the top-left anchor N)anchorrVr&)rGchartr+s rJ add_chartWorksheet.add_chart(s!  !L E"rLcLUbX!lURRU5 g)zN Add an image to the sheet. Optionally provide a cell for the top-left anchor N)r+rWr&)rGimgr+s rJ add_imageWorksheet.add_image2s!  J C rLcURRUR5(a$[SR UR55e[ US5(d [ S5 URRU5 g)zZ Check for duplicate name in definedNames and other worksheet tables before adding table. z"Table with name {0} already existsrz6In write-only mode you must add table columns manuallyN) rH_duplicate_namenamerrhasattrrr\r)rGtables rJ add_tableWorksheet.add_table<s` ;; & &uzz 2 2AHHTU Ut[)) I J rLcUR$rD)r\rqs rJtablesWorksheet.tablesIs ||rLc:URRU5 grD)r]r&)rGpivots rJ add_pivotWorksheet.add_pivotNs E"rLcUc[XUXTS9nURn[X5nURR U5 UR U5 g)z?Set merge on a cell range. Range is a cell range (e.g. A1:E1) N range_stringrrrr)r"coordr#r[r_clean_merge_range)rGrC start_row start_columnend_row end_columncrmcrs rJ merge_cellsWorksheet.merge_cellsRsO   T](;B88Ld1 c" $rLcURn[U5 UHup4[XU5URX44'M! UR 5 g)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 rUr)rGrKr rrs rJrEWorksheet._clean_merge_range]s@   U HC$.t#$>DKK ! rLzUse ws.merged_cells.rangesc4URRSS$)zReturn a copy of cell rangesN)r[rangesrqs rJmerged_cell_rangesWorksheet.merged_cell_rangesjs  ''**rLc,[XUXTS9nURUR;a$[SR UR55eURR U5 UR n[U5 UHupURX4 M g)zBRemove merge on a cell range. Range is a cell range (e.g. A1:E1) rBzCell range {0} is not mergedN) r"rDr[rrremover rOrU) rGrCrFrGrHrIrJr rrs rJ unmerge_cellsWorksheet.unmerge_cellsqs LPY(; 884,, ,;BB288LM M   $ U HC SJ'rLcURS-n[U[[[45(d[ U5(a[ US5Htup4[U[5(aAUnUR(aURU:wa [S5eXlX5l X%l O [XX4S9nXPRX#4'Mv Oy[U[5(aSUR5H>up4[U[5(a [!U5n[XX4S9nXPRX#4'M@ OUR#U5 X lg)aeAppends 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 rz,Cells cannot be copied from other worksheets)rrrN)rjrrrrr enumerater rHrrrrUdictitemsrr _invalid_row)rGiterablerow_idxrcontentrs rJr&Worksheet.appends $##a' x$u!5 6 68$$$-h$: gt,,"D{{t{{d':()WXX"&K")K&H'QD26 W./%;$ ' '$,NN$4 gs++6w?GDgM26 W./ %5   h '#rLc0US:nSnSnUS:XaURUS9nUnSn OURUS9nUnSn [U5n[UR[ U 5US9H3upU(aX:aMU(aX:aM!UR XXg5 M5 g)z2 Move either rows or columns around by the offset rr)r)rr)rreverseN)rrrsortedrUr _move_cell) rGrroffset row_or_colrc row_offset col_offsetr rrrs rJ _move_cellsWorksheet._move_cellss1*    NN7N3EJCNN7N3EJCU !$++:c?GTKC3=V- OOC @ UrLcFURXSS9 URUlg)z$ Insert row or rows before row==idx rrrfrgN)rjrrjrGidxamounts rJ insert_rowsWorksheet.insert_rowss# F LLrLc$URXSS9 g)z* Insert column or columns before col==idx rrrfrgN)rjrns rJ insert_colsWorksheet.insert_colss IrLcZ[XUR5nURX-U*SS9 URnURS-nUH6n[ XE5H$nXg4UR ;dMUR Xg4 M& M8 URUlUR (dSUlgg)z" Delete row or rows from row==idx rrmrrN)_gutterrrjrrrrUrj)rGrorp remainderrrrrs rJ delete_rowsWorksheet.delete_rowss C6  VGN////A%CW.:, CH-/!LL{{ !D rLc[XUR5nURX-U*SS9 URnURS-nUH6n[ XE5H$nXv4UR ;dMUR Xv4 M& M8 g)z( Delete column or columns from col==idx rrtrN)rxrrjrrrrU)rGrorpryrrrrs rJ delete_colsWorksheet.delete_colss{ C9  VGQ,,,,"CW.:, CH-/rLc[U[5(a [U5n[U[5(d [S5eU(dU(dgUS:nUS:nU(a[ UR US9nO[ UR US9n[R"U5HupURXX#U5 M URX#S9 g)z 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)rc) row_shift col_shift) rrr"rrdrrr from_iterablereshift) rG cell_rangerr translatedownrightr rrs rJ move_rangeWorksheet.move_ranges j# & &":.J*i00BC CD axq :??D9E:??E:E++E2HC OOCd) <3 48rLcxURX5nURU-nURU-nX`RXx4'URURUR4 XvlXlU(aFURS:Xa5[ UR UR5n U RX4S9Ulggg)zN Move a cell from one place to another. Delete at old index Rebase coordinate r) row_delta col_deltaN) rrrrUrrrrtranslate_formula) rGrrrhrirrnew_rownew_colts rJreWorksheet._move_cell!s ~~c*((Z'++ *(, G$% KK4;;/ 0 3.4::t7A,,z,XDJ/9rLcH[SR[U555e)NzQValue must be a list, tuple, range or generator, or a dict. Supplied value is {0}) TypeErrorrtype)rGr^s rJr]Worksheet._invalid_row3s$krr N rLc[U5$)z(Dimension factory for column information)rrqs rJrQWorksheet._add_column9st$$rLc[U5$)z%Dimension factory for row information)rrqs rJrOWorksheet._add_row>sD!!rLcPUR(a[UR5$g)z7Rows to be printed at the top of every page (ex: '1:3')N)rcrrqs rJprint_title_rowsWorksheet.print_title_rowsD#   t''( ( rLc,Ub[U5Ulgg)z> Set rows to be printed on the top of every page format `1:3` N)r,rc)rGrs rJrrK  '~D  rLcPUR(a[UR5$g)z@Columns to be printed at the left side of every page (ex: 'A:C')N)rdrrqs rJprint_title_colsWorksheet.print_title_colsUrrLc,Ub[U5Ulgg)z@ Set cols to be printed on the left of every page format ``A:C` N)r+rd)rGrs rJrr\rrLcj[URURURS9n[ U5$)N)rrrI)r*rdrcrIr)rGtitless rJ print_titlesWorksheet.print_titlesfs-$"2"29I9IQUQ[Q[\6{rLcbURURl[UR5$)zp The print area for the worksheet, or None if not set. To set, supply a range like 'A1:D4' or a list of ranges. )rIrerrqs rJ print_areaWorksheet.print_areals' "&4##$$rLc U(d[5Ulg[U[5(a[R"U5Ulg[ US5(a+[R"SR U55Ulgg)zr 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-rerr from_stringr6join)rGrs rJrrvs^ ({D  s # #(44U;D  UJ ' '(44SXXe_ED (rL) rUrVrZrjrYr_rWr]rerdrcrXr\rkrTrRrlr^rirmr[rfrarbrhrSrPrprornr`rgrD)NNNNF)F)NNNNN)NNrr)r)rrF)V__name__ __module__ __qualname____firstlineno____doc__ _rel_type_path mime_type BREAK_NONE BREAK_ROW BREAK_COLUMNSHEETSTATE_VISIBLESHEETSTATE_HIDDENSHEETSTATE_VERYHIDDENPAPERSIZE_LETTERPAPERSIZE_LETTER_SMALLPAPERSIZE_TABLOIDPAPERSIZE_LEDGERPAPERSIZE_LEGALPAPERSIZE_STATEMENTPAPERSIZE_EXECUTIVE PAPERSIZE_A3 PAPERSIZE_A4PAPERSIZE_A4_SMALL PAPERSIZE_A5ORIENTATION_PORTRAITORIENTATION_LANDSCAPErErFpropertyrur{rrrrsetterrrrrrrrrrrrrrrrrrrrrrr#r(r-r1r8r;r?rLrErrSrWr&rjrqrurzr}rrer]rQrOrrrr__static_attributes__rrLrJr/r/Ds\I )E[IJIL" ( OLLL&'#(L!!2277--44  ! !F> '*&GR  + ^*** $SN#  #SL #  bb26#!  #% ,-+.+ ( -$`A8)J"*.$9<Y$ % " )) ..)) .. %% F FrLr/c\[[US-U- U5[X-U5S-5nU$)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)rrr)rorfmax_valgutters rJrxrxs3 3wqy'-s3:w/G/I JF MrLN)Gr itertoolsroperatorrinspectrwarningsropenpyxl.compatropenpyxl.utilsrr r r openpyxl.cellr r openpyxl.formatting.formattingropenpyxl.packaging.relationshipropenpyxl.workbook.childropenpyxl.workbook.defined_nameropenpyxl.formula.translaterdatavalidationrpagerrrrrrrrrhrfiltersrrgrrr rr!r"merger# propertiesr$ pagebreakr%r&scenarior'r7r(formular)print_settingsr*r+r,r-r/rxrrLrJrs5  +D<22.  ( 2"+)"!} F} F@rL