Index

A

a (openpyxl.drawing.effect.AlphaReplaceEffect attribute) aboveAverage (openpyxl.formatting.rule.Rule attribute) absolute_coordinate() (in module openpyxl.utils.cell) AbsoluteAnchor (class in openpyxl.drawing.spreadsheet_drawing) absoluteAnchor (openpyxl.drawing.spreadsheet_drawing.SpreadsheetDrawing attribute) accent1 (openpyxl.drawing.colors.ColorMapping attribute) accent2 (openpyxl.drawing.colors.ColorMapping attribute) accent3 (openpyxl.drawing.colors.ColorMapping attribute) accent4 (openpyxl.drawing.colors.ColorMapping attribute) accent5 (openpyxl.drawing.colors.ColorMapping attribute) accent6 (openpyxl.drawing.colors.ColorMapping attribute) action (openpyxl.drawing.text.Hyperlink attribute) (openpyxl.pivot.table.Format attribute) active (openpyxl.packaging.workbook.WorkbookPackage property) (openpyxl.workbook.workbook.Workbook property) (openpyxl.worksheet.views.SheetViewList property) active_cell (openpyxl.worksheet.worksheet.Worksheet property) activeCell (openpyxl.worksheet.views.Selection attribute) activeCellId (openpyxl.worksheet.views.Selection attribute) activePane (openpyxl.worksheet.views.Pane attribute) activeSheetId (openpyxl.workbook.views.CustomWorkbookView attribute) activeTab (openpyxl.workbook.views.BookView attribute) add() (openpyxl.formatting.formatting.ConditionalFormattingList method) (openpyxl.styles.differential.DifferentialStyleList method) (openpyxl.utils.indexed_list.IndexedList method) (openpyxl.workbook.defined_name.DefinedNameDict method) (openpyxl.worksheet.cell_range.MultiCellRange method) (openpyxl.worksheet.datavalidation.DataValidation method) (openpyxl.worksheet.table.TableList method) add_chart() (openpyxl.chartsheet.chartsheet.Chartsheet method) (openpyxl.worksheet.worksheet.Worksheet method) add_comment_shape() (openpyxl.comments.shape_writer.ShapeWriter method) add_comment_shapetype() (openpyxl.comments.shape_writer.ShapeWriter method) add_data_validation() (openpyxl.worksheet.worksheet.Worksheet method) add_filter_column() (openpyxl.worksheet.filters.AutoFilter method) add_image() (openpyxl.worksheet.worksheet.Worksheet method) add_named_style() (openpyxl.workbook.workbook.Workbook method) add_pivot() (openpyxl.worksheet.worksheet.Worksheet method) add_sort_condition() (openpyxl.worksheet.filters.AutoFilter method) add_table() (openpyxl.worksheet.worksheet.Worksheet method) AdjPoint2D (class in openpyxl.drawing.geometry) AdjustHandleList (class in openpyxl.drawing.geometry) ahLst (openpyxl.drawing.geometry.CustomGeometry2D attribute) algn (openpyxl.drawing.effect.OuterShadow attribute) (openpyxl.drawing.effect.ReflectionEffect attribute) (openpyxl.drawing.fill.TileInfoProperties attribute) (openpyxl.drawing.line.LineProperties attribute) (openpyxl.drawing.text.ParagraphProperties attribute) (openpyxl.drawing.text.TabStop attribute) algorithmName (openpyxl.chartsheet.protection.ChartsheetProtection attribute) (openpyxl.workbook.protection.FileSharing attribute) (openpyxl.worksheet.protection.SheetProtection attribute) Alias (class in openpyxl.descriptors.base) Alignment (class in openpyxl.styles.alignment) alignment (openpyxl.cell.read_only.EmptyCell attribute) (openpyxl.cell.read_only.ReadOnlyCell property) (openpyxl.cell.text.PhoneticProperties attribute) (openpyxl.styles.cell_style.CellStyle attribute) (openpyxl.styles.cell_style.CellStyleList attribute) (openpyxl.styles.differential.DifferentialStyle attribute) (openpyxl.styles.named_styles.NamedStyle attribute) (openpyxl.styles.styleable.StyleableObject attribute) alignmentId (openpyxl.styles.cell_style.StyleArray attribute) alignWithMargins (openpyxl.worksheet.header_footer.HeaderFooter attribute) allCaption (openpyxl.pivot.cache.CacheHierarchy attribute) allDrilled (openpyxl.pivot.table.PivotField attribute) allow_blank (openpyxl.worksheet.datavalidation.DataValidation attribute) allow_none (openpyxl.chart.data_source.NumberValueDescriptor attribute) (openpyxl.chart.descriptors.NestedGapAmount attribute) (openpyxl.chart.descriptors.NestedOverlap attribute) (openpyxl.chart.descriptors.NumberFormatDescriptor attribute) (openpyxl.chart.title.TitleDescriptor attribute) (openpyxl.descriptors.base.MatchPattern attribute) (openpyxl.descriptors.base.Max attribute) (openpyxl.descriptors.base.Min attribute) (openpyxl.descriptors.base.Typed attribute) (openpyxl.descriptors.excel.CellRange attribute) (openpyxl.descriptors.excel.Relation attribute) (openpyxl.drawing.colors.ColorChoiceDescriptor attribute) allowBlank (openpyxl.worksheet.datavalidation.DataValidation attribute) allowPng (openpyxl.workbook.web.WebPublishing attribute) allowRefreshQuery (openpyxl.workbook.properties.WorkbookProperties attribute) allUniqueName (openpyxl.pivot.cache.CacheHierarchy attribute) alpha (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) alphaBiLevel (openpyxl.drawing.fill.Blip attribute) AlphaBiLevelEffect (class in openpyxl.drawing.effect) alphaCeiling (openpyxl.drawing.fill.Blip attribute) AlphaCeilingEffect (class in openpyxl.drawing.effect) alphaFloor (openpyxl.drawing.fill.Blip attribute) AlphaFloorEffect (class in openpyxl.drawing.effect) alphaInv (openpyxl.drawing.fill.Blip attribute) AlphaInverseEffect (class in openpyxl.drawing.effect) alphaMod (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) (openpyxl.drawing.fill.Blip attribute) alphaModFix (openpyxl.drawing.fill.Blip attribute) AlphaModulateEffect (class in openpyxl.drawing.effect) AlphaModulateFixedEffect (class in openpyxl.drawing.effect) alphaOff (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) alphaRepl (openpyxl.drawing.fill.Blip attribute) AlphaReplaceEffect (class in openpyxl.drawing.effect) altLang (openpyxl.drawing.text.CharacterProperties attribute) altText (openpyxl.comments.comment_sheet.Properties attribute) (openpyxl.worksheet.controls.ControlProperty attribute) (openpyxl.worksheet.ole.ObjectPr attribute) amt (openpyxl.drawing.effect.AlphaModulateFixedEffect attribute) (openpyxl.drawing.effect.TintEffect attribute) anchor (openpyxl.drawing.drawing.Drawing property) (openpyxl.drawing.geometry.Backdrop attribute) (openpyxl.drawing.image.Image attribute) (openpyxl.drawing.text.RichTextProperties attribute) (openpyxl.worksheet.controls.ControlProperty attribute) (openpyxl.worksheet.ole.ObjectPr attribute) AnchorClientData (class in openpyxl.drawing.spreadsheet_drawing)

anchorCtr (openpyxl.drawing.text.RichTextProperties attribute) AnchorMarker (class in openpyxl.drawing.spreadsheet_drawing) ang (openpyxl.drawing.fill.LinearShadeProperties attribute) (openpyxl.drawing.geometry.ConnectionSite attribute) angle_to_degrees() (in module openpyxl.utils.units) append() (openpyxl.cell.rich_text.CellRichText method) (openpyxl.descriptors.container.ElementList method) (openpyxl.packaging.custom.CustomPropertyList method) (openpyxl.packaging.manifest.Manifest method) (openpyxl.packaging.relationship.RelationshipList method) (openpyxl.styles.differential.DifferentialStyleList method) (openpyxl.styles.named_styles.NamedStyleList method) (openpyxl.utils.indexed_list.IndexedList method) (openpyxl.worksheet.datavalidation.DataValidationList method) (openpyxl.worksheet.pagebreak.RowBreak method) (openpyxl.worksheet.scenario.ScenarioList method) (openpyxl.worksheet.table.TablePartList method) (openpyxl.worksheet.worksheet.Worksheet method) Application (openpyxl.packaging.extended.ExtendedProperties attribute) apply_stylesheet() (in module openpyxl.styles.stylesheet) applyAlignment (openpyxl.styles.cell_style.CellStyle property) applyAlignmentFormats (openpyxl.pivot.table.TableDefinition attribute) applyBorder (openpyxl.styles.cell_style.CellStyle attribute) applyBorderFormats (openpyxl.pivot.table.TableDefinition attribute) applyFill (openpyxl.styles.cell_style.CellStyle attribute) applyFont (openpyxl.styles.cell_style.CellStyle attribute) applyFontFormats (openpyxl.pivot.table.TableDefinition attribute) applyNumberFormat (openpyxl.styles.cell_style.CellStyle attribute) applyNumberFormats (openpyxl.pivot.table.TableDefinition attribute) applyPatternFormats (openpyxl.pivot.table.TableDefinition attribute) applyProtection (openpyxl.styles.cell_style.CellStyle property) applyStyles (openpyxl.worksheet.properties.Outline attribute) applyToEnd (openpyxl.chart.picture.PictureOptions attribute) applyToFront (openpyxl.chart.picture.PictureOptions attribute) applyToSides (openpyxl.chart.picture.PictureOptions attribute) applyWidthHeightFormats (openpyxl.pivot.table.TableDefinition attribute) appName (openpyxl.workbook.properties.FileVersion attribute) AppVersion (openpyxl.packaging.extended.ExtendedProperties attribute) area3DChart (openpyxl.chart.plotarea.PlotArea attribute) AreaChart (class in openpyxl.chart.area_chart) areaChart (openpyxl.chart.plotarea.PlotArea attribute) AreaChart3D (class in openpyxl.chart.area_chart) array (openpyxl.worksheet.table.TableFormula attribute) array_formulae (openpyxl.worksheet.worksheet.Worksheet property) ArrayDescriptor (class in openpyxl.styles.cell_style) ArrayFormula (class in openpyxl.worksheet.formula) as_list() (openpyxl.cell.rich_text.CellRichText method) as_name() (openpyxl.styles.named_styles.NamedStyle method) as_tuple() (openpyxl.styles.named_styles.NamedStyle method) as_xf() (openpyxl.styles.named_styles.NamedStyle method) ASCII (class in openpyxl.descriptors.base) assign_names() (openpyxl.reader.workbook.WorkbookParser method) asteriskTotals (openpyxl.pivot.table.TableDefinition attribute) attr_text (openpyxl.workbook.defined_name.DefinedName attribute) (openpyxl.worksheet.table.TableFormula attribute) attribute (openpyxl.descriptors.nested.Nested attribute) (openpyxl.descriptors.sequence.ValueSequence attribute) (openpyxl.pivot.cache.CacheHierarchy attribute) author (openpyxl.comments.author.AuthorList attribute) (openpyxl.comments.comment_sheet.CommentRecord attribute) authorId (openpyxl.comments.comment_sheet.CommentRecord attribute) AuthorList (class in openpyxl.comments.author) authors (openpyxl.comments.author.AuthorList attribute) (openpyxl.comments.comment_sheet.CommentSheet attribute) auto (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.TextAxis attribute) (openpyxl.styles.colors.Color attribute) auto_size (openpyxl.worksheet.dimensions.ColumnDimension attribute) autoCompressPictures (openpyxl.workbook.properties.WorkbookProperties attribute) autoEnd (openpyxl.pivot.cache.RangePr attribute) autoFill (openpyxl.comments.comment_sheet.Properties attribute) (openpyxl.worksheet.controls.ControlProperty attribute) (openpyxl.worksheet.ole.ObjectPr attribute) AutoFilter (class in openpyxl.worksheet.filters) autoFilter (openpyxl.pivot.table.PivotFilter attribute) (openpyxl.worksheet.protection.SheetProtection attribute) (openpyxl.worksheet.table.Table attribute) autoFilterDateGrouping (openpyxl.workbook.views.BookView attribute) autoFormatId (openpyxl.pivot.table.TableDefinition attribute) autoLine (openpyxl.comments.comment_sheet.Properties attribute) (openpyxl.worksheet.controls.ControlProperty attribute) (openpyxl.worksheet.ole.ObjectPr attribute) autoLoad (openpyxl.worksheet.ole.OleObject attribute) AutonumberBullet (class in openpyxl.drawing.text) autoPage (openpyxl.pivot.cache.Consolidation attribute) autoPageBreaks (openpyxl.worksheet.page.PrintPageSetup property) (openpyxl.worksheet.properties.PageSetupProperties attribute) autoPict (openpyxl.worksheet.controls.ControlProperty attribute) (openpyxl.worksheet.ole.ObjectPr attribute) autoRecover (openpyxl.packaging.workbook.FileRecoveryProperties attribute) autoRepublish (openpyxl.chartsheet.publish.WebPublishItem attribute) (openpyxl.workbook.web.WebPublishObject attribute) autoScale (openpyxl.comments.comment_sheet.Properties attribute) autoShow (openpyxl.pivot.table.PivotField attribute) AutoSortScope (class in openpyxl.pivot.table) autoSortScope (openpyxl.pivot.table.PivotField attribute) autoStart (openpyxl.pivot.cache.RangePr attribute) autoTitleDeleted (openpyxl.chart.chartspace.ChartContainer attribute) autoUpdate (openpyxl.chart.chartspace.ExternalData attribute) (openpyxl.workbook.views.CustomWorkbookView attribute) avgSubtotal (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.Reference attribute) avLst (openpyxl.drawing.geometry.CustomGeometry2D attribute) (openpyxl.drawing.geometry.PresetGeometry2D attribute) (openpyxl.drawing.text.PresetTextShape attribute) avoid_duplicate_name() (in module openpyxl.workbook.child) AxDataSource (class in openpyxl.chart.data_source) axId (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.NumericAxis attribute) (openpyxl.chart.axis.SeriesAxis attribute) (openpyxl.chart.axis.TextAxis attribute) axis (openpyxl.pivot.table.PivotArea attribute) (openpyxl.pivot.table.PivotField attribute) axPos (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.NumericAxis attribute) (openpyxl.chart.axis.SeriesAxis attribute) (openpyxl.chart.axis.TextAxis attribute)

B

b (openpyxl.cell.text.InlineFont attribute) (openpyxl.chart.print_settings.PageMargins attribute) (openpyxl.drawing.colors.RGBPercent attribute) (openpyxl.drawing.fill.RelativeRect attribute) (openpyxl.drawing.geometry.GeomRect attribute) (openpyxl.drawing.text.CharacterProperties attribute) (openpyxl.pivot.cache.GroupItems attribute) (openpyxl.pivot.cache.SharedItems attribute) (openpyxl.pivot.fields.Error attribute) (openpyxl.pivot.fields.Missing attribute) (openpyxl.pivot.fields.Number attribute) (openpyxl.pivot.fields.Text attribute) (openpyxl.pivot.record.Record attribute) (openpyxl.styles.fonts.Font attribute) Backdrop (class in openpyxl.drawing.geometry) backdrop (openpyxl.drawing.geometry.Scene3D attribute) background (openpyxl.drawing.fill.PatternFillProperties attribute) backgroundQuery (openpyxl.pivot.cache.CacheDefinition attribute) backupFile (openpyxl.workbook.properties.WorkbookProperties attribute) backWall (openpyxl.chart.bar_chart.BarChart3D attribute) (openpyxl.chart.chartspace.ChartContainer attribute) backward (openpyxl.chart.trendline.Trendline attribute) bandFmt (openpyxl.chart.surface_chart.BandFormatList attribute) bandFmts (openpyxl.chart.surface_chart.SurfaceChart attribute) (openpyxl.chart.surface_chart.SurfaceChart3D attribute) BandFormat (class in openpyxl.chart.surface_chart) BandFormatList (class in openpyxl.chart.surface_chart) bar3DChart (openpyxl.chart.plotarea.PlotArea attribute) BarChart (class in openpyxl.chart.bar_chart) barChart (openpyxl.chart.plotarea.PlotArea attribute) BarChart3D (class in openpyxl.chart.bar_chart) barDir (openpyxl.chart.bar_chart.BarChart attribute) (openpyxl.chart.bar_chart.BarChart3D attribute) base (openpyxl.pivot.cache.FieldGroup attribute) Base64Binary (class in openpyxl.descriptors.excel) base_date (openpyxl.cell.cell.Cell property) baseColWidth (openpyxl.worksheet.dimensions.SheetFormatProperties attribute) baseField (openpyxl.pivot.table.DataField attribute) baseItem (openpyxl.pivot.table.DataField attribute) baseline (openpyxl.drawing.text.CharacterProperties attribute) baseTimeUnit (openpyxl.chart.axis.DateAxis attribute) bc (openpyxl.pivot.fields.Error attribute) (openpyxl.pivot.fields.Missing attribute) (openpyxl.pivot.fields.Number attribute) (openpyxl.pivot.fields.Text attribute) bestFit (openpyxl.worksheet.dimensions.ColumnDimension attribute) Bevel (class in openpyxl.drawing.geometry) bevel (openpyxl.drawing.line.LineProperties attribute) bevelB (openpyxl.drawing.geometry.Shape3D attribute) bevelT (openpyxl.drawing.geometry.Shape3D attribute) bg1 (openpyxl.drawing.colors.ColorMapping attribute) bg2 (openpyxl.drawing.colors.ColorMapping attribute) bgClr (openpyxl.drawing.fill.PatternFillProperties attribute) bgColor (openpyxl.styles.fills.PatternFill attribute) biLevel (openpyxl.drawing.fill.Blip attribute) BiLevelEffect (class in openpyxl.drawing.effect) bind() (openpyxl.comments.comments.Comment method) (openpyxl.styles.named_styles.NamedStyle method) bIns (openpyxl.drawing.text.RichTextProperties attribute) blackAndWhite (openpyxl.worksheet.page.PrintPageSetup attribute) blank (openpyxl.worksheet.filters.Filters attribute) BlankFilter (class in openpyxl.worksheet.filters) blend (openpyxl.drawing.effect.FillOverlayEffect attribute) Blip (class in openpyxl.drawing.fill) blip (openpyxl.drawing.fill.BlipFillProperties attribute) blipFill (openpyxl.drawing.picture.PictureFrame attribute) (openpyxl.drawing.text.CharacterProperties attribute) BlipFillProperties (class in openpyxl.drawing.fill) blue (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) blueMod (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) blueOff (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute)

blur (openpyxl.drawing.effect.EffectList attribute) (openpyxl.drawing.fill.Blip attribute) BlurEffect (class in openpyxl.drawing.effect) blurRad (openpyxl.drawing.effect.InnerShadowEffect attribute) (openpyxl.drawing.effect.OuterShadow attribute) (openpyxl.drawing.effect.ReflectionEffect attribute) bmk (openpyxl.drawing.text.CharacterProperties attribute) body (openpyxl.chart.title.Title attribute) bodyPr (openpyxl.chart.text.RichText attribute) bold (openpyxl.styles.fonts.Font attribute) BookView (class in openpyxl.workbook.views) bookViews (openpyxl.packaging.workbook.WorkbookPackage attribute) Bool (class in openpyxl.descriptors.base) Boolean (class in openpyxl.pivot.fields) BoolProperty (class in openpyxl.packaging.custom) Border (class in openpyxl.styles.borders) border (openpyxl.cell.read_only.EmptyCell attribute) (openpyxl.cell.read_only.ReadOnlyCell property) (openpyxl.styles.differential.DifferentialStyle attribute) (openpyxl.styles.named_styles.NamedStyle attribute) (openpyxl.styles.styleable.StyleableObject attribute) border_style (openpyxl.styles.borders.Side attribute) borderId (openpyxl.styles.cell_style.CellStyle attribute) (openpyxl.styles.cell_style.StyleArray attribute) borders (openpyxl.styles.stylesheet.Stylesheet attribute) bottom (openpyxl.chart.print_settings.PageMargins attribute) (openpyxl.drawing.fill.RelativeRect attribute) (openpyxl.formatting.rule.Rule attribute) (openpyxl.styles.borders.Border attribute) (openpyxl.styles.fills.GradientFill attribute) (openpyxl.worksheet.cell_range.CellRange property) (openpyxl.worksheet.page.PageMargins attribute) boundaries (openpyxl.worksheet.dimensions.SheetDimension property) BoundDictionary (class in openpyxl.utils.bound_dictionary) bounds (openpyxl.worksheet.cell_range.CellRange property) br (openpyxl.drawing.text.Paragraph attribute) Break (class in openpyxl.worksheet.pagebreak) BREAK_COLUMN (openpyxl.worksheet.worksheet.Worksheet attribute) BREAK_NONE (openpyxl.worksheet.worksheet.Worksheet attribute) BREAK_ROW (openpyxl.worksheet.worksheet.Worksheet attribute) bright (openpyxl.drawing.effect.LuminanceEffect attribute) brk (openpyxl.worksheet.pagebreak.ColBreak attribute) (openpyxl.worksheet.pagebreak.RowBreak attribute) buAutoNum (openpyxl.drawing.text.ParagraphProperties attribute) bubble3D (openpyxl.chart.bubble_chart.BubbleChart attribute) (openpyxl.chart.marker.DataPoint attribute) (openpyxl.chart.series.Series attribute) (openpyxl.chart.series.XYSeries attribute) BubbleChart (class in openpyxl.chart.bubble_chart) bubbleChart (openpyxl.chart.plotarea.PlotArea attribute) bubbleScale (openpyxl.chart.bubble_chart.BubbleChart attribute) bubbleSize (openpyxl.chart.series.Series attribute) (openpyxl.chart.series.XYSeries attribute) buBlip (openpyxl.drawing.text.ParagraphProperties attribute) buChar (openpyxl.drawing.text.ParagraphProperties attribute) buClr (openpyxl.drawing.text.ParagraphProperties attribute) buClrTx (openpyxl.drawing.text.ParagraphProperties attribute) buFont (openpyxl.drawing.text.ParagraphProperties attribute) buFontTx (openpyxl.drawing.text.ParagraphProperties attribute) builtin_format_code() (in module openpyxl.styles.numbers) builtin_format_id() (in module openpyxl.styles.numbers) builtInGroupCount (openpyxl.workbook.function_group.FunctionGroupList attribute) builtinId (openpyxl.styles.named_styles.NamedStyle attribute) builtInUnit (openpyxl.chart.axis.DisplayUnitsLabelList attribute) buNone (openpyxl.drawing.text.ParagraphProperties attribute) buSzPct (openpyxl.drawing.text.ParagraphProperties attribute) buSzPts (openpyxl.drawing.text.ParagraphProperties attribute) buSzTx (openpyxl.drawing.text.ParagraphProperties attribute) bwMode (openpyxl.chart.shapes.GraphicalProperties attribute) (openpyxl.drawing.properties.GroupShapeProperties attribute) by_priority() (openpyxl.pivot.table.ConditionalFormatList method) by_sheet() (openpyxl.workbook.defined_name.DefinedNameList method) byPosition (openpyxl.pivot.table.Reference attribute)

C

c (openpyxl.pivot.fields.Boolean attribute) (openpyxl.pivot.fields.DateTimeField attribute) (openpyxl.pivot.fields.Error attribute) (openpyxl.pivot.fields.Missing attribute) (openpyxl.pivot.fields.Number attribute) (openpyxl.pivot.fields.Text attribute) (openpyxl.pivot.fields.TupleList attribute) (openpyxl.pivot.table.FieldItem attribute) cache (openpyxl.pivot.table.TableDefinition attribute) CacheDefinition (class in openpyxl.pivot.cache) CacheField (class in openpyxl.pivot.cache) cacheFields (openpyxl.pivot.cache.CacheDefinition attribute) cacheHierarchies (openpyxl.pivot.cache.CacheDefinition attribute) CacheHierarchy (class in openpyxl.pivot.cache) cacheId (openpyxl.packaging.workbook.PivotCache attribute) (openpyxl.pivot.table.TableDefinition attribute) cacheIndex (openpyxl.pivot.table.PivotArea attribute) CacheSource (class in openpyxl.pivot.cache) cacheSource (openpyxl.pivot.cache.CacheDefinition attribute) calcCompleted (openpyxl.workbook.properties.CalcProperties attribute) calcId (openpyxl.workbook.properties.CalcProperties attribute) calcMode (openpyxl.workbook.properties.CalcProperties attribute) calcOnSave (openpyxl.workbook.properties.CalcProperties attribute) calcPr (openpyxl.packaging.workbook.WorkbookPackage attribute) CalcProperties (class in openpyxl.workbook.properties) calculate_dimension() (openpyxl.worksheet.worksheet.Worksheet method) calculatedColumn (openpyxl.worksheet.errors.IgnoredError attribute) calculatedColumnFormula (openpyxl.worksheet.table.TableColumn attribute) CalculatedItem (class in openpyxl.pivot.cache) calculatedItems (openpyxl.pivot.cache.CacheDefinition attribute) CalculatedMember (class in openpyxl.pivot.cache) calculatedMembers (openpyxl.pivot.cache.CacheDefinition attribute) calendarType (openpyxl.worksheet.filters.Filters attribute) Camera (class in openpyxl.drawing.geometry) camera (openpyxl.drawing.geometry.Scene3D attribute) cap (openpyxl.drawing.line.LineProperties attribute) (openpyxl.drawing.text.CharacterProperties attribute) (openpyxl.pivot.table.PageField attribute) caption (openpyxl.pivot.cache.CacheField attribute) (openpyxl.pivot.cache.CacheHierarchy attribute) (openpyxl.pivot.cache.GroupLevel attribute) (openpyxl.pivot.cache.LevelGroup attribute) (openpyxl.pivot.cache.MeasureGroup attribute) (openpyxl.pivot.cache.OLAPKPI attribute) (openpyxl.pivot.cache.PivotDimension attribute) (openpyxl.pivot.table.PivotHierarchy attribute) caseSensitive (openpyxl.worksheet.filters.SortState attribute) cast_numeric() (in module openpyxl.utils.inference) cast_percentage() (in module openpyxl.utils.inference) cast_time() (in module openpyxl.utils.inference) cat (openpyxl.chart.series.Series attribute) catAx (openpyxl.chart.plotarea.PlotArea attribute) category (openpyxl.packaging.core.DocumentProperties attribute) Cell (class in openpyxl.cell.cell) cell (openpyxl.workbook.external_link.external.ExternalRow attribute) cell() (openpyxl.worksheet.worksheet.Worksheet method) cellColor (openpyxl.worksheet.filters.ColorFilter attribute) cellComments (openpyxl.worksheet.page.PrintPageSetup attribute) CellCoordinatesException CellIsRule() (in module openpyxl.formatting.rule) CellRange (class in openpyxl.descriptors.excel) (class in openpyxl.worksheet.cell_range) CellRichText (class in openpyxl.cell.rich_text) cells (openpyxl.formatting.formatting.ConditionalFormatting attribute) (openpyxl.worksheet.cell_range.CellRange property) (openpyxl.worksheet.datavalidation.DataValidation attribute) CellSmartTag (class in openpyxl.worksheet.smart_tag) cellSmartTag (openpyxl.worksheet.smart_tag.CellSmartTags attribute) CellSmartTagPr (class in openpyxl.worksheet.smart_tag) cellSmartTagPr (openpyxl.worksheet.smart_tag.CellSmartTag attribute) CellSmartTags (class in openpyxl.worksheet.smart_tag) cellSmartTags (openpyxl.worksheet.smart_tag.SmartTags attribute) CellStyle (class in openpyxl.styles.cell_style) CellStyleList (class in openpyxl.styles.cell_style) cellStyles (openpyxl.styles.stylesheet.Stylesheet attribute) cellStyleXfs (openpyxl.styles.stylesheet.Stylesheet attribute) CellWatch (class in openpyxl.worksheet.cell_watch) cellWatch (openpyxl.worksheet.cell_watch.CellWatches attribute) CellWatches (class in openpyxl.worksheet.cell_watch) cellXfs (openpyxl.styles.stylesheet.Stylesheet attribute) center (openpyxl.worksheet.header_footer.HeaderFooterItem attribute) centerFooterEvenPages (openpyxl.chartsheet.relation.DrawingHF attribute) centerFooterFirstPage (openpyxl.chartsheet.relation.DrawingHF attribute) centerFooterOddPages (openpyxl.chartsheet.relation.DrawingHF attribute) centerHeaderEvenPages (openpyxl.chartsheet.relation.DrawingHF attribute) centerHeaderFirstPage (openpyxl.chartsheet.relation.DrawingHF attribute) centerHeaderOddPages (openpyxl.chartsheet.relation.DrawingHF attribute) centre (openpyxl.worksheet.header_footer.HeaderFooterItem attribute) cf (openpyxl.worksheet.controls.ControlProperty attribute) cfe (openpyxl.chartsheet.relation.DrawingHF attribute) cff (openpyxl.chartsheet.relation.DrawingHF attribute) cfo (openpyxl.chartsheet.relation.DrawingHF attribute) cfRule (openpyxl.formatting.formatting.ConditionalFormatting attribute) cfvo (openpyxl.formatting.rule.RuleType attribute) changesSavedWin (openpyxl.workbook.views.CustomWorkbookView attribute) CharacterProperties (class in openpyxl.drawing.text) Characters (openpyxl.packaging.extended.ExtendedProperties attribute) characterSet (openpyxl.workbook.web.WebPublishing attribute) CharactersWithSpaces (openpyxl.packaging.extended.ExtendedProperties attribute) charset (openpyxl.cell.text.InlineFont attribute) (openpyxl.drawing.text.Font attribute) (openpyxl.styles.fonts.Font attribute) chart (openpyxl.chart.chartspace.ChartSpace attribute) (openpyxl.drawing.graphic.GraphicData attribute) (openpyxl.pivot.table.ChartFormat attribute) ChartContainer (class in openpyxl.chart.chartspace) ChartFormat (class in openpyxl.pivot.table) chartFormat (openpyxl.pivot.table.TableDefinition attribute) chartFormats (openpyxl.pivot.table.TableDefinition attribute) ChartLines (class in openpyxl.chart.axis) chartObject (openpyxl.chart.chartspace.Protection attribute) ChartRelation (class in openpyxl.drawing.relation) Chartsheet (class in openpyxl.chartsheet.chartsheet) ChartsheetProperties (class in openpyxl.chartsheet.properties) ChartsheetProtection (class in openpyxl.chartsheet.protection) chartsheets (openpyxl.workbook.workbook.Workbook property) ChartsheetView (class in openpyxl.chartsheet.views) ChartsheetViewList (class in openpyxl.chartsheet.views) ChartSpace (class in openpyxl.chart.chartspace) che (openpyxl.chartsheet.relation.DrawingHF attribute) check_error() (openpyxl.cell.cell.Cell method) check_string() (openpyxl.cell.cell.Cell method) checkCompatibility (openpyxl.workbook.properties.WorkbookProperties attribute) chExt (openpyxl.drawing.geometry.GroupTransform2D attribute) (openpyxl.drawing.geometry.Transform2D attribute) (openpyxl.drawing.xdr.XDRTransform2D attribute) chf (openpyxl.chartsheet.relation.DrawingHF attribute) ChildSheet (class in openpyxl.packaging.workbook) cho (openpyxl.chartsheet.relation.DrawingHF attribute) chOff (openpyxl.drawing.geometry.GroupTransform2D attribute) (openpyxl.drawing.geometry.Transform2D attribute) (openpyxl.drawing.xdr.XDRTransform2D attribute) clientData (openpyxl.drawing.spreadsheet_drawing.AbsoluteAnchor attribute) (openpyxl.drawing.spreadsheet_drawing.OneCellAnchor attribute) (openpyxl.drawing.spreadsheet_drawing.TwoCellAnchor attribute) close() (openpyxl.workbook.workbook.Workbook method) clrChange (openpyxl.drawing.fill.Blip attribute) clrFrom (openpyxl.drawing.effect.ColorChangeEffect attribute) clrMapOvr (openpyxl.chart.chartspace.ChartSpace attribute) clrRepl (openpyxl.drawing.fill.Blip attribute) clrTo (openpyxl.drawing.effect.ColorChangeEffect attribute) cm_to_dxa() (in module openpyxl.utils.units) cm_to_EMU() (in module openpyxl.utils.units) cmpd (openpyxl.drawing.line.LineProperties attribute) cNvCxnSpPr (openpyxl.drawing.connector.ConnectorNonVisual attribute) cNvGraphicFramePr (openpyxl.drawing.graphic.NonVisualGraphicFrame attribute) cNvGrpSpPr (openpyxl.drawing.properties.NonVisualGroupShape attribute) cNvPicPr (openpyxl.drawing.picture.PictureNonVisual attribute) cNvPr (openpyxl.drawing.connector.ConnectorNonVisual attribute) (openpyxl.drawing.connector.ShapeMeta attribute) (openpyxl.drawing.graphic.NonVisualGraphicFrame attribute) (openpyxl.drawing.picture.PictureNonVisual attribute) (openpyxl.drawing.properties.NonVisualGroupShape attribute) cNvSpPr (openpyxl.drawing.connector.ShapeMeta attribute) codeName (openpyxl.chartsheet.properties.ChartsheetProperties attribute) (openpyxl.workbook.properties.FileVersion attribute) (openpyxl.workbook.properties.WorkbookProperties attribute) (openpyxl.worksheet.properties.WorksheetProperties attribute) codePage (openpyxl.workbook.web.WebPublishing attribute) col (openpyxl.drawing.spreadsheet_drawing.AnchorMarker attribute) col_id (openpyxl.worksheet.filters.FilterColumn attribute) col_idx (openpyxl.cell.cell.Cell property) ColBreak (class in openpyxl.worksheet.pagebreak) colFields (openpyxl.pivot.table.TableDefinition attribute) colGrandTotals (openpyxl.pivot.table.TableDefinition attribute) colHeaderCaption (openpyxl.pivot.table.TableDefinition attribute) colHidden (openpyxl.comments.comment_sheet.Properties attribute) ColHierarchiesUsage (class in openpyxl.pivot.table) colHierarchiesUsage (openpyxl.pivot.table.TableDefinition attribute) colHierarchyUsage (openpyxl.pivot.table.ColHierarchiesUsage attribute) colId (openpyxl.worksheet.filters.FilterColumn attribute) colItems (openpyxl.pivot.table.TableDefinition attribute) collapse_cell_addresses() (in module openpyxl.worksheet.datavalidation) collapsed (openpyxl.worksheet.dimensions.ColumnDimension attribute) (openpyxl.worksheet.dimensions.Dimension attribute) collapsedLevelsAreSubtotals (openpyxl.pivot.table.PivotArea attribute) collection (openpyxl.styles.styleable.NamedStyleDescriptor attribute) (openpyxl.styles.styleable.NumberFormatDescriptor attribute) colOff (openpyxl.drawing.spreadsheet_drawing.AnchorMarker attribute) Color (class in openpyxl.drawing.effect) (class in openpyxl.styles.colors) color (openpyxl.cell.text.InlineFont attribute) (openpyxl.formatting.rule.ColorScale attribute) (openpyxl.formatting.rule.DataBar attribute) (openpyxl.styles.borders.Side attribute) (openpyxl.styles.fills.Stop attribute) (openpyxl.styles.fonts.Font attribute) ColorChangeEffect (class in openpyxl.drawing.effect) ColorChoice (class in openpyxl.drawing.colors) ColorChoiceDescriptor (class in openpyxl.drawing.colors) ColorDescriptor (class in openpyxl.styles.colors) ColorFilter (class in openpyxl.worksheet.filters) colorFilter (openpyxl.worksheet.filters.FilterColumn attribute) colorId (openpyxl.worksheet.views.SheetView attribute) ColorList (class in openpyxl.styles.colors) ColorMapping (class in openpyxl.drawing.colors) ColorReplaceEffect (class in openpyxl.drawing.effect) colors (openpyxl.styles.stylesheet.Stylesheet attribute) ColorScale (class in openpyxl.formatting.rule)

colorScale (openpyxl.formatting.rule.Rule attribute) ColorScaleRule() (in module openpyxl.formatting.rule) colPageCount (openpyxl.pivot.table.Location attribute) ColRange (class in openpyxl.worksheet.print_settings) cols (openpyxl.chart.reference.Reference property) (openpyxl.worksheet.cell_range.CellRange property) (openpyxl.worksheet.print_settings.PrintTitles attribute) cols_from_range() (in module openpyxl.utils.cell) column (openpyxl.cell.cell.Cell attribute) (openpyxl.cell.cell.MergedCell attribute) (openpyxl.cell.read_only.ReadOnlyCell attribute) column_groups (openpyxl.worksheet.worksheet.Worksheet property) column_index_from_string() (in module openpyxl.utils.cell) column_letter (openpyxl.cell.cell.Cell property) (openpyxl.cell.read_only.ReadOnlyCell property) column_names (openpyxl.worksheet.table.Table property) ColumnDimension (class in openpyxl.worksheet.dimensions) columns (openpyxl.worksheet.worksheet.Worksheet property) columnSort (openpyxl.worksheet.filters.SortState attribute) Comment (class in openpyxl.comments.comments) comment (openpyxl.cell.cell.Cell property) (openpyxl.cell.cell.MergedCell attribute) (openpyxl.workbook.defined_name.DefinedName attribute) (openpyxl.worksheet.scenario.Scenario attribute) (openpyxl.worksheet.table.Table attribute) commentList (openpyxl.comments.comment_sheet.CommentSheet attribute) commentPr (openpyxl.comments.comment_sheet.CommentRecord attribute) CommentRecord (class in openpyxl.comments.comment_sheet) comments (openpyxl.comments.comment_sheet.CommentSheet property) CommentSheet (class in openpyxl.comments.comment_sheet) comp (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) compact (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.TableDefinition attribute) compactData (openpyxl.pivot.table.TableDefinition attribute) Company (openpyxl.packaging.extended.ExtendedProperties attribute) compatLnSpc (openpyxl.drawing.text.RichTextProperties attribute) concurrentCalc (openpyxl.workbook.properties.CalcProperties attribute) concurrentManualCount (openpyxl.workbook.properties.CalcProperties attribute) condense (openpyxl.cell.text.InlineFont attribute) (openpyxl.styles.fonts.Font attribute) ConditionalFormat (class in openpyxl.pivot.table) conditionalFormat (openpyxl.pivot.table.ConditionalFormatList attribute) ConditionalFormatList (class in openpyxl.pivot.table) conditionalFormats (openpyxl.pivot.table.TableDefinition attribute) ConditionalFormatting (class in openpyxl.formatting.formatting) ConditionalFormattingList (class in openpyxl.formatting.formatting) conformance (openpyxl.packaging.workbook.WorkbookPackage attribute) Connection (class in openpyxl.drawing.connector) connectionId (openpyxl.pivot.cache.CacheSource attribute) (openpyxl.worksheet.table.Table attribute) ConnectionSite (class in openpyxl.drawing.geometry) ConnectionSiteList (class in openpyxl.drawing.geometry) ConnectorLocking (class in openpyxl.drawing.connector) ConnectorNonVisual (class in openpyxl.drawing.connector) ConnectorShape (class in openpyxl.drawing.connector) Consolidation (class in openpyxl.pivot.cache) consolidation (openpyxl.pivot.cache.CacheSource attribute) cont (openpyxl.drawing.effect.AlphaModulateEffect attribute) container (openpyxl.descriptors.sequence.Sequence attribute) (openpyxl.descriptors.sequence.UniqueSequence attribute) containsBlank (openpyxl.pivot.cache.SharedItems attribute) containsDate (openpyxl.pivot.cache.SharedItems attribute) containsInteger (openpyxl.pivot.cache.SharedItems attribute) containsMixedTypes (openpyxl.pivot.cache.SharedItems attribute) containsNonDate (openpyxl.pivot.cache.SharedItems attribute) containsNumber (openpyxl.pivot.cache.SharedItems attribute) containsSemiMixedTypes (openpyxl.pivot.cache.SharedItems attribute) containsString (openpyxl.pivot.cache.SharedItems attribute) content (openpyxl.cell.text.Text property) (openpyxl.chartsheet.protection.ChartsheetProtection attribute) (openpyxl.comments.comment_sheet.CommentRecord property) contentPart (openpyxl.drawing.spreadsheet_drawing.AbsoluteAnchor attribute) (openpyxl.drawing.spreadsheet_drawing.OneCellAnchor attribute) (openpyxl.drawing.spreadsheet_drawing.TwoCellAnchor attribute) contentStatus (openpyxl.packaging.core.DocumentProperties attribute) ContentType (openpyxl.packaging.manifest.FileExtension attribute) (openpyxl.packaging.manifest.Override attribute) contourClr (openpyxl.drawing.geometry.Shape3D attribute) contourW (openpyxl.drawing.geometry.Shape3D attribute) contrast (openpyxl.drawing.effect.LuminanceEffect attribute) Control (class in openpyxl.worksheet.controls) control (openpyxl.worksheet.controls.Controls attribute) controlPr (openpyxl.worksheet.controls.Control attribute) ControlProperty (class in openpyxl.worksheet.controls) Controls (class in openpyxl.worksheet.controls) convert() (openpyxl.worksheet.filters.CustomFilter method) Convertible (class in openpyxl.descriptors.base) coord (openpyxl.worksheet.cell_range.CellRange property) coordinate (openpyxl.cell.cell.Cell property) (openpyxl.cell.cell.MergedCell property) (openpyxl.cell.read_only.ReadOnlyCell property) coordinate_from_string() (in module openpyxl.utils.cell) coordinate_to_tuple() (in module openpyxl.utils.cell) copies (openpyxl.worksheet.page.PrintPageSetup attribute) copy() (openpyxl.styles.proxy.StyleProxy method) copy_worksheet() (openpyxl.workbook.workbook.Workbook method) (openpyxl.worksheet.copier.WorksheetCopy method) count (openpyxl.chartsheet.publish.WebPublishItems attribute) (openpyxl.descriptors.sequence.NestedSequence attribute) (openpyxl.drawing.drawing.Drawing attribute) (openpyxl.pivot.cache.CacheHierarchy attribute) (openpyxl.pivot.cache.GroupItems property) (openpyxl.pivot.cache.OLAPSet attribute) (openpyxl.pivot.cache.PCDSDTCEntries attribute) (openpyxl.pivot.cache.SharedItems property) (openpyxl.pivot.record.RecordList property) (openpyxl.pivot.table.ColHierarchiesUsage property) (openpyxl.pivot.table.ConditionalFormatList property) (openpyxl.pivot.table.MemberList property) (openpyxl.pivot.table.PivotFilters attribute) (openpyxl.pivot.table.Reference property) (openpyxl.pivot.table.RowHierarchiesUsage property) (openpyxl.styles.cell_style.CellStyleList property) (openpyxl.styles.differential.DifferentialStyleList property) (openpyxl.styles.numbers.NumberFormatList property) (openpyxl.styles.table.TableStyle attribute) (openpyxl.styles.table.TableStyleList property) (openpyxl.workbook.web.WebPublishObjectList property) (openpyxl.worksheet.datavalidation.DataValidationList property) (openpyxl.worksheet.merge.MergeCells property) (openpyxl.worksheet.pagebreak.ColBreak property) (openpyxl.worksheet.pagebreak.RowBreak property) (openpyxl.worksheet.scenario.Scenario property) (openpyxl.worksheet.table.TablePartList property) countASubtotal (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.Reference attribute) countSubtotal (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.Reference attribute) cp (openpyxl.pivot.fields.Boolean attribute) (openpyxl.pivot.fields.DateTimeField attribute) (openpyxl.pivot.fields.Error attribute) (openpyxl.pivot.fields.Missing attribute) (openpyxl.pivot.fields.Number attribute) (openpyxl.pivot.fields.Text attribute) crashSave (openpyxl.packaging.workbook.FileRecoveryProperties attribute) create_chartsheet() (openpyxl.workbook.workbook.Workbook method) create_named_range() (openpyxl.workbook.workbook.Workbook method) create_sheet() (openpyxl.workbook.workbook.Workbook method) created (openpyxl.packaging.core.DocumentProperties attribute) createdVersion (openpyxl.pivot.cache.CacheDefinition attribute) (openpyxl.pivot.table.TableDefinition attribute) creator (openpyxl.packaging.core.DocumentProperties attribute) crossAx (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.NumericAxis attribute) (openpyxl.chart.axis.SeriesAxis attribute) (openpyxl.chart.axis.TextAxis attribute) crossBetween (openpyxl.chart.axis.NumericAxis attribute) crosses (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.NumericAxis attribute) (openpyxl.chart.axis.SeriesAxis attribute) (openpyxl.chart.axis.TextAxis attribute) crossesAt (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.NumericAxis attribute) (openpyxl.chart.axis.SeriesAxis attribute) (openpyxl.chart.axis.TextAxis attribute) cs (openpyxl.drawing.text.CharacterProperties attribute) css (openpyxl.workbook.web.WebPublishing attribute) cstate (openpyxl.drawing.fill.Blip attribute) culture (openpyxl.pivot.cache.ServerFormat attribute) current (openpyxl.worksheet.scenario.ScenarioList attribute) custDash (openpyxl.drawing.line.LineProperties attribute) custGeom (openpyxl.chart.shapes.GraphicalProperties attribute) custom_formats (openpyxl.styles.stylesheet.Stylesheet property) CustomChartsheetView (class in openpyxl.chartsheet.custom) CustomChartsheetViews (class in openpyxl.chartsheet.custom) CustomFilter (class in openpyxl.worksheet.filters) customFilter (openpyxl.worksheet.filters.CustomFilters attribute) CustomFilters (class in openpyxl.worksheet.filters) customFilters (openpyxl.worksheet.filters.FilterColumn attribute) customFormat (openpyxl.worksheet.dimensions.RowDimension property) CustomGeometry2D (class in openpyxl.drawing.geometry) customHeight (openpyxl.worksheet.dimensions.RowDimension property) (openpyxl.worksheet.dimensions.SheetFormatProperties attribute) customList (openpyxl.worksheet.filters.SortCondition attribute) customListSort (openpyxl.pivot.table.TableDefinition attribute) customMenu (openpyxl.workbook.defined_name.DefinedName attribute) customPr (openpyxl.worksheet.custom.CustomProperties attribute) CustomProperties (class in openpyxl.worksheet.custom) CustomProperty (class in openpyxl.worksheet.custom) CustomPropertyList (class in openpyxl.packaging.custom) customRollUp (openpyxl.pivot.cache.GroupLevel attribute) customSheetView (openpyxl.chartsheet.custom.CustomChartsheetViews attribute) customSheetViews (openpyxl.chartsheet.chartsheet.Chartsheet attribute) CustomSplit (class in openpyxl.chart.pie_chart) customWidth (openpyxl.worksheet.dimensions.ColumnDimension property) CustomWorkbookView (class in openpyxl.workbook.views) customWorkbookViews (openpyxl.packaging.workbook.WorkbookPackage attribute) custSplit (openpyxl.chart.pie_chart.ProjectedPieChart attribute) custUnit (openpyxl.chart.axis.DisplayUnitsLabelList attribute) cx (openpyxl.drawing.geometry.PositiveSize2D attribute) (openpyxl.drawing.xdr.XDRPositiveSize2D attribute) cxn (openpyxl.drawing.geometry.ConnectionSiteList attribute) cxnLst (openpyxl.drawing.geometry.CustomGeometry2D attribute) cxnSp (openpyxl.drawing.spreadsheet_drawing.AbsoluteAnchor attribute) (openpyxl.drawing.spreadsheet_drawing.OneCellAnchor attribute) (openpyxl.drawing.spreadsheet_drawing.TwoCellAnchor attribute) cxnSpLocks (openpyxl.drawing.connector.NonVisualConnectorProperties attribute) cy (openpyxl.drawing.geometry.PositiveSize2D attribute) (openpyxl.drawing.xdr.XDRPositiveSize2D attribute)

D

d (openpyxl.drawing.line.DashStop attribute) (openpyxl.pivot.cache.GroupItems attribute) (openpyxl.pivot.cache.SharedItems attribute) (openpyxl.pivot.record.Record attribute) (openpyxl.pivot.table.FieldItem attribute) DashStop (class in openpyxl.drawing.line) DashStopList (class in openpyxl.drawing.line) dashStyle (openpyxl.drawing.line.LineProperties attribute) data (openpyxl.chart.chartspace.Protection attribute) data_only (openpyxl.workbook.workbook.Workbook property) data_points (openpyxl.chart.series.Series attribute) data_type (openpyxl.cell.cell.Cell attribute) (openpyxl.cell.cell.MergedCell attribute) (openpyxl.cell.read_only.EmptyCell attribute) (openpyxl.cell.read_only.ReadOnlyCell attribute) DataBar (class in openpyxl.formatting.rule) dataBar (openpyxl.formatting.rule.Rule attribute) DataBarRule() (in module openpyxl.formatting.rule) databaseField (openpyxl.pivot.cache.CacheField attribute) dataCaption (openpyxl.pivot.table.TableDefinition attribute) dataCellStyle (openpyxl.worksheet.table.Table attribute) (openpyxl.worksheet.table.TableColumn attribute) dataDxfId (openpyxl.worksheet.table.Table attribute) (openpyxl.worksheet.table.TableColumn attribute) dataExtractLoad (openpyxl.packaging.workbook.FileRecoveryProperties attribute) DataField (class in openpyxl.pivot.table) dataField (openpyxl.pivot.table.PivotField attribute) dataFields (openpyxl.pivot.table.TableDefinition attribute) dataframe_to_rows() (in module openpyxl.utils.dataframe) DataLabel (class in openpyxl.chart.label) (openpyxl.chart.pivot.PivotFormat attribute) DataLabelList (class in openpyxl.chart.label) dataLabels (openpyxl.chart.bubble_chart.BubbleChart attribute) (openpyxl.chart.radar_chart.RadarChart attribute) (openpyxl.chart.scatter_chart.ScatterChart attribute) (openpyxl.chart.stock_chart.StockChart attribute) dataOnly (openpyxl.pivot.table.PivotArea attribute) dataOnRows (openpyxl.pivot.table.TableDefinition attribute) DataPoint (class in openpyxl.chart.marker) dataPosition (openpyxl.pivot.table.TableDefinition attribute) dataSourceSort (openpyxl.pivot.table.PivotField attribute) DataTable (class in openpyxl.chart.plotarea) DataTableFormula (class in openpyxl.worksheet.formula) DataValidation (class in openpyxl.worksheet.datavalidation) dataValidation (openpyxl.worksheet.datavalidation.DataValidationList attribute) DataValidationList (class in openpyxl.worksheet.datavalidation) date1904 (openpyxl.chart.chartspace.ChartSpace attribute) (openpyxl.workbook.properties.WorkbookProperties attribute) dateAx (openpyxl.chart.plotarea.PlotArea attribute) DateAxis (class in openpyxl.chart.axis) dateCompatibility (openpyxl.workbook.properties.WorkbookProperties attribute) DateGroupItem (class in openpyxl.worksheet.filters) dateGroupItem (openpyxl.worksheet.filters.Filters attribute) DateTime (class in openpyxl.descriptors.base) DateTimeField (class in openpyxl.pivot.fields) dateTimeGrouping (openpyxl.worksheet.filters.DateGroupItem attribute) DateTimeProperty (class in openpyxl.packaging.custom) day (openpyxl.worksheet.filters.DateGroupItem attribute) days_to_time() (in module openpyxl.utils.datetime) dde (openpyxl.worksheet.ole.ObjectPr attribute) Default (class in openpyxl.descriptors.base) (openpyxl.packaging.manifest.Manifest attribute) DEFAULT_HEADER (in module openpyxl.utils.units) defaultAttributeDrillState (openpyxl.pivot.table.PivotField attribute) defaultColWidth (openpyxl.worksheet.dimensions.SheetFormatProperties attribute) defaultGridColor (openpyxl.worksheet.views.SheetView attribute) defaultMemberUniqueName (openpyxl.pivot.cache.CacheHierarchy attribute) defaultPivotStyle (openpyxl.styles.table.TableStyleList attribute) defaultRowHeight (openpyxl.worksheet.dimensions.SheetFormatProperties attribute) defaultSize (openpyxl.comments.comment_sheet.Properties attribute) (openpyxl.worksheet.controls.ControlProperty attribute) (openpyxl.worksheet.ole.ObjectPr attribute) defaultSubtotal (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.Reference attribute) defaultTableStyle (openpyxl.styles.table.TableStyleList attribute) defaultThemeVersion (openpyxl.workbook.properties.WorkbookProperties attribute) DefinedName (class in openpyxl.workbook.defined_name) definedName (openpyxl.workbook.defined_name.DefinedNameList attribute) DefinedNameDict (class in openpyxl.workbook.defined_name) DefinedNameList (class in openpyxl.workbook.defined_name) definedNames (openpyxl.packaging.workbook.WorkbookPackage attribute) (openpyxl.workbook.external_link.external.ExternalBook attribute) defPPr (openpyxl.drawing.text.ListStyle attribute) defRPr (openpyxl.drawing.text.ParagraphProperties attribute) defTabSz (openpyxl.drawing.text.ParagraphProperties attribute) defusedxml_available() (in module openpyxl.xml) defusedxml_env_set() (in module openpyxl.xml) degree (openpyxl.styles.fills.GradientFill attribute) degrees_to_angle() (in module openpyxl.utils.units) delete (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.NumericAxis attribute) (openpyxl.chart.axis.SeriesAxis attribute) (openpyxl.chart.axis.TextAxis attribute) (openpyxl.chart.label.DataLabelList attribute) (openpyxl.chart.legend.LegendEntry attribute) delete_cols() (openpyxl.worksheet.worksheet.Worksheet method) delete_rows() (openpyxl.worksheet.worksheet.Worksheet method) deleteColumns (openpyxl.worksheet.protection.SheetProtection attribute) deleted (openpyxl.worksheet.scenario.InputCells attribute) (openpyxl.worksheet.smart_tag.CellSmartTag attribute) deleteRows (openpyxl.worksheet.protection.SheetProtection attribute) denormalized (openpyxl.worksheet.table.XMLColumnProps attribute) descending (openpyxl.worksheet.filters.SortCondition attribute) descr (openpyxl.drawing.properties.NonVisualDrawingProps attribute) description (openpyxl.packaging.core.DocumentProperties attribute) (openpyxl.pivot.table.PivotFilter attribute) (openpyxl.workbook.defined_name.DefinedName attribute) Descriptor (class in openpyxl.descriptors.base) destinationFile (openpyxl.chartsheet.publish.WebPublishItem attribute) (openpyxl.workbook.web.WebPublishObject attribute) destinations (openpyxl.workbook.defined_name.DefinedName property) diagonal (openpyxl.styles.borders.Border attribute) diagonalDown (openpyxl.styles.borders.Border attribute) diagonalUp (openpyxl.styles.borders.Border attribute)

differentFirst (openpyxl.worksheet.header_footer.HeaderFooter attribute) DifferentialStyle (class in openpyxl.styles.differential) DifferentialStyleList (class in openpyxl.styles.differential) differentOddEven (openpyxl.worksheet.header_footer.HeaderFooter attribute) DigSig (openpyxl.packaging.extended.ExtendedProperties attribute) DigSigBlob (class in openpyxl.packaging.extended) Dimension (class in openpyxl.worksheet.dimensions) dimension (openpyxl.pivot.cache.MeasureDimensionMap attribute) DimensionHolder (class in openpyxl.worksheet.dimensions) dimensions (openpyxl.pivot.cache.CacheDefinition attribute) (openpyxl.worksheet.worksheet.Worksheet property) dimensionUniqueName (openpyxl.pivot.cache.CacheHierarchy attribute) dir (openpyxl.drawing.effect.InnerShadowEffect attribute) (openpyxl.drawing.effect.OuterShadow attribute) (openpyxl.drawing.effect.PresetShadowEffect attribute) (openpyxl.drawing.effect.ReflectionEffect attribute) (openpyxl.drawing.geometry.LightRig attribute) direction (openpyxl.chart.error_bar.ErrorBars attribute) dirty (openpyxl.drawing.text.CharacterProperties attribute) disable() (openpyxl.worksheet.protection.SheetProtection method) disabled (openpyxl.comments.comment_sheet.Properties attribute) (openpyxl.worksheet.controls.ControlProperty attribute) (openpyxl.worksheet.ole.ObjectPr attribute) disableFieldList (openpyxl.pivot.table.TableDefinition attribute) disablePrompts (openpyxl.worksheet.datavalidation.DataValidationList attribute) discretePr (openpyxl.pivot.cache.FieldGroup attribute) dispBlanksAs (openpyxl.chart.chartspace.ChartContainer attribute) dispEq (openpyxl.chart.trendline.Trendline attribute) display (openpyxl.worksheet.hyperlink.Hyperlink attribute) displayFolder (openpyxl.pivot.cache.CacheHierarchy attribute) (openpyxl.pivot.cache.OLAPKPI attribute) displayName (openpyxl.worksheet.table.Table attribute) DisplayUnitsLabel (class in openpyxl.chart.axis) DisplayUnitsLabelList (class in openpyxl.chart.axis) dispRSqr (openpyxl.chart.trendline.Trendline attribute) dispUnits (openpyxl.chart.axis.NumericAxis attribute) dispUnitsLbl (openpyxl.chart.axis.DisplayUnitsLabelList attribute) dist (openpyxl.drawing.effect.InnerShadowEffect attribute) (openpyxl.drawing.effect.OuterShadow attribute) (openpyxl.drawing.effect.PresetShadowEffect attribute) (openpyxl.drawing.effect.ReflectionEffect attribute) divId (openpyxl.chartsheet.publish.WebPublishItem attribute) (openpyxl.workbook.web.WebPublishObject attribute) dLbl (openpyxl.chart.label.DataLabelList attribute) (openpyxl.chart.pivot.PivotFormat attribute) dLblPos (openpyxl.chart.label.DataLabel attribute) (openpyxl.chart.label.DataLabelList attribute) dLbls (openpyxl.chart.area_chart.AreaChart attribute) (openpyxl.chart.area_chart.AreaChart3D attribute) (openpyxl.chart.bar_chart.BarChart attribute) (openpyxl.chart.bar_chart.BarChart3D attribute) (openpyxl.chart.bubble_chart.BubbleChart attribute) (openpyxl.chart.line_chart.LineChart attribute) (openpyxl.chart.line_chart.LineChart3D attribute) (openpyxl.chart.pie_chart.DoughnutChart attribute) (openpyxl.chart.pie_chart.PieChart attribute) (openpyxl.chart.pie_chart.PieChart3D attribute) (openpyxl.chart.pie_chart.ProjectedPieChart attribute) (openpyxl.chart.radar_chart.RadarChart attribute) (openpyxl.chart.scatter_chart.ScatterChart attribute) (openpyxl.chart.series.Series attribute) (openpyxl.chart.series.XYSeries attribute) (openpyxl.chart.stock_chart.StockChart attribute) DocSecurity (openpyxl.packaging.extended.ExtendedProperties attribute) DocumentProperties (class in openpyxl.packaging.core) DocumentSecurity (in module openpyxl.workbook.protection) DoughnutChart (class in openpyxl.chart.pie_chart) doughnutChart (openpyxl.chart.plotarea.PlotArea attribute) downBars (openpyxl.chart.updown_bars.UpDownBars attribute) dpi (openpyxl.drawing.fill.BlipFillProperties attribute) (openpyxl.workbook.web.WebPublishing attribute) dPt (openpyxl.chart.series.Series attribute) (openpyxl.chart.series.XYSeries attribute) draft (openpyxl.worksheet.page.PrintPageSetup attribute) dragOff (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.PivotHierarchy attribute) dragToCol (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.PivotHierarchy attribute) dragToData (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.PivotHierarchy attribute) dragToPage (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.PivotHierarchy attribute) dragToRow (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.PivotHierarchy attribute) Drawing (class in openpyxl.drawing.drawing) (class in openpyxl.worksheet.drawing) drawing (openpyxl.chartsheet.chartsheet.Chartsheet attribute) DrawingHF (class in openpyxl.chartsheet.relation) drawingHF (openpyxl.chartsheet.chartsheet.Chartsheet attribute) dropLines (openpyxl.chart.area_chart.AreaChart attribute) (openpyxl.chart.area_chart.AreaChart3D attribute) (openpyxl.chart.line_chart.LineChart attribute) (openpyxl.chart.line_chart.LineChart3D attribute) (openpyxl.chart.stock_chart.StockChart attribute) ds (openpyxl.drawing.line.DashStopList attribute) dTable (openpyxl.chart.plotarea.PlotArea attribute) DummyWorksheet (class in openpyxl.chart.reference) duotone (openpyxl.drawing.fill.Blip attribute) DuotoneEffect (class in openpyxl.drawing.effect) dvAspect (openpyxl.worksheet.ole.OleObject attribute) dx (openpyxl.drawing.geometry.Vector3D attribute) dxa_to_cm() (in module openpyxl.utils.units) dxa_to_inch() (in module openpyxl.utils.units) dxf (openpyxl.formatting.rule.Rule attribute) (openpyxl.styles.differential.DifferentialStyleList attribute) dxfId (openpyxl.formatting.rule.Rule attribute) (openpyxl.pivot.table.Format attribute) (openpyxl.styles.table.TableStyleElement attribute) (openpyxl.worksheet.filters.ColorFilter attribute) (openpyxl.worksheet.filters.SortCondition attribute) dxfs (openpyxl.styles.stylesheet.Stylesheet attribute) dy (openpyxl.drawing.geometry.Vector3D attribute) DynamicFilter (class in openpyxl.worksheet.filters) dynamicFilter (openpyxl.worksheet.filters.FilterColumn attribute) dz (openpyxl.drawing.geometry.Vector3D attribute)

E

e (openpyxl.pivot.cache.GroupItems attribute) (openpyxl.pivot.cache.PCDSDTCEntries attribute) (openpyxl.pivot.cache.SharedItems attribute) (openpyxl.pivot.record.Record attribute) (openpyxl.pivot.table.FieldItem attribute) ea (openpyxl.drawing.text.CharacterProperties attribute) eaLnBrk (openpyxl.drawing.text.ParagraphProperties attribute) eb (openpyxl.cell.text.PhoneticText attribute) editAs (openpyxl.drawing.spreadsheet_drawing.TwoCellAnchor attribute) editData (openpyxl.pivot.table.TableDefinition attribute) EffectContainer (class in openpyxl.drawing.effect) effectDag (openpyxl.drawing.text.CharacterProperties attribute) EffectList (class in openpyxl.drawing.effect) effectLst (openpyxl.drawing.text.CharacterProperties attribute) effectRef (openpyxl.drawing.geometry.ShapeStyle attribute) ElementList (class in openpyxl.descriptors.container) embed (openpyxl.drawing.fill.Blip attribute) (openpyxl.workbook.smart_tags.SmartTagProperties attribute) EmbeddedWAVAudioFile (class in openpyxl.drawing.text) EmptyCell (class in openpyxl.cell.read_only) emptyCellReference (openpyxl.worksheet.errors.IgnoredError attribute) EmptyTag (class in openpyxl.descriptors.nested) EMU_to_cm() (in module openpyxl.utils.units) EMU_to_inch() (in module openpyxl.utils.units) EMU_to_pixels() (in module openpyxl.utils.units) enable() (openpyxl.worksheet.protection.SheetProtection method) enabled (openpyxl.worksheet.protection.SheetProtection attribute) enableDrill (openpyxl.pivot.table.TableDefinition attribute) enableFieldProperties (openpyxl.pivot.table.TableDefinition attribute) enableFormatConditionsCalculation (openpyxl.worksheet.properties.WorksheetProperties attribute) enableRefresh (openpyxl.pivot.cache.CacheDefinition attribute) enableWizard (openpyxl.pivot.table.TableDefinition attribute) encoding (openpyxl.cell.cell.Cell property) end (openpyxl.styles.borders.Border attribute) end_color (openpyxl.styles.fills.PatternFill attribute) endA (openpyxl.drawing.effect.ReflectionEffect attribute) endCxn (openpyxl.drawing.connector.NonVisualConnectorProperties attribute) endDate (openpyxl.pivot.cache.RangePr attribute) endNum (openpyxl.pivot.cache.RangePr attribute) endParaRPr (openpyxl.drawing.text.Paragraph attribute) endPos (openpyxl.drawing.effect.ReflectionEffect attribute) endSnd (openpyxl.drawing.text.Hyperlink attribute) entries (openpyxl.pivot.cache.TupleCache attribute) epoch (openpyxl.workbook.workbook.Workbook property) equalAverage (openpyxl.formatting.rule.Rule attribute) err (openpyxl.drawing.text.CharacterProperties attribute) errBars (openpyxl.chart.series.Series attribute) (openpyxl.chart.series.XYSeries attribute) errBarType (openpyxl.chart.error_bar.ErrorBars attribute) errDir (openpyxl.chart.error_bar.ErrorBars attribute) Error (class in openpyxl.pivot.fields) error (openpyxl.worksheet.datavalidation.DataValidation attribute) ErrorBars (class in openpyxl.chart.error_bar) errorCaption (openpyxl.pivot.table.TableDefinition attribute) errors (openpyxl.worksheet.page.PrintPageSetup attribute) errorStyle (openpyxl.worksheet.datavalidation.DataValidation attribute) errorTitle (openpyxl.worksheet.datavalidation.DataValidation attribute) errValType (openpyxl.chart.error_bar.ErrorBars attribute) escape() (in module openpyxl.utils.escape) evalError (openpyxl.worksheet.errors.IgnoredError attribute) evalOrder (openpyxl.pivot.table.PivotFilter attribute) evenFooter (openpyxl.worksheet.header_footer.HeaderFooter attribute) evenHeader (openpyxl.worksheet.header_footer.HeaderFooter attribute) excel_base_date (openpyxl.workbook.workbook.Workbook property) ExcelReader (class in openpyxl.reader.excel) ExcelWriter (class in openpyxl.writer.excel) exclude (openpyxl.worksheet.filters.StringFilter attribute) expand() (openpyxl.worksheet.cell_range.CellRange method) expand_cell_ranges() (in module openpyxl.worksheet.datavalidation) expand_index() (in module openpyxl.utils.dataframe) expected_type (openpyxl.chart.descriptors.NumberFormatDescriptor attribute) (openpyxl.chart.title.TitleDescriptor attribute) (openpyxl.descriptors.base.ASCII attribute) (openpyxl.descriptors.base.Bool attribute) (openpyxl.descriptors.base.DateTime attribute) (openpyxl.descriptors.base.Float attribute) (openpyxl.descriptors.base.Integer attribute) (openpyxl.descriptors.base.Max attribute) (openpyxl.descriptors.base.Min attribute) (openpyxl.descriptors.base.String attribute) (openpyxl.descriptors.base.Tuple attribute) (openpyxl.descriptors.base.Typed attribute) (openpyxl.descriptors.container.ElementList property) (openpyxl.descriptors.excel.TextPoint attribute) (openpyxl.descriptors.sequence.Sequence attribute) (openpyxl.drawing.colors.ColorChoiceDescriptor attribute) (openpyxl.packaging.core.NestedDateTime attribute) (openpyxl.packaging.relationship.RelationshipList attribute) (openpyxl.styles.colors.ColorDescriptor attribute) (openpyxl.styles.colors.RGB attribute) (openpyxl.styles.fills.StopList attribute) explosion (openpyxl.chart.marker.DataPoint attribute) (openpyxl.chart.series.Series attribute) ext (openpyxl.descriptors.excel.ExtensionList attribute) (openpyxl.drawing.geometry.GroupTransform2D attribute) (openpyxl.drawing.geometry.Transform2D attribute) (openpyxl.drawing.spreadsheet_drawing.AbsoluteAnchor attribute) (openpyxl.drawing.spreadsheet_drawing.OneCellAnchor attribute) (openpyxl.drawing.xdr.XDRTransform2D attribute) (openpyxl.worksheet.errors.ExtensionList attribute) extend (openpyxl.cell.text.InlineFont attribute) (openpyxl.styles.fonts.Font attribute) extend() (openpyxl.cell.rich_text.CellRichText method) ExtendedProperties (class in openpyxl.packaging.extended) Extension (class in openpyxl.descriptors.excel) (class in openpyxl.worksheet.errors) (openpyxl.packaging.manifest.FileExtension attribute) ExtensionList (class in openpyxl.descriptors.excel) (class in openpyxl.worksheet.errors) extensions (openpyxl.packaging.manifest.Manifest property) ExternalBook (class in openpyxl.workbook.external_link.external) externalBook (openpyxl.workbook.external_link.external.ExternalLink attribute) ExternalCell (class in openpyxl.workbook.external_link.external) ExternalData (class in openpyxl.chart.chartspace) externalData (openpyxl.chart.chartspace.ChartSpace attribute) ExternalDefinedName (class in openpyxl.workbook.external_link.external) ExternalLink (class in openpyxl.workbook.external_link.external)

ExternalReference (class in openpyxl.workbook.external_reference) externalReferences (openpyxl.packaging.workbook.WorkbookPackage attribute) ExternalRow (class in openpyxl.workbook.external_link.external) ExternalSheetData (class in openpyxl.workbook.external_link.external) ExternalSheetDataSet (class in openpyxl.workbook.external_link.external) ExternalSheetNames (class in openpyxl.workbook.external_link.external) extLst (openpyxl.chart.area_chart.AreaChart attribute) (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.DisplayUnitsLabelList attribute) (openpyxl.chart.axis.NumericAxis attribute) (openpyxl.chart.axis.Scaling attribute) (openpyxl.chart.axis.SeriesAxis attribute) (openpyxl.chart.axis.TextAxis attribute) (openpyxl.chart.bar_chart.BarChart attribute) (openpyxl.chart.bar_chart.BarChart3D attribute) (openpyxl.chart.bubble_chart.BubbleChart attribute) (openpyxl.chart.chartspace.ChartContainer attribute) (openpyxl.chart.chartspace.ChartSpace attribute) (openpyxl.chart.data_source.MultiLevelStrData attribute) (openpyxl.chart.data_source.MultiLevelStrRef attribute) (openpyxl.chart.data_source.NumData attribute) (openpyxl.chart.data_source.NumRef attribute) (openpyxl.chart.data_source.StrData attribute) (openpyxl.chart.data_source.StrRef attribute) (openpyxl.chart.error_bar.ErrorBars attribute) (openpyxl.chart.label.DataLabel attribute) (openpyxl.chart.label.DataLabelList attribute) (openpyxl.chart.layout.Layout attribute) (openpyxl.chart.layout.ManualLayout attribute) (openpyxl.chart.legend.Legend attribute) (openpyxl.chart.legend.LegendEntry attribute) (openpyxl.chart.line_chart.LineChart attribute) (openpyxl.chart.line_chart.LineChart3D attribute) (openpyxl.chart.marker.DataPoint attribute) (openpyxl.chart.marker.Marker attribute) (openpyxl.chart.pie_chart.DoughnutChart attribute) (openpyxl.chart.pie_chart.PieChart attribute) (openpyxl.chart.pie_chart.PieChart3D attribute) (openpyxl.chart.pie_chart.ProjectedPieChart attribute) (openpyxl.chart.pivot.PivotFormat attribute) (openpyxl.chart.pivot.PivotSource attribute) (openpyxl.chart.plotarea.DataTable attribute) (openpyxl.chart.plotarea.PlotArea attribute) (openpyxl.chart.radar_chart.RadarChart attribute) (openpyxl.chart.scatter_chart.ScatterChart attribute) (openpyxl.chart.series.Series attribute) (openpyxl.chart.shapes.GraphicalProperties attribute) (openpyxl.chart.stock_chart.StockChart attribute) (openpyxl.chart.surface_chart.SurfaceChart attribute) (openpyxl.chart.surface_chart.SurfaceChart3D attribute) (openpyxl.chart.title.Title attribute) (openpyxl.chart.trendline.Trendline attribute) (openpyxl.chart.trendline.TrendlineLabel attribute) (openpyxl.chart.updown_bars.UpDownBars attribute) (openpyxl.chartsheet.chartsheet.Chartsheet attribute) (openpyxl.chartsheet.views.ChartsheetView attribute) (openpyxl.chartsheet.views.ChartsheetViewList attribute) (openpyxl.comments.comment_sheet.CommentSheet attribute) (openpyxl.drawing.colors.ColorMapping attribute) (openpyxl.drawing.connector.ConnectorLocking attribute) (openpyxl.drawing.connector.NonVisualConnectorProperties attribute) (openpyxl.drawing.fill.Blip attribute) (openpyxl.drawing.geometry.Backdrop attribute) (openpyxl.drawing.geometry.Scene3D attribute) (openpyxl.drawing.geometry.Shape3D attribute) (openpyxl.drawing.graphic.GraphicFrameLocking attribute) (openpyxl.drawing.graphic.NonVisualGraphicFrameProperties attribute) (openpyxl.drawing.line.LineProperties attribute) (openpyxl.drawing.picture.NonVisualPictureProperties attribute) (openpyxl.drawing.picture.PictureLocking attribute) (openpyxl.drawing.properties.GroupLocking attribute) (openpyxl.drawing.properties.GroupShapeProperties attribute) (openpyxl.drawing.properties.NonVisualDrawingProps attribute) (openpyxl.drawing.properties.NonVisualDrawingShapeProps attribute) (openpyxl.drawing.properties.NonVisualGroupDrawingShapeProps attribute) (openpyxl.drawing.text.CharacterProperties attribute) (openpyxl.drawing.text.Hyperlink attribute) (openpyxl.drawing.text.ListStyle attribute) (openpyxl.drawing.text.ParagraphProperties attribute) (openpyxl.drawing.text.RichTextProperties attribute) (openpyxl.formatting.rule.FormatObject attribute) (openpyxl.formatting.rule.Rule attribute) (openpyxl.packaging.workbook.WorkbookPackage attribute) (openpyxl.pivot.cache.CacheDefinition attribute) (openpyxl.pivot.cache.CacheField attribute) (openpyxl.pivot.cache.CacheHierarchy attribute) (openpyxl.pivot.cache.CacheSource attribute) (openpyxl.pivot.cache.CalculatedItem attribute) (openpyxl.pivot.cache.CalculatedMember attribute) (openpyxl.pivot.cache.GroupLevel attribute) (openpyxl.pivot.cache.TupleCache attribute) (openpyxl.pivot.record.RecordList attribute) (openpyxl.pivot.table.ConditionalFormat attribute) (openpyxl.pivot.table.DataField attribute) (openpyxl.pivot.table.Format attribute) (openpyxl.pivot.table.PageField attribute) (openpyxl.pivot.table.PivotArea attribute) (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.PivotFilter attribute) (openpyxl.pivot.table.PivotHierarchy attribute) (openpyxl.pivot.table.Reference attribute) (openpyxl.pivot.table.TableDefinition attribute) (openpyxl.styles.cell_style.CellStyle attribute) (openpyxl.styles.stylesheet.Stylesheet attribute) (openpyxl.workbook.views.BookView attribute) (openpyxl.workbook.views.CustomWorkbookView attribute) (openpyxl.worksheet.errors.IgnoredErrors attribute) (openpyxl.worksheet.filters.AutoFilter attribute) (openpyxl.worksheet.filters.FilterColumn attribute) (openpyxl.worksheet.filters.SortState attribute) (openpyxl.worksheet.table.Table attribute) (openpyxl.worksheet.table.TableColumn attribute) (openpyxl.worksheet.table.XMLColumnProps attribute) (openpyxl.worksheet.views.SheetViewList attribute) extrusionClr (openpyxl.drawing.geometry.Shape3D attribute) extrusionH (openpyxl.drawing.geometry.Shape3D attribute) extrusionOk (openpyxl.drawing.geometry.Path2D attribute)

F

f (openpyxl.chart.data_source.MultiLevelStrRef attribute) (openpyxl.chart.data_source.NumRef attribute) (openpyxl.chart.data_source.StrRef attribute) (openpyxl.pivot.fields.Boolean attribute) (openpyxl.pivot.fields.DateTimeField attribute) (openpyxl.pivot.fields.Error attribute) (openpyxl.pivot.fields.Missing attribute) (openpyxl.pivot.fields.Number attribute) (openpyxl.pivot.fields.Text attribute) (openpyxl.pivot.table.FieldItem attribute) fadeDir (openpyxl.drawing.effect.ReflectionEffect attribute) family (openpyxl.cell.text.InlineFont attribute) (openpyxl.styles.fonts.Font attribute) fc (openpyxl.pivot.fields.Error attribute) (openpyxl.pivot.fields.Missing attribute) (openpyxl.pivot.fields.Number attribute) (openpyxl.pivot.fields.Text attribute) fgClr (openpyxl.drawing.fill.PatternFillProperties attribute) fgColor (openpyxl.styles.fills.PatternFill attribute) field (openpyxl.pivot.cache.CalculatedItem attribute) (openpyxl.pivot.table.MemberProperty attribute) (openpyxl.pivot.table.PivotArea attribute) (openpyxl.pivot.table.Reference attribute) FieldGroup (class in openpyxl.pivot.cache) fieldGroup (openpyxl.pivot.cache.CacheField attribute) FieldItem (class in openpyxl.pivot.table) fieldListSortAscending (openpyxl.pivot.table.TableDefinition attribute) fieldPosition (openpyxl.pivot.table.PivotArea attribute) fieldPrintTitles (openpyxl.pivot.table.TableDefinition attribute) fieldsUsage (openpyxl.pivot.cache.CacheHierarchy attribute) FieldUsage (class in openpyxl.pivot.cache) file_link (openpyxl.workbook.external_link.external.ExternalLink attribute) FileExtension (class in openpyxl.packaging.manifest) filenames (openpyxl.packaging.manifest.Manifest property) fileRecoveryPr (openpyxl.packaging.workbook.WorkbookPackage attribute) FileRecoveryProperties (class in openpyxl.packaging.workbook) FileSharing (class in openpyxl.workbook.protection) fileSharing (openpyxl.packaging.workbook.WorkbookPackage attribute) FileVersion (class in openpyxl.workbook.properties) fileVersion (openpyxl.packaging.workbook.WorkbookPackage attribute) Fill (class in openpyxl.styles.fills) fill (openpyxl.cell.read_only.EmptyCell attribute) (openpyxl.cell.read_only.ReadOnlyCell property) (openpyxl.drawing.geometry.Path2D attribute) (openpyxl.styles.differential.DifferentialStyle attribute) (openpyxl.styles.named_styles.NamedStyle attribute) (openpyxl.styles.styleable.StyleableObject attribute) fill_type (openpyxl.styles.fills.GradientFill attribute) (openpyxl.styles.fills.PatternFill attribute) fillId (openpyxl.styles.cell_style.CellStyle attribute) (openpyxl.styles.cell_style.StyleArray attribute) fillOverlay (openpyxl.drawing.effect.EffectList attribute) (openpyxl.drawing.fill.Blip attribute) FillOverlayEffect (class in openpyxl.drawing.effect) fillRect (openpyxl.drawing.fill.StretchInfoProperties attribute) fillRef (openpyxl.drawing.geometry.ShapeStyle attribute) fills (openpyxl.styles.stylesheet.Stylesheet attribute) fillToRect (openpyxl.drawing.fill.PathShadeProperties attribute) filter (openpyxl.pivot.table.PivotFilters attribute) (openpyxl.worksheet.filters.Filters attribute) FilterColumn (class in openpyxl.worksheet.filters) filterColumn (openpyxl.worksheet.filters.AutoFilter attribute) filterMode (openpyxl.worksheet.properties.WorksheetProperties attribute) filterPrivacy (openpyxl.workbook.properties.WorkbookProperties attribute) Filters (class in openpyxl.worksheet.filters) filters (openpyxl.pivot.table.TableDefinition attribute) (openpyxl.worksheet.filters.FilterColumn attribute) filterVal (openpyxl.worksheet.filters.Top10 attribute) find() (openpyxl.packaging.manifest.Manifest method) (openpyxl.packaging.relationship.RelationshipList method) find_images() (in module openpyxl.reader.drawings) find_sheets() (openpyxl.reader.workbook.WorkbookParser method) findall() (openpyxl.packaging.manifest.Manifest method) firstDataCol (openpyxl.pivot.table.Location attribute) firstDataRow (openpyxl.pivot.table.Location attribute) firstFooter (openpyxl.worksheet.header_footer.HeaderFooter attribute) firstHeader (openpyxl.worksheet.header_footer.HeaderFooter attribute) firstHeaderRow (openpyxl.pivot.table.Location attribute) firstPageNumber (openpyxl.worksheet.page.PrintPageSetup attribute) firstSheet (openpyxl.workbook.views.BookView attribute) firstSliceAng (openpyxl.chart.pie_chart.DoughnutChart attribute) (openpyxl.chart.pie_chart.PieChart attribute) fitToHeight (openpyxl.worksheet.page.PrintPageSetup attribute) fitToPage (openpyxl.worksheet.page.PrintPageSetup property) (openpyxl.worksheet.properties.PageSetupProperties attribute) fitToWidth (openpyxl.worksheet.page.PrintPageSetup attribute) flatTx (openpyxl.drawing.text.RichTextProperties attribute) fld (openpyxl.drawing.text.Paragraph attribute) (openpyxl.pivot.fields.Tuple attribute) (openpyxl.pivot.table.DataField attribute) (openpyxl.pivot.table.PageField attribute) (openpyxl.pivot.table.PivotFilter attribute) flip (openpyxl.drawing.fill.GradientFillProperties attribute) (openpyxl.drawing.fill.TileInfoProperties attribute) flipH (openpyxl.drawing.geometry.GroupTransform2D attribute) (openpyxl.drawing.geometry.Transform2D attribute) (openpyxl.drawing.xdr.XDRTransform2D attribute) flipV (openpyxl.drawing.geometry.GroupTransform2D attribute) (openpyxl.drawing.geometry.Transform2D attribute) (openpyxl.drawing.xdr.XDRTransform2D attribute)

Float (class in openpyxl.descriptors.base) FloatProperty (class in openpyxl.packaging.custom) fLocksText (openpyxl.drawing.connector.Shape attribute) fLocksWithSheet (openpyxl.drawing.spreadsheet_drawing.AnchorClientData attribute) floor (openpyxl.chart.bar_chart.BarChart3D attribute) (openpyxl.chart.chartspace.ChartContainer attribute) fmla (openpyxl.drawing.geometry.GeomGuide attribute) (openpyxl.drawing.text.GeomGuide attribute) fmtId (openpyxl.chart.pivot.PivotSource attribute) folHlink (openpyxl.drawing.colors.ColorMapping attribute) Font (class in openpyxl.drawing.text) (class in openpyxl.styles.fonts) font (openpyxl.cell.read_only.EmptyCell attribute) (openpyxl.cell.read_only.ReadOnlyCell property) (openpyxl.cell.rich_text.TextBlock attribute) (openpyxl.cell.text.RichText attribute) (openpyxl.styles.differential.DifferentialStyle attribute) (openpyxl.styles.named_styles.NamedStyle attribute) (openpyxl.styles.styleable.StyleableObject attribute) fontAlgn (openpyxl.drawing.text.ParagraphProperties attribute) fontId (openpyxl.cell.text.PhoneticProperties attribute) (openpyxl.styles.cell_style.CellStyle attribute) (openpyxl.styles.cell_style.StyleArray attribute) fontRef (openpyxl.drawing.geometry.ShapeStyle attribute) FontReference (class in openpyxl.drawing.geometry) fonts (openpyxl.styles.stylesheet.Stylesheet attribute) fontScale (openpyxl.drawing.text.TextNormalAutofit attribute) footer (openpyxl.chart.print_settings.PageMargins attribute) (openpyxl.worksheet.page.PageMargins attribute) forceAA (openpyxl.drawing.text.RichTextProperties attribute) forceFullCalc (openpyxl.workbook.properties.CalcProperties attribute) foreground (openpyxl.drawing.fill.PatternFillProperties attribute) Format (class in openpyxl.pivot.table) format (openpyxl.pivot.cache.ServerFormat attribute) (openpyxl.pivot.table.ChartFormat attribute) format() (openpyxl.worksheet.merge.MergedCellRange method) formatCells (openpyxl.worksheet.protection.SheetProtection attribute) formatCode (openpyxl.chart.data_source.NumData attribute) (openpyxl.chart.data_source.NumFmt attribute) (openpyxl.chart.data_source.NumVal attribute) (openpyxl.styles.numbers.NumberFormat attribute) formatColumns (openpyxl.worksheet.protection.SheetProtection attribute) FormatObject (class in openpyxl.formatting.rule) formatRows (openpyxl.worksheet.protection.SheetProtection attribute) formats (openpyxl.pivot.table.TableDefinition attribute) formatted (openpyxl.cell.text.Text attribute) formatted_fields() (openpyxl.pivot.table.TableDefinition method) formatting (openpyxl.chart.chartspace.Protection attribute) formula (openpyxl.formatting.rule.Rule attribute) (openpyxl.pivot.cache.CacheField attribute) (openpyxl.pivot.cache.CalculatedItem attribute) (openpyxl.worksheet.errors.IgnoredError attribute) formula1 (openpyxl.worksheet.datavalidation.DataValidation attribute) formula2 (openpyxl.worksheet.datavalidation.DataValidation attribute) formulaRange (openpyxl.worksheet.errors.IgnoredError attribute) FormulaRule() (in module openpyxl.formatting.rule) forward (openpyxl.chart.trendline.Trendline attribute) fov (openpyxl.drawing.geometry.Camera attribute) fPrintsWithSheet (openpyxl.drawing.spreadsheet_drawing.AnchorClientData attribute) fPublished (openpyxl.drawing.connector.ConnectorShape attribute) (openpyxl.drawing.connector.Shape attribute) (openpyxl.drawing.graphic.GraphicFrame attribute) (openpyxl.drawing.picture.PictureFrame attribute) freeze_panes (openpyxl.worksheet.worksheet.Worksheet property) from_array() (openpyxl.styles.cell_style.CellStyle class method) from_cell() (openpyxl.comments.comment_sheet.CommentRecord class method) from_comments() (openpyxl.comments.comment_sheet.CommentSheet class method) from_excel() (in module openpyxl.utils.datetime) from_ISO8601() (in module openpyxl.utils.datetime) from_string() (openpyxl.worksheet.print_settings.PrintArea class method) (openpyxl.worksheet.print_settings.PrintTitles class method) from_tree() (openpyxl.cell.rich_text.CellRichText class method) (openpyxl.chart.axis.NumericAxis class method) (openpyxl.chart.plotarea.PlotArea class method) (openpyxl.descriptors.container.ElementList class method) (openpyxl.descriptors.nested.EmptyTag method) (openpyxl.descriptors.nested.Nested method) (openpyxl.descriptors.nested.NestedBool method) (openpyxl.descriptors.nested.NestedText method) (openpyxl.descriptors.sequence.NestedSequence method) (openpyxl.descriptors.sequence.ValueSequence method) (openpyxl.descriptors.serialisable.Serialisable class method) (openpyxl.packaging.custom.CustomPropertyList class method) (openpyxl.styles.fills.Fill class method) (openpyxl.styles.fonts.Font class method) (openpyxl.styles.stylesheet.Stylesheet class method) (openpyxl.workbook.protection.WorkbookProtection class method) (openpyxl.worksheet.header_footer.HeaderFooterItem class method) (openpyxl.worksheet.page.PrintPageSetup class method) (openpyxl.worksheet.table.TableColumn class method) fromWordArt (openpyxl.drawing.text.RichTextProperties attribute) fullCalcOnLoad (openpyxl.workbook.properties.CalcProperties attribute) fullPrecision (openpyxl.workbook.properties.CalcProperties attribute) function (openpyxl.workbook.defined_name.DefinedName attribute) FunctionGroup (class in openpyxl.workbook.function_group) functionGroup (openpyxl.workbook.function_group.FunctionGroupList attribute) functionGroupId (openpyxl.workbook.defined_name.DefinedName attribute) FunctionGroupList (class in openpyxl.workbook.function_group) functionGroups (openpyxl.packaging.workbook.WorkbookPackage attribute)

G

g (openpyxl.drawing.colors.RGBPercent attribute) gamma (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) gapDepth (openpyxl.chart.area_chart.AreaChart3D attribute) (openpyxl.chart.bar_chart.BarChart3D attribute) (openpyxl.chart.line_chart.LineChart3D attribute) gapWidth (openpyxl.chart.bar_chart.BarChart attribute) (openpyxl.chart.bar_chart.BarChart3D attribute) (openpyxl.chart.pie_chart.ProjectedPieChart attribute) (openpyxl.chart.updown_bars.UpDownBars attribute) gd (openpyxl.drawing.geometry.GeomGuideList attribute) (openpyxl.drawing.text.GeomGuideList attribute) gdLst (openpyxl.drawing.geometry.CustomGeometry2D attribute) GeomGuide (class in openpyxl.drawing.geometry) (class in openpyxl.drawing.text) GeomGuideList (class in openpyxl.drawing.geometry) (class in openpyxl.drawing.text) GeomRect (class in openpyxl.drawing.geometry) get() (openpyxl.packaging.relationship.RelationshipList method) (openpyxl.worksheet.table.TableList method) get_column_interval() (in module openpyxl.utils.cell) get_column_letter() (in module openpyxl.utils.cell) get_dependents() (in module openpyxl.packaging.relationship) get_index() (openpyxl.workbook.workbook.Workbook method) get_rel() (in module openpyxl.packaging.relationship) get_rels_path() (in module openpyxl.packaging.relationship) get_sheet_by_name() (openpyxl.workbook.workbook.Workbook method) get_sheet_names() (openpyxl.workbook.workbook.Workbook method) get_time_format() (in module openpyxl.cell.cell) get_type() (in module openpyxl.cell.cell) glow (openpyxl.drawing.effect.EffectList attribute) GlowEffect (class in openpyxl.drawing.effect) goal (openpyxl.pivot.cache.OLAPKPI attribute) gradFill (openpyxl.chart.shapes.GraphicalProperties attribute) (openpyxl.drawing.line.LineProperties attribute) (openpyxl.drawing.text.CharacterProperties attribute) GradientFill (class in openpyxl.styles.fills) GradientFillProperties (class in openpyxl.drawing.fill) GradientStop (class in openpyxl.drawing.fill) grandCol (openpyxl.pivot.table.PivotArea attribute) grandRow (openpyxl.pivot.table.PivotArea attribute) grandTotalCaption (openpyxl.pivot.table.TableDefinition attribute) graphic (openpyxl.drawing.graphic.GraphicFrame attribute) graphical_properties (openpyxl.chart.chartspace.ChartSpace attribute) GraphicalProperties (class in openpyxl.chart.shapes) graphicalProperties (openpyxl.chart.axis.ChartLines attribute) (openpyxl.chart.axis.DisplayUnitsLabel attribute) (openpyxl.chart.error_bar.ErrorBars attribute) (openpyxl.chart.legend.Legend attribute) (openpyxl.chart.marker.DataPoint attribute) (openpyxl.chart.marker.Marker attribute) (openpyxl.chart.pivot.PivotFormat attribute) (openpyxl.chart.plotarea.DataTable attribute) (openpyxl.chart.plotarea.PlotArea attribute) (openpyxl.chart.series.Series attribute) (openpyxl.chart.surface_chart.BandFormat attribute) (openpyxl.chart.title.Title attribute) (openpyxl.chart.trendline.Trendline attribute) (openpyxl.chart.trendline.TrendlineLabel attribute) (openpyxl.drawing.connector.Shape attribute) (openpyxl.drawing.picture.PictureFrame attribute)

GraphicData (class in openpyxl.drawing.graphic) graphicData (openpyxl.drawing.graphic.GraphicObject attribute) GraphicFrame (class in openpyxl.drawing.graphic) graphicFrame (openpyxl.drawing.spreadsheet_drawing.AbsoluteAnchor attribute) (openpyxl.drawing.spreadsheet_drawing.OneCellAnchor attribute) (openpyxl.drawing.spreadsheet_drawing.TwoCellAnchor attribute) GraphicFrameLocking (class in openpyxl.drawing.graphic) graphicFrameLocks (openpyxl.drawing.graphic.NonVisualGraphicFrameProperties attribute) GraphicObject (class in openpyxl.drawing.graphic) gray (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) GrayscaleEffect (class in openpyxl.drawing.effect) grayscl (openpyxl.drawing.fill.Blip attribute) green (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) greenMod (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) greenOff (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) gridDropZones (openpyxl.pivot.table.TableDefinition attribute) gridLines (openpyxl.worksheet.page.PrintOptions attribute) gridLinesSet (openpyxl.worksheet.page.PrintOptions attribute) group (openpyxl.pivot.cache.GroupMember attribute) group() (openpyxl.worksheet.dimensions.DimensionHolder method) groupBy (openpyxl.pivot.cache.RangePr attribute) grouping (openpyxl.chart.area_chart.AreaChart attribute) (openpyxl.chart.area_chart.AreaChart3D attribute) (openpyxl.chart.bar_chart.BarChart attribute) (openpyxl.chart.bar_chart.BarChart3D attribute) (openpyxl.chart.line_chart.LineChart attribute) (openpyxl.chart.line_chart.LineChart3D attribute) groupInterval (openpyxl.pivot.cache.RangePr attribute) GroupItems (class in openpyxl.pivot.cache) groupItems (openpyxl.pivot.cache.FieldGroup attribute) GroupLevel (class in openpyxl.pivot.cache) groupLevels (openpyxl.pivot.cache.CacheHierarchy attribute) GroupLocking (class in openpyxl.drawing.properties) GroupMember (class in openpyxl.pivot.cache) groupMembers (openpyxl.pivot.cache.LevelGroup attribute) groups (openpyxl.pivot.cache.GroupLevel attribute) GroupShape (class in openpyxl.drawing.graphic) GroupShapeProperties (class in openpyxl.drawing.properties) GroupTransform2D (class in openpyxl.drawing.geometry) grow (openpyxl.drawing.effect.BlurEffect attribute) grpFill (openpyxl.drawing.text.CharacterProperties attribute) grpSp (openpyxl.drawing.spreadsheet_drawing.AbsoluteAnchor attribute) (openpyxl.drawing.spreadsheet_drawing.OneCellAnchor attribute) (openpyxl.drawing.spreadsheet_drawing.TwoCellAnchor attribute) grpSpLocks (openpyxl.drawing.properties.NonVisualGroupDrawingShapeProps attribute) grpSpPr (openpyxl.drawing.graphic.GroupShape attribute) gsLst (openpyxl.drawing.fill.GradientFillProperties attribute) gte (openpyxl.formatting.rule.FormatObject attribute) Guid (class in openpyxl.descriptors.excel) guid (openpyxl.chartsheet.custom.CustomChartsheetView attribute) (openpyxl.comments.comment_sheet.CommentRecord attribute) (openpyxl.workbook.views.CustomWorkbookView attribute)

H

h (openpyxl.chart.layout.ManualLayout attribute) (openpyxl.drawing.geometry.Bevel attribute) (openpyxl.drawing.geometry.Path2D attribute) (openpyxl.pivot.table.FieldItem attribute) hangingPunct (openpyxl.drawing.text.ParagraphProperties attribute) has_style (openpyxl.cell.read_only.ReadOnlyCell property) (openpyxl.styles.styleable.StyleableObject property) hash_password() (in module openpyxl.utils.protection) hashValue (openpyxl.chartsheet.protection.ChartsheetProtection attribute) (openpyxl.workbook.protection.FileSharing attribute) (openpyxl.worksheet.protection.SheetProtection attribute) headEnd (openpyxl.drawing.line.LineProperties attribute) header (openpyxl.chart.print_settings.PageMargins attribute) (openpyxl.worksheet.page.PageMargins attribute) HeaderFooter (class in openpyxl.worksheet.header_footer) headerFooter (openpyxl.chart.print_settings.PrintSettings attribute) HeaderFooter (openpyxl.chartsheet.chartsheet.Chartsheet attribute) headerFooter (openpyxl.chartsheet.chartsheet.Chartsheet attribute) (openpyxl.chartsheet.custom.CustomChartsheetView attribute) HeaderFooterItem (class in openpyxl.worksheet.header_footer) headerRowBorderDxfId (openpyxl.worksheet.table.Table attribute) headerRowCellStyle (openpyxl.worksheet.table.Table attribute) (openpyxl.worksheet.table.TableColumn attribute) headerRowCount (openpyxl.worksheet.table.Table attribute) headerRowDxfId (openpyxl.worksheet.table.Table attribute) (openpyxl.worksheet.table.TableColumn attribute) HeadingPairs (openpyxl.packaging.extended.ExtendedProperties attribute) headings (openpyxl.worksheet.page.PrintOptions attribute) height (openpyxl.chart.layout.ManualLayout attribute) (openpyxl.drawing.drawing.Drawing property) (openpyxl.drawing.geometry.PositiveSize2D attribute) (openpyxl.worksheet.dimensions.RowDimension attribute) help (openpyxl.workbook.defined_name.DefinedName attribute) HexBinary (class in openpyxl.descriptors.excel) hidden (openpyxl.drawing.properties.NonVisualDrawingProps attribute) (openpyxl.pivot.cache.CacheHierarchy attribute) (openpyxl.styles.named_styles.NamedStyle attribute) (openpyxl.styles.protection.Protection attribute) (openpyxl.workbook.defined_name.DefinedName attribute) (openpyxl.worksheet.dimensions.Dimension attribute) (openpyxl.worksheet.scenario.Scenario attribute) hiddenButton (openpyxl.worksheet.filters.FilterColumn attribute) hiddenLevel (openpyxl.pivot.table.PivotField attribute) HiddenSlides (openpyxl.packaging.extended.ExtendedProperties attribute) hide_drop_down (openpyxl.worksheet.datavalidation.DataValidation attribute) hideNewItems (openpyxl.pivot.table.PivotField attribute) hidePivotFieldList (openpyxl.workbook.properties.WorkbookProperties attribute) hier (openpyxl.pivot.fields.Tuple attribute) (openpyxl.pivot.table.PageField attribute) hierarchy (openpyxl.pivot.cache.CacheField attribute) (openpyxl.pivot.cache.CalculatedMember attribute)

HierarchyUsage (class in openpyxl.pivot.table) hierarchyUsage (openpyxl.pivot.table.HierarchyUsage attribute) highlight (openpyxl.drawing.text.CharacterProperties attribute) highlightClick (openpyxl.drawing.text.Hyperlink attribute) hiLowLines (openpyxl.chart.line_chart.LineChart attribute) (openpyxl.chart.line_chart.LineChart3D attribute) (openpyxl.chart.stock_chart.StockChart attribute) history (openpyxl.drawing.text.Hyperlink attribute) hlink (openpyxl.drawing.colors.ColorMapping attribute) hlinkClick (openpyxl.drawing.properties.NonVisualDrawingProps attribute) (openpyxl.drawing.text.CharacterProperties attribute) hlinkHover (openpyxl.drawing.properties.NonVisualDrawingProps attribute) hlinkMouseOver (openpyxl.drawing.text.CharacterProperties attribute) HLinks (openpyxl.packaging.extended.ExtendedProperties attribute) hMode (openpyxl.chart.layout.ManualLayout attribute) holeSize (openpyxl.chart.pie_chart.DoughnutChart attribute) horizontal (openpyxl.styles.alignment.Alignment attribute) (openpyxl.styles.borders.Border attribute) horizontalCentered (openpyxl.worksheet.page.PrintOptions attribute) horizontalDpi (openpyxl.worksheet.page.PrintPageSetup attribute) horzOverflow (openpyxl.drawing.text.RichTextProperties attribute) hour (openpyxl.worksheet.filters.DateGroupItem attribute) hsl (openpyxl.drawing.fill.Blip attribute) hslClr (openpyxl.drawing.colors.ColorChoice attribute) (openpyxl.drawing.effect.GlowEffect attribute) (openpyxl.drawing.effect.InnerShadowEffect attribute) (openpyxl.drawing.effect.OuterShadow attribute) (openpyxl.drawing.effect.PresetShadowEffect attribute) (openpyxl.drawing.fill.GradientStop attribute) (openpyxl.drawing.fill.SolidColorFillProperties attribute) HSLColor (class in openpyxl.drawing.colors) HSLEffect (class in openpyxl.drawing.effect) ht (openpyxl.worksheet.dimensions.RowDimension attribute) hue (openpyxl.drawing.colors.HSLColor attribute) (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) (openpyxl.drawing.effect.HSLEffect attribute) (openpyxl.drawing.effect.TintEffect attribute) hueMod (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) hueOff (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) Hyperlink (class in openpyxl.drawing.text) (class in openpyxl.worksheet.hyperlink) hyperlink (openpyxl.cell.cell.Cell property) (openpyxl.cell.cell.MergedCell attribute) (openpyxl.worksheet.hyperlink.HyperlinkList attribute) HyperlinkBase (openpyxl.packaging.extended.ExtendedProperties attribute) HyperlinkList (class in openpyxl.worksheet.hyperlink) HyperlinksChanged (openpyxl.packaging.extended.ExtendedProperties attribute)

I

i (openpyxl.cell.text.InlineFont attribute) (openpyxl.drawing.text.CharacterProperties attribute) (openpyxl.pivot.fields.Error attribute) (openpyxl.pivot.fields.Missing attribute) (openpyxl.pivot.fields.Number attribute) (openpyxl.pivot.fields.Text attribute) (openpyxl.pivot.table.RowColItem attribute) (openpyxl.styles.fonts.Font attribute) i1 (openpyxl.pivot.cache.RangeSet attribute) i2 (openpyxl.pivot.cache.RangeSet attribute) i3 (openpyxl.pivot.cache.RangeSet attribute) i4 (openpyxl.pivot.cache.RangeSet attribute) IconFilter (class in openpyxl.worksheet.filters) iconFilter (openpyxl.worksheet.filters.FilterColumn attribute) iconId (openpyxl.worksheet.filters.IconFilter attribute) (openpyxl.worksheet.filters.SortCondition attribute) IconSet (class in openpyxl.formatting.rule) iconSet (openpyxl.formatting.rule.IconSet attribute) (openpyxl.formatting.rule.Rule attribute) (openpyxl.pivot.cache.CacheHierarchy attribute) (openpyxl.worksheet.filters.IconFilter attribute) (openpyxl.worksheet.filters.SortCondition attribute) IconSetRule() (in module openpyxl.formatting.rule) id (openpyxl.chart.chartspace.ExternalData attribute) (openpyxl.chartsheet.publish.WebPublishItem attribute) (openpyxl.chartsheet.relation.DrawingHF attribute) (openpyxl.chartsheet.relation.SheetBackgroundPicture attribute) (openpyxl.drawing.connector.Connection attribute) (openpyxl.drawing.properties.NonVisualDrawingProps attribute) (openpyxl.drawing.relation.ChartRelation attribute) (openpyxl.drawing.text.Hyperlink attribute) (openpyxl.drawing.text.TextField attribute) (openpyxl.packaging.interface.ISerialisableFile property) Id (openpyxl.packaging.relationship.Relationship attribute) id (openpyxl.packaging.relationship.Relationship attribute) (openpyxl.packaging.workbook.ChildSheet attribute) (openpyxl.packaging.workbook.PivotCache attribute) (openpyxl.pivot.cache.CacheDefinition attribute) (openpyxl.pivot.cache.LevelGroup attribute) (openpyxl.pivot.table.PivotFilter attribute) (openpyxl.pivot.table.TableDefinition attribute) (openpyxl.workbook.external_link.external.ExternalBook attribute) (openpyxl.workbook.external_reference.ExternalReference attribute) (openpyxl.workbook.web.WebPublishObject attribute) (openpyxl.worksheet.controls.ControlProperty attribute) (openpyxl.worksheet.drawing.Drawing attribute) (openpyxl.worksheet.hyperlink.Hyperlink attribute) (openpyxl.worksheet.page.PrintPageSetup attribute) (openpyxl.worksheet.pagebreak.Break attribute) (openpyxl.worksheet.related.Related attribute) (openpyxl.worksheet.table.Table attribute) (openpyxl.worksheet.table.TableColumn attribute) identifier (openpyxl.packaging.core.DocumentProperties attribute) identifiers (openpyxl.chart.series.Series attribute) idx (openpyxl.chart.data_source.NumVal attribute) (openpyxl.chart.data_source.StrVal attribute) (openpyxl.chart.label.DataLabel attribute) (openpyxl.chart.legend.LegendEntry attribute) (openpyxl.chart.marker.DataPoint attribute) (openpyxl.chart.pivot.PivotFormat attribute) (openpyxl.chart.series.Series attribute) (openpyxl.chart.series.XYSeries attribute) (openpyxl.chart.surface_chart.BandFormat attribute) (openpyxl.drawing.connector.Connection attribute) (openpyxl.drawing.geometry.FontReference attribute) (openpyxl.drawing.geometry.StyleMatrixReference attribute) idx_base (openpyxl.descriptors.sequence.Sequence attribute) (openpyxl.descriptors.serialisable.Serialisable attribute) Ignorable (openpyxl.packaging.workbook.WorkbookPackage attribute) IgnoredError (class in openpyxl.worksheet.errors) ignoredError (openpyxl.worksheet.errors.IgnoredErrors attribute) IgnoredErrors (class in openpyxl.worksheet.errors) IllegalCharacterError Image (class in openpyxl.drawing.image) iMeasureFld (openpyxl.pivot.table.PivotFilter attribute) iMeasureHier (openpyxl.pivot.table.PivotFilter attribute)

imeMode (openpyxl.worksheet.datavalidation.DataValidation attribute) immersive (openpyxl.pivot.table.TableDefinition attribute) inch_to_dxa() (in module openpyxl.utils.units) inch_to_EMU() (in module openpyxl.utils.units) includeHiddenRowCol (openpyxl.workbook.views.CustomWorkbookView attribute) includeNewItemsInFilter (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.PivotHierarchy attribute) includePrintSettings (openpyxl.workbook.views.CustomWorkbookView attribute) indent (openpyxl.drawing.text.ParagraphProperties attribute) (openpyxl.pivot.table.TableDefinition attribute) (openpyxl.styles.alignment.Alignment attribute) Index (class in openpyxl.pivot.fields) index (openpyxl.styles.colors.Color property) (openpyxl.styles.colors.ColorList property) (openpyxl.worksheet.dimensions.ColumnDimension attribute) (openpyxl.worksheet.dimensions.Dimension attribute) index() (openpyxl.utils.indexed_list.IndexedList method) (openpyxl.workbook.workbook.Workbook method) indexed (openpyxl.styles.colors.Color attribute) indexedColors (openpyxl.styles.colors.ColorList attribute) IndexedList (class in openpyxl.utils.indexed_list) InlineFont (class in openpyxl.cell.text) InnerShadowEffect (class in openpyxl.drawing.effect) innerShdw (openpyxl.drawing.effect.EffectList attribute) InputCells (class in openpyxl.worksheet.scenario) inputCells (openpyxl.worksheet.scenario.Scenario attribute) insert_cols() (openpyxl.worksheet.worksheet.Worksheet method) insert_rows() (openpyxl.worksheet.worksheet.Worksheet method) insertBlankRow (openpyxl.pivot.table.PivotField attribute) insertColumns (openpyxl.worksheet.protection.SheetProtection attribute) insertHyperlinks (openpyxl.worksheet.protection.SheetProtection attribute) insertPageBreak (openpyxl.pivot.table.PivotField attribute) insertRow (openpyxl.worksheet.table.Table attribute) insertRows (openpyxl.worksheet.protection.SheetProtection attribute) insertRowShift (openpyxl.worksheet.table.Table attribute) Integer (class in openpyxl.descriptors.base) intercept (openpyxl.chart.trendline.Trendline attribute) internal_value (openpyxl.cell.cell.Cell property) (openpyxl.cell.read_only.ReadOnlyCell property) intersection() (openpyxl.worksheet.cell_range.CellRange method) IntProperty (class in openpyxl.packaging.custom) inv (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) invalid (openpyxl.pivot.cache.CacheDefinition attribute) InvalidFileException invalidUrl (openpyxl.drawing.text.Hyperlink attribute) invertIfNegative (openpyxl.chart.marker.DataPoint attribute) (openpyxl.chart.series.Series attribute) (openpyxl.chart.series.XYSeries attribute) invGamma (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) is_builtin() (in module openpyxl.styles.numbers) is_date (openpyxl.cell.cell.Cell property) (openpyxl.cell.read_only.EmptyCell attribute) (openpyxl.cell.read_only.ReadOnlyCell property) is_date_format() (in module openpyxl.styles.numbers) is_datetime() (in module openpyxl.styles.numbers) is_external (openpyxl.workbook.defined_name.DefinedName property) is_reserved (openpyxl.workbook.defined_name.DefinedName property) is_timedelta_format() (in module openpyxl.styles.numbers) isdisjoint() (openpyxl.worksheet.cell_range.CellRange method) ISerialisableFile (class in openpyxl.packaging.interface) isgenerator() (in module openpyxl.worksheet.worksheet) issubset() (openpyxl.worksheet.cell_range.CellRange method) issuperset() (openpyxl.worksheet.cell_range.CellRange method) italic (openpyxl.styles.fonts.Font attribute) item (openpyxl.pivot.fields.Tuple attribute) (openpyxl.pivot.table.PageField attribute) itemPageCount (openpyxl.pivot.table.PivotField attribute) itemPrintTitles (openpyxl.pivot.table.TableDefinition attribute) items (openpyxl.pivot.table.PivotField attribute) items() (openpyxl.worksheet.table.TableList method) iter_cols() (openpyxl.worksheet.worksheet.Worksheet method) iter_rows() (openpyxl.worksheet.worksheet.Worksheet method) iterate (openpyxl.workbook.properties.CalcProperties attribute) iterateCount (openpyxl.workbook.properties.CalcProperties attribute) iterateDelta (openpyxl.workbook.properties.CalcProperties attribute)

J

join_lines (openpyxl.chart.pie_chart.ProjectedPieChart attribute)

justifyLastLine (openpyxl.styles.alignment.Alignment attribute) justLastX (openpyxl.comments.comment_sheet.Properties attribute)

K

kern (openpyxl.drawing.text.CharacterProperties attribute) key (openpyxl.styles.styleable.NamedStyleDescriptor attribute) (openpyxl.styles.styleable.NumberFormatDescriptor attribute) (openpyxl.worksheet.smart_tag.CellSmartTagPr attribute) keyAttribute (openpyxl.pivot.cache.CacheHierarchy attribute) keywords (openpyxl.packaging.core.DocumentProperties attribute)

kpis (openpyxl.pivot.cache.CacheDefinition attribute) kumimoji (openpyxl.drawing.text.CharacterProperties attribute) kx (openpyxl.drawing.effect.OuterShadow attribute) (openpyxl.drawing.effect.ReflectionEffect attribute) ky (openpyxl.drawing.effect.OuterShadow attribute) (openpyxl.drawing.effect.ReflectionEffect attribute)

L

l (openpyxl.chart.print_settings.PageMargins attribute) (openpyxl.drawing.fill.RelativeRect attribute) (openpyxl.drawing.geometry.GeomRect attribute) labelOnly (openpyxl.pivot.table.PivotArea attribute) labels (openpyxl.chart.series.Series attribute) lang (openpyxl.chart.chartspace.ChartSpace attribute) (openpyxl.drawing.text.CharacterProperties attribute) language (openpyxl.packaging.core.DocumentProperties attribute) last_modified_by (openpyxl.packaging.core.DocumentProperties attribute) lastClr (openpyxl.drawing.colors.SystemColor attribute) lastEdited (openpyxl.workbook.properties.FileVersion attribute) lastModifiedBy (openpyxl.packaging.core.DocumentProperties attribute) lastPrinted (openpyxl.packaging.core.DocumentProperties attribute) lat (openpyxl.drawing.geometry.SphereCoords attribute) latin (openpyxl.drawing.text.CharacterProperties attribute) latinLnBrk (openpyxl.drawing.text.ParagraphProperties attribute) Layout (class in openpyxl.chart.layout) layout (openpyxl.chart.axis.DisplayUnitsLabel attribute) (openpyxl.chart.legend.Legend attribute) (openpyxl.chart.plotarea.PlotArea attribute) (openpyxl.chart.title.Title attribute) (openpyxl.chart.trendline.TrendlineLabel attribute) layoutTarget (openpyxl.chart.layout.ManualLayout attribute) lblAlgn (openpyxl.chart.axis.TextAxis attribute) lblOffset (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.TextAxis attribute) left (openpyxl.chart.print_settings.PageMargins attribute) (openpyxl.drawing.fill.RelativeRect attribute) (openpyxl.styles.borders.Border attribute) (openpyxl.styles.fills.GradientFill attribute) (openpyxl.worksheet.cell_range.CellRange property) (openpyxl.worksheet.header_footer.HeaderFooterItem attribute) (openpyxl.worksheet.page.PageMargins attribute) leftFooterEvenPages (openpyxl.chartsheet.relation.DrawingHF attribute) leftFooterFirstPage (openpyxl.chartsheet.relation.DrawingHF attribute) leftFooterOddPages (openpyxl.chartsheet.relation.DrawingHF attribute) leftHeaderEvenPages (openpyxl.chartsheet.relation.DrawingHF attribute) leftHeaderFirstPage (openpyxl.chartsheet.relation.DrawingHF attribute) leftHeaderOddPages (openpyxl.chartsheet.relation.DrawingHF attribute) Legend (class in openpyxl.chart.legend) legend (openpyxl.chart.chartspace.ChartContainer attribute) LegendEntry (class in openpyxl.chart.legend) legendEntry (openpyxl.chart.legend.Legend attribute) legendPos (openpyxl.chart.legend.Legend attribute) len (openpyxl.drawing.line.LineEndProperties attribute) Length (class in openpyxl.descriptors.base) length (openpyxl.drawing.line.DashStop attribute) Level (class in openpyxl.chart.data_source) level (openpyxl.pivot.cache.CacheField attribute) (openpyxl.pivot.table.MemberList attribute) (openpyxl.pivot.table.MemberProperty attribute) LevelGroup (class in openpyxl.pivot.cache) lfe (openpyxl.chartsheet.relation.DrawingHF attribute) lff (openpyxl.chartsheet.relation.DrawingHF attribute) lfo (openpyxl.chartsheet.relation.DrawingHF attribute) lhe (openpyxl.chartsheet.relation.DrawingHF attribute) lhf (openpyxl.chartsheet.relation.DrawingHF attribute) lho (openpyxl.chartsheet.relation.DrawingHF attribute) LightRig (class in openpyxl.drawing.geometry) lightRig (openpyxl.drawing.geometry.Scene3D attribute) lin (openpyxl.drawing.fill.GradientFillProperties attribute) line (openpyxl.chart.shapes.GraphicalProperties attribute) line3DChart (openpyxl.chart.plotarea.PlotArea attribute) linear (openpyxl.drawing.fill.GradientFillProperties attribute) LinearShadeProperties (class in openpyxl.drawing.fill) LineBreak (class in openpyxl.drawing.text)

LineChart (class in openpyxl.chart.line_chart) lineChart (openpyxl.chart.plotarea.PlotArea attribute) LineChart3D (class in openpyxl.chart.line_chart) LineEndProperties (class in openpyxl.drawing.line) LineProperties (class in openpyxl.drawing.line) Lines (openpyxl.packaging.extended.ExtendedProperties attribute) link (openpyxl.drawing.fill.Blip attribute) (openpyxl.worksheet.ole.OleObject attribute) linkedCell (openpyxl.worksheet.controls.ControlProperty attribute) LinkProperty (class in openpyxl.packaging.custom) LinksUpToDate (openpyxl.packaging.extended.ExtendedProperties attribute) lIns (openpyxl.drawing.text.RichTextProperties attribute) listDataValidation (openpyxl.worksheet.errors.IgnoredError attribute) listFillRange (openpyxl.worksheet.controls.ControlProperty attribute) ListStyle (class in openpyxl.drawing.text) ln (openpyxl.chart.shapes.GraphicalProperties attribute) (openpyxl.drawing.text.CharacterProperties attribute) lnRef (openpyxl.drawing.geometry.ShapeStyle attribute) lnSpc (openpyxl.drawing.text.ParagraphProperties attribute) lnSpcReduction (openpyxl.drawing.text.TextNormalAutofit attribute) load_workbook() (in module openpyxl.reader.excel) localname() (in module openpyxl.xml.functions) localSheetId (openpyxl.workbook.defined_name.DefinedName attribute) Location (class in openpyxl.pivot.table) location (openpyxl.pivot.table.TableDefinition attribute) (openpyxl.worksheet.hyperlink.Hyperlink attribute) lock_revision (openpyxl.workbook.protection.WorkbookProtection attribute) lock_structure (openpyxl.workbook.protection.WorkbookProtection attribute) lock_windows (openpyxl.workbook.protection.WorkbookProtection attribute) locked (openpyxl.comments.comment_sheet.Properties attribute) (openpyxl.styles.protection.Protection attribute) (openpyxl.worksheet.controls.ControlProperty attribute) (openpyxl.worksheet.ole.ObjectPr attribute) (openpyxl.worksheet.scenario.Scenario attribute) lockRevision (openpyxl.workbook.protection.WorkbookProtection attribute) lockStructure (openpyxl.workbook.protection.WorkbookProtection attribute) lockText (openpyxl.comments.comment_sheet.Properties attribute) lockWindows (openpyxl.workbook.protection.WorkbookProtection attribute) logBase (openpyxl.chart.axis.Scaling attribute) lon (openpyxl.drawing.geometry.SphereCoords attribute) longFileNames (openpyxl.workbook.web.WebPublishing attribute) longText (openpyxl.pivot.cache.SharedItems attribute) lowestEdited (openpyxl.workbook.properties.FileVersion attribute) lstStyle (openpyxl.chart.text.RichText attribute) lum (openpyxl.drawing.colors.HSLColor attribute) (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) (openpyxl.drawing.effect.HSLEffect attribute) (openpyxl.drawing.fill.Blip attribute) LuminanceEffect (class in openpyxl.drawing.effect) lumMod (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) lumOff (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) lvl (openpyxl.chart.data_source.MultiLevelStrData attribute) (openpyxl.drawing.text.ParagraphProperties attribute) lvl1pPr (openpyxl.drawing.text.ListStyle attribute) lvl2pPr (openpyxl.drawing.text.ListStyle attribute) lvl3pPr (openpyxl.drawing.text.ListStyle attribute) lvl4pPr (openpyxl.drawing.text.ListStyle attribute) lvl5pPr (openpyxl.drawing.text.ListStyle attribute) lvl6pPr (openpyxl.drawing.text.ListStyle attribute) lvl7pPr (openpyxl.drawing.text.ListStyle attribute) lvl8pPr (openpyxl.drawing.text.ListStyle attribute) lvl9pPr (openpyxl.drawing.text.ListStyle attribute) lxml_available() (in module openpyxl.xml) lxml_env_set() (in module openpyxl.xml)

M

m (openpyxl.pivot.cache.GroupItems attribute) (openpyxl.pivot.cache.PCDSDTCEntries attribute) (openpyxl.pivot.cache.SharedItems attribute) (openpyxl.pivot.record.Record attribute) (openpyxl.pivot.table.FieldItem attribute) macro (openpyxl.drawing.connector.ConnectorShape attribute) (openpyxl.drawing.connector.Shape attribute) (openpyxl.drawing.graphic.GraphicFrame attribute) (openpyxl.drawing.picture.PictureFrame attribute) (openpyxl.worksheet.controls.ControlProperty attribute) (openpyxl.worksheet.ole.ObjectPr attribute) majorGridlines (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.NumericAxis attribute) (openpyxl.chart.axis.SeriesAxis attribute) (openpyxl.chart.axis.TextAxis attribute) majorTickMark (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.NumericAxis attribute) (openpyxl.chart.axis.SeriesAxis attribute) (openpyxl.chart.axis.TextAxis attribute) majorTimeUnit (openpyxl.chart.axis.DateAxis attribute) majorUnit (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.NumericAxis attribute) man (openpyxl.worksheet.pagebreak.Break attribute) Manager (openpyxl.packaging.extended.ExtendedProperties attribute) Manifest (class in openpyxl.packaging.manifest) manualBreakCount (openpyxl.worksheet.pagebreak.ColBreak property) (openpyxl.worksheet.pagebreak.RowBreak property) ManualLayout (class in openpyxl.chart.layout) manualLayout (openpyxl.chart.layout.Layout attribute) mapId (openpyxl.worksheet.table.XMLColumnProps attribute) mappingCount (openpyxl.pivot.cache.CacheField attribute) maps (openpyxl.pivot.cache.CacheDefinition attribute) Marker (class in openpyxl.chart.marker) marker (openpyxl.chart.line_chart.LineChart attribute) (openpyxl.chart.line_chart.LineChart3D attribute) (openpyxl.chart.marker.DataPoint attribute) (openpyxl.chart.pivot.PivotFormat attribute) (openpyxl.chart.series.Series attribute) (openpyxl.chart.series.XYSeries attribute) marL (openpyxl.drawing.text.ParagraphProperties attribute) marR (openpyxl.drawing.text.ParagraphProperties attribute) MatchPattern (class in openpyxl.descriptors.base) Max (class in openpyxl.descriptors.base) max (openpyxl.chart.axis.Scaling attribute) (openpyxl.chart.descriptors.NestedGapAmount attribute) (openpyxl.chart.descriptors.NestedOverlap attribute) (openpyxl.descriptors.excel.Percentage attribute) (openpyxl.descriptors.excel.TextPoint attribute) (openpyxl.worksheet.dimensions.ColumnDimension attribute) (openpyxl.worksheet.pagebreak.Break attribute) max_col (openpyxl.chart.reference.Reference attribute) (openpyxl.worksheet.cell_range.CellRange attribute) (openpyxl.worksheet.print_settings.ColRange attribute) max_column (openpyxl.worksheet.worksheet.Worksheet property) max_row (openpyxl.chart.reference.Reference attribute) (openpyxl.worksheet.cell_range.CellRange attribute) (openpyxl.worksheet.print_settings.RowRange attribute) (openpyxl.worksheet.worksheet.Worksheet property) maxDate (openpyxl.pivot.cache.SharedItems attribute) maximized (openpyxl.workbook.views.CustomWorkbookView attribute) maxLength (openpyxl.formatting.rule.DataBar attribute) maxRank (openpyxl.pivot.cache.OLAPSet attribute) maxSubtotal (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.Reference attribute) maxVal (openpyxl.worksheet.filters.DynamicFilter attribute) maxValIso (openpyxl.worksheet.filters.DynamicFilter attribute) maxValue (openpyxl.pivot.cache.SharedItems attribute) mdx (openpyxl.pivot.cache.CalculatedMember attribute) (openpyxl.pivot.cache.Query attribute) mdxSubqueries (openpyxl.pivot.table.TableDefinition attribute) measure (openpyxl.pivot.cache.CacheHierarchy attribute) (openpyxl.pivot.cache.PivotDimension attribute) MeasureDimensionMap (class in openpyxl.pivot.cache) measureFilter (openpyxl.pivot.table.PivotField attribute) MeasureGroup (class in openpyxl.pivot.cache) measureGroup (openpyxl.pivot.cache.CacheHierarchy attribute) (openpyxl.pivot.cache.MeasureDimensionMap attribute) (openpyxl.pivot.cache.OLAPKPI attribute) measureGroups (openpyxl.pivot.cache.CacheDefinition attribute) measures (openpyxl.pivot.cache.CacheHierarchy attribute) member (openpyxl.pivot.table.MemberList attribute) MemberList (class in openpyxl.pivot.table) memberName (openpyxl.pivot.cache.CalculatedMember attribute) MemberProperty (class in openpyxl.pivot.table) memberPropertyField (openpyxl.pivot.cache.CacheField attribute) members (openpyxl.pivot.table.PivotHierarchy attribute) memberValueDatatype (openpyxl.pivot.cache.CacheHierarchy attribute) merge_cells() (openpyxl.worksheet.worksheet.Worksheet method) MergeCell (class in openpyxl.worksheet.merge) mergeCell (openpyxl.worksheet.merge.MergeCells attribute) MergeCells (class in openpyxl.worksheet.merge) merged_cell_ranges (openpyxl.worksheet.worksheet.Worksheet property) MergedCell (class in openpyxl.cell.cell) MergedCellRange (class in openpyxl.worksheet.merge) mergeInterval (openpyxl.workbook.views.CustomWorkbookView attribute) mergeItem (openpyxl.pivot.table.TableDefinition attribute) meta (openpyxl.drawing.connector.Shape attribute) MetaSerialisable (class in openpyxl.descriptors) MetaStrict (class in openpyxl.descriptors) mime_type (openpyxl.chartsheet.chartsheet.Chartsheet attribute) (openpyxl.comments.comment_sheet.CommentSheet attribute) (openpyxl.drawing.spreadsheet_drawing.SpreadsheetDrawing attribute) (openpyxl.pivot.cache.CacheDefinition attribute) (openpyxl.pivot.record.RecordList attribute) (openpyxl.pivot.table.TableDefinition attribute) (openpyxl.workbook.external_link.external.ExternalLink attribute) (openpyxl.workbook.workbook.Workbook property) (openpyxl.worksheet.table.Table attribute) (openpyxl.worksheet.worksheet.Worksheet attribute) Min (class in openpyxl.descriptors.base) min (openpyxl.chart.axis.Scaling attribute) (openpyxl.chart.descriptors.NestedGapAmount attribute) (openpyxl.chart.descriptors.NestedOverlap attribute) (openpyxl.descriptors.excel.Percentage attribute) (openpyxl.descriptors.excel.TextPoint attribute) (openpyxl.worksheet.dimensions.ColumnDimension attribute) (openpyxl.worksheet.pagebreak.Break attribute) min_col (openpyxl.chart.reference.Reference attribute) (openpyxl.worksheet.cell_range.CellRange attribute) (openpyxl.worksheet.print_settings.ColRange attribute) min_column (openpyxl.worksheet.worksheet.Worksheet property) min_row (openpyxl.chart.reference.Reference attribute) (openpyxl.worksheet.cell_range.CellRange attribute) (openpyxl.worksheet.print_settings.RowRange attribute) (openpyxl.worksheet.worksheet.Worksheet property) minDate (openpyxl.pivot.cache.SharedItems attribute) minimized (openpyxl.workbook.views.BookView attribute) (openpyxl.workbook.views.CustomWorkbookView attribute) minLength (openpyxl.formatting.rule.DataBar attribute) MinMax (class in openpyxl.descriptors.base) minorGridlines (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.NumericAxis attribute) (openpyxl.chart.axis.SeriesAxis attribute) (openpyxl.chart.axis.TextAxis attribute) minorTickMark (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.NumericAxis attribute) (openpyxl.chart.axis.SeriesAxis attribute) (openpyxl.chart.axis.TextAxis attribute) minorTimeUnit (openpyxl.chart.axis.DateAxis attribute) minorUnit (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.NumericAxis attribute) minRefreshableVersion (openpyxl.pivot.cache.CacheDefinition attribute) (openpyxl.pivot.table.TableDefinition attribute) minSubtotal (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.Reference attribute) minus (openpyxl.chart.error_bar.ErrorBars attribute) minute (openpyxl.worksheet.filters.DateGroupItem attribute) minValue (openpyxl.pivot.cache.SharedItems attribute) Missing (class in openpyxl.pivot.fields) missingCaption (openpyxl.pivot.table.TableDefinition attribute) missingItemsLimit (openpyxl.pivot.cache.CacheDefinition attribute) miter (openpyxl.drawing.line.LineProperties attribute) MMClips (openpyxl.packaging.extended.ExtendedProperties attribute) modified (openpyxl.packaging.core.DocumentProperties attribute) module openpyxl openpyxl.cell openpyxl.cell.cell openpyxl.cell.read_only openpyxl.cell.rich_text openpyxl.cell.text openpyxl.chart openpyxl.chart.area_chart openpyxl.chart.axis openpyxl.chart.bar_chart openpyxl.chart.bubble_chart openpyxl.chart.chartspace openpyxl.chart.data_source openpyxl.chart.descriptors openpyxl.chart.error_bar openpyxl.chart.label openpyxl.chart.layout openpyxl.chart.legend openpyxl.chart.line_chart openpyxl.chart.marker openpyxl.chart.picture openpyxl.chart.pie_chart openpyxl.chart.pivot openpyxl.chart.plotarea openpyxl.chart.print_settings openpyxl.chart.radar_chart openpyxl.chart.reader openpyxl.chart.reference openpyxl.chart.scatter_chart openpyxl.chart.series openpyxl.chart.series_factory openpyxl.chart.shapes openpyxl.chart.stock_chart openpyxl.chart.surface_chart openpyxl.chart.text openpyxl.chart.title openpyxl.chart.trendline openpyxl.chart.updown_bars openpyxl.chartsheet openpyxl.chartsheet.chartsheet openpyxl.chartsheet.custom openpyxl.chartsheet.properties openpyxl.chartsheet.protection openpyxl.chartsheet.publish openpyxl.chartsheet.relation openpyxl.chartsheet.views openpyxl.comments openpyxl.comments.author openpyxl.comments.comment_sheet openpyxl.comments.comments openpyxl.comments.shape_writer openpyxl.descriptors openpyxl.descriptors.base openpyxl.descriptors.container openpyxl.descriptors.excel openpyxl.descriptors.namespace openpyxl.descriptors.nested openpyxl.descriptors.sequence openpyxl.descriptors.serialisable openpyxl.drawing openpyxl.drawing.colors openpyxl.drawing.connector openpyxl.drawing.drawing openpyxl.drawing.effect openpyxl.drawing.fill openpyxl.drawing.geometry openpyxl.drawing.graphic openpyxl.drawing.image openpyxl.drawing.line openpyxl.drawing.picture openpyxl.drawing.properties openpyxl.drawing.relation openpyxl.drawing.spreadsheet_drawing openpyxl.drawing.text openpyxl.drawing.xdr openpyxl.formatting openpyxl.formatting.formatting openpyxl.formatting.rule openpyxl.packaging openpyxl.packaging.core openpyxl.packaging.custom openpyxl.packaging.extended openpyxl.packaging.interface openpyxl.packaging.manifest openpyxl.packaging.relationship openpyxl.packaging.workbook openpyxl.pivot openpyxl.pivot.cache openpyxl.pivot.fields openpyxl.pivot.record openpyxl.pivot.table openpyxl.reader openpyxl.reader.drawings openpyxl.reader.excel openpyxl.reader.strings openpyxl.reader.workbook openpyxl.styles openpyxl.styles.alignment openpyxl.styles.borders openpyxl.styles.builtins openpyxl.styles.cell_style openpyxl.styles.colors openpyxl.styles.differential openpyxl.styles.fills openpyxl.styles.fonts openpyxl.styles.named_styles openpyxl.styles.numbers openpyxl.styles.protection openpyxl.styles.proxy openpyxl.styles.styleable openpyxl.styles.stylesheet openpyxl.styles.table openpyxl.utils openpyxl.utils.bound_dictionary openpyxl.utils.cell openpyxl.utils.dataframe openpyxl.utils.datetime openpyxl.utils.escape openpyxl.utils.exceptions openpyxl.utils.indexed_list openpyxl.utils.inference openpyxl.utils.protection openpyxl.utils.units openpyxl.workbook openpyxl.workbook.child openpyxl.workbook.defined_name openpyxl.workbook.external_link openpyxl.workbook.external_link.external openpyxl.workbook.external_reference openpyxl.workbook.function_group openpyxl.workbook.properties openpyxl.workbook.protection openpyxl.workbook.smart_tags openpyxl.workbook.views openpyxl.workbook.web openpyxl.workbook.workbook openpyxl.worksheet openpyxl.worksheet.cell_range openpyxl.worksheet.cell_watch openpyxl.worksheet.controls openpyxl.worksheet.copier openpyxl.worksheet.custom openpyxl.worksheet.datavalidation openpyxl.worksheet.dimensions openpyxl.worksheet.drawing openpyxl.worksheet.errors openpyxl.worksheet.filters openpyxl.worksheet.formula openpyxl.worksheet.header_footer openpyxl.worksheet.hyperlink openpyxl.worksheet.merge openpyxl.worksheet.ole openpyxl.worksheet.page openpyxl.worksheet.pagebreak openpyxl.worksheet.picture openpyxl.worksheet.print_settings openpyxl.worksheet.properties openpyxl.worksheet.protection openpyxl.worksheet.related openpyxl.worksheet.scenario openpyxl.worksheet.smart_tag openpyxl.worksheet.table openpyxl.worksheet.views openpyxl.worksheet.worksheet openpyxl.writer openpyxl.writer.excel openpyxl.writer.theme openpyxl.xml openpyxl.xml.constants openpyxl.xml.functions

month (openpyxl.worksheet.filters.DateGroupItem attribute) move_range() (openpyxl.worksheet.worksheet.Worksheet method) move_sheet() (openpyxl.workbook.workbook.Workbook method) moveWithCells (openpyxl.worksheet.ole.ObjectAnchor attribute) mpFld (openpyxl.pivot.table.PivotFilter attribute) mpMap (openpyxl.pivot.cache.CacheField attribute) mps (openpyxl.pivot.table.PivotHierarchy attribute) mruColors (openpyxl.styles.colors.ColorList attribute) MultiCellRange (class in openpyxl.worksheet.cell_range) MultiLevelStrData (class in openpyxl.chart.data_source) MultiLevelStrRef (class in openpyxl.chart.data_source) multiLvlStrCache (openpyxl.chart.data_source.MultiLevelStrRef attribute) multiLvlStrRef (openpyxl.chart.data_source.AxDataSource attribute) multipleFieldFilters (openpyxl.pivot.table.TableDefinition attribute) multipleItemSelectionAllowed (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.PivotHierarchy attribute) MultiSequence (class in openpyxl.descriptors.sequence) MultiSequencePart (class in openpyxl.descriptors.sequence)

N

n (openpyxl.pivot.cache.GroupItems attribute) (openpyxl.pivot.cache.PCDSDTCEntries attribute) (openpyxl.pivot.cache.SharedItems attribute) (openpyxl.pivot.record.Record attribute) (openpyxl.pivot.table.FieldItem attribute) name (openpyxl.chart.pivot.PivotSource attribute) (openpyxl.chart.trendline.Trendline attribute) (openpyxl.drawing.effect.EffectContainer attribute) (openpyxl.drawing.geometry.GeomGuide attribute) (openpyxl.drawing.properties.NonVisualDrawingProps attribute) (openpyxl.drawing.text.EmbeddedWAVAudioFile attribute) (openpyxl.drawing.text.GeomGuide attribute) (openpyxl.packaging.workbook.ChildSheet attribute) (openpyxl.pivot.cache.CacheField attribute) (openpyxl.pivot.cache.CalculatedMember attribute) (openpyxl.pivot.cache.LevelGroup attribute) (openpyxl.pivot.cache.MeasureGroup attribute) (openpyxl.pivot.cache.PageItem attribute) (openpyxl.pivot.cache.PivotDimension attribute) (openpyxl.pivot.cache.RangeSet attribute) (openpyxl.pivot.cache.WorksheetSource attribute) (openpyxl.pivot.table.DataField attribute) (openpyxl.pivot.table.MemberProperty attribute) (openpyxl.pivot.table.PageField attribute) (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.PivotFilter attribute) (openpyxl.pivot.table.PivotTableStyle attribute) (openpyxl.pivot.table.TableDefinition attribute) (openpyxl.styles.fonts.Font attribute) (openpyxl.styles.named_styles.NamedStyle attribute) (openpyxl.styles.table.TableStyle attribute) (openpyxl.workbook.defined_name.DefinedName attribute) (openpyxl.workbook.external_link.external.ExternalDefinedName attribute) (openpyxl.workbook.function_group.FunctionGroup attribute) (openpyxl.workbook.smart_tags.SmartTag attribute) (openpyxl.workbook.views.CustomWorkbookView attribute) (openpyxl.worksheet.controls.Control attribute) (openpyxl.worksheet.custom.CustomProperty attribute) (openpyxl.worksheet.scenario.Scenario attribute) (openpyxl.worksheet.table.Table attribute) (openpyxl.worksheet.table.TableColumn attribute) (openpyxl.worksheet.table.TableStyleInfo attribute) named_styles (openpyxl.workbook.workbook.Workbook property) NamedRangeException NamedStyle (class in openpyxl.styles.named_styles) NamedStyleDescriptor (class in openpyxl.styles.styleable) NamedStyleList (class in openpyxl.styles.named_styles) nameLen (openpyxl.pivot.table.MemberProperty attribute) names (openpyxl.packaging.custom.CustomPropertyList property) (openpyxl.styles.named_styles.NamedStyleList property) namespace (openpyxl.descriptors.excel.Relation attribute) (openpyxl.descriptors.serialisable.Serialisable attribute) (openpyxl.drawing.colors.ColorChoice attribute) (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) (openpyxl.drawing.fill.Blip attribute) (openpyxl.drawing.fill.GradientFillProperties attribute) (openpyxl.drawing.fill.GradientStop attribute) (openpyxl.drawing.fill.LinearShadeProperties attribute) (openpyxl.drawing.fill.PathShadeProperties attribute) (openpyxl.drawing.fill.PatternFillProperties attribute) (openpyxl.drawing.fill.RelativeRect attribute) (openpyxl.drawing.fill.StretchInfoProperties attribute) (openpyxl.drawing.geometry.GroupTransform2D attribute) (openpyxl.drawing.geometry.Point2D attribute) (openpyxl.drawing.geometry.PositiveSize2D attribute) (openpyxl.drawing.geometry.PresetGeometry2D attribute) (openpyxl.drawing.geometry.Shape3D attribute) (openpyxl.drawing.geometry.Transform2D attribute) (openpyxl.drawing.graphic.GraphicData attribute) (openpyxl.drawing.graphic.GraphicObject attribute) (openpyxl.drawing.line.DashStop attribute) (openpyxl.drawing.line.LineEndProperties attribute) (openpyxl.drawing.line.LineProperties attribute) (openpyxl.drawing.picture.PictureLocking attribute) (openpyxl.drawing.properties.GroupLocking attribute) (openpyxl.drawing.relation.ChartRelation attribute) (openpyxl.drawing.text.CharacterProperties attribute) (openpyxl.drawing.text.Font attribute) (openpyxl.drawing.text.Hyperlink attribute) (openpyxl.drawing.text.LineBreak attribute) (openpyxl.drawing.text.ListStyle attribute) (openpyxl.drawing.text.Paragraph attribute) (openpyxl.drawing.text.ParagraphProperties attribute) (openpyxl.drawing.text.RegularTextRun attribute) (openpyxl.drawing.text.RichTextProperties attribute) (openpyxl.drawing.xdr.XDRPoint2D attribute) (openpyxl.drawing.xdr.XDRPositiveSize2D attribute) (openpyxl.drawing.xdr.XDRTransform2D attribute) (openpyxl.packaging.core.DocumentProperties attribute) namespaced() (in module openpyxl.descriptors.namespace) namespaceUri (openpyxl.workbook.smart_tags.SmartTag attribute) Nested (class in openpyxl.descriptors.nested) nested (openpyxl.descriptors.base.Typed attribute) (openpyxl.descriptors.nested.Nested attribute) NestedBool (class in openpyxl.descriptors.nested) NestedBoolText (class in openpyxl.packaging.custom) NestedDateTime (class in openpyxl.packaging.core) NestedFloat (class in openpyxl.descriptors.nested) NestedGapAmount (class in openpyxl.chart.descriptors) NestedInteger (class in openpyxl.descriptors.nested) NestedMinMax (class in openpyxl.descriptors.nested) NestedNoneSet (class in openpyxl.descriptors.nested) NestedOverlap (class in openpyxl.chart.descriptors) NestedSequence (class in openpyxl.descriptors.sequence) NestedSet (class in openpyxl.descriptors.nested) NestedString (class in openpyxl.descriptors.nested) NestedText (class in openpyxl.descriptors.nested)

NestedValue (class in openpyxl.descriptors.nested) noAdjustHandles (openpyxl.drawing.fill.Blip attribute) (openpyxl.drawing.picture.PictureLocking attribute) (openpyxl.drawing.properties.GroupLocking attribute) noAutofit (openpyxl.drawing.text.RichTextProperties attribute) noChangeArrowheads (openpyxl.drawing.fill.Blip attribute) (openpyxl.drawing.picture.PictureLocking attribute) (openpyxl.drawing.properties.GroupLocking attribute) noChangeAspect (openpyxl.drawing.fill.Blip attribute) (openpyxl.drawing.graphic.GraphicFrameLocking attribute) (openpyxl.drawing.picture.PictureLocking attribute) (openpyxl.drawing.properties.GroupLocking attribute) noChangeShapeType (openpyxl.drawing.fill.Blip attribute) (openpyxl.drawing.picture.PictureLocking attribute) (openpyxl.drawing.properties.GroupLocking attribute) noCrop (openpyxl.drawing.picture.PictureLocking attribute) noDrilldown (openpyxl.drawing.graphic.GraphicFrameLocking attribute) noEditPoints (openpyxl.drawing.fill.Blip attribute) (openpyxl.drawing.picture.PictureLocking attribute) (openpyxl.drawing.properties.GroupLocking attribute) noEndCap (openpyxl.chart.error_bar.ErrorBars attribute) noFill (openpyxl.chart.shapes.GraphicalProperties attribute) (openpyxl.drawing.line.LineProperties attribute) (openpyxl.drawing.text.CharacterProperties attribute) noGrp (openpyxl.drawing.fill.Blip attribute) (openpyxl.drawing.graphic.GraphicFrameLocking attribute) (openpyxl.drawing.picture.PictureLocking attribute) (openpyxl.drawing.properties.GroupLocking attribute) noMove (openpyxl.drawing.fill.Blip attribute) (openpyxl.drawing.graphic.GraphicFrameLocking attribute) (openpyxl.drawing.picture.PictureLocking attribute) (openpyxl.drawing.properties.GroupLocking attribute) noMultiLvlLbl (openpyxl.chart.axis.TextAxis attribute) nonAutoSortDefault (openpyxl.pivot.table.PivotField attribute) NoneSet (class in openpyxl.descriptors.base) NonVisualConnectorProperties (class in openpyxl.drawing.connector) NonVisualDrawingProps (class in openpyxl.drawing.properties) NonVisualDrawingShapeProps (class in openpyxl.drawing.properties) NonVisualGraphicFrame (class in openpyxl.drawing.graphic) NonVisualGraphicFrameProperties (class in openpyxl.drawing.graphic) NonVisualGroupDrawingShapeProps (class in openpyxl.drawing.properties) NonVisualGroupShape (class in openpyxl.drawing.properties) NonVisualPictureProperties (class in openpyxl.drawing.picture) nonVisualProperties (openpyxl.drawing.graphic.GroupShape attribute) noProof (openpyxl.drawing.text.CharacterProperties attribute) noResize (openpyxl.drawing.fill.Blip attribute) (openpyxl.drawing.graphic.GraphicFrameLocking attribute) (openpyxl.drawing.picture.PictureLocking attribute) (openpyxl.drawing.properties.GroupLocking attribute) norm (openpyxl.drawing.geometry.Backdrop attribute) normalizeH (openpyxl.drawing.text.CharacterProperties attribute) normAutofit (openpyxl.drawing.text.RichTextProperties attribute) noRot (openpyxl.drawing.fill.Blip attribute) (openpyxl.drawing.picture.PictureLocking attribute) (openpyxl.drawing.properties.GroupLocking attribute) noSelect (openpyxl.drawing.fill.Blip attribute) (openpyxl.drawing.graphic.GraphicFrameLocking attribute) (openpyxl.drawing.picture.PictureLocking attribute) (openpyxl.drawing.properties.GroupLocking attribute) Notes (openpyxl.packaging.extended.ExtendedProperties attribute) noUngrp (openpyxl.drawing.properties.GroupLocking attribute) Number (class in openpyxl.pivot.fields) number_format (openpyxl.cell.read_only.EmptyCell attribute) (openpyxl.cell.read_only.ReadOnlyCell property) (openpyxl.styles.named_styles.NamedStyle attribute) (openpyxl.styles.styleable.StyleableObject attribute) NumberFilter (class in openpyxl.worksheet.filters) NumberFormat (class in openpyxl.styles.numbers) NumberFormatDescriptor (class in openpyxl.chart.descriptors) (class in openpyxl.styles.numbers) (class in openpyxl.styles.styleable) NumberFormatList (class in openpyxl.styles.numbers) numberStoredAsText (openpyxl.worksheet.errors.IgnoredError attribute) NumberValueDescriptor (class in openpyxl.chart.data_source) numCache (openpyxl.chart.data_source.NumRef attribute) numCol (openpyxl.drawing.text.RichTextProperties attribute) NumData (class in openpyxl.chart.data_source) NumDataSource (class in openpyxl.chart.data_source) NumericAxis (class in openpyxl.chart.axis) NumFmt (class in openpyxl.chart.data_source) numFmt (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.NumericAxis attribute) (openpyxl.chart.axis.SeriesAxis attribute) (openpyxl.chart.axis.TextAxis attribute) (openpyxl.chart.label.DataLabel attribute) (openpyxl.chart.label.DataLabelList attribute) (openpyxl.chart.trendline.TrendlineLabel attribute) (openpyxl.styles.differential.DifferentialStyle attribute) (openpyxl.styles.numbers.NumberFormatList attribute) numFmtId (openpyxl.pivot.cache.CacheField attribute) (openpyxl.pivot.table.DataField attribute) (openpyxl.pivot.table.PivotField attribute) (openpyxl.styles.cell_style.CellStyle attribute) (openpyxl.styles.cell_style.StyleArray attribute) (openpyxl.styles.numbers.NumberFormat attribute) (openpyxl.worksheet.scenario.InputCells attribute) numFmts (openpyxl.styles.stylesheet.Stylesheet attribute) numLit (openpyxl.chart.data_source.AxDataSource attribute) (openpyxl.chart.data_source.NumDataSource attribute) NumRef (class in openpyxl.chart.data_source) numRef (openpyxl.chart.data_source.AxDataSource attribute) (openpyxl.chart.data_source.NumDataSource attribute) NumVal (class in openpyxl.chart.data_source) nvCxnSpPr (openpyxl.drawing.connector.ConnectorShape attribute) nvGraphicFramePr (openpyxl.drawing.graphic.GraphicFrame attribute) nvGrpSpPr (openpyxl.drawing.graphic.GroupShape attribute) nvPicPr (openpyxl.drawing.picture.PictureFrame attribute) nvSpPr (openpyxl.drawing.connector.Shape attribute)

O

ObjectAnchor (class in openpyxl.worksheet.ole) ObjectPr (class in openpyxl.worksheet.ole) objectPr (openpyxl.worksheet.ole.OleObject attribute) objects (openpyxl.chartsheet.protection.ChartsheetProtection attribute) (openpyxl.worksheet.protection.SheetProtection attribute) oddFooter (openpyxl.worksheet.header_footer.HeaderFooter attribute) oddHeader (openpyxl.worksheet.header_footer.HeaderFooter attribute) off (openpyxl.drawing.geometry.GroupTransform2D attribute) (openpyxl.drawing.geometry.Transform2D attribute) (openpyxl.drawing.xdr.XDRTransform2D attribute) offset (openpyxl.pivot.table.PivotArea attribute) offset() (openpyxl.cell.cell.Cell method) ofPieChart (openpyxl.chart.plotarea.PlotArea attribute) ofPieType (openpyxl.chart.pie_chart.ProjectedPieChart attribute) OLAPKPI (class in openpyxl.pivot.cache) OLAPSet (class in openpyxl.pivot.cache) OleObject (class in openpyxl.worksheet.ole) oleObject (openpyxl.worksheet.ole.OleObjects attribute) OleObjects (class in openpyxl.worksheet.ole) oleSize (openpyxl.packaging.workbook.WorkbookPackage attribute) oleUpdate (openpyxl.worksheet.ole.OleObject attribute) OneCellAnchor (class in openpyxl.drawing.spreadsheet_drawing) oneCellAnchor (openpyxl.drawing.spreadsheet_drawing.SpreadsheetDrawing attribute) oneField (openpyxl.pivot.cache.CacheHierarchy attribute) onlySync (openpyxl.workbook.views.CustomWorkbookView attribute) openpyxl module openpyxl.cell module openpyxl.cell.cell module openpyxl.cell.read_only module openpyxl.cell.rich_text module openpyxl.cell.text module openpyxl.chart module openpyxl.chart.area_chart module openpyxl.chart.axis module openpyxl.chart.bar_chart module openpyxl.chart.bubble_chart module openpyxl.chart.chartspace module openpyxl.chart.data_source module openpyxl.chart.descriptors module openpyxl.chart.error_bar module openpyxl.chart.label module openpyxl.chart.layout module openpyxl.chart.legend module openpyxl.chart.line_chart module openpyxl.chart.marker module openpyxl.chart.picture module openpyxl.chart.pie_chart module openpyxl.chart.pivot module openpyxl.chart.plotarea module openpyxl.chart.print_settings module openpyxl.chart.radar_chart module openpyxl.chart.reader module openpyxl.chart.reference module openpyxl.chart.scatter_chart module openpyxl.chart.series module openpyxl.chart.series_factory module openpyxl.chart.shapes module openpyxl.chart.stock_chart module openpyxl.chart.surface_chart module openpyxl.chart.text module openpyxl.chart.title module openpyxl.chart.trendline module openpyxl.chart.updown_bars module openpyxl.chartsheet module openpyxl.chartsheet.chartsheet module openpyxl.chartsheet.custom module openpyxl.chartsheet.properties module openpyxl.chartsheet.protection module openpyxl.chartsheet.publish module openpyxl.chartsheet.relation module openpyxl.chartsheet.views module openpyxl.comments module openpyxl.comments.author module openpyxl.comments.comment_sheet module openpyxl.comments.comments module openpyxl.comments.shape_writer module openpyxl.descriptors module openpyxl.descriptors.base module openpyxl.descriptors.container module openpyxl.descriptors.excel module openpyxl.descriptors.namespace module openpyxl.descriptors.nested module openpyxl.descriptors.sequence module openpyxl.descriptors.serialisable module openpyxl.drawing module openpyxl.drawing.colors module openpyxl.drawing.connector module openpyxl.drawing.drawing module openpyxl.drawing.effect module openpyxl.drawing.fill module openpyxl.drawing.geometry module openpyxl.drawing.graphic module openpyxl.drawing.image module openpyxl.drawing.line module openpyxl.drawing.picture module openpyxl.drawing.properties module openpyxl.drawing.relation module openpyxl.drawing.spreadsheet_drawing module openpyxl.drawing.text module openpyxl.drawing.xdr module openpyxl.formatting module openpyxl.formatting.formatting module openpyxl.formatting.rule module openpyxl.packaging module openpyxl.packaging.core module openpyxl.packaging.custom module openpyxl.packaging.extended module openpyxl.packaging.interface module openpyxl.packaging.manifest module openpyxl.packaging.relationship module openpyxl.packaging.workbook module openpyxl.pivot module openpyxl.pivot.cache module

openpyxl.pivot.fields module openpyxl.pivot.record module openpyxl.pivot.table module openpyxl.reader module openpyxl.reader.drawings module openpyxl.reader.excel module openpyxl.reader.strings module openpyxl.reader.workbook module openpyxl.styles module openpyxl.styles.alignment module openpyxl.styles.borders module openpyxl.styles.builtins module openpyxl.styles.cell_style module openpyxl.styles.colors module openpyxl.styles.differential module openpyxl.styles.fills module openpyxl.styles.fonts module openpyxl.styles.named_styles module openpyxl.styles.numbers module openpyxl.styles.protection module openpyxl.styles.proxy module openpyxl.styles.styleable module openpyxl.styles.stylesheet module openpyxl.styles.table module openpyxl.utils module openpyxl.utils.bound_dictionary module openpyxl.utils.cell module openpyxl.utils.dataframe module openpyxl.utils.datetime module openpyxl.utils.escape module openpyxl.utils.exceptions module openpyxl.utils.indexed_list module openpyxl.utils.inference module openpyxl.utils.protection module openpyxl.utils.units module openpyxl.workbook module openpyxl.workbook.child module openpyxl.workbook.defined_name module openpyxl.workbook.external_link module openpyxl.workbook.external_link.external module openpyxl.workbook.external_reference module openpyxl.workbook.function_group module openpyxl.workbook.properties module openpyxl.workbook.protection module openpyxl.workbook.smart_tags module openpyxl.workbook.views module openpyxl.workbook.web module openpyxl.workbook.workbook module openpyxl.worksheet module openpyxl.worksheet.cell_range module openpyxl.worksheet.cell_watch module openpyxl.worksheet.controls module openpyxl.worksheet.copier module openpyxl.worksheet.custom module openpyxl.worksheet.datavalidation module openpyxl.worksheet.dimensions module openpyxl.worksheet.drawing module openpyxl.worksheet.errors module openpyxl.worksheet.filters module openpyxl.worksheet.formula module openpyxl.worksheet.header_footer module openpyxl.worksheet.hyperlink module openpyxl.worksheet.merge module openpyxl.worksheet.ole module openpyxl.worksheet.page module openpyxl.worksheet.pagebreak module openpyxl.worksheet.picture module openpyxl.worksheet.print_settings module openpyxl.worksheet.properties module openpyxl.worksheet.protection module openpyxl.worksheet.related module openpyxl.worksheet.scenario module openpyxl.worksheet.smart_tag module openpyxl.worksheet.table module openpyxl.worksheet.views module openpyxl.worksheet.worksheet module openpyxl.writer module openpyxl.writer.excel module openpyxl.writer.theme module openpyxl.xml module openpyxl.xml.constants module openpyxl.xml.functions module operator (openpyxl.formatting.rule.Rule attribute) (openpyxl.worksheet.datavalidation.DataValidation attribute) (openpyxl.worksheet.filters.BlankFilter property) (openpyxl.worksheet.filters.CustomFilter attribute) (openpyxl.worksheet.filters.NumberFilter attribute) (openpyxl.worksheet.filters.StringFilter attribute) optimizeMemory (openpyxl.pivot.cache.CacheDefinition attribute) order (openpyxl.chart.series.Series attribute) (openpyxl.chart.series.XYSeries attribute) (openpyxl.chart.trendline.Trendline attribute) orientation (openpyxl.chart.axis.Scaling attribute) (openpyxl.worksheet.page.PrintPageSetup attribute) ORIENTATION_LANDSCAPE (openpyxl.worksheet.worksheet.Worksheet attribute) ORIENTATION_PORTRAIT (openpyxl.worksheet.worksheet.Worksheet attribute) OuterShadow (class in openpyxl.drawing.effect) outerShdw (openpyxl.drawing.effect.EffectList attribute) Outline (class in openpyxl.worksheet.properties) outline (openpyxl.cell.text.InlineFont attribute) (openpyxl.pivot.table.PivotArea attribute) (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.PivotHierarchy attribute) (openpyxl.pivot.table.TableDefinition attribute) (openpyxl.styles.borders.Border attribute) (openpyxl.styles.fonts.Font attribute) outline_level (openpyxl.worksheet.dimensions.Dimension attribute) outlineData (openpyxl.pivot.table.TableDefinition attribute) outlineLevel (openpyxl.worksheet.dimensions.Dimension attribute) outlineLevelCol (openpyxl.worksheet.dimensions.SheetFormatProperties attribute) outlineLevelRow (openpyxl.worksheet.dimensions.SheetFormatProperties attribute) outlinePr (openpyxl.worksheet.properties.WorksheetProperties attribute) overlap (openpyxl.chart.bar_chart.BarChart attribute) overlay (openpyxl.chart.legend.Legend attribute) (openpyxl.chart.title.Title attribute) Override (class in openpyxl.packaging.manifest) (openpyxl.packaging.manifest.Manifest attribute)

P

p (openpyxl.chart.text.RichText attribute) PageBreak (in module openpyxl.worksheet.pagebreak) PageField (class in openpyxl.pivot.table) pageFields (openpyxl.pivot.table.TableDefinition attribute) PageItem (class in openpyxl.pivot.cache) PageMargins (class in openpyxl.chart.print_settings) (class in openpyxl.worksheet.page) pageMargins (openpyxl.chart.print_settings.PrintSettings attribute) (openpyxl.chartsheet.chartsheet.Chartsheet attribute) (openpyxl.chartsheet.custom.CustomChartsheetView attribute) pageOrder (openpyxl.worksheet.page.PrintPageSetup attribute) pageOverThenDown (openpyxl.pivot.table.TableDefinition attribute) Pages (openpyxl.packaging.extended.ExtendedProperties attribute) pages (openpyxl.pivot.cache.Consolidation attribute) pageSetup (openpyxl.chart.print_settings.PrintSettings attribute) (openpyxl.chartsheet.chartsheet.Chartsheet attribute) (openpyxl.chartsheet.custom.CustomChartsheetView attribute) pageSetUpPr (openpyxl.worksheet.properties.WorksheetProperties attribute) PageSetupProperties (class in openpyxl.worksheet.properties) pageStyle (openpyxl.pivot.table.TableDefinition attribute) pageWrap (openpyxl.pivot.table.TableDefinition attribute) Pane (class in openpyxl.worksheet.views) pane (openpyxl.worksheet.views.Selection attribute) (openpyxl.worksheet.views.SheetView attribute) panose (openpyxl.drawing.text.Font attribute) paperHeight (openpyxl.worksheet.page.PrintPageSetup attribute) paperSize (openpyxl.worksheet.page.PrintPageSetup attribute) PAPERSIZE_A3 (openpyxl.worksheet.worksheet.Worksheet attribute) PAPERSIZE_A4 (openpyxl.worksheet.worksheet.Worksheet attribute) PAPERSIZE_A4_SMALL (openpyxl.worksheet.worksheet.Worksheet attribute) PAPERSIZE_A5 (openpyxl.worksheet.worksheet.Worksheet attribute) PAPERSIZE_EXECUTIVE (openpyxl.worksheet.worksheet.Worksheet attribute) PAPERSIZE_LEDGER (openpyxl.worksheet.worksheet.Worksheet attribute) PAPERSIZE_LEGAL (openpyxl.worksheet.worksheet.Worksheet attribute) PAPERSIZE_LETTER (openpyxl.worksheet.worksheet.Worksheet attribute) PAPERSIZE_LETTER_SMALL (openpyxl.worksheet.worksheet.Worksheet attribute) PAPERSIZE_STATEMENT (openpyxl.worksheet.worksheet.Worksheet attribute) PAPERSIZE_TABLOID (openpyxl.worksheet.worksheet.Worksheet attribute) paperWidth (openpyxl.worksheet.page.PrintPageSetup attribute) par (openpyxl.pivot.cache.FieldGroup attribute) Paragraph (class in openpyxl.drawing.text) ParagraphProperties (class in openpyxl.drawing.text) paragraphs (openpyxl.chart.text.RichText attribute) Paragraphs (openpyxl.packaging.extended.ExtendedProperties attribute) parent (openpyxl.cell.cell.Cell attribute) (openpyxl.cell.read_only.ReadOnlyCell attribute) (openpyxl.comments.comments.Comment property) (openpyxl.pivot.cache.CalculatedMember attribute) (openpyxl.pivot.cache.OLAPKPI attribute) (openpyxl.styles.styleable.StyleableObject attribute) (openpyxl.worksheet.dimensions.ColumnDimension attribute) (openpyxl.worksheet.dimensions.Dimension attribute) (openpyxl.worksheet.dimensions.RowDimension attribute) parentSet (openpyxl.pivot.cache.CacheHierarchy attribute) parse() (openpyxl.reader.workbook.WorkbookParser method) PartName (openpyxl.drawing.spreadsheet_drawing.SpreadsheetDrawing attribute) (openpyxl.packaging.manifest.Override attribute) path (openpyxl.comments.comment_sheet.CommentSheet property) (openpyxl.drawing.fill.GradientFillProperties attribute) (openpyxl.drawing.fill.PathShadeProperties attribute) (openpyxl.drawing.geometry.Path2DList attribute) (openpyxl.drawing.image.Image property) (openpyxl.drawing.spreadsheet_drawing.SpreadsheetDrawing property) (openpyxl.packaging.manifest.Manifest attribute) (openpyxl.pivot.cache.CacheDefinition property) (openpyxl.pivot.record.RecordList property) (openpyxl.pivot.table.TableDefinition property) (openpyxl.workbook.external_link.external.ExternalLink property) (openpyxl.workbook.workbook.Workbook attribute) (openpyxl.worksheet.table.Table property) Path2D (class in openpyxl.drawing.geometry) Path2DList (class in openpyxl.drawing.geometry) pathLst (openpyxl.drawing.geometry.CustomGeometry2D attribute) PathShadeProperties (class in openpyxl.drawing.fill) pattern (openpyxl.descriptors.excel.Base64Binary attribute) (openpyxl.descriptors.excel.CellRange attribute) (openpyxl.descriptors.excel.Guid attribute) (openpyxl.descriptors.excel.HexBinary attribute) (openpyxl.descriptors.excel.Percentage attribute) (openpyxl.descriptors.excel.UniversalMeasure attribute) PatternFill (class in openpyxl.styles.fills) PatternFillProperties (class in openpyxl.drawing.fill) patternType (openpyxl.styles.fills.PatternFill attribute) pattFill (openpyxl.chart.shapes.GraphicalProperties attribute) (openpyxl.drawing.line.LineProperties attribute) (openpyxl.drawing.text.CharacterProperties attribute) PCDSDTCEntries (class in openpyxl.pivot.cache) percent (openpyxl.formatting.rule.IconSet attribute) (openpyxl.formatting.rule.Rule attribute) (openpyxl.worksheet.filters.Top10 attribute) Percentage (class in openpyxl.descriptors.excel) period (openpyxl.chart.trendline.Trendline attribute) personalView (openpyxl.workbook.views.CustomWorkbookView attribute) phonetic (openpyxl.cell.text.Text attribute) phoneticPr (openpyxl.cell.text.Text attribute) PhoneticProperties (class in openpyxl.cell.text) (openpyxl.cell.text.Text attribute) PhoneticText (class in openpyxl.cell.text) pic (openpyxl.drawing.graphic.GroupShape attribute) (openpyxl.drawing.spreadsheet_drawing.AbsoluteAnchor attribute) (openpyxl.drawing.spreadsheet_drawing.OneCellAnchor attribute) (openpyxl.drawing.spreadsheet_drawing.TwoCellAnchor attribute) picLocks (openpyxl.drawing.picture.NonVisualPictureProperties attribute) picture (openpyxl.chartsheet.chartsheet.Chartsheet attribute) pictureFormat (openpyxl.chart.picture.PictureOptions attribute) PictureFrame (class in openpyxl.drawing.picture) PictureLocking (class in openpyxl.drawing.picture) PictureNonVisual (class in openpyxl.drawing.picture) PictureOptions (class in openpyxl.chart.picture) pictureOptions (openpyxl.chart.marker.DataPoint attribute) (openpyxl.chart.series.Series attribute) pictureStackUnit (openpyxl.chart.picture.PictureOptions attribute) pie3DChart (openpyxl.chart.plotarea.PlotArea attribute) PieChart (class in openpyxl.chart.pie_chart) pieChart (openpyxl.chart.plotarea.PlotArea attribute) PieChart3D (class in openpyxl.chart.pie_chart) pitchFamily (openpyxl.drawing.text.Font attribute) pivot (openpyxl.formatting.formatting.ConditionalFormatting attribute) (openpyxl.styles.table.TableStyle attribute) pivot_caches (openpyxl.reader.workbook.WorkbookParser property) PivotArea (class in openpyxl.pivot.table)

pivotArea (openpyxl.pivot.cache.CalculatedItem attribute) (openpyxl.pivot.table.AutoSortScope attribute) (openpyxl.pivot.table.ChartFormat attribute) (openpyxl.pivot.table.Format attribute) pivotAreas (openpyxl.pivot.table.ConditionalFormat attribute) pivotButton (openpyxl.styles.cell_style.CellStyle attribute) (openpyxl.styles.cell_style.StyleArray attribute) (openpyxl.styles.styleable.StyleableObject attribute) PivotCache (class in openpyxl.packaging.workbook) pivotCaches (openpyxl.packaging.workbook.WorkbookPackage attribute) PivotDimension (class in openpyxl.pivot.cache) PivotField (class in openpyxl.pivot.table) pivotFields (openpyxl.pivot.table.TableDefinition attribute) PivotFilter (class in openpyxl.pivot.table) PivotFilters (class in openpyxl.pivot.table) pivotFmts (openpyxl.chart.chartspace.ChartContainer attribute) PivotFormat (class in openpyxl.chart.pivot) pivotHierarchies (openpyxl.pivot.table.TableDefinition attribute) PivotHierarchy (class in openpyxl.pivot.table) PivotSource (class in openpyxl.chart.pivot) pivotSource (openpyxl.chart.chartspace.ChartSpace attribute) pivotTables (openpyxl.worksheet.protection.SheetProtection attribute) PivotTableStyle (class in openpyxl.pivot.table) pivotTableStyle (openpyxl.pivot.table.TableDefinition attribute) pivotTableStyleInfo (openpyxl.pivot.table.TableDefinition attribute) pixels_to_EMU() (in module openpyxl.utils.units) pixels_to_points() (in module openpyxl.utils.units) plain (openpyxl.cell.text.Text attribute) pLen (openpyxl.pivot.table.MemberProperty attribute) PlotArea (class in openpyxl.chart.plotarea) plotArea (openpyxl.chart.chartspace.ChartContainer attribute) plotVisOnly (openpyxl.chart.chartspace.ChartContainer attribute) plus (openpyxl.chart.error_bar.ErrorBars attribute) Point2D (class in openpyxl.drawing.geometry) Point3D (class in openpyxl.drawing.geometry) points_to_pixels() (in module openpyxl.utils.units) pop() (openpyxl.chart.reference.Reference method) pos (openpyxl.drawing.fill.GradientStop attribute) (openpyxl.drawing.geometry.ConnectionSite attribute) (openpyxl.drawing.spreadsheet_drawing.AbsoluteAnchor attribute) (openpyxl.drawing.text.TabStop attribute) position (openpyxl.chart.legend.Legend attribute) (openpyxl.styles.fills.Stop attribute) PositiveSize2D (class in openpyxl.drawing.geometry) pPos (openpyxl.pivot.table.MemberProperty attribute) pPr (openpyxl.drawing.text.Paragraph attribute) (openpyxl.drawing.text.TextField attribute) preferRelativeResize (openpyxl.drawing.picture.NonVisualPictureProperties attribute) PresentationFormat (openpyxl.packaging.extended.ExtendedProperties attribute) preserveFormatting (openpyxl.pivot.table.TableDefinition attribute) preset (openpyxl.drawing.fill.PatternFillProperties attribute) PresetGeometry2D (class in openpyxl.drawing.geometry) PresetShadowEffect (class in openpyxl.drawing.effect) PresetTextShape (class in openpyxl.drawing.text) print_area (openpyxl.worksheet.worksheet.Worksheet property) print_title_cols (openpyxl.worksheet.worksheet.Worksheet property) print_title_rows (openpyxl.worksheet.worksheet.Worksheet property) print_titles (openpyxl.worksheet.worksheet.Worksheet property) PrintArea (class in openpyxl.worksheet.print_settings) printDrill (openpyxl.pivot.table.TableDefinition attribute) PrintOptions (class in openpyxl.worksheet.page) PrintPageSetup (class in openpyxl.worksheet.page) PrintSettings (class in openpyxl.chart.print_settings) printSettings (openpyxl.chart.chartspace.ChartSpace attribute) PrintTitles (class in openpyxl.worksheet.print_settings) priority (openpyxl.formatting.rule.Rule attribute) (openpyxl.pivot.table.ConditionalFormat attribute) productSubtotal (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.Reference attribute) progId (openpyxl.worksheet.ole.OleObject attribute) ProjectedPieChart (class in openpyxl.chart.pie_chart) prompt (openpyxl.worksheet.datavalidation.DataValidation attribute) promptedSolutions (openpyxl.workbook.properties.WorkbookProperties attribute) promptTitle (openpyxl.worksheet.datavalidation.DataValidation attribute) Properties (class in openpyxl.comments.comment_sheet) properties (openpyxl.chart.text.RichText attribute) (openpyxl.drawing.text.Paragraph attribute) (openpyxl.drawing.text.RegularTextRun attribute) (openpyxl.packaging.workbook.WorkbookPackage attribute) propertyName (openpyxl.pivot.cache.CacheField attribute) props (openpyxl.packaging.custom.CustomPropertyList attribute) Protection (class in openpyxl.chart.chartspace) (class in openpyxl.styles.protection) protection (openpyxl.cell.read_only.ReadOnlyCell property) (openpyxl.chart.chartspace.ChartSpace attribute) (openpyxl.styles.cell_style.CellStyle attribute) (openpyxl.styles.cell_style.CellStyleList attribute) (openpyxl.styles.differential.DifferentialStyle attribute) (openpyxl.styles.named_styles.NamedStyle attribute) (openpyxl.styles.styleable.StyleableObject attribute) protectionId (openpyxl.styles.cell_style.StyleArray attribute) prst (openpyxl.drawing.effect.PresetShadowEffect attribute) (openpyxl.drawing.fill.PatternFillProperties attribute) (openpyxl.drawing.geometry.Bevel attribute) (openpyxl.drawing.geometry.Camera attribute) (openpyxl.drawing.geometry.PresetGeometry2D attribute) (openpyxl.drawing.text.PresetTextShape attribute) prstClr (openpyxl.drawing.colors.ColorChoice attribute) (openpyxl.drawing.effect.GlowEffect attribute) (openpyxl.drawing.effect.InnerShadowEffect attribute) (openpyxl.drawing.effect.OuterShadow attribute) (openpyxl.drawing.effect.PresetShadowEffect attribute) (openpyxl.drawing.fill.GradientStop attribute) (openpyxl.drawing.fill.SolidColorFillProperties attribute) prstDash (openpyxl.drawing.line.LineProperties attribute) prstGeom (openpyxl.chart.shapes.GraphicalProperties attribute) prstMaterial (openpyxl.drawing.geometry.Shape3D attribute) prstShdw (openpyxl.drawing.effect.EffectList attribute) prstTxWarp (openpyxl.drawing.text.RichTextProperties attribute) pt (openpyxl.chart.data_source.Level attribute) (openpyxl.chart.data_source.NumData attribute) (openpyxl.chart.data_source.StrData attribute) (openpyxl.worksheet.pagebreak.Break attribute) ptCount (openpyxl.chart.data_source.MultiLevelStrData attribute) (openpyxl.chart.data_source.NumData attribute) (openpyxl.chart.data_source.StrData attribute) published (openpyxl.chartsheet.properties.ChartsheetProperties attribute) (openpyxl.pivot.table.TableDefinition attribute) (openpyxl.worksheet.properties.WorksheetProperties attribute) (openpyxl.worksheet.table.Table attribute) publishItems (openpyxl.workbook.properties.WorkbookProperties attribute) publishToServer (openpyxl.workbook.defined_name.DefinedName attribute)

Q

QualifiedDateTime (class in openpyxl.packaging.core) Query (class in openpyxl.pivot.cache) queryCache (openpyxl.pivot.cache.TupleCache attribute) queryFailed (openpyxl.pivot.cache.OLAPSet attribute)

queryTableFieldId (openpyxl.worksheet.table.TableColumn attribute) quote_sheetname() (in module openpyxl.utils.cell) quotePrefix (openpyxl.styles.cell_style.CellStyle attribute) (openpyxl.styles.cell_style.StyleArray attribute) (openpyxl.styles.styleable.StyleableObject attribute)

R

r (openpyxl.cell.text.Text attribute) (openpyxl.chart.print_settings.PageMargins attribute) (openpyxl.drawing.colors.RGBPercent attribute) (openpyxl.drawing.fill.RelativeRect attribute) (openpyxl.drawing.geometry.GeomRect attribute) (openpyxl.drawing.text.Paragraph attribute) (openpyxl.pivot.record.RecordList attribute) (openpyxl.pivot.table.RowColItem attribute) (openpyxl.workbook.external_link.external.ExternalCell attribute) (openpyxl.workbook.external_link.external.ExternalRow attribute) (openpyxl.worksheet.cell_watch.CellWatch attribute) (openpyxl.worksheet.dimensions.RowDimension attribute) (openpyxl.worksheet.scenario.InputCells attribute) (openpyxl.worksheet.smart_tag.CellSmartTags attribute) rad (openpyxl.drawing.effect.BlurEffect attribute) (openpyxl.drawing.effect.GlowEffect attribute) (openpyxl.drawing.effect.SoftEdgesEffect attribute) RadarChart (class in openpyxl.chart.radar_chart) radarChart (openpyxl.chart.plotarea.PlotArea attribute) radarStyle (openpyxl.chart.radar_chart.RadarChart attribute) range (openpyxl.worksheet.dimensions.ColumnDimension property) range_boundaries() (in module openpyxl.utils.cell) range_string (openpyxl.chart.reference.Reference attribute) range_to_tuple() (in module openpyxl.utils.cell) RangePr (class in openpyxl.pivot.cache) rangePr (openpyxl.pivot.cache.FieldGroup attribute) ranges (openpyxl.worksheet.cell_range.MultiCellRange attribute) (openpyxl.worksheet.datavalidation.DataValidation attribute) RangeSet (class in openpyxl.pivot.cache) rangeSets (openpyxl.pivot.cache.Consolidation attribute) rank (openpyxl.formatting.rule.Rule attribute) rankBy (openpyxl.pivot.table.PivotField attribute) read() (openpyxl.reader.excel.ExcelReader method) read_chart() (in module openpyxl.chart.reader) read_chartsheet() (openpyxl.reader.excel.ExcelReader method) read_custom() (openpyxl.reader.excel.ExcelReader method) read_external_link() (in module openpyxl.workbook.external_link.external) read_manifest() (openpyxl.reader.excel.ExcelReader method) read_only (openpyxl.workbook.workbook.Workbook property) read_properties() (openpyxl.reader.excel.ExcelReader method) read_rich_text() (in module openpyxl.reader.strings) read_string_table() (in module openpyxl.reader.strings) read_strings() (openpyxl.reader.excel.ExcelReader method) read_theme() (openpyxl.reader.excel.ExcelReader method) read_workbook() (openpyxl.reader.excel.ExcelReader method) read_worksheets() (openpyxl.reader.excel.ExcelReader method) readingOrder (openpyxl.styles.alignment.Alignment attribute) ReadOnlyCell (class in openpyxl.cell.read_only) readOnlyRecommended (openpyxl.workbook.protection.FileSharing attribute) ReadOnlyWorkbookException recalcAlways (openpyxl.worksheet.controls.ControlProperty attribute) Record (class in openpyxl.pivot.record) recordCount (openpyxl.pivot.cache.CacheDefinition attribute) RecordList (class in openpyxl.pivot.record) records (openpyxl.pivot.cache.CacheDefinition attribute) red (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) redMod (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) redOff (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) ref (openpyxl.chart.data_source.NumRef attribute) (openpyxl.comments.comment_sheet.CommentRecord attribute) (openpyxl.pivot.cache.RangeSet attribute) (openpyxl.pivot.cache.WorksheetSource attribute) (openpyxl.pivot.table.Location attribute) (openpyxl.worksheet.dimensions.SheetDimension attribute) (openpyxl.worksheet.filters.AutoFilter attribute) (openpyxl.worksheet.filters.SortCondition attribute) (openpyxl.worksheet.filters.SortState attribute) (openpyxl.worksheet.hyperlink.Hyperlink attribute) (openpyxl.worksheet.merge.MergeCell property) (openpyxl.worksheet.table.Table attribute) Reference (class in openpyxl.chart.reference) (class in openpyxl.pivot.table) references (openpyxl.pivot.table.PivotArea attribute) refersTo (openpyxl.workbook.external_link.external.ExternalDefinedName attribute) reflection (openpyxl.drawing.effect.EffectList attribute) ReflectionEffect (class in openpyxl.drawing.effect) refMode (openpyxl.workbook.properties.CalcProperties attribute) refreshAllConnections (openpyxl.workbook.properties.WorkbookProperties attribute) refreshedBy (openpyxl.pivot.cache.CacheDefinition attribute) refreshedDate (openpyxl.pivot.cache.CacheDefinition attribute) refreshedDateIso (openpyxl.pivot.cache.CacheDefinition attribute) refreshedVersion (openpyxl.pivot.cache.CacheDefinition attribute) refreshError (openpyxl.workbook.external_link.external.ExternalSheetData attribute) refreshOnLoad (openpyxl.pivot.cache.CacheDefinition attribute) RegularTextRun (class in openpyxl.drawing.text) reindex() (openpyxl.worksheet.dimensions.ColumnDimension method) rel_type (openpyxl.pivot.cache.CacheDefinition attribute) (openpyxl.pivot.record.RecordList attribute) (openpyxl.pivot.table.TableDefinition attribute) Related (class in openpyxl.worksheet.related) Relation (class in openpyxl.descriptors.excel) Relationship (class in openpyxl.packaging.relationship) RelationshipList (class in openpyxl.packaging.relationship) relative (openpyxl.pivot.table.Reference attribute) relativeIndent (openpyxl.styles.alignment.Alignment attribute) RelativeRect (class in openpyxl.drawing.fill) rels (openpyxl.reader.workbook.WorkbookParser property) remove() (openpyxl.workbook.workbook.Workbook method) (openpyxl.worksheet.cell_range.MultiCellRange method)

remove_sheet() (openpyxl.workbook.workbook.Workbook method) repairLoad (openpyxl.packaging.workbook.FileRecoveryProperties attribute) reservationPassword (openpyxl.workbook.protection.FileSharing attribute) rev (openpyxl.drawing.geometry.SphereCoords attribute) reverse (openpyxl.formatting.rule.IconSet attribute) revision (openpyxl.packaging.core.DocumentProperties attribute) revision_password (openpyxl.workbook.protection.WorkbookProtection property) revisionsAlgorithmName (openpyxl.workbook.protection.WorkbookProtection attribute) revisionsHashValue (openpyxl.workbook.protection.WorkbookProtection attribute) revisionsPassword (openpyxl.workbook.protection.WorkbookProtection property) revisionsPasswordCharacterSet (openpyxl.workbook.protection.WorkbookProtection attribute) revisionsSaltValue (openpyxl.workbook.protection.WorkbookProtection attribute) revisionsSpinCount (openpyxl.workbook.protection.WorkbookProtection attribute) rfe (openpyxl.chartsheet.relation.DrawingHF attribute) rff (openpyxl.chartsheet.relation.DrawingHF attribute) rfo (openpyxl.chartsheet.relation.DrawingHF attribute) rFont (openpyxl.cell.text.InlineFont attribute) RGB (class in openpyxl.styles.colors) (openpyxl.drawing.colors.ColorChoice attribute) (openpyxl.drawing.fill.GradientStop attribute) (openpyxl.drawing.fill.SolidColorFillProperties attribute) rgb (openpyxl.styles.colors.Color attribute) (openpyxl.styles.colors.RgbColor attribute) RgbColor (class in openpyxl.styles.colors) RGBPercent (class in openpyxl.drawing.colors) (openpyxl.drawing.colors.ColorChoice attribute) (openpyxl.drawing.fill.GradientStop attribute) (openpyxl.drawing.fill.SolidColorFillProperties attribute) rhe (openpyxl.chartsheet.relation.DrawingHF attribute) rhf (openpyxl.chartsheet.relation.DrawingHF attribute) rho (openpyxl.chartsheet.relation.DrawingHF attribute) rich (openpyxl.chart.text.Text attribute) RichText (class in openpyxl.cell.text) (class in openpyxl.chart.text) RichTextProperties (class in openpyxl.drawing.text) rig (openpyxl.drawing.geometry.LightRig attribute) right (openpyxl.chart.print_settings.PageMargins attribute) (openpyxl.drawing.fill.RelativeRect attribute) (openpyxl.styles.borders.Border attribute) (openpyxl.styles.fills.GradientFill attribute) (openpyxl.worksheet.cell_range.CellRange property) (openpyxl.worksheet.header_footer.HeaderFooterItem attribute) (openpyxl.worksheet.page.PageMargins attribute) rightFooterEvenPages (openpyxl.chartsheet.relation.DrawingHF attribute) rightFooterFirstPage (openpyxl.chartsheet.relation.DrawingHF attribute) rightFooterOddPages (openpyxl.chartsheet.relation.DrawingHF attribute) rightHeaderEvenPages (openpyxl.chartsheet.relation.DrawingHF attribute) rightHeaderFirstPage (openpyxl.chartsheet.relation.DrawingHF attribute) rightHeaderOddPages (openpyxl.chartsheet.relation.DrawingHF attribute) rightToLeft (openpyxl.worksheet.views.SheetView attribute) rIns (openpyxl.drawing.text.RichTextProperties attribute) rot (openpyxl.drawing.geometry.Camera attribute) (openpyxl.drawing.geometry.GroupTransform2D attribute) (openpyxl.drawing.geometry.LightRig attribute) (openpyxl.drawing.geometry.Transform2D attribute) (openpyxl.drawing.text.RichTextProperties attribute) (openpyxl.drawing.xdr.XDRTransform2D attribute) rotWithShape (openpyxl.drawing.effect.OuterShadow attribute) (openpyxl.drawing.effect.ReflectionEffect attribute) (openpyxl.drawing.fill.BlipFillProperties attribute) (openpyxl.drawing.fill.GradientFillProperties attribute) round (openpyxl.drawing.line.LineProperties attribute) roundedCorners (openpyxl.chart.chartspace.ChartSpace attribute) row (openpyxl.cell.cell.Cell attribute) (openpyxl.cell.cell.MergedCell attribute) (openpyxl.cell.read_only.ReadOnlyCell attribute) (openpyxl.drawing.spreadsheet_drawing.AnchorMarker attribute) (openpyxl.workbook.external_link.external.ExternalSheetData attribute) RowBreak (class in openpyxl.worksheet.pagebreak) RowColField (class in openpyxl.pivot.table) RowColItem (class in openpyxl.pivot.table) RowDimension (class in openpyxl.worksheet.dimensions) rowFields (openpyxl.pivot.table.TableDefinition attribute) rowGrandTotals (openpyxl.pivot.table.TableDefinition attribute) rowHeaderCaption (openpyxl.pivot.table.TableDefinition attribute) rowHidden (openpyxl.comments.comment_sheet.Properties attribute) RowHierarchiesUsage (class in openpyxl.pivot.table) rowHierarchiesUsage (openpyxl.pivot.table.TableDefinition attribute) rowHierarchyUsage (openpyxl.pivot.table.RowHierarchiesUsage attribute) rowItems (openpyxl.pivot.table.TableDefinition attribute) rowOff (openpyxl.drawing.spreadsheet_drawing.AnchorMarker attribute) rowPageCount (openpyxl.pivot.table.Location attribute) RowRange (class in openpyxl.worksheet.print_settings) rows (openpyxl.chart.reference.Reference property) (openpyxl.worksheet.cell_range.CellRange property) (openpyxl.worksheet.print_settings.PrintTitles attribute) (openpyxl.worksheet.worksheet.Worksheet property) rows_from_range() (in module openpyxl.utils.cell) rPh (openpyxl.cell.text.Text attribute) rPr (openpyxl.cell.text.RichText attribute) (openpyxl.drawing.text.LineBreak attribute) (openpyxl.drawing.text.RegularTextRun attribute) (openpyxl.drawing.text.TextField attribute) rtl (openpyxl.drawing.text.CharacterProperties attribute) (openpyxl.drawing.text.ParagraphProperties attribute) rtlCol (openpyxl.drawing.text.RichTextProperties attribute) Rule (class in openpyxl.formatting.rule) rules (openpyxl.formatting.formatting.ConditionalFormatting attribute) RuleType (class in openpyxl.formatting.rule) rupBuild (openpyxl.workbook.properties.FileVersion attribute)

S

s (openpyxl.pivot.cache.GroupItems attribute) (openpyxl.pivot.cache.PCDSDTCEntries attribute) (openpyxl.pivot.cache.SharedItems attribute) (openpyxl.pivot.record.Record attribute) (openpyxl.pivot.table.FieldItem attribute) (openpyxl.worksheet.dimensions.RowDimension property) saltValue (openpyxl.chartsheet.protection.ChartsheetProtection attribute) (openpyxl.workbook.protection.FileSharing attribute) (openpyxl.worksheet.protection.SheetProtection attribute) sat (openpyxl.drawing.colors.HSLColor attribute) (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) (openpyxl.drawing.effect.HSLEffect attribute) satMod (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) satOff (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) save() (openpyxl.workbook.workbook.Workbook method) (openpyxl.writer.excel.ExcelWriter method) save_workbook() (in module openpyxl.writer.excel) saveData (openpyxl.pivot.cache.CacheDefinition attribute) saveExternalLinkValues (openpyxl.workbook.properties.WorkbookProperties attribute) sb (openpyxl.cell.text.PhoneticText attribute) scale (openpyxl.chartsheet.custom.CustomChartsheetView attribute) (openpyxl.worksheet.page.PrintPageSetup attribute) ScaleCrop (openpyxl.packaging.extended.ExtendedProperties attribute) scaled (openpyxl.drawing.fill.LinearShadeProperties attribute) scaleWithDoc (openpyxl.worksheet.header_footer.HeaderFooter attribute) Scaling (class in openpyxl.chart.axis) scaling (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.NumericAxis attribute) (openpyxl.chart.axis.SeriesAxis attribute) (openpyxl.chart.axis.TextAxis attribute) ScatterChart (class in openpyxl.chart.scatter_chart) scatterChart (openpyxl.chart.plotarea.PlotArea attribute) scatterStyle (openpyxl.chart.scatter_chart.ScatterChart attribute) Scenario (class in openpyxl.worksheet.scenario) scenario (openpyxl.worksheet.scenario.ScenarioList attribute) ScenarioList (class in openpyxl.worksheet.scenario) scenarios (openpyxl.worksheet.protection.SheetProtection attribute) Scene3D (class in openpyxl.drawing.geometry) scene3d (openpyxl.chart.shapes.GraphicalProperties attribute) (openpyxl.drawing.properties.GroupShapeProperties attribute) (openpyxl.drawing.text.RichTextProperties attribute) scheme (openpyxl.cell.text.InlineFont attribute) (openpyxl.styles.fonts.Font attribute) schemeClr (openpyxl.drawing.colors.ColorChoice attribute) (openpyxl.drawing.effect.GlowEffect attribute) (openpyxl.drawing.effect.InnerShadowEffect attribute) (openpyxl.drawing.effect.OuterShadow attribute) (openpyxl.drawing.effect.PresetShadowEffect attribute) (openpyxl.drawing.fill.GradientStop attribute) (openpyxl.drawing.fill.SolidColorFillProperties attribute) SchemeColor (class in openpyxl.drawing.colors) scope (openpyxl.pivot.table.ConditionalFormat attribute) scrgbClr (openpyxl.drawing.colors.ColorChoice attribute) (openpyxl.drawing.effect.GlowEffect attribute) (openpyxl.drawing.effect.InnerShadowEffect attribute) (openpyxl.drawing.effect.OuterShadow attribute) (openpyxl.drawing.effect.PresetShadowEffect attribute) (openpyxl.drawing.fill.GradientStop attribute) (openpyxl.drawing.fill.SolidColorFillProperties attribute) sd (openpyxl.pivot.table.FieldItem attribute) second (openpyxl.worksheet.filters.DateGroupItem attribute) secondPiePt (openpyxl.chart.pie_chart.CustomSplit attribute) secondPieSize (openpyxl.chart.pie_chart.ProjectedPieChart attribute) selected (openpyxl.pivot.table.Reference attribute) selected_cell (openpyxl.worksheet.worksheet.Worksheet property) Selection (class in openpyxl.worksheet.views) selection (openpyxl.chart.chartspace.Protection attribute) (openpyxl.worksheet.views.SheetView attribute) selectLockedCells (openpyxl.worksheet.protection.SheetProtection attribute) selectUnlockedCells (openpyxl.worksheet.protection.SheetProtection attribute) separator (openpyxl.chart.label.DataLabel attribute) (openpyxl.chart.label.DataLabelList attribute) seq_types (openpyxl.descriptors.sequence.Sequence attribute) (openpyxl.descriptors.sequence.UniqueSequence attribute) Sequence (class in openpyxl.descriptors.sequence) ser (openpyxl.chart.area_chart.AreaChart attribute) (openpyxl.chart.area_chart.AreaChart3D attribute) (openpyxl.chart.bar_chart.BarChart attribute) (openpyxl.chart.bar_chart.BarChart3D attribute) (openpyxl.chart.bubble_chart.BubbleChart attribute) (openpyxl.chart.line_chart.LineChart attribute) (openpyxl.chart.line_chart.LineChart3D attribute) (openpyxl.chart.pie_chart.DoughnutChart attribute) (openpyxl.chart.pie_chart.PieChart attribute) (openpyxl.chart.pie_chart.PieChart3D attribute) (openpyxl.chart.pie_chart.ProjectedPieChart attribute) (openpyxl.chart.radar_chart.RadarChart attribute) (openpyxl.chart.scatter_chart.ScatterChart attribute) (openpyxl.chart.stock_chart.StockChart attribute) (openpyxl.chart.surface_chart.SurfaceChart attribute) (openpyxl.chart.surface_chart.SurfaceChart3D attribute) serAx (openpyxl.chart.plotarea.PlotArea attribute) Serialisable (class in openpyxl.descriptors.serialisable) Series (class in openpyxl.chart.series) series (openpyxl.pivot.table.ChartFormat attribute) SeriesAxis (class in openpyxl.chart.axis) SeriesFactory() (in module openpyxl.chart.series_factory) SeriesLabel (class in openpyxl.chart.series) serLines (openpyxl.chart.bar_chart.BarChart attribute) (openpyxl.chart.bar_chart.BarChart3D attribute) (openpyxl.chart.pie_chart.ProjectedPieChart attribute) serverField (openpyxl.pivot.cache.CacheField attribute) (openpyxl.pivot.table.PivotField attribute) ServerFormat (class in openpyxl.pivot.cache) serverFormats (openpyxl.pivot.cache.TupleCache attribute) Set (class in openpyxl.descriptors.base) set (openpyxl.pivot.cache.CacheHierarchy attribute) (openpyxl.pivot.cache.CalculatedMember attribute) set_dimension() (openpyxl.drawing.drawing.Drawing method) set_password() (openpyxl.worksheet.protection.SheetProtection method) set_printer_settings() (openpyxl.worksheet.worksheet.Worksheet method) set_revisions_password() (openpyxl.workbook.protection.WorkbookProtection method) set_workbook_password() (openpyxl.workbook.protection.WorkbookProtection method) setDefinition (openpyxl.pivot.cache.OLAPSet attribute) sets (openpyxl.pivot.cache.TupleCache attribute) shade (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) shadow (openpyxl.cell.text.InlineFont attribute) (openpyxl.styles.fonts.Font attribute) Shape (class in openpyxl.drawing.connector) shape (openpyxl.chart.bar_chart.BarChart3D attribute) (openpyxl.chart.series.Series attribute) Shape3D (class in openpyxl.drawing.geometry) shape3D (openpyxl.chart.shapes.GraphicalProperties attribute) shapeId (openpyxl.comments.comment_sheet.CommentRecord attribute) (openpyxl.worksheet.controls.Control attribute) (openpyxl.worksheet.ole.OleObject attribute) ShapeMeta (class in openpyxl.drawing.connector) ShapeStyle (class in openpyxl.drawing.geometry) ShapeWriter (class in openpyxl.comments.shape_writer) SharedDoc (openpyxl.packaging.extended.ExtendedProperties attribute) SharedItems (class in openpyxl.pivot.cache) sharedItems (openpyxl.pivot.cache.CacheField attribute) sheet (openpyxl.pivot.cache.RangeSet attribute) (openpyxl.pivot.cache.WorksheetSource attribute) (openpyxl.worksheet.protection.SheetProtection attribute) sheet_properties (openpyxl.worksheet.page.PrintPageSetup property) sheet_state (openpyxl.chartsheet.chartsheet.Chartsheet attribute) sheet_view (openpyxl.worksheet.worksheet.Worksheet property) SheetBackgroundPicture (class in openpyxl.chartsheet.relation) (class in openpyxl.worksheet.picture) sheetData (openpyxl.workbook.external_link.external.ExternalSheetDataSet attribute) sheetDataSet (openpyxl.workbook.external_link.external.ExternalBook attribute) SheetDimension (class in openpyxl.worksheet.dimensions) SheetFormatProperties (class in openpyxl.worksheet.dimensions) sheetId (openpyxl.packaging.workbook.ChildSheet attribute) (openpyxl.workbook.external_link.external.ExternalDefinedName attribute) (openpyxl.workbook.external_link.external.ExternalSheetData attribute) sheetname (openpyxl.chart.reference.Reference property) sheetName (openpyxl.workbook.external_link.external.ExternalSheetNames attribute) sheetNames (openpyxl.workbook.external_link.external.ExternalBook attribute) sheetnames (openpyxl.workbook.workbook.Workbook property) sheetPr (openpyxl.chartsheet.chartsheet.Chartsheet attribute) SheetProtection (class in openpyxl.worksheet.protection) sheetProtection (openpyxl.chartsheet.chartsheet.Chartsheet attribute) sheets (openpyxl.packaging.workbook.WorkbookPackage attribute) SHEETSTATE_HIDDEN (openpyxl.worksheet.worksheet.Worksheet attribute) SHEETSTATE_VERYHIDDEN (openpyxl.worksheet.worksheet.Worksheet attribute) SHEETSTATE_VISIBLE (openpyxl.worksheet.worksheet.Worksheet attribute) SheetTitleException SheetView (class in openpyxl.worksheet.views) sheetView (openpyxl.chartsheet.views.ChartsheetViewList attribute) (openpyxl.worksheet.views.SheetViewList attribute) SheetViewList (class in openpyxl.worksheet.views) sheetViews (openpyxl.chartsheet.chartsheet.Chartsheet attribute) shift() (openpyxl.worksheet.cell_range.CellRange method) short_color() (in module openpyxl.utils.units) shortcutKey (openpyxl.workbook.defined_name.DefinedName attribute) show (openpyxl.workbook.smart_tags.SmartTagProperties attribute) (openpyxl.worksheet.scenario.ScenarioList attribute) show_gridlines (openpyxl.worksheet.worksheet.Worksheet property) showAll (openpyxl.pivot.table.PivotField attribute) showAsCaption (openpyxl.pivot.table.MemberProperty attribute) showBorderUnselectedTables (openpyxl.workbook.properties.WorkbookProperties attribute) showBubbleSize (openpyxl.chart.label.DataLabel attribute) (openpyxl.chart.label.DataLabelList attribute) showButton (openpyxl.worksheet.filters.FilterColumn attribute) showCalcMbrs (openpyxl.pivot.table.TableDefinition attribute) showCatName (openpyxl.chart.label.DataLabel attribute) (openpyxl.chart.label.DataLabelList attribute) showCell (openpyxl.pivot.table.MemberProperty attribute) showColHeaders (openpyxl.pivot.table.PivotTableStyle attribute) showColStripes (openpyxl.pivot.table.PivotTableStyle attribute) showColumnStripes (openpyxl.worksheet.table.TableStyleInfo attribute) showComments (openpyxl.workbook.views.CustomWorkbookView attribute) showDataAs (openpyxl.pivot.table.DataField attribute) showDataDropDown (openpyxl.pivot.table.TableDefinition attribute) showDataTips (openpyxl.pivot.table.TableDefinition attribute) showDLblsOverMax (openpyxl.chart.chartspace.ChartContainer attribute) showDrill (openpyxl.pivot.table.TableDefinition attribute) showDropDown (openpyxl.worksheet.datavalidation.DataValidation attribute) showDropDowns (openpyxl.pivot.table.PivotField attribute) showDropZones (openpyxl.pivot.table.TableDefinition attribute) showEmptyCol (openpyxl.pivot.table.TableDefinition attribute) showEmptyRow (openpyxl.pivot.table.TableDefinition attribute) showError (openpyxl.pivot.table.TableDefinition attribute) showErrorMessage (openpyxl.worksheet.datavalidation.DataValidation attribute) showFirstColumn (openpyxl.worksheet.table.TableStyleInfo attribute) showFormulaBar (openpyxl.workbook.views.CustomWorkbookView attribute) showFormulas (openpyxl.worksheet.views.SheetView attribute) showGridLines (openpyxl.worksheet.views.SheetView attribute) showHeaders (openpyxl.pivot.table.TableDefinition attribute) showHorizontalScroll (openpyxl.workbook.views.BookView attribute) (openpyxl.workbook.views.CustomWorkbookView attribute) showHorzBorder (openpyxl.chart.plotarea.DataTable attribute) showInFieldList (openpyxl.pivot.table.PivotHierarchy attribute) showInkAnnotation (openpyxl.workbook.properties.WorkbookProperties attribute) showInputMessage (openpyxl.worksheet.datavalidation.DataValidation attribute) showItems (openpyxl.pivot.table.TableDefinition attribute) showKeys (openpyxl.chart.plotarea.DataTable attribute) showLastColumn (openpyxl.pivot.table.PivotTableStyle attribute) (openpyxl.worksheet.table.TableStyleInfo attribute) showLeaderLines (openpyxl.chart.label.DataLabel attribute) (openpyxl.chart.label.DataLabelList attribute) showLegendKey (openpyxl.chart.label.DataLabel attribute) (openpyxl.chart.label.DataLabelList attribute) showMemberPropertyTips (openpyxl.pivot.table.TableDefinition attribute) showMissing (openpyxl.pivot.table.TableDefinition attribute) showMultipleLabel (openpyxl.pivot.table.TableDefinition attribute) showNegBubbles (openpyxl.chart.bubble_chart.BubbleChart attribute) showObjects (openpyxl.workbook.properties.WorkbookProperties attribute) (openpyxl.workbook.views.CustomWorkbookView attribute) showOutline (openpyxl.chart.plotarea.DataTable attribute) showOutlineSymbols (openpyxl.worksheet.properties.Outline attribute) (openpyxl.worksheet.views.SheetView attribute) showPercent (openpyxl.chart.label.DataLabel attribute) (openpyxl.chart.label.DataLabelList attribute) showPivotChartFilter (openpyxl.workbook.properties.WorkbookProperties attribute) showPropAsCaption (openpyxl.pivot.table.PivotField attribute) showPropCell (openpyxl.pivot.table.PivotField attribute) showPropTip (openpyxl.pivot.table.PivotField attribute) showRowColHeaders (openpyxl.worksheet.views.SheetView attribute) showRowHeaders (openpyxl.pivot.table.PivotTableStyle attribute) showRowStripes (openpyxl.pivot.table.PivotTableStyle attribute) (openpyxl.worksheet.table.TableStyleInfo attribute)

showRuler (openpyxl.worksheet.views.SheetView attribute) showSerName (openpyxl.chart.label.DataLabel attribute) (openpyxl.chart.label.DataLabelList attribute) showSheetTabs (openpyxl.workbook.views.BookView attribute) (openpyxl.workbook.views.CustomWorkbookView attribute) showStatusbar (openpyxl.workbook.views.CustomWorkbookView attribute) showTip (openpyxl.pivot.table.MemberProperty attribute) showVal (openpyxl.chart.label.DataLabel attribute) (openpyxl.chart.label.DataLabelList attribute) showValue (openpyxl.formatting.rule.DataBar attribute) (openpyxl.formatting.rule.IconSet attribute) showVertBorder (openpyxl.chart.plotarea.DataTable attribute) showVerticalScroll (openpyxl.workbook.views.BookView attribute) (openpyxl.workbook.views.CustomWorkbookView attribute) showWhiteSpace (openpyxl.worksheet.views.SheetView attribute) showZeros (openpyxl.worksheet.views.SheetView attribute) shrink() (openpyxl.worksheet.cell_range.CellRange method) shrink_to_fit (openpyxl.styles.alignment.Alignment attribute) shrinkToFit (openpyxl.styles.alignment.Alignment attribute) Side (class in openpyxl.styles.borders) sideWall (openpyxl.chart.bar_chart.BarChart3D attribute) (openpyxl.chart.chartspace.ChartContainer attribute) size (openpyxl.chart.error_bar.ErrorBars attribute) (openpyxl.chart.marker.Marker attribute) (openpyxl.styles.fonts.Font attribute) (openpyxl.styles.table.TableStyleElement attribute) (openpyxl.worksheet.cell_range.CellRange property) sizeRepresents (openpyxl.chart.bubble_chart.BubbleChart attribute) sizeWithCells (openpyxl.worksheet.ole.ObjectAnchor attribute) Slides (openpyxl.packaging.extended.ExtendedProperties attribute) SmartTag (class in openpyxl.workbook.smart_tags) SmartTagList (class in openpyxl.workbook.smart_tags) smartTagPr (openpyxl.packaging.workbook.WorkbookPackage attribute) SmartTagProperties (class in openpyxl.workbook.smart_tags) SmartTags (class in openpyxl.worksheet.smart_tag) smartTagType (openpyxl.workbook.smart_tags.SmartTagList attribute) smartTagTypes (openpyxl.packaging.workbook.WorkbookPackage attribute) smooth (openpyxl.chart.line_chart.LineChart attribute) (openpyxl.chart.line_chart.LineChart3D attribute) (openpyxl.chart.series.Series attribute) (openpyxl.chart.series.XYSeries attribute) smtClean (openpyxl.drawing.text.CharacterProperties attribute) smtId (openpyxl.drawing.text.CharacterProperties attribute) snd (openpyxl.drawing.text.Hyperlink attribute) softEdge (openpyxl.drawing.effect.EffectList attribute) SoftEdgesEffect (class in openpyxl.drawing.effect) SolidColorFillProperties (class in openpyxl.drawing.fill) solidFill (openpyxl.chart.shapes.GraphicalProperties attribute) (openpyxl.drawing.line.LineProperties attribute) (openpyxl.drawing.text.CharacterProperties attribute) solveOrder (openpyxl.pivot.cache.CalculatedMember attribute) sort (openpyxl.worksheet.protection.SheetProtection attribute) sortBy (openpyxl.worksheet.filters.SortCondition attribute) sortByTuple (openpyxl.pivot.cache.OLAPSet attribute) SortCondition (class in openpyxl.worksheet.filters) sortCondition (openpyxl.worksheet.filters.SortState attribute) sorted() (openpyxl.worksheet.cell_range.MultiCellRange method) sortMethod (openpyxl.worksheet.filters.SortState attribute) SortState (class in openpyxl.worksheet.filters) sortState (openpyxl.worksheet.filters.AutoFilter attribute) (openpyxl.worksheet.table.Table attribute) sortType (openpyxl.pivot.cache.OLAPSet attribute) (openpyxl.pivot.table.PivotField attribute) sourceLinked (openpyxl.chart.data_source.NumFmt attribute) sourceObject (openpyxl.chartsheet.publish.WebPublishItem attribute) (openpyxl.workbook.web.WebPublishObject attribute) sourceRef (openpyxl.chartsheet.publish.WebPublishItem attribute) sourceType (openpyxl.chartsheet.publish.WebPublishItem attribute) sp (openpyxl.drawing.line.DashStop attribute) (openpyxl.drawing.spreadsheet_drawing.AbsoluteAnchor attribute) (openpyxl.drawing.spreadsheet_drawing.OneCellAnchor attribute) (openpyxl.drawing.spreadsheet_drawing.TwoCellAnchor attribute) sp3d (openpyxl.chart.shapes.GraphicalProperties attribute) space (openpyxl.drawing.line.DashStop attribute) Spacing (class in openpyxl.drawing.text) spAutoFit (openpyxl.drawing.text.RichTextProperties attribute) spc (openpyxl.drawing.text.CharacterProperties attribute) spcAft (openpyxl.drawing.text.ParagraphProperties attribute) spcBef (openpyxl.drawing.text.ParagraphProperties attribute) spcCol (openpyxl.drawing.text.RichTextProperties attribute) spcFirstLastPara (openpyxl.drawing.text.RichTextProperties attribute) spcPct (openpyxl.drawing.text.Spacing attribute) spcPts (openpyxl.drawing.text.Spacing attribute) SphereCoords (class in openpyxl.drawing.geometry) spinCount (openpyxl.chartsheet.protection.ChartsheetProtection attribute) (openpyxl.workbook.protection.FileSharing attribute) (openpyxl.worksheet.protection.SheetProtection attribute) splitPos (openpyxl.chart.pie_chart.ProjectedPieChart attribute) splitType (openpyxl.chart.pie_chart.ProjectedPieChart attribute) spLocks (openpyxl.drawing.properties.NonVisualDrawingShapeProps attribute) spPr (openpyxl.chart.axis.ChartLines attribute) (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.DisplayUnitsLabel attribute) (openpyxl.chart.axis.NumericAxis attribute) (openpyxl.chart.axis.SeriesAxis attribute) (openpyxl.chart.axis.TextAxis attribute) (openpyxl.chart.chartspace.ChartSpace attribute) (openpyxl.chart.error_bar.ErrorBars attribute) (openpyxl.chart.label.DataLabel attribute) (openpyxl.chart.label.DataLabelList attribute) (openpyxl.chart.legend.Legend attribute) (openpyxl.chart.marker.DataPoint attribute) (openpyxl.chart.marker.Marker attribute) (openpyxl.chart.pivot.PivotFormat attribute) (openpyxl.chart.plotarea.DataTable attribute) (openpyxl.chart.plotarea.PlotArea attribute) (openpyxl.chart.series.Series attribute) (openpyxl.chart.series.XYSeries attribute) (openpyxl.chart.surface_chart.BandFormat attribute) (openpyxl.chart.title.Title attribute) (openpyxl.chart.trendline.Trendline attribute) (openpyxl.chart.trendline.TrendlineLabel attribute) (openpyxl.drawing.connector.ConnectorShape attribute) (openpyxl.drawing.connector.Shape attribute) (openpyxl.drawing.picture.PictureFrame attribute) SpreadsheetDrawing (class in openpyxl.drawing.spreadsheet_drawing) sqlType (openpyxl.pivot.cache.CacheField attribute) sqref (openpyxl.formatting.formatting.ConditionalFormatting attribute) (openpyxl.worksheet.datavalidation.DataValidation attribute) (openpyxl.worksheet.errors.IgnoredError attribute) (openpyxl.worksheet.scenario.ScenarioList attribute) (openpyxl.worksheet.views.Selection attribute) srcRect (openpyxl.drawing.fill.BlipFillProperties attribute) srgbClr (openpyxl.drawing.colors.ColorChoice attribute) (openpyxl.drawing.effect.GlowEffect attribute) (openpyxl.drawing.effect.InnerShadowEffect attribute) (openpyxl.drawing.effect.OuterShadow attribute) (openpyxl.drawing.effect.PresetShadowEffect attribute) (openpyxl.drawing.fill.GradientStop attribute) (openpyxl.drawing.fill.SolidColorFillProperties attribute) st (openpyxl.pivot.fields.Error attribute) (openpyxl.pivot.fields.Missing attribute) (openpyxl.pivot.fields.Number attribute) (openpyxl.pivot.fields.Text attribute) stA (openpyxl.drawing.effect.ReflectionEffect attribute) start (openpyxl.styles.borders.Border attribute) start_color (openpyxl.styles.fills.PatternFill attribute) startAt (openpyxl.drawing.text.AutonumberBullet attribute) startDate (openpyxl.pivot.cache.RangePr attribute) startNum (openpyxl.pivot.cache.RangePr attribute) state (openpyxl.chartsheet.custom.CustomChartsheetView attribute) (openpyxl.packaging.workbook.ChildSheet attribute) (openpyxl.worksheet.views.Pane attribute) status (openpyxl.pivot.cache.OLAPKPI attribute) statusBar (openpyxl.workbook.defined_name.DefinedName attribute) stCxn (openpyxl.drawing.connector.NonVisualConnectorProperties attribute) stdDev (openpyxl.formatting.rule.Rule attribute) stdDevPSubtotal (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.Reference attribute) stdDevSubtotal (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.Reference attribute) StockChart (class in openpyxl.chart.stock_chart) stockChart (openpyxl.chart.plotarea.PlotArea attribute) Stop (class in openpyxl.styles.fills) stop (openpyxl.styles.fills.GradientFill attribute) stop_list (openpyxl.drawing.fill.GradientFillProperties attribute) stopIfTrue (openpyxl.formatting.rule.Rule attribute) StopList (class in openpyxl.styles.fills) stPos (openpyxl.drawing.effect.ReflectionEffect attribute) strCache (openpyxl.chart.data_source.StrRef attribute) StrData (class in openpyxl.chart.data_source) stretch (openpyxl.drawing.fill.BlipFillProperties attribute) StretchInfoProperties (class in openpyxl.drawing.fill) Strict (class in openpyxl.descriptors) strike (openpyxl.cell.text.InlineFont attribute) (openpyxl.drawing.text.CharacterProperties attribute) (openpyxl.styles.fonts.Font attribute) strikethrough (openpyxl.styles.fonts.Font attribute) String (class in openpyxl.descriptors.base) StringFilter (class in openpyxl.worksheet.filters) StringProperty (class in openpyxl.packaging.custom) stringValue1 (openpyxl.pivot.table.PivotFilter attribute) stringValue2 (openpyxl.pivot.table.PivotFilter attribute) strLit (openpyxl.chart.data_source.AxDataSource attribute) stroke (openpyxl.drawing.geometry.Path2D attribute) StrRef (class in openpyxl.chart.data_source) strRef (openpyxl.chart.data_source.AxDataSource attribute) (openpyxl.chart.series.SeriesLabel attribute) (openpyxl.chart.text.Text attribute) StrVal (class in openpyxl.chart.data_source) style (openpyxl.chart.chartspace.ChartSpace attribute) (openpyxl.chart.error_bar.ErrorBars attribute) (openpyxl.drawing.connector.ConnectorShape attribute) (openpyxl.drawing.connector.Shape attribute) (openpyxl.drawing.picture.PictureFrame attribute) (openpyxl.styles.borders.Side attribute) (openpyxl.styles.styleable.StyleableObject attribute) (openpyxl.worksheet.dimensions.Dimension property) style_array (openpyxl.cell.read_only.ReadOnlyCell property) style_id (openpyxl.styles.styleable.StyleableObject property) style_names (openpyxl.workbook.workbook.Workbook property) StyleableObject (class in openpyxl.styles.styleable) StyleArray (class in openpyxl.styles.cell_style) StyleArrayDescriptor (class in openpyxl.styles.styleable) StyleDescriptor (class in openpyxl.styles.styleable) StyleMatrixReference (class in openpyxl.drawing.geometry) StyleProxy (class in openpyxl.styles.proxy) styles (openpyxl.styles.differential.DifferentialStyleList attribute) Stylesheet (class in openpyxl.styles.stylesheet) subject (openpyxl.packaging.core.DocumentProperties attribute) subtotal (openpyxl.pivot.table.DataField attribute) subtotalCaption (openpyxl.pivot.table.PivotField attribute) subtotalHiddenItems (openpyxl.pivot.table.TableDefinition attribute) subtotalTop (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.PivotHierarchy attribute) summary (openpyxl.pivot.table.TableDefinition property) summaryBelow (openpyxl.worksheet.properties.Outline attribute) summaryRight (openpyxl.worksheet.properties.Outline attribute) sumSubtotal (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.Reference attribute) supportAdvancedDrill (openpyxl.pivot.cache.CacheDefinition attribute) supportSubquery (openpyxl.pivot.cache.CacheDefinition attribute) surface3DChart (openpyxl.chart.plotarea.PlotArea attribute) SurfaceChart (class in openpyxl.chart.surface_chart) surfaceChart (openpyxl.chart.plotarea.PlotArea attribute) SurfaceChart3D (class in openpyxl.chart.surface_chart) sx (openpyxl.drawing.effect.OuterShadow attribute) (openpyxl.drawing.effect.ReflectionEffect attribute) (openpyxl.drawing.fill.TileInfoProperties attribute) sy (openpyxl.drawing.effect.OuterShadow attribute) (openpyxl.drawing.effect.ReflectionEffect attribute) (openpyxl.drawing.fill.TileInfoProperties attribute) sym (openpyxl.drawing.text.CharacterProperties attribute) symbol (openpyxl.chart.marker.Marker attribute) syncHorizontal (openpyxl.worksheet.properties.WorksheetProperties attribute) syncRef (openpyxl.worksheet.properties.WorksheetProperties attribute) syncVertical (openpyxl.worksheet.properties.WorksheetProperties attribute) sysClr (openpyxl.drawing.colors.ColorChoice attribute) (openpyxl.drawing.effect.GlowEffect attribute) (openpyxl.drawing.effect.InnerShadowEffect attribute) (openpyxl.drawing.effect.OuterShadow attribute) (openpyxl.drawing.effect.PresetShadowEffect attribute) (openpyxl.drawing.fill.GradientStop attribute) (openpyxl.drawing.fill.SolidColorFillProperties attribute) SystemColor (class in openpyxl.drawing.colors) sz (openpyxl.cell.text.InlineFont attribute) (openpyxl.drawing.text.CharacterProperties attribute) (openpyxl.styles.fonts.Font attribute)

T

t (openpyxl.cell.text.PhoneticText attribute) (openpyxl.cell.text.RichText attribute) (openpyxl.cell.text.Text attribute) (openpyxl.chart.print_settings.PageMargins attribute) (openpyxl.drawing.fill.RelativeRect attribute) (openpyxl.drawing.geometry.GeomRect attribute) (openpyxl.drawing.text.RegularTextRun attribute) (openpyxl.drawing.text.TextField attribute) (openpyxl.pivot.table.FieldItem attribute) (openpyxl.pivot.table.RowColItem attribute) (openpyxl.workbook.external_link.external.ExternalCell attribute) (openpyxl.worksheet.formula.ArrayFormula attribute) (openpyxl.worksheet.formula.DataTableFormula attribute) tab (openpyxl.drawing.text.TabStopList attribute) tabColor (openpyxl.chartsheet.properties.ChartsheetProperties attribute) (openpyxl.worksheet.properties.WorksheetProperties attribute) Table (class in openpyxl.worksheet.table) table (openpyxl.styles.table.TableStyle attribute) tableBorderDxfId (openpyxl.worksheet.table.Table attribute) TableColumn (class in openpyxl.worksheet.table) tableColumns (openpyxl.worksheet.table.Table attribute) TableDefinition (class in openpyxl.pivot.table) TableFormula (class in openpyxl.worksheet.table) TableList (class in openpyxl.worksheet.table) TableNameDescriptor (class in openpyxl.worksheet.table) tablePart (openpyxl.worksheet.table.TablePartList attribute) TablePartList (class in openpyxl.worksheet.table) tables (openpyxl.worksheet.worksheet.Worksheet property) TableStyle (class in openpyxl.styles.table) tableStyle (openpyxl.styles.table.TableStyleList attribute) TableStyleElement (class in openpyxl.styles.table) tableStyleElement (openpyxl.styles.table.TableStyle attribute) TableStyleInfo (class in openpyxl.worksheet.table) tableStyleInfo (openpyxl.worksheet.table.Table attribute) TableStyleList (class in openpyxl.styles.table) tableStyles (openpyxl.styles.stylesheet.Stylesheet attribute) tableType (openpyxl.worksheet.table.Table attribute) tabLst (openpyxl.drawing.text.ParagraphProperties attribute) tabRatio (openpyxl.workbook.views.BookView attribute) (openpyxl.workbook.views.CustomWorkbookView attribute) tabSelected (openpyxl.chartsheet.views.ChartsheetView attribute) (openpyxl.worksheet.views.SheetView attribute) TabStop (class in openpyxl.drawing.text) TabStopList (class in openpyxl.drawing.text) tag (openpyxl.pivot.table.TableDefinition attribute) tagname (openpyxl.cell.text.InlineFont attribute) (openpyxl.cell.text.PhoneticProperties attribute) (openpyxl.cell.text.PhoneticText attribute) (openpyxl.cell.text.RichText attribute) (openpyxl.cell.text.Text attribute) (openpyxl.chart.area_chart.AreaChart attribute) (openpyxl.chart.area_chart.AreaChart3D attribute) (openpyxl.chart.axis.ChartLines attribute) (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.DisplayUnitsLabel attribute) (openpyxl.chart.axis.DisplayUnitsLabelList attribute) (openpyxl.chart.axis.NumericAxis attribute) (openpyxl.chart.axis.Scaling attribute) (openpyxl.chart.axis.SeriesAxis attribute) (openpyxl.chart.axis.TextAxis attribute) (openpyxl.chart.bar_chart.BarChart attribute) (openpyxl.chart.bar_chart.BarChart3D attribute) (openpyxl.chart.bubble_chart.BubbleChart attribute) (openpyxl.chart.chartspace.ChartContainer attribute) (openpyxl.chart.chartspace.ChartSpace attribute) (openpyxl.chart.chartspace.ExternalData attribute) (openpyxl.chart.chartspace.Protection attribute) (openpyxl.chart.data_source.AxDataSource attribute) (openpyxl.chart.data_source.Level attribute) (openpyxl.chart.data_source.MultiLevelStrData attribute) (openpyxl.chart.data_source.MultiLevelStrRef attribute) (openpyxl.chart.data_source.StrData attribute) (openpyxl.chart.data_source.StrRef attribute) (openpyxl.chart.data_source.StrVal attribute) (openpyxl.chart.error_bar.ErrorBars attribute) (openpyxl.chart.label.DataLabel attribute) (openpyxl.chart.label.DataLabelList attribute) (openpyxl.chart.layout.Layout attribute) (openpyxl.chart.layout.ManualLayout attribute) (openpyxl.chart.legend.Legend attribute) (openpyxl.chart.legend.LegendEntry attribute) (openpyxl.chart.line_chart.LineChart attribute) (openpyxl.chart.line_chart.LineChart3D attribute) (openpyxl.chart.marker.DataPoint attribute) (openpyxl.chart.marker.Marker attribute) (openpyxl.chart.picture.PictureOptions attribute) (openpyxl.chart.pie_chart.CustomSplit attribute) (openpyxl.chart.pie_chart.DoughnutChart attribute) (openpyxl.chart.pie_chart.PieChart attribute) (openpyxl.chart.pie_chart.PieChart3D attribute) (openpyxl.chart.pie_chart.ProjectedPieChart attribute) (openpyxl.chart.pivot.PivotFormat attribute) (openpyxl.chart.pivot.PivotSource attribute) (openpyxl.chart.plotarea.DataTable attribute) (openpyxl.chart.plotarea.PlotArea attribute) (openpyxl.chart.print_settings.PageMargins attribute) (openpyxl.chart.print_settings.PrintSettings attribute) (openpyxl.chart.radar_chart.RadarChart attribute) (openpyxl.chart.scatter_chart.ScatterChart attribute) (openpyxl.chart.series.Series attribute) (openpyxl.chart.series.SeriesLabel attribute) (openpyxl.chart.shapes.GraphicalProperties attribute) (openpyxl.chart.stock_chart.StockChart attribute) (openpyxl.chart.surface_chart.BandFormat attribute) (openpyxl.chart.surface_chart.BandFormatList attribute) (openpyxl.chart.surface_chart.SurfaceChart attribute) (openpyxl.chart.surface_chart.SurfaceChart3D attribute) (openpyxl.chart.text.RichText attribute) (openpyxl.chart.text.Text attribute) (openpyxl.chart.title.Title attribute) (openpyxl.chart.trendline.Trendline attribute) (openpyxl.chart.trendline.TrendlineLabel attribute) (openpyxl.chart.updown_bars.UpDownBars attribute) (openpyxl.chartsheet.chartsheet.Chartsheet attribute) (openpyxl.chartsheet.custom.CustomChartsheetView attribute) (openpyxl.chartsheet.custom.CustomChartsheetViews attribute) (openpyxl.chartsheet.properties.ChartsheetProperties attribute) (openpyxl.chartsheet.protection.ChartsheetProtection attribute) (openpyxl.chartsheet.publish.WebPublishItem attribute) (openpyxl.chartsheet.publish.WebPublishItems attribute) (openpyxl.chartsheet.relation.SheetBackgroundPicture attribute) (openpyxl.chartsheet.views.ChartsheetView attribute) (openpyxl.chartsheet.views.ChartsheetViewList attribute) (openpyxl.comments.author.AuthorList attribute) (openpyxl.comments.comment_sheet.CommentRecord attribute) (openpyxl.comments.comment_sheet.CommentSheet attribute) (openpyxl.descriptors.container.ElementList property) (openpyxl.descriptors.serialisable.Serialisable property) (openpyxl.drawing.colors.ColorChoice attribute) (openpyxl.drawing.colors.ColorMapping attribute) (openpyxl.drawing.colors.HSLColor attribute) (openpyxl.drawing.colors.RGBPercent attribute) (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) (openpyxl.drawing.connector.ConnectorShape attribute) (openpyxl.drawing.connector.ShapeMeta attribute) (openpyxl.drawing.effect.GrayscaleEffect attribute) (openpyxl.drawing.effect.LuminanceEffect attribute) (openpyxl.drawing.effect.OuterShadow attribute) (openpyxl.drawing.effect.TintEffect attribute) (openpyxl.drawing.fill.Blip attribute) (openpyxl.drawing.fill.BlipFillProperties attribute) (openpyxl.drawing.fill.GradientFillProperties attribute) (openpyxl.drawing.fill.GradientStop attribute) (openpyxl.drawing.fill.LinearShadeProperties attribute) (openpyxl.drawing.fill.PathShadeProperties attribute) (openpyxl.drawing.fill.PatternFillProperties attribute) (openpyxl.drawing.fill.RelativeRect attribute) (openpyxl.drawing.fill.SolidColorFillProperties attribute) (openpyxl.drawing.fill.StretchInfoProperties attribute) (openpyxl.drawing.geometry.Bevel attribute) (openpyxl.drawing.geometry.Camera attribute) (openpyxl.drawing.geometry.GroupTransform2D attribute) (openpyxl.drawing.geometry.LightRig attribute) (openpyxl.drawing.geometry.Point2D attribute) (openpyxl.drawing.geometry.Point3D attribute) (openpyxl.drawing.geometry.PositiveSize2D attribute) (openpyxl.drawing.geometry.SphereCoords attribute) (openpyxl.drawing.geometry.Transform2D attribute) (openpyxl.drawing.geometry.Vector3D attribute) (openpyxl.drawing.graphic.GraphicData attribute) (openpyxl.drawing.graphic.GraphicFrame attribute) (openpyxl.drawing.graphic.GraphicObject attribute) (openpyxl.drawing.graphic.NonVisualGraphicFrame attribute) (openpyxl.drawing.graphic.NonVisualGraphicFrameProperties attribute) (openpyxl.drawing.line.DashStop attribute) (openpyxl.drawing.line.LineEndProperties attribute) (openpyxl.drawing.line.LineProperties attribute) (openpyxl.drawing.picture.NonVisualPictureProperties attribute) (openpyxl.drawing.picture.PictureFrame attribute) (openpyxl.drawing.picture.PictureLocking attribute) (openpyxl.drawing.picture.PictureNonVisual attribute) (openpyxl.drawing.properties.GroupLocking attribute) (openpyxl.drawing.properties.GroupShapeProperties attribute) (openpyxl.drawing.properties.NonVisualDrawingProps attribute) (openpyxl.drawing.properties.NonVisualDrawingShapeProps attribute) (openpyxl.drawing.properties.NonVisualGroupDrawingShapeProps attribute) (openpyxl.drawing.properties.NonVisualGroupShape attribute) (openpyxl.drawing.relation.ChartRelation attribute) (openpyxl.drawing.spreadsheet_drawing.AbsoluteAnchor attribute) (openpyxl.drawing.spreadsheet_drawing.AnchorMarker attribute) (openpyxl.drawing.spreadsheet_drawing.OneCellAnchor attribute) (openpyxl.drawing.spreadsheet_drawing.SpreadsheetDrawing attribute) (openpyxl.drawing.spreadsheet_drawing.TwoCellAnchor attribute) (openpyxl.drawing.text.CharacterProperties attribute) (openpyxl.drawing.text.Font attribute) (openpyxl.drawing.text.Hyperlink attribute) (openpyxl.drawing.text.LineBreak attribute) (openpyxl.drawing.text.ListStyle attribute) (openpyxl.drawing.text.Paragraph attribute) (openpyxl.drawing.text.ParagraphProperties attribute) (openpyxl.drawing.text.RegularTextRun attribute) (openpyxl.drawing.text.RichTextProperties attribute) (openpyxl.formatting.formatting.ConditionalFormatting attribute) (openpyxl.formatting.rule.ColorScale attribute) (openpyxl.formatting.rule.DataBar attribute) (openpyxl.formatting.rule.FormatObject attribute) (openpyxl.formatting.rule.IconSet attribute) (openpyxl.formatting.rule.Rule attribute) (openpyxl.packaging.core.DocumentProperties attribute) (openpyxl.packaging.extended.ExtendedProperties attribute) (openpyxl.packaging.manifest.FileExtension attribute) (openpyxl.packaging.manifest.Manifest attribute) (openpyxl.packaging.manifest.Override attribute) (openpyxl.packaging.relationship.Relationship attribute) (openpyxl.packaging.relationship.RelationshipList attribute) (openpyxl.packaging.workbook.ChildSheet attribute) (openpyxl.packaging.workbook.FileRecoveryProperties attribute) (openpyxl.packaging.workbook.PivotCache attribute) (openpyxl.packaging.workbook.WorkbookPackage attribute) (openpyxl.pivot.cache.CacheDefinition attribute) (openpyxl.pivot.cache.CacheField attribute) (openpyxl.pivot.cache.CacheHierarchy attribute) (openpyxl.pivot.cache.CacheSource attribute) (openpyxl.pivot.cache.CalculatedItem attribute) (openpyxl.pivot.cache.CalculatedMember attribute) (openpyxl.pivot.cache.Consolidation attribute) (openpyxl.pivot.cache.FieldGroup attribute) (openpyxl.pivot.cache.FieldUsage attribute) (openpyxl.pivot.cache.GroupItems attribute) (openpyxl.pivot.cache.GroupLevel attribute) (openpyxl.pivot.cache.GroupMember attribute) (openpyxl.pivot.cache.LevelGroup attribute) (openpyxl.pivot.cache.MeasureDimensionMap attribute) (openpyxl.pivot.cache.MeasureGroup attribute) (openpyxl.pivot.cache.OLAPKPI attribute) (openpyxl.pivot.cache.OLAPSet attribute) (openpyxl.pivot.cache.PageItem attribute) (openpyxl.pivot.cache.PCDSDTCEntries attribute) (openpyxl.pivot.cache.PivotDimension attribute) (openpyxl.pivot.cache.Query attribute) (openpyxl.pivot.cache.RangePr attribute) (openpyxl.pivot.cache.RangeSet attribute) (openpyxl.pivot.cache.ServerFormat attribute) (openpyxl.pivot.cache.SharedItems attribute) (openpyxl.pivot.cache.TupleCache attribute) (openpyxl.pivot.cache.WorksheetSource attribute) (openpyxl.pivot.fields.Boolean attribute) (openpyxl.pivot.fields.DateTimeField attribute) (openpyxl.pivot.fields.Error attribute) (openpyxl.pivot.fields.Index attribute) (openpyxl.pivot.fields.Missing attribute) (openpyxl.pivot.fields.Number attribute) (openpyxl.pivot.fields.Text attribute) (openpyxl.pivot.fields.Tuple attribute) (openpyxl.pivot.fields.TupleList attribute) (openpyxl.pivot.record.Record attribute) (openpyxl.pivot.record.RecordList attribute) (openpyxl.pivot.table.ChartFormat attribute) (openpyxl.pivot.table.ColHierarchiesUsage attribute) (openpyxl.pivot.table.ConditionalFormat attribute) (openpyxl.pivot.table.ConditionalFormatList attribute) (openpyxl.pivot.table.DataField attribute) (openpyxl.pivot.table.FieldItem attribute) (openpyxl.pivot.table.Format attribute) (openpyxl.pivot.table.HierarchyUsage attribute) (openpyxl.pivot.table.Location attribute) (openpyxl.pivot.table.MemberList attribute) (openpyxl.pivot.table.MemberProperty attribute) (openpyxl.pivot.table.PageField attribute) (openpyxl.pivot.table.PivotArea attribute) (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.PivotFilter attribute) (openpyxl.pivot.table.PivotHierarchy attribute) (openpyxl.pivot.table.PivotTableStyle attribute) (openpyxl.pivot.table.Reference attribute) (openpyxl.pivot.table.RowColField attribute) (openpyxl.pivot.table.RowColItem attribute) (openpyxl.pivot.table.RowHierarchiesUsage attribute) (openpyxl.pivot.table.TableDefinition attribute) (openpyxl.styles.alignment.Alignment attribute) (openpyxl.styles.borders.Border attribute) (openpyxl.styles.cell_style.CellStyle attribute) (openpyxl.styles.cell_style.CellStyleList attribute) (openpyxl.styles.cell_style.StyleArray attribute) (openpyxl.styles.colors.Color attribute) (openpyxl.styles.colors.ColorList attribute) (openpyxl.styles.colors.RgbColor attribute) (openpyxl.styles.differential.DifferentialStyle attribute) (openpyxl.styles.differential.DifferentialStyleList attribute) (openpyxl.styles.fills.Fill attribute) (openpyxl.styles.fills.GradientFill attribute) (openpyxl.styles.fills.PatternFill attribute) (openpyxl.styles.fills.Stop attribute) (openpyxl.styles.fonts.Font attribute) (openpyxl.styles.protection.Protection attribute) (openpyxl.styles.stylesheet.Stylesheet attribute) (openpyxl.styles.table.TableStyle attribute) (openpyxl.styles.table.TableStyleElement attribute) (openpyxl.styles.table.TableStyleList attribute) (openpyxl.workbook.defined_name.DefinedName attribute) (openpyxl.workbook.defined_name.DefinedNameList attribute) (openpyxl.workbook.external_link.external.ExternalBook attribute) (openpyxl.workbook.external_link.external.ExternalDefinedName attribute) (openpyxl.workbook.external_link.external.ExternalLink attribute) (openpyxl.workbook.external_reference.ExternalReference attribute) (openpyxl.workbook.function_group.FunctionGroup attribute) (openpyxl.workbook.function_group.FunctionGroupList attribute) (openpyxl.workbook.properties.CalcProperties attribute) (openpyxl.workbook.properties.FileVersion attribute) (openpyxl.workbook.properties.WorkbookProperties attribute) (openpyxl.workbook.protection.FileSharing attribute) (openpyxl.workbook.protection.WorkbookProtection attribute) (openpyxl.workbook.smart_tags.SmartTag attribute) (openpyxl.workbook.smart_tags.SmartTagList attribute) (openpyxl.workbook.smart_tags.SmartTagProperties attribute) (openpyxl.workbook.views.BookView attribute) (openpyxl.workbook.views.CustomWorkbookView attribute) (openpyxl.workbook.web.WebPublishing attribute) (openpyxl.workbook.web.WebPublishObject attribute) (openpyxl.workbook.web.WebPublishObjectList attribute) (openpyxl.worksheet.cell_watch.CellWatch attribute) (openpyxl.worksheet.cell_watch.CellWatches attribute) (openpyxl.worksheet.controls.Control attribute) (openpyxl.worksheet.controls.ControlProperty attribute) (openpyxl.worksheet.controls.Controls attribute) (openpyxl.worksheet.custom.CustomProperties attribute) (openpyxl.worksheet.custom.CustomProperty attribute) (openpyxl.worksheet.datavalidation.DataValidation attribute) (openpyxl.worksheet.datavalidation.DataValidationList attribute) (openpyxl.worksheet.dimensions.SheetDimension attribute) (openpyxl.worksheet.dimensions.SheetFormatProperties attribute) (openpyxl.worksheet.drawing.Drawing attribute) (openpyxl.worksheet.errors.Extension attribute) (openpyxl.worksheet.errors.ExtensionList attribute) (openpyxl.worksheet.errors.IgnoredError attribute) (openpyxl.worksheet.errors.IgnoredErrors attribute) (openpyxl.worksheet.filters.AutoFilter attribute) (openpyxl.worksheet.filters.ColorFilter attribute) (openpyxl.worksheet.filters.CustomFilter attribute) (openpyxl.worksheet.filters.CustomFilters attribute) (openpyxl.worksheet.filters.DateGroupItem attribute) (openpyxl.worksheet.filters.DynamicFilter attribute) (openpyxl.worksheet.filters.FilterColumn attribute) (openpyxl.worksheet.filters.Filters attribute) (openpyxl.worksheet.filters.IconFilter attribute) (openpyxl.worksheet.filters.SortCondition attribute) (openpyxl.worksheet.filters.SortState attribute) (openpyxl.worksheet.filters.Top10 attribute) (openpyxl.worksheet.header_footer.HeaderFooter attribute) (openpyxl.worksheet.hyperlink.Hyperlink attribute) (openpyxl.worksheet.hyperlink.HyperlinkList attribute) (openpyxl.worksheet.merge.MergeCell attribute) (openpyxl.worksheet.merge.MergeCells attribute) (openpyxl.worksheet.ole.ObjectAnchor attribute) (openpyxl.worksheet.ole.ObjectPr attribute) (openpyxl.worksheet.ole.OleObject attribute) (openpyxl.worksheet.ole.OleObjects attribute) (openpyxl.worksheet.page.PageMargins attribute) (openpyxl.worksheet.page.PrintOptions attribute) (openpyxl.worksheet.page.PrintPageSetup attribute) (openpyxl.worksheet.pagebreak.Break attribute) (openpyxl.worksheet.pagebreak.ColBreak attribute) (openpyxl.worksheet.pagebreak.RowBreak attribute) (openpyxl.worksheet.picture.SheetBackgroundPicture attribute) (openpyxl.worksheet.properties.Outline attribute) (openpyxl.worksheet.properties.PageSetupProperties attribute) (openpyxl.worksheet.properties.WorksheetProperties attribute) (openpyxl.worksheet.protection.SheetProtection attribute) (openpyxl.worksheet.scenario.InputCells attribute) (openpyxl.worksheet.scenario.Scenario attribute) (openpyxl.worksheet.scenario.ScenarioList attribute) (openpyxl.worksheet.smart_tag.CellSmartTag attribute) (openpyxl.worksheet.smart_tag.CellSmartTagPr attribute) (openpyxl.worksheet.smart_tag.CellSmartTags attribute) (openpyxl.worksheet.smart_tag.SmartTags attribute) (openpyxl.worksheet.table.Table attribute) (openpyxl.worksheet.table.TableColumn attribute) (openpyxl.worksheet.table.TableFormula attribute) (openpyxl.worksheet.table.TablePartList attribute) (openpyxl.worksheet.table.TableStyleInfo attribute) (openpyxl.worksheet.table.XMLColumnProps attribute) (openpyxl.worksheet.views.SheetView attribute) (openpyxl.worksheet.views.SheetViewList attribute)

tailEnd (openpyxl.drawing.line.LineProperties attribute) Target (openpyxl.packaging.relationship.Relationship attribute) target (openpyxl.packaging.relationship.Relationship attribute) (openpyxl.worksheet.hyperlink.Hyperlink attribute) TargetMode (openpyxl.packaging.relationship.Relationship attribute) targetScreenSize (openpyxl.workbook.web.WebPublishing attribute) Template (openpyxl.packaging.extended.ExtendedProperties attribute) template (openpyxl.workbook.workbook.Workbook attribute) Text (class in openpyxl.cell.text) (class in openpyxl.chart.text) (class in openpyxl.descriptors.base) (class in openpyxl.pivot.fields) text (openpyxl.cell.rich_text.TextBlock attribute) (openpyxl.cell.text.PhoneticText attribute) (openpyxl.cell.text.RichText attribute) (openpyxl.chart.axis.DisplayUnitsLabel attribute) (openpyxl.chart.title.Title attribute) (openpyxl.comments.comment_sheet.CommentRecord attribute) (openpyxl.comments.comments.Comment property) (openpyxl.drawing.text.Paragraph attribute) (openpyxl.formatting.rule.Rule attribute) (openpyxl.worksheet.table.TableFormula attribute) text_rotation (openpyxl.styles.alignment.Alignment attribute) TextAxis (class in openpyxl.chart.axis) TextBlock (class in openpyxl.cell.rich_text) TextBody (openpyxl.chart.pivot.PivotFormat attribute) TextField (class in openpyxl.drawing.text) textHAlign (openpyxl.comments.comment_sheet.Properties attribute) textlink (openpyxl.drawing.connector.Shape attribute) TextNormalAutofit (class in openpyxl.drawing.text) TextPoint (class in openpyxl.descriptors.excel) textPropertes (openpyxl.chart.axis.DisplayUnitsLabel attribute) textProperties (openpyxl.chart.chartspace.ChartSpace attribute) (openpyxl.chart.legend.Legend attribute) (openpyxl.chart.trendline.TrendlineLabel attribute) textRotation (openpyxl.styles.alignment.Alignment attribute) textVAlign (openpyxl.comments.comment_sheet.Properties attribute) tgtFrame (openpyxl.drawing.text.Hyperlink attribute) theme (openpyxl.styles.colors.Color attribute) thickBot (openpyxl.worksheet.dimensions.RowDimension attribute) thickBottom (openpyxl.worksheet.dimensions.SheetFormatProperties attribute) thicket (openpyxl.workbook.web.WebPublishing attribute) thickTop (openpyxl.worksheet.dimensions.RowDimension attribute) (openpyxl.worksheet.dimensions.SheetFormatProperties attribute) thresh (openpyxl.drawing.effect.AlphaBiLevelEffect attribute) (openpyxl.drawing.effect.BiLevelEffect attribute) tickLblPos (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.NumericAxis attribute) (openpyxl.chart.axis.SeriesAxis attribute) (openpyxl.chart.axis.TextAxis attribute) tickLblSkip (openpyxl.chart.axis.SeriesAxis attribute) (openpyxl.chart.axis.TextAxis attribute) tickMarkSkip (openpyxl.chart.axis.SeriesAxis attribute) (openpyxl.chart.axis.TextAxis attribute) tile (openpyxl.drawing.fill.BlipFillProperties attribute) TileInfoProperties (class in openpyxl.drawing.fill) tileRect (openpyxl.drawing.fill.GradientFillProperties attribute) time (openpyxl.pivot.cache.CacheHierarchy attribute) (openpyxl.pivot.cache.OLAPKPI attribute) time_to_days() (in module openpyxl.utils.datetime) timedelta_to_days() (in module openpyxl.utils.datetime) timePeriod (openpyxl.formatting.rule.Rule attribute) tIns (openpyxl.drawing.text.RichTextProperties attribute) tint (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) (openpyxl.drawing.fill.Blip attribute) (openpyxl.styles.colors.Color attribute) TintEffect (class in openpyxl.drawing.effect) Title (class in openpyxl.chart.title) title (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.NumericAxis attribute) (openpyxl.chart.axis.SeriesAxis attribute) (openpyxl.chart.axis.TextAxis attribute) (openpyxl.chart.chartspace.ChartContainer attribute) (openpyxl.chart.series.Series attribute) (openpyxl.chartsheet.publish.WebPublishItem attribute) (openpyxl.drawing.properties.NonVisualDrawingProps attribute) (openpyxl.packaging.core.DocumentProperties attribute) (openpyxl.workbook.web.WebPublishObject attribute) (openpyxl.worksheet.print_settings.PrintTitles attribute) title_maker() (in module openpyxl.chart.title) TitleDescriptor (class in openpyxl.chart.title) TitlesOfParts (openpyxl.packaging.extended.ExtendedProperties attribute) to (openpyxl.drawing.spreadsheet_drawing.TwoCellAnchor attribute) (openpyxl.worksheet.ole.ObjectAnchor attribute) to_array() (openpyxl.styles.cell_style.CellStyle method) to_dict() (openpyxl.packaging.relationship.RelationshipList method) to_excel() (in module openpyxl.utils.datetime) to_ISO8601() (in module openpyxl.utils.datetime) to_tree() (openpyxl.cell.rich_text.CellRichText method) (openpyxl.cell.rich_text.TextBlock method) (openpyxl.chart.chartspace.ChartSpace method) (openpyxl.chart.plotarea.PlotArea method) (openpyxl.chart.series.Series method) (openpyxl.chart.text.Text method) (openpyxl.chartsheet.chartsheet.Chartsheet method) (openpyxl.comments.comment_sheet.CommentSheet method) (openpyxl.descriptors.container.ElementList method) (openpyxl.descriptors.nested.EmptyTag method) (openpyxl.descriptors.nested.Nested method) (openpyxl.descriptors.nested.NestedText method) (openpyxl.descriptors.sequence.MultiSequence method) (openpyxl.descriptors.sequence.NestedSequence method) (openpyxl.descriptors.sequence.Sequence method) (openpyxl.descriptors.sequence.ValueSequence method) (openpyxl.descriptors.serialisable.Serialisable method) (openpyxl.packaging.core.NestedDateTime method) (openpyxl.packaging.core.QualifiedDateTime method) (openpyxl.packaging.custom.CustomPropertyList method) (openpyxl.packaging.extended.ExtendedProperties method) (openpyxl.packaging.manifest.Manifest method) (openpyxl.packaging.relationship.RelationshipList method) (openpyxl.packaging.workbook.WorkbookPackage method) (openpyxl.pivot.cache.CacheDefinition method) (openpyxl.pivot.record.RecordList method) (openpyxl.pivot.table.ConditionalFormatList method) (openpyxl.pivot.table.TableDefinition method) (openpyxl.styles.fills.GradientFill method) (openpyxl.styles.fills.PatternFill method) (openpyxl.styles.stylesheet.Stylesheet method) (openpyxl.workbook.external_link.external.ExternalLink method) (openpyxl.worksheet.datavalidation.DataValidationList method) (openpyxl.worksheet.dimensions.ColumnDimension method) (openpyxl.worksheet.dimensions.DimensionHolder method) (openpyxl.worksheet.filters.StringFilter method) (openpyxl.worksheet.header_footer.HeaderFooterItem method) (openpyxl.worksheet.related.Related method) (openpyxl.worksheet.table.Table method) tooltip (openpyxl.drawing.text.Hyperlink attribute) (openpyxl.worksheet.hyperlink.Hyperlink attribute) top (openpyxl.chart.print_settings.PageMargins attribute) (openpyxl.drawing.fill.RelativeRect attribute) (openpyxl.styles.borders.Border attribute) (openpyxl.styles.fills.GradientFill attribute) (openpyxl.worksheet.cell_range.CellRange property) (openpyxl.worksheet.filters.Top10 attribute) (openpyxl.worksheet.page.PageMargins attribute) Top10 (class in openpyxl.worksheet.filters) top10 (openpyxl.worksheet.filters.FilterColumn attribute) topAutoShow (openpyxl.pivot.table.PivotField attribute) topLeftCell (openpyxl.worksheet.views.Pane attribute) (openpyxl.worksheet.views.SheetView attribute) totalsRowBorderDxfId (openpyxl.worksheet.table.Table attribute) totalsRowCellStyle (openpyxl.worksheet.table.Table attribute) (openpyxl.worksheet.table.TableColumn attribute) totalsRowCount (openpyxl.worksheet.table.Table attribute) totalsRowDxfId (openpyxl.worksheet.table.Table attribute) (openpyxl.worksheet.table.TableColumn attribute) totalsRowFormula (openpyxl.worksheet.table.TableColumn attribute) totalsRowFunction (openpyxl.worksheet.table.TableColumn attribute) totalsRowLabel (openpyxl.worksheet.table.TableColumn attribute) totalsRowShown (openpyxl.worksheet.table.Table attribute) TotalTime (openpyxl.packaging.extended.ExtendedProperties attribute) tpl (openpyxl.pivot.fields.TupleList attribute) tpls (openpyxl.pivot.cache.OLAPSet attribute) (openpyxl.pivot.cache.Query attribute) (openpyxl.pivot.fields.Error attribute) (openpyxl.pivot.fields.Missing attribute) (openpyxl.pivot.fields.Number attribute) (openpyxl.pivot.fields.Text attribute) Transform (class in openpyxl.drawing.colors) transform (openpyxl.chart.shapes.GraphicalProperties attribute) Transform2D (class in openpyxl.drawing.geometry) transitionEntry (openpyxl.worksheet.properties.WorksheetProperties attribute) transitionEvaluation (openpyxl.worksheet.properties.WorksheetProperties attribute) trend (openpyxl.pivot.cache.OLAPKPI attribute) Trendline (class in openpyxl.chart.trendline) trendline (openpyxl.chart.series.Series attribute) (openpyxl.chart.series.XYSeries attribute) TrendlineLabel (class in openpyxl.chart.trendline) trendlineLbl (openpyxl.chart.trendline.Trendline attribute) trendlineType (openpyxl.chart.trendline.Trendline attribute) Tuple (class in openpyxl.descriptors.base) (class in openpyxl.pivot.fields) TupleCache (class in openpyxl.pivot.cache) tupleCache (openpyxl.pivot.cache.CacheDefinition attribute) TupleList (class in openpyxl.pivot.fields) TwoCellAnchor (class in openpyxl.drawing.spreadsheet_drawing) twoCellAnchor (openpyxl.drawing.spreadsheet_drawing.SpreadsheetDrawing attribute) twoDigitTextYear (openpyxl.worksheet.errors.IgnoredError attribute) tx (openpyxl.chart.axis.DisplayUnitsLabel attribute) (openpyxl.chart.series.Series attribute) (openpyxl.chart.series.XYSeries attribute) (openpyxl.chart.title.Title attribute) (openpyxl.chart.trendline.TrendlineLabel attribute) (openpyxl.drawing.fill.TileInfoProperties attribute) tx1 (openpyxl.drawing.colors.ColorMapping attribute) tx2 (openpyxl.drawing.colors.ColorMapping attribute) txBax (openpyxl.drawing.properties.NonVisualDrawingShapeProps attribute) txBody (openpyxl.drawing.connector.Shape attribute) txPr (openpyxl.chart.axis.DateAxis attribute) (openpyxl.chart.axis.DisplayUnitsLabel attribute) (openpyxl.chart.axis.NumericAxis attribute) (openpyxl.chart.axis.SeriesAxis attribute) (openpyxl.chart.axis.TextAxis attribute) (openpyxl.chart.chartspace.ChartSpace attribute) (openpyxl.chart.label.DataLabel attribute) (openpyxl.chart.label.DataLabelList attribute) (openpyxl.chart.legend.Legend attribute) (openpyxl.chart.legend.LegendEntry attribute) (openpyxl.chart.pivot.PivotFormat attribute) (openpyxl.chart.plotarea.DataTable attribute) (openpyxl.chart.title.Title attribute) (openpyxl.chart.trendline.TrendlineLabel attribute) ty (openpyxl.drawing.fill.TileInfoProperties attribute) type (openpyxl.cell.text.PhoneticProperties attribute) (openpyxl.chart.pie_chart.ProjectedPieChart attribute) (openpyxl.chart.radar_chart.RadarChart attribute) (openpyxl.drawing.effect.EffectContainer attribute) (openpyxl.drawing.line.LineEndProperties attribute) (openpyxl.drawing.text.AutonumberBullet attribute) (openpyxl.drawing.text.TextField attribute) (openpyxl.formatting.rule.FormatObject attribute) (openpyxl.formatting.rule.Rule attribute) Type (openpyxl.packaging.relationship.Relationship attribute) type (openpyxl.pivot.cache.CacheSource attribute) (openpyxl.pivot.table.ConditionalFormat attribute) (openpyxl.pivot.table.PivotArea attribute) (openpyxl.pivot.table.PivotFilter attribute) (openpyxl.styles.colors.Color attribute) (openpyxl.styles.fills.GradientFill attribute) (openpyxl.styles.table.TableStyleElement attribute) (openpyxl.workbook.defined_name.DefinedName property) (openpyxl.worksheet.datavalidation.DataValidation attribute) (openpyxl.worksheet.filters.DynamicFilter attribute) (openpyxl.worksheet.smart_tag.CellSmartTag attribute) Typed (class in openpyxl.descriptors.base) typeface (openpyxl.drawing.text.Font attribute)

U

u (openpyxl.cell.text.InlineFont attribute) (openpyxl.drawing.text.CharacterProperties attribute) (openpyxl.pivot.fields.Boolean attribute) (openpyxl.pivot.fields.DateTimeField attribute) (openpyxl.pivot.fields.Error attribute) (openpyxl.pivot.fields.Missing attribute) (openpyxl.pivot.fields.Number attribute) (openpyxl.pivot.fields.Text attribute) (openpyxl.styles.fonts.Font attribute) uFill (openpyxl.drawing.text.CharacterProperties attribute) uFillTx (openpyxl.drawing.text.CharacterProperties attribute) uiObject (openpyxl.comments.comment_sheet.Properties attribute) (openpyxl.worksheet.controls.ControlProperty attribute) (openpyxl.worksheet.ole.ObjectPr attribute) uLn (openpyxl.drawing.text.CharacterProperties attribute) uLnTx (openpyxl.drawing.text.CharacterProperties attribute) un (openpyxl.pivot.fields.Error attribute) (openpyxl.pivot.fields.Missing attribute) (openpyxl.pivot.fields.Number attribute) (openpyxl.pivot.fields.Text attribute) unbalanced (openpyxl.pivot.cache.CacheHierarchy attribute) unbalancedGroup (openpyxl.pivot.cache.CacheHierarchy attribute) unbind() (openpyxl.comments.comments.Comment method) underline (openpyxl.styles.fonts.Font attribute) UNDERLINE_DOUBLE (openpyxl.styles.fonts.Font attribute) UNDERLINE_DOUBLE_ACCOUNTING (openpyxl.styles.fonts.Font attribute) UNDERLINE_SINGLE (openpyxl.styles.fonts.Font attribute) UNDERLINE_SINGLE_ACCOUNTING (openpyxl.styles.fonts.Font attribute) undone (openpyxl.worksheet.scenario.InputCells attribute) unescape() (in module openpyxl.utils.escape) union() (openpyxl.worksheet.cell_range.CellRange method) unique (openpyxl.descriptors.sequence.Sequence attribute) uniqueList (openpyxl.pivot.cache.CacheField attribute) uniqueMemberProperty (openpyxl.pivot.table.PivotField attribute)

uniqueName (openpyxl.pivot.cache.CacheHierarchy attribute) (openpyxl.pivot.cache.GroupLevel attribute) (openpyxl.pivot.cache.GroupMember attribute) (openpyxl.pivot.cache.LevelGroup attribute) (openpyxl.pivot.cache.OLAPKPI attribute) (openpyxl.pivot.cache.PivotDimension attribute) (openpyxl.worksheet.table.TableColumn attribute) uniqueParent (openpyxl.pivot.cache.LevelGroup attribute) UniqueSequence (class in openpyxl.descriptors.sequence) UniversalMeasure (class in openpyxl.descriptors.excel) unlockedFormula (openpyxl.worksheet.errors.IgnoredError attribute) unmerge_cells() (openpyxl.worksheet.worksheet.Worksheet method) up (openpyxl.drawing.geometry.Backdrop attribute) upBars (openpyxl.chart.updown_bars.UpDownBars attribute) updatedVersion (openpyxl.pivot.table.TableDefinition attribute) updateLinks (openpyxl.workbook.properties.WorkbookProperties attribute) UpDownBars (class in openpyxl.chart.updown_bars) upDownBars (openpyxl.chart.line_chart.LineChart attribute) (openpyxl.chart.line_chart.LineChart3D attribute) (openpyxl.chart.stock_chart.StockChart attribute) upgradeOnRefresh (openpyxl.pivot.cache.CacheDefinition attribute) upright (openpyxl.drawing.text.RichTextProperties attribute) uri (openpyxl.descriptors.excel.Extension attribute) (openpyxl.drawing.graphic.GraphicData attribute) (openpyxl.worksheet.errors.Extension attribute) url (openpyxl.workbook.smart_tags.SmartTag attribute) useA (openpyxl.drawing.effect.ColorChangeEffect attribute) useAutoFormatting (openpyxl.pivot.table.TableDefinition attribute) useFirstPageNumber (openpyxl.worksheet.page.PrintPageSetup attribute) usePrinterDefaults (openpyxl.worksheet.page.PrintPageSetup attribute) user (openpyxl.pivot.cache.GroupLevel attribute) (openpyxl.worksheet.scenario.Scenario attribute) userInterface (openpyxl.chart.chartspace.Protection attribute) userName (openpyxl.workbook.protection.FileSharing attribute) userShapes (openpyxl.chart.chartspace.ChartSpace attribute)

V

v (openpyxl.chart.data_source.NumVal attribute) (openpyxl.chart.data_source.StrVal attribute) (openpyxl.chart.series.SeriesLabel attribute) (openpyxl.pivot.fields.Boolean attribute) (openpyxl.pivot.fields.DateTimeField attribute) (openpyxl.pivot.fields.Error attribute) (openpyxl.pivot.fields.Index attribute) (openpyxl.pivot.fields.Number attribute) (openpyxl.pivot.fields.Text attribute) (openpyxl.workbook.external_link.external.ExternalCell attribute) vacatedStyle (openpyxl.pivot.table.TableDefinition attribute) val (openpyxl.chart.error_bar.ErrorBars attribute) (openpyxl.chart.series.Series attribute) (openpyxl.drawing.colors.SchemeColor attribute) (openpyxl.drawing.colors.SystemColor attribute) (openpyxl.formatting.rule.FormatObject attribute) (openpyxl.worksheet.filters.BlankFilter property) (openpyxl.worksheet.filters.CustomFilter attribute) (openpyxl.worksheet.filters.DynamicFilter attribute) (openpyxl.worksheet.filters.NumberFilter attribute) (openpyxl.worksheet.filters.StringFilter attribute) (openpyxl.worksheet.filters.Top10 attribute) (openpyxl.worksheet.scenario.InputCells attribute) (openpyxl.worksheet.smart_tag.CellSmartTagPr attribute) valAx (openpyxl.chart.plotarea.PlotArea attribute) validation_type (openpyxl.worksheet.datavalidation.DataValidation attribute) valIso (openpyxl.worksheet.filters.DynamicFilter attribute) value (openpyxl.cell.cell.Cell property) (openpyxl.cell.cell.MergedCell attribute) (openpyxl.cell.read_only.EmptyCell attribute) (openpyxl.cell.read_only.ReadOnlyCell property) (openpyxl.chart.series.SeriesLabel attribute) (openpyxl.drawing.text.RegularTextRun attribute) (openpyxl.packaging.custom.BoolProperty attribute) (openpyxl.packaging.custom.DateTimeProperty attribute) (openpyxl.packaging.custom.FloatProperty attribute) (openpyxl.packaging.custom.IntProperty attribute) (openpyxl.packaging.custom.LinkProperty attribute) (openpyxl.packaging.custom.StringProperty attribute) (openpyxl.pivot.cache.OLAPKPI attribute) (openpyxl.styles.colors.Color property) (openpyxl.workbook.defined_name.DefinedName attribute)

ValueDescriptor (class in openpyxl.formatting.rule) values (openpyxl.worksheet.worksheet.Worksheet property) ValueSequence (class in openpyxl.descriptors.sequence) varPSubtotal (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.Reference attribute) varSubtotal (openpyxl.pivot.table.PivotField attribute) (openpyxl.pivot.table.Reference attribute) varyColors (openpyxl.chart.area_chart.AreaChart attribute) (openpyxl.chart.area_chart.AreaChart3D attribute) (openpyxl.chart.bar_chart.BarChart attribute) (openpyxl.chart.bar_chart.BarChart3D attribute) (openpyxl.chart.bubble_chart.BubbleChart attribute) (openpyxl.chart.line_chart.LineChart attribute) (openpyxl.chart.line_chart.LineChart3D attribute) (openpyxl.chart.pie_chart.DoughnutChart attribute) (openpyxl.chart.pie_chart.PieChart attribute) (openpyxl.chart.pie_chart.PieChart3D attribute) (openpyxl.chart.pie_chart.ProjectedPieChart attribute) (openpyxl.chart.radar_chart.RadarChart attribute) (openpyxl.chart.scatter_chart.ScatterChart attribute) vbProcedure (openpyxl.workbook.defined_name.DefinedName attribute) Vector3D (class in openpyxl.drawing.geometry) VectorLpstr (class in openpyxl.packaging.extended) VectorVariant (class in openpyxl.packaging.extended) version (openpyxl.packaging.core.DocumentProperties attribute) vert (openpyxl.drawing.text.RichTextProperties attribute) vertAlign (openpyxl.cell.text.InlineFont attribute) (openpyxl.styles.fonts.Font attribute) vertical (openpyxl.styles.alignment.Alignment attribute) (openpyxl.styles.borders.Border attribute) verticalCentered (openpyxl.worksheet.page.PrintOptions attribute) verticalDpi (openpyxl.worksheet.page.PrintPageSetup attribute) vertOverflow (openpyxl.drawing.text.RichTextProperties attribute) view (openpyxl.worksheet.views.SheetView attribute) view3D (openpyxl.chart.bar_chart.BarChart3D attribute) (openpyxl.chart.chartspace.ChartContainer attribute) visibility (openpyxl.workbook.views.BookView attribute) visualProperties (openpyxl.drawing.graphic.GroupShape attribute) visualTotals (openpyxl.pivot.table.TableDefinition attribute) vm (openpyxl.workbook.external_link.external.ExternalCell attribute) vml (openpyxl.comments.shape_writer.ShapeWriter attribute) (openpyxl.workbook.web.WebPublishing attribute) vml_path (openpyxl.comments.shape_writer.ShapeWriter attribute)

W

w (openpyxl.chart.layout.ManualLayout attribute) (openpyxl.drawing.geometry.Bevel attribute) (openpyxl.drawing.geometry.Path2D attribute) (openpyxl.drawing.line.LineEndProperties attribute) (openpyxl.drawing.line.LineProperties attribute) WebPublishing (class in openpyxl.workbook.web) webPublishing (openpyxl.packaging.workbook.WorkbookPackage attribute) WebPublishItem (class in openpyxl.chartsheet.publish) webPublishItem (openpyxl.chartsheet.publish.WebPublishItems attribute) WebPublishItems (class in openpyxl.chartsheet.publish) webPublishItems (openpyxl.chartsheet.chartsheet.Chartsheet attribute) WebPublishObject (class in openpyxl.workbook.web) webPublishObject (openpyxl.workbook.web.WebPublishObjectList attribute) WebPublishObjectList (class in openpyxl.workbook.web) webPublishObjects (openpyxl.packaging.workbook.WorkbookPackage attribute) weight (openpyxl.pivot.cache.OLAPKPI attribute) whitespace() (in module openpyxl.xml.functions) width (openpyxl.chart.layout.ManualLayout attribute) (openpyxl.drawing.drawing.Drawing property) (openpyxl.drawing.geometry.PositiveSize2D attribute) (openpyxl.drawing.line.LineProperties attribute) (openpyxl.worksheet.dimensions.ColumnDimension attribute) windowHeight (openpyxl.workbook.views.BookView attribute) (openpyxl.workbook.views.CustomWorkbookView attribute) windowProtection (openpyxl.worksheet.views.SheetView attribute) windowWidth (openpyxl.workbook.views.BookView attribute) (openpyxl.workbook.views.CustomWorkbookView attribute) wireframe (openpyxl.chart.surface_chart.SurfaceChart attribute) (openpyxl.chart.surface_chart.SurfaceChart3D attribute) wMode (openpyxl.chart.layout.ManualLayout attribute) Words (openpyxl.packaging.extended.ExtendedProperties attribute) Workbook (class in openpyxl.workbook.workbook) workbook_password (openpyxl.workbook.protection.WorkbookProtection property)

workbookAlgorithmName (openpyxl.workbook.protection.WorkbookProtection attribute) WorkbookAlreadySaved workbookHashValue (openpyxl.workbook.protection.WorkbookProtection attribute) WorkbookPackage (class in openpyxl.packaging.workbook) workbookParameter (openpyxl.workbook.defined_name.DefinedName attribute) WorkbookParser (class in openpyxl.reader.workbook) workbookPassword (openpyxl.workbook.protection.WorkbookProtection property) workbookPasswordCharacterSet (openpyxl.workbook.protection.WorkbookProtection attribute) workbookPr (openpyxl.packaging.workbook.WorkbookPackage attribute) WorkbookProperties (class in openpyxl.workbook.properties) WorkbookProtection (class in openpyxl.workbook.protection) workbookProtection (openpyxl.packaging.workbook.WorkbookPackage attribute) workbookSaltValue (openpyxl.workbook.protection.WorkbookProtection attribute) workbookSpinCount (openpyxl.workbook.protection.WorkbookProtection attribute) workbookViewId (openpyxl.chartsheet.views.ChartsheetView attribute) (openpyxl.worksheet.views.SheetView attribute) Worksheet (class in openpyxl.worksheet.worksheet) WorksheetCopy (class in openpyxl.worksheet.copier) WorksheetProperties (class in openpyxl.worksheet.properties) worksheets (openpyxl.workbook.workbook.Workbook property) WorksheetSource (class in openpyxl.pivot.cache) worksheetSource (openpyxl.pivot.cache.CacheSource attribute) wrap (openpyxl.drawing.text.RichTextProperties attribute) wrap_text (openpyxl.styles.alignment.Alignment attribute) wrapText (openpyxl.styles.alignment.Alignment attribute) write() (openpyxl.comments.shape_writer.ShapeWriter method) write_data() (openpyxl.writer.excel.ExcelWriter method) write_only (openpyxl.workbook.workbook.Workbook property) write_shapes() (openpyxl.comments.comment_sheet.CommentSheet method) write_stylesheet() (in module openpyxl.styles.stylesheet) write_theme() (in module openpyxl.writer.theme) write_worksheet() (openpyxl.writer.excel.ExcelWriter method) WriteOnlyCell() (in module openpyxl.cell.cell)

X

x (openpyxl.chart.layout.ManualLayout attribute) (openpyxl.drawing.geometry.AdjPoint2D attribute) (openpyxl.drawing.geometry.Point2D attribute) (openpyxl.drawing.geometry.Point3D attribute) (openpyxl.drawing.xdr.XDRPoint2D attribute) (openpyxl.pivot.cache.FieldUsage attribute) (openpyxl.pivot.fields.Boolean attribute) (openpyxl.pivot.fields.DateTimeField attribute) (openpyxl.pivot.fields.Error attribute) (openpyxl.pivot.fields.Missing attribute) (openpyxl.pivot.fields.Number attribute) (openpyxl.pivot.fields.Text attribute) (openpyxl.pivot.record.Record attribute) (openpyxl.pivot.table.FieldItem attribute) (openpyxl.pivot.table.Reference attribute) (openpyxl.pivot.table.RowColField attribute) (openpyxl.pivot.table.RowColItem attribute) x_axis (openpyxl.chart.area_chart.AreaChart attribute) (openpyxl.chart.area_chart.AreaChart3D attribute) (openpyxl.chart.bar_chart.BarChart attribute) (openpyxl.chart.bar_chart.BarChart3D attribute) (openpyxl.chart.bubble_chart.BubbleChart attribute) (openpyxl.chart.line_chart.LineChart attribute) (openpyxl.chart.line_chart.LineChart3D attribute) (openpyxl.chart.radar_chart.RadarChart attribute) (openpyxl.chart.scatter_chart.ScatterChart attribute) (openpyxl.chart.stock_chart.StockChart attribute) (openpyxl.chart.surface_chart.SurfaceChart3D attribute)

XDRPoint2D (class in openpyxl.drawing.xdr) XDRPositiveSize2D (class in openpyxl.drawing.xdr) XDRTransform2D (class in openpyxl.drawing.xdr) xf (openpyxl.styles.cell_style.CellStyleList attribute) xfId (openpyxl.styles.cell_style.CellStyle attribute) (openpyxl.styles.cell_style.StyleArray attribute) xfrm (openpyxl.chart.shapes.GraphicalProperties attribute) (openpyxl.drawing.graphic.GraphicFrame attribute) (openpyxl.drawing.properties.GroupShapeProperties attribute) xlm (openpyxl.workbook.defined_name.DefinedName attribute) xmlBased (openpyxl.worksheet.smart_tag.CellSmartTag attribute) xmlColumnPr (openpyxl.worksheet.table.TableColumn attribute) XMLColumnProps (class in openpyxl.worksheet.table) xmlDataType (openpyxl.worksheet.table.XMLColumnProps attribute) xMode (openpyxl.chart.layout.ManualLayout attribute) xpath (openpyxl.worksheet.table.XMLColumnProps attribute) xSplit (openpyxl.worksheet.views.Pane attribute) xVal (openpyxl.chart.series.Series attribute) (openpyxl.chart.series.XYSeries attribute) xWindow (openpyxl.workbook.views.BookView attribute) (openpyxl.workbook.views.CustomWorkbookView attribute) (openpyxl.worksheet.datavalidation.DataValidationList attribute) XYSeries (class in openpyxl.chart.series)

Y

y (openpyxl.chart.layout.ManualLayout attribute) (openpyxl.drawing.geometry.AdjPoint2D attribute) (openpyxl.drawing.geometry.Point2D attribute) (openpyxl.drawing.geometry.Point3D attribute) (openpyxl.drawing.xdr.XDRPoint2D attribute) y_axis (openpyxl.chart.area_chart.AreaChart attribute) (openpyxl.chart.area_chart.AreaChart3D attribute) (openpyxl.chart.bar_chart.BarChart attribute) (openpyxl.chart.bar_chart.BarChart3D attribute) (openpyxl.chart.bubble_chart.BubbleChart attribute) (openpyxl.chart.line_chart.LineChart attribute) (openpyxl.chart.line_chart.LineChart3D attribute) (openpyxl.chart.radar_chart.RadarChart attribute) (openpyxl.chart.scatter_chart.ScatterChart attribute) (openpyxl.chart.stock_chart.StockChart attribute) (openpyxl.chart.surface_chart.SurfaceChart3D attribute)

year (openpyxl.worksheet.filters.DateGroupItem attribute) yMode (openpyxl.chart.layout.ManualLayout attribute) ySplit (openpyxl.worksheet.views.Pane attribute) yVal (openpyxl.chart.series.Series attribute) (openpyxl.chart.series.XYSeries attribute) yWindow (openpyxl.workbook.views.BookView attribute) (openpyxl.workbook.views.CustomWorkbookView attribute) (openpyxl.worksheet.datavalidation.DataValidationList attribute)

Z

z (openpyxl.drawing.geometry.Point3D attribute) (openpyxl.drawing.geometry.Shape3D attribute) z_axis (openpyxl.chart.area_chart.AreaChart3D attribute) (openpyxl.chart.bar_chart.BarChart3D attribute) (openpyxl.chart.line_chart.LineChart3D attribute) (openpyxl.chart.surface_chart.SurfaceChart3D attribute) z_order (openpyxl.worksheet.ole.ObjectAnchor attribute) zeroHeight (openpyxl.worksheet.dimensions.SheetFormatProperties attribute) zoom (openpyxl.drawing.geometry.Camera attribute)

zoomScale (openpyxl.chartsheet.views.ChartsheetView attribute) (openpyxl.worksheet.views.SheetView attribute) zoomScaleNormal (openpyxl.worksheet.views.SheetView attribute) zoomScalePageLayoutView (openpyxl.worksheet.views.SheetView attribute) zoomScaleSheetLayoutView (openpyxl.worksheet.views.SheetView attribute) zoomToFit (openpyxl.chartsheet.custom.CustomChartsheetView attribute) (openpyxl.chartsheet.views.ChartsheetView attribute) (openpyxl.worksheet.views.SheetView attribute) zVal (openpyxl.chart.series.Series attribute)