openpyxl
2.4
Manipulating a workbook in memory
Saving to a file
Loading from a file
Simple usage
Working with Pandas and NumPy
Charts
Comments
Read-only mode
Write-only mode
Working with styles
Additional Worksheet Properties
Conditional Formatting
Print Settings
Using filters and sorts
Worksheet Tables
Validating cells
Defined Names
Parsing Formulas
Protection
Development
Testing on Windows
openpyxl package
2.4.11 (2018-01-24)
2.4.10 (2018-01-19)
2.4.9 (2017-10-19)
2.4.8 (2017-05-30)
2.4.7 (2017-04-24)
2.4.6 (2017-04-14)
2.4.5 (2017-03-07)
2.4.4 (2017-02-23)
2.4.3 (unreleased)
2.4.2 (2017-01-31)
2.4.1 (2016-11-23)
2.4.0 (2016-09-15)
2.4.0-b1 (2016-06-08)
2.4.0-a1 (2016-04-11)
2.3.5 (2016-04-11)
2.3.4 (2016-03-16)
2.3.3 (2016-01-18)
2.3.2 (2015-12-07)
2.3.1 (2015-11-20)
2.3.0 (2015-10-20)
2.3.0-b2 (2015-09-04)
2.3.0-b1 (2015-06-29)
2.2.6 (unreleased)
2.2.5 (2015-06-29)
2.2.4 (2015-06-17)
2.2.3 (2015-05-26)
2.2.2 (2015-04-28)
2.2.1 (2015-03-31)
2.2.0 (2015-03-11)
2.2.0-b1 (2015-02-18)
2.1.5 (2015-02-18)
2.1.4 (2014-12-16)
2.1.3 (2014-12-09)
2.1.2 (2014-10-23)
2.1.1 (2014-10-08)
2.1.0 (2014-09-21)
2.0.5 (2014-08-08)
2.0.4 (2014-06-25)
2.0.3 (2014-05-22)
2.0.2 (2014-05-13)
2.0.1 (2014-05-13) brown bag
2.0.0 (2014-05-13) brown bag
1.8.6 (2014-05-05)
1.8.5 (2014-03-25)
1.8.4 (2014-02-25)
1.8.3 (2014-02-09)
1.8.2 (2014-01-17)
1.8.1 (2014-01-14)
1.8.0 (2014-01-08)
1.7.0 (2013-10-31)
openpyxl
Docs
»
Index
Edit on Bitbucket
Index
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
J
|
K
|
L
|
M
|
N
|
O
|
P
|
Q
|
R
|
S
|
T
|
U
|
V
|
W
|
X
|
Y
|
Z
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)
AbstractCell (class in openpyxl.cell.interface)
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)
active (openpyxl.workbook.parser.WorkbookPackage attribute)
(openpyxl.workbook.workbook.Workbook attribute)
active_cell (openpyxl.worksheet.worksheet.Worksheet attribute)
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.worksheet.datavalidation.DataValidation 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_range() (openpyxl.workbook.workbook.Workbook method)
add_named_style() (openpyxl.workbook.workbook.Workbook method)
add_print_title() (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.shapes)
AdjustHandleList (class in openpyxl.drawing.shapes)
ahLst (openpyxl.drawing.shapes.CustomGeometry2D attribute)
algn (openpyxl.drawing.effect.OuterShadowEffect 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 attribute)
(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)
allow_blank (openpyxl.worksheet.datavalidation.DataValidation attribute)
allow_none (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)
alpha (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.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.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)
amt (openpyxl.drawing.effect.AlphaModulateFixedEffect attribute)
(openpyxl.drawing.effect.TintEffect attribute)
anchor (openpyxl.cell.cell.Cell attribute)
(openpyxl.comments.comment_sheet.Properties attribute)
(openpyxl.drawing.drawing.Drawing attribute)
(openpyxl.drawing.shapes.Backdrop attribute)
(openpyxl.drawing.text.RichTextProperties attribute)
anchor() (openpyxl.drawing.image.Image method)
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.shapes.ConnectionSite attribute)
angle_to_degrees() (in module openpyxl.utils.units)
append() (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.workbook.defined_name.DefinedNameList method)
(openpyxl.worksheet.datavalidation.DataValidationList method)
(openpyxl.worksheet.hyperlink.HyperlinkList method)
(openpyxl.worksheet.pagebreak.PageBreak method)
(openpyxl.worksheet.table.TablePartList method)
(openpyxl.worksheet.worksheet.Worksheet method)
(openpyxl.writer.write_only.WriteOnlyWorksheet method)
Application (openpyxl.packaging.extended.ExtendedProperties attribute)
apply_stylesheet() (in module openpyxl.styles.stylesheet)
applyAlignment (openpyxl.styles.cell_style.CellStyle attribute)
applyBorder (openpyxl.styles.cell_style.CellStyle attribute)
applyFill (openpyxl.styles.cell_style.CellStyle attribute)
applyFont (openpyxl.styles.cell_style.CellStyle attribute)
applyNumberFormat (openpyxl.styles.cell_style.CellStyle attribute)
applyProtection (openpyxl.styles.cell_style.CellStyle attribute)
applyStyles (openpyxl.worksheet.properties.Outline attribute)
applyToEnd (openpyxl.chart.picture.PictureOptions attribute)
applyToFront (openpyxl.chart.picture.PictureOptions attribute)
applyToSides (openpyxl.chart.picture.PictureOptions attribute)
appName (openpyxl.workbook.properties.FileVersion attribute)
AppVersion (openpyxl.packaging.extended.ExtendedProperties attribute)
area3DChart (openpyxl.chart.chartspace.PlotArea attribute)
AreaChart (class in openpyxl.chart.area_chart)
areaChart (openpyxl.chart.chartspace.PlotArea attribute)
AreaChart3D (class in openpyxl.chart.area_chart)
array (openpyxl.worksheet.table.TableFormula attribute)
ArrayDescriptor (class in openpyxl.styles.cell_style)
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.packaging.workbook.WorkbookParser method)
attr_text (openpyxl.workbook.defined_name.DefinedName attribute)
(openpyxl.worksheet.table.TableFormula attribute)
attribute (openpyxl.descriptors.nested.Nested attribute)
(openpyxl.descriptors.sequence.ValueSequence 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)
autoFill (openpyxl.comments.comment_sheet.Properties attribute)
AutoFilter (class in openpyxl.worksheet.filters)
autoFilter (openpyxl.worksheet.protection.SheetProtection attribute)
(openpyxl.worksheet.table.Table attribute)
autoFilterDateGrouping (openpyxl.workbook.views.BookView attribute)
autoLine (openpyxl.comments.comment_sheet.Properties attribute)
AutonumberBullet (class in openpyxl.drawing.text)
autoPageBreaks (openpyxl.worksheet.page.PrintPageSetup attribute)
(openpyxl.worksheet.properties.PageSetupProperties attribute)
autoRecover (openpyxl.workbook.parser.FileRecoveryProperties attribute)
autoRepublish (openpyxl.chartsheet.publish.WebPublishItem attribute)
(openpyxl.workbook.web.WebPublishObject attribute)
autoScale (openpyxl.comments.comment_sheet.Properties attribute)
autoTitleDeleted (openpyxl.chart.chartspace.ChartContainer attribute)
autoUpdate (openpyxl.chart.chartspace.ExternalData attribute)
(openpyxl.workbook.views.CustomWorkbookView attribute)
avLst (openpyxl.drawing.shapes.CustomGeometry2D attribute)
(openpyxl.drawing.shapes.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)
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.shapes.GeomRect attribute)
(openpyxl.drawing.text.CharacterProperties attribute)
(openpyxl.styles.fonts.Font attribute)
Backdrop (class in openpyxl.drawing.shapes)
backdrop (openpyxl.drawing.shapes.Scene3D attribute)
background (openpyxl.drawing.fill.PatternFillProperties 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.chartspace.PlotArea attribute)
BarChart (class in openpyxl.chart.bar_chart)
barChart (openpyxl.chart.chartspace.PlotArea attribute)
BarChart3D (class in openpyxl.chart.bar_chart)
barDir (openpyxl.chart.bar_chart.BarChart attribute)
(openpyxl.chart.bar_chart.BarChart3D attribute)
Base64Binary (class in openpyxl.descriptors.excel)
base_date (openpyxl.cell.cell.Cell attribute)
(openpyxl.cell.interface.AbstractCell attribute)
(openpyxl.cell.read_only.ReadOnlyCell attribute)
baseColWidth (openpyxl.worksheet.dimensions.SheetFormatProperties attribute)
baseline (openpyxl.drawing.text.CharacterProperties attribute)
baseTimeUnit (openpyxl.chart.axis.DateAxis attribute)
bestFit (openpyxl.worksheet.dimensions.ColumnDimension attribute)
Bevel (class in openpyxl.drawing.shapes)
bevel (openpyxl.drawing.line.LineProperties attribute)
bevelB (openpyxl.drawing.shapes.Shape3D attribute)
bevelT (openpyxl.drawing.shapes.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)
blend (openpyxl.drawing.effect.FillOverlayEffect attribute)
Blip (class in openpyxl.drawing.fill)
blip (openpyxl.drawing.fill.BlipFillProperties attribute)
blipFill (openpyxl.drawing.graphic.PictureFrame attribute)
(openpyxl.drawing.text.CharacterProperties attribute)
BlipFillProperties (class in openpyxl.drawing.fill)
blue (openpyxl.drawing.colors.SystemColor attribute)
blueMod (openpyxl.drawing.colors.SystemColor attribute)
blueOff (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.OuterShadowEffect 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.workbook.parser.WorkbookPackage attribute)
Bool (class in openpyxl.descriptors.base)
Border (class in openpyxl.styles.borders)
border (openpyxl.cell.read_only.EmptyCell attribute)
(openpyxl.cell.read_only.ReadOnlyCell attribute)
(openpyxl.styles.differential.DifferentialStyle attribute)
(openpyxl.styles.named_styles.NamedStyle attribute)
(openpyxl.styles.styleable.StyleableObject attribute)
border_color (openpyxl.drawing.shape.Shape attribute)
border_style (openpyxl.styles.borders.Side attribute)
border_width (openpyxl.drawing.shape.Shape 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.page.PageMargins attribute)
boundaries (openpyxl.worksheet.dimensions.SheetDimension attribute)
BoundDictionary (class in openpyxl.utils.bound_dictionary)
bounding_box() (in module openpyxl.drawing.image)
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.PageBreak 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.chartspace.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.graphic.GroupShapeProperties attribute)
C
cacheId (openpyxl.workbook.pivot.PivotCache 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.workbook.parser.WorkbookPackage attribute)
CalcProperties (class in openpyxl.workbook.properties)
calculate_dimension() (openpyxl.worksheet.read_only.ReadOnlyWorksheet method)
(openpyxl.worksheet.worksheet.Worksheet method)
calculatedColumnFormula (openpyxl.worksheet.table.TableColumn attribute)
calendarType (openpyxl.worksheet.filters.Filters attribute)
Camera (class in openpyxl.drawing.shapes)
camera (openpyxl.drawing.shapes.Scene3D attribute)
cap (openpyxl.drawing.line.LineProperties attribute)
(openpyxl.drawing.text.CharacterProperties attribute)
caseSensitive (openpyxl.worksheet.filters.SortState attribute)
cat (openpyxl.chart.series.Series attribute)
catAx (openpyxl.chart.chartspace.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)
CELL_TAG (openpyxl.reader.worksheet.WorkSheetParser attribute)
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)
cells (openpyxl.chart.reference.Reference 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)
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)
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)
ChartContainer (class in openpyxl.chart.chartspace)
ChartLines (class in openpyxl.chart.axis)
chartObject (openpyxl.chart.chartspace.Protection attribute)
ChartRelation (class in openpyxl.drawing.graphic)
Chartsheet (class in openpyxl.chartsheet.chartsheet)
ChartsheetProperties (class in openpyxl.chartsheet.properties)
ChartsheetProtection (class in openpyxl.chartsheet.protection)
chartsheets (openpyxl.workbook.workbook.Workbook attribute)
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.graphic.GroupTransform2D attribute)
chf (openpyxl.chartsheet.relation.DrawingHF attribute)
ChildSheet (class in openpyxl.workbook.parser)
cho (openpyxl.chartsheet.relation.DrawingHF attribute)
chOff (openpyxl.drawing.graphic.GroupTransform2D 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)
(openpyxl.writer.write_only.WriteOnlyWorksheet 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.graphic.ConnectorNonVisual attribute)
cNvGraphicFramePr (openpyxl.drawing.graphic.NonVisualGraphicFrame attribute)
cNvGrpSpPr (openpyxl.drawing.graphic.NonVisualGroupShape attribute)
cNvPicPr (openpyxl.drawing.graphic.PictureNonVisual attribute)
cNvPr (openpyxl.drawing.graphic.ConnectorNonVisual attribute)
(openpyxl.drawing.graphic.NonVisualGraphicFrame attribute)
(openpyxl.drawing.graphic.NonVisualGroupShape attribute)
(openpyxl.drawing.graphic.PictureNonVisual attribute)
(openpyxl.drawing.graphic.ShapeMeta attribute)
cNvSpPr (openpyxl.drawing.graphic.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 attribute)
colHidden (openpyxl.comments.comment_sheet.Properties attribute)
colId (openpyxl.worksheet.filters.FilterColumn attribute)
collapse_cell_addresses() (in module openpyxl.worksheet.datavalidation)
collapsed (openpyxl.worksheet.dimensions.ColumnDimension attribute)
(openpyxl.worksheet.dimensions.Dimension 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.drawing.shape.Shape attribute)
(openpyxl.formatting.rule.ColorScale attribute)
(openpyxl.formatting.rule.DataBar attribute)
(openpyxl.styles.borders.Side attribute)
(openpyxl.styles.colors.MRUColorList 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)
cols (openpyxl.chart.reference.Reference attribute)
cols_from_range() (in module openpyxl.utils.cell)
column (openpyxl.cell.cell.Cell attribute)
(openpyxl.cell.read_only.ReadOnlyCell attribute)
column_index_from_string() (in module openpyxl.utils.cell)
ColumnDimension (class in openpyxl.worksheet.dimensions)
columns (openpyxl.worksheet.worksheet.Worksheet attribute)
columnSort (openpyxl.worksheet.filters.SortState attribute)
Comment (class in openpyxl.comments.comments)
comment (openpyxl.cell.cell.Cell attribute)
(openpyxl.cell.interface.AbstractCell attribute)
(openpyxl.workbook.defined_name.DefinedName 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 attribute)
CommentSheet (class in openpyxl.comments.comment_sheet)
comp (openpyxl.drawing.colors.SystemColor 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)
ConditionalFormatting (class in openpyxl.formatting.formatting)
ConditionalFormattingList (class in openpyxl.formatting.formatting)
conformance (openpyxl.workbook.parser.WorkbookPackage attribute)
Connection (class in openpyxl.drawing.graphic)
connectionId (openpyxl.worksheet.table.Table attribute)
ConnectionSite (class in openpyxl.drawing.shapes)
ConnectionSiteList (class in openpyxl.drawing.shapes)
ConnectorLocking (class in openpyxl.drawing.graphic)
ConnectorNonVisual (class in openpyxl.drawing.graphic)
cont (openpyxl.drawing.effect.AlphaModulateEffect attribute)
content (openpyxl.cell.text.Text attribute)
(openpyxl.chartsheet.protection.ChartsheetProtection attribute)
(openpyxl.comments.comment_sheet.CommentRecord attribute)
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.shapes.Shape3D attribute)
contourW (openpyxl.drawing.shapes.Shape3D attribute)
contrast (openpyxl.drawing.effect.LuminanceEffect attribute)
Convertible (class in openpyxl.descriptors.base)
coordinate (openpyxl.cell.cell.Cell attribute)
(openpyxl.cell.interface.AbstractCell attribute)
(openpyxl.cell.read_only.ReadOnlyCell attribute)
coordinate_from_string() (in module openpyxl.utils.cell)
coordinate_to_tuple() (in module openpyxl.utils.cell)
coordinates (openpyxl.drawing.shape.Shape attribute)
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.styles.cell_style.CellStyleList attribute)
(openpyxl.styles.numbers.NumberFormatList attribute)
(openpyxl.styles.table.TableStyle attribute)
(openpyxl.styles.table.TableStyleList attribute)
(openpyxl.workbook.web.WebPublishObjectList attribute)
(openpyxl.worksheet.datavalidation.DataValidationList attribute)
(openpyxl.worksheet.merge.MergeCells attribute)
(openpyxl.worksheet.pagebreak.PageBreak attribute)
(openpyxl.worksheet.table.TablePartList attribute)
crashSave (openpyxl.workbook.parser.FileRecoveryProperties attribute)
create_chartsheet() (openpyxl.workbook.workbook.Workbook method)
create_named_range() (openpyxl.workbook.workbook.Workbook method)
create_sheet() (openpyxl.workbook.workbook.Workbook method)
create_temporary_file() (in module openpyxl.writer.write_only)
created (openpyxl.packaging.core.DocumentProperties 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)
custDash (openpyxl.drawing.line.LineProperties attribute)
custGeom (openpyxl.chart.shapes.GraphicalProperties attribute)
custom_formats (openpyxl.styles.stylesheet.Stylesheet attribute)
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 attribute)
CustomGeometry2D (class in openpyxl.drawing.shapes)
customHeight (openpyxl.worksheet.dimensions.RowDimension attribute)
(openpyxl.worksheet.dimensions.SheetFormatProperties attribute)
customList (openpyxl.worksheet.filters.SortCondition attribute)
customMenu (openpyxl.workbook.defined_name.DefinedName 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 attribute)
CustomWorkbookView (class in openpyxl.workbook.views)
customWorkbookViews (openpyxl.workbook.parser.WorkbookPackage attribute)
custSplit (openpyxl.chart.pie_chart.ProjectedPieChart attribute)
custUnit (openpyxl.chart.axis.DisplayUnitsLabelList attribute)
cx (openpyxl.drawing.shapes.PositiveSize2D attribute)
cxn (openpyxl.drawing.shapes.ConnectionSiteList attribute)
cxnLst (openpyxl.drawing.shapes.CustomGeometry2D attribute)
cxnSp (openpyxl.drawing.spreadsheet_drawing.AbsoluteAnchor attribute)
(openpyxl.drawing.spreadsheet_drawing.OneCellAnchor attribute)
(openpyxl.drawing.spreadsheet_drawing.TwoCellAnchor attribute)
cxnSpLocks (openpyxl.drawing.graphic.NonVisualConnectorProperties attribute)
cy (openpyxl.drawing.shapes.PositiveSize2D attribute)
D
d (openpyxl.drawing.line.DashStop 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 attribute)
data_points (openpyxl.chart.series.Series attribute)
data_type (openpyxl.cell.cell.Cell 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)
dataCellStyle (openpyxl.worksheet.table.Table attribute)
(openpyxl.worksheet.table.TableColumn attribute)
dataDxfId (openpyxl.worksheet.table.Table attribute)
(openpyxl.worksheet.table.TableColumn attribute)
dataExtractLoad (openpyxl.workbook.parser.FileRecoveryProperties attribute)
dataframe_to_rows() (in module openpyxl.utils.dataframe)
DataLabel (class in openpyxl.chart.label)
(openpyxl.chart.chartspace.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)
DataPoint (class in openpyxl.chart.marker)
DataTable (class in openpyxl.chart.chartspace)
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.chartspace.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)
datetime_to_W3CDTF() (in module openpyxl.utils.datetime)
dateTimeGrouping (openpyxl.worksheet.filters.DateGroupItem attribute)
day (openpyxl.worksheet.filters.DateGroupItem attribute)
days_to_time() (in module openpyxl.utils.datetime)
Default (class in openpyxl.descriptors.base)
(openpyxl.packaging.manifest.Manifest attribute)
DEFAULT_HEADER (in module openpyxl.utils.units)
defaultColWidth (openpyxl.worksheet.dimensions.SheetFormatProperties attribute)
defaultGridColor (openpyxl.worksheet.views.SheetView attribute)
defaultPivotStyle (openpyxl.styles.table.TableStyleList attribute)
defaultRowHeight (openpyxl.worksheet.dimensions.SheetFormatProperties attribute)
defaultSize (openpyxl.comments.comment_sheet.Properties 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)
DefinedNameList (class in openpyxl.workbook.defined_name)
definedNames (openpyxl.workbook.external_link.external.ExternalBook attribute)
(openpyxl.workbook.parser.WorkbookPackage attribute)
defPPr (openpyxl.drawing.text.ListStyle attribute)
defRPr (openpyxl.drawing.text.ParagraphProperties attribute)
defTabSz (openpyxl.drawing.text.ParagraphProperties attribute)
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() (openpyxl.workbook.defined_name.DefinedNameList method)
deleteColumns (openpyxl.worksheet.protection.SheetProtection attribute)
deleteRows (openpyxl.worksheet.protection.SheetProtection attribute)
denormalized (openpyxl.worksheet.table.XMLColumnProps attribute)
descending (openpyxl.worksheet.filters.SortCondition attribute)
descr (openpyxl.drawing.graphic.NonVisualDrawingProps attribute)
description (openpyxl.packaging.core.DocumentProperties 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 attribute)
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)
DimensionHolder (class in openpyxl.worksheet.dimensions)
dimensions (openpyxl.worksheet.worksheet.Worksheet attribute)
dir (openpyxl.drawing.effect.InnerShadowEffect attribute)
(openpyxl.drawing.effect.OuterShadowEffect attribute)
(openpyxl.drawing.effect.PresetShadowEffect attribute)
(openpyxl.drawing.effect.ReflectionEffect attribute)
(openpyxl.drawing.shapes.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)
disablePrompts (openpyxl.worksheet.datavalidation.DataValidationList attribute)
dispBlanksAs (openpyxl.chart.chartspace.ChartContainer attribute)
dispEq (openpyxl.chart.trendline.Trendline attribute)
display (openpyxl.worksheet.hyperlink.Hyperlink 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.OuterShadowEffect 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.chartspace.PivotFormat attribute)
(openpyxl.chart.label.DataLabelList 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.chartspace.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)
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)
dst() (openpyxl.utils.datetime.GMT method)
dTable (openpyxl.chart.chartspace.PlotArea attribute)
DummyWorksheet (class in openpyxl.chart.reference)
duotone (openpyxl.drawing.fill.Blip attribute)
DuotoneEffect (class in openpyxl.drawing.effect)
dx (openpyxl.drawing.shapes.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.styles.table.TableStyleElement attribute)
(openpyxl.worksheet.filters.ColorFilter attribute)
(openpyxl.worksheet.filters.SortCondition attribute)
dxfs (openpyxl.styles.stylesheet.Stylesheet attribute)
dy (openpyxl.drawing.shapes.Vector3D attribute)
DynamicFilter (class in openpyxl.worksheet.filters)
dynamicFilter (openpyxl.worksheet.filters.FilterColumn attribute)
dz (openpyxl.drawing.shapes.Vector3D attribute)
E
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)
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.shapes.ShapeStyle attribute)
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)
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)
enableFormatConditionsCalculation (openpyxl.worksheet.properties.WorksheetProperties attribute)
encoding (openpyxl.cell.cell.Cell attribute)
(openpyxl.cell.interface.AbstractCell attribute)
end (openpyxl.styles.borders.Border attribute)
end_color (openpyxl.styles.fills.PatternFill attribute)
endA (openpyxl.drawing.effect.ReflectionEffect attribute)
endCxn (openpyxl.drawing.graphic.NonVisualConnectorProperties attribute)
endParaRPr (openpyxl.drawing.text.Paragraph attribute)
endPos (openpyxl.drawing.effect.ReflectionEffect attribute)
endSnd (openpyxl.drawing.text.Hyperlink attribute)
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 (openpyxl.worksheet.datavalidation.DataValidation attribute)
ERROR_CODES (openpyxl.cell.cell.Cell attribute)
ErrorBars (class in openpyxl.chart.error_bar)
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)
etree_write_cell() (in module openpyxl.writer.etree_worksheet)
evenFooter (openpyxl.worksheet.header_footer.HeaderFooter attribute)
evenHeader (openpyxl.worksheet.header_footer.HeaderFooter attribute)
ExcelWriter (class in openpyxl.writer.excel)
expand_cell_ranges() (in module openpyxl.worksheet.datavalidation)
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.excel.TextPoint attribute)
(openpyxl.descriptors.sequence.Sequence attribute)
(openpyxl.drawing.colors.ColorChoiceDescriptor attribute)
(openpyxl.packaging.core.NestedDateTime attribute)
(openpyxl.styles.colors.ColorDescriptor attribute)
(openpyxl.styles.colors.RGB attribute)
explosion (openpyxl.chart.marker.DataPoint attribute)
(openpyxl.chart.series.Series attribute)
ext (openpyxl.descriptors.excel.ExtensionList attribute)
(openpyxl.drawing.graphic.GroupTransform2D attribute)
(openpyxl.drawing.shapes.Transform2D attribute)
(openpyxl.drawing.spreadsheet_drawing.AbsoluteAnchor attribute)
(openpyxl.drawing.spreadsheet_drawing.OneCellAnchor attribute)
extend (openpyxl.cell.text.InlineFont attribute)
(openpyxl.styles.fonts.Font attribute)
ExtendedProperties (class in openpyxl.packaging.extended)
Extension (class in openpyxl.descriptors.excel)
(openpyxl.packaging.manifest.FileExtension attribute)
ExtensionList (class in openpyxl.descriptors.excel)
extensions (openpyxl.packaging.manifest.Manifest attribute)
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.workbook.parser.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.chartspace.DataTable attribute)
(openpyxl.chart.chartspace.PivotFormat attribute)
(openpyxl.chart.chartspace.PivotSource attribute)
(openpyxl.chart.chartspace.PlotArea 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.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.fill.Blip attribute)
(openpyxl.drawing.graphic.ConnectorLocking attribute)
(openpyxl.drawing.graphic.GraphicFrameLocking attribute)
(openpyxl.drawing.graphic.GroupLocking attribute)
(openpyxl.drawing.graphic.GroupShapeProperties attribute)
(openpyxl.drawing.graphic.NonVisualConnectorProperties attribute)
(openpyxl.drawing.graphic.NonVisualDrawingProps attribute)
(openpyxl.drawing.graphic.NonVisualDrawingShapeProps attribute)
(openpyxl.drawing.graphic.NonVisualGraphicFrameProperties attribute)
(openpyxl.drawing.graphic.NonVisualGroupDrawingShapeProps attribute)
(openpyxl.drawing.graphic.NonVisualPictureProperties attribute)
(openpyxl.drawing.graphic.PictureLocking attribute)
(openpyxl.drawing.line.LineProperties attribute)
(openpyxl.drawing.shapes.Backdrop attribute)
(openpyxl.drawing.shapes.Scene3D attribute)
(openpyxl.drawing.shapes.Shape3D 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.styles.cell_style.CellStyle attribute)
(openpyxl.styles.stylesheet.Stylesheet attribute)
(openpyxl.workbook.parser.WorkbookPackage attribute)
(openpyxl.workbook.views.BookView attribute)
(openpyxl.workbook.views.CustomWorkbookView 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.shapes.Shape3D attribute)
extrusionH (openpyxl.drawing.shapes.Shape3D attribute)
extrusionOk (openpyxl.drawing.shapes.Path2D attribute)
F
f (openpyxl.chart.data_source.NumRef attribute)
(openpyxl.chart.data_source.StrRef attribute)
fadeDir (openpyxl.drawing.effect.ReflectionEffect attribute)
family (openpyxl.cell.text.InlineFont attribute)
(openpyxl.styles.fonts.Font attribute)
fgClr (openpyxl.drawing.fill.PatternFillProperties attribute)
fgColor (openpyxl.styles.fills.PatternFill attribute)
file_link (openpyxl.workbook.external_link.external.ExternalLink attribute)
FileExtension (class in openpyxl.packaging.manifest)
filename (openpyxl.writer.write_only.WriteOnlyWorksheet attribute)
filenames (openpyxl.packaging.manifest.Manifest attribute)
fileRecoveryPr (openpyxl.workbook.parser.WorkbookPackage attribute)
FileRecoveryProperties (class in openpyxl.workbook.parser)
FileSharing (class in openpyxl.workbook.protection)
fileSharing (openpyxl.workbook.parser.WorkbookPackage attribute)
FileVersion (class in openpyxl.workbook.properties)
fileVersion (openpyxl.workbook.parser.WorkbookPackage attribute)
Fill (class in openpyxl.styles.fills)
fill (openpyxl.cell.read_only.EmptyCell attribute)
(openpyxl.cell.read_only.ReadOnlyCell attribute)
(openpyxl.drawing.shapes.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.shapes.ShapeStyle attribute)
fills (openpyxl.styles.stylesheet.Stylesheet attribute)
fillToRect (openpyxl.drawing.fill.PathShadeProperties attribute)
filter (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.worksheet.filters.FilterColumn attribute)
filterVal (openpyxl.worksheet.filters.Top10 attribute)
find() (openpyxl.packaging.manifest.Manifest method)
(openpyxl.packaging.relationship.RelationshipList method)
find_sheets() (openpyxl.packaging.workbook.WorkbookParser method)
firstFooter (openpyxl.worksheet.header_footer.HeaderFooter attribute)
firstHeader (openpyxl.worksheet.header_footer.HeaderFooter 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 attribute)
(openpyxl.worksheet.properties.PageSetupProperties attribute)
fitToWidth (openpyxl.worksheet.page.PrintPageSetup attribute)
flatten() (in module openpyxl.worksheet.worksheet)
flatTx (openpyxl.drawing.text.RichTextProperties attribute)
fld (openpyxl.drawing.text.Paragraph attribute)
flip (openpyxl.drawing.fill.GradientFillProperties attribute)
(openpyxl.drawing.fill.TileInfoProperties attribute)
flipH (openpyxl.drawing.graphic.GroupTransform2D attribute)
(openpyxl.drawing.shapes.Transform2D attribute)
flipV (openpyxl.drawing.graphic.GroupTransform2D attribute)
(openpyxl.drawing.shapes.Transform2D attribute)
Float (class in openpyxl.descriptors.base)
fLocksWithSheet (openpyxl.drawing.spreadsheet_drawing.AnchorClientData attribute)
floor (openpyxl.chart.bar_chart.BarChart3D attribute)
(openpyxl.chart.chartspace.ChartContainer attribute)
fmla (openpyxl.drawing.shapes.GeomGuide attribute)
(openpyxl.drawing.text.GeomGuide attribute)
fmtId (openpyxl.chart.chartspace.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 attribute)
(openpyxl.cell.text.RichText attribute)
(openpyxl.styles.differential.DifferentialStyle attribute)
(openpyxl.styles.named_styles.NamedStyle attribute)
(openpyxl.styles.styleable.StyleableObject attribute)
FONT_HEIGHT (openpyxl.drawing.shape.Shape attribute)
FONT_WIDTH (openpyxl.drawing.shape.Shape 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.shapes.ShapeStyle attribute)
FontReference (class in openpyxl.drawing.shapes)
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)
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)
formatted (openpyxl.cell.text.Text attribute)
formatting (openpyxl.chart.chartspace.Protection attribute)
formula (openpyxl.formatting.rule.Rule attribute)
formula1 (openpyxl.worksheet.datavalidation.DataValidation attribute)
formula2 (openpyxl.worksheet.datavalidation.DataValidation attribute)
FORMULA_TAG (openpyxl.reader.worksheet.WorkSheetParser attribute)
FormulaRule() (in module openpyxl.formatting.rule)
forward (openpyxl.chart.trendline.Trendline attribute)
fov (openpyxl.drawing.shapes.Camera attribute)
fPrintsWithSheet (openpyxl.drawing.spreadsheet_drawing.AnchorClientData attribute)
fPublished (openpyxl.drawing.graphic.GraphicFrame attribute)
(openpyxl.drawing.graphic.PictureFrame attribute)
(openpyxl.drawing.graphic.Shape attribute)
freeze_panes (openpyxl.worksheet.worksheet.Worksheet attribute)
(openpyxl.writer.write_only.WriteOnlyWorksheet attribute)
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_tree() (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.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.workbook.parser.WorkbookPackage attribute)
G
g (openpyxl.drawing.colors.RGBPercent attribute)
gamma (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.shapes.GeomGuideList attribute)
(openpyxl.drawing.text.GeomGuideList attribute)
gdLst (openpyxl.drawing.shapes.CustomGeometry2D attribute)
GeomGuide (class in openpyxl.drawing.shapes)
(class in openpyxl.drawing.text)
GeomGuideList (class in openpyxl.drawing.shapes)
(class in openpyxl.drawing.text)
GeomRect (class in openpyxl.drawing.shapes)
get() (openpyxl.workbook.defined_name.DefinedNameList method)
get_active_sheet() (in module openpyxl.writer.workbook)
(openpyxl.workbook.workbook.Workbook method)
get_cell_collection() (openpyxl.worksheet.worksheet.Worksheet 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_emu_dimensions() (openpyxl.drawing.drawing.Drawing method)
get_index() (openpyxl.workbook.workbook.Workbook method)
get_named_range() (openpyxl.workbook.workbook.Workbook method)
(openpyxl.worksheet.worksheet.Worksheet method)
get_named_ranges() (openpyxl.workbook.workbook.Workbook method)
get_rels_path() (in module openpyxl.packaging.relationship)
get_rows_to_write() (in module openpyxl.writer.etree_worksheet)
get_sheet_by_name() (openpyxl.workbook.workbook.Workbook method)
get_sheet_names() (openpyxl.workbook.workbook.Workbook method)
get_squared_range() (openpyxl.worksheet.read_only.ReadOnlyWorksheet method)
(openpyxl.worksheet.worksheet.Worksheet method)
glow (openpyxl.drawing.effect.EffectList attribute)
GlowEffect (class in openpyxl.drawing.effect)
GMT (class in openpyxl.utils.datetime)
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)
GradientStopList (class in openpyxl.drawing.fill)
graphic (openpyxl.drawing.graphic.GraphicFrame attribute)
GraphicalProperties (class in openpyxl.chart.shapes)
graphicalProperties (openpyxl.chart.axis.ChartLines attribute)
(openpyxl.chart.axis.DisplayUnitsLabel attribute)
(openpyxl.chart.chartspace.ChartSpace attribute)
(openpyxl.chart.chartspace.DataTable attribute)
(openpyxl.chart.chartspace.PivotFormat attribute)
(openpyxl.chart.chartspace.PlotArea attribute)
(openpyxl.chart.error_bar.ErrorBars attribute)
(openpyxl.chart.legend.Legend attribute)
(openpyxl.chart.marker.DataPoint attribute)
(openpyxl.chart.marker.Marker 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.graphic.PictureFrame attribute)
(openpyxl.drawing.graphic.Shape 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.SystemColor attribute)
GrayscaleEffect (class in openpyxl.drawing.effect)
grayscl (openpyxl.drawing.fill.Blip attribute)
green (openpyxl.drawing.colors.SystemColor attribute)
greenMod (openpyxl.drawing.colors.SystemColor attribute)
greenOff (openpyxl.drawing.colors.SystemColor attribute)
gridLines (openpyxl.worksheet.page.PrintOptions attribute)
gridLinesSet (openpyxl.worksheet.page.PrintOptions attribute)
group() (openpyxl.worksheet.dimensions.DimensionHolder method)
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)
GroupLocking (class in openpyxl.drawing.graphic)
GroupShape (class in openpyxl.drawing.graphic)
GroupShapeProperties (class in openpyxl.drawing.graphic)
GroupTransform2D (class in openpyxl.drawing.graphic)
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.graphic.NonVisualGroupDrawingShapeProps attribute)
grpSpPr (openpyxl.drawing.graphic.GroupShape attribute)
gs (openpyxl.drawing.fill.GradientStopList attribute)
gsLst (openpyxl.drawing.fill.GradientFillProperties attribute)
gte (openpyxl.formatting.rule.FormatObject attribute)
guess_types (openpyxl.cell.cell.Cell attribute)
(openpyxl.cell.interface.AbstractCell 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.shapes.Bevel attribute)
(openpyxl.drawing.shapes.Path2D attribute)
hangingPunct (openpyxl.drawing.text.ParagraphProperties attribute)
has_style (openpyxl.styles.styleable.StyleableObject attribute)
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)
(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 attribute)
(openpyxl.drawing.shapes.PositiveSize2D attribute)
(openpyxl.worksheet.dimensions.RowDimension attribute)
help (openpyxl.workbook.defined_name.DefinedName attribute)
HexBinary (class in openpyxl.descriptors.excel)
hidden (openpyxl.drawing.graphic.NonVisualDrawingProps attribute)
(openpyxl.styles.named_styles.NamedStyle attribute)
(openpyxl.styles.protection.Protection attribute)
(openpyxl.workbook.defined_name.DefinedName attribute)
(openpyxl.worksheet.dimensions.Dimension attribute)
hiddenButton (openpyxl.worksheet.filters.FilterColumn attribute)
HiddenSlides (openpyxl.packaging.extended.ExtendedProperties attribute)
hide_drop_down (openpyxl.worksheet.datavalidation.DataValidation attribute)
hidePivotFieldList (openpyxl.workbook.properties.WorkbookProperties 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.graphic.NonVisualDrawingProps attribute)
(openpyxl.drawing.text.CharacterProperties attribute)
hlinkHover (openpyxl.drawing.graphic.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.OuterShadowEffect attribute)
(openpyxl.drawing.effect.PresetShadowEffect 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.SystemColor attribute)
(openpyxl.drawing.effect.HSLEffect attribute)
(openpyxl.drawing.effect.TintEffect attribute)
hueMod (openpyxl.drawing.colors.SystemColor attribute)
hueOff (openpyxl.drawing.colors.SystemColor attribute)
Hyperlink (class in openpyxl.drawing.text)
(class in openpyxl.worksheet.hyperlink)
hyperlink (openpyxl.cell.cell.Cell 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.styles.fonts.Font 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.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.graphic.ChartRelation attribute)
(openpyxl.drawing.graphic.Connection attribute)
(openpyxl.drawing.graphic.NonVisualDrawingProps attribute)
(openpyxl.drawing.text.TextField attribute)
(openpyxl.packaging.interface.ISerialisableFile attribute)
Id (openpyxl.packaging.relationship.Relationship attribute)
id (openpyxl.packaging.relationship.Relationship attribute)
(openpyxl.workbook.external_link.external.ExternalBook attribute)
(openpyxl.workbook.external_reference.ExternalReference attribute)
(openpyxl.workbook.parser.ChildSheet attribute)
(openpyxl.workbook.web.WebPublishObject 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.chartspace.PivotFormat attribute)
(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.series.Series attribute)
(openpyxl.chart.series.XYSeries attribute)
(openpyxl.chart.surface_chart.BandFormat attribute)
(openpyxl.drawing.graphic.Connection attribute)
(openpyxl.drawing.shapes.FontReference attribute)
(openpyxl.drawing.shapes.StyleMatrixReference attribute)
idx_base (openpyxl.descriptors.sequence.Sequence attribute)
(openpyxl.descriptors.serialisable.Serialisable attribute)
Ignorable (openpyxl.workbook.parser.WorkbookPackage attribute)
IllegalCharacterError
Image (class in openpyxl.drawing.image)
imeMode (openpyxl.worksheet.datavalidation.DataValidation attribute)
inch_to_dxa() (in module openpyxl.utils.units)
inch_to_EMU() (in module openpyxl.utils.units)
includeHiddenRowCol (openpyxl.workbook.views.CustomWorkbookView attribute)
includePrintSettings (openpyxl.workbook.views.CustomWorkbookView attribute)
indent (openpyxl.drawing.text.ParagraphProperties attribute)
(openpyxl.styles.alignment.Alignment attribute)
index (openpyxl.styles.colors.Color attribute)
(openpyxl.styles.colors.ColorList attribute)
(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)
IndexedColorList (class in openpyxl.styles.colors)
indexedColors (openpyxl.styles.colors.ColorList attribute)
IndexedList (class in openpyxl.utils.indexed_list)
INLINE_STRING (openpyxl.reader.worksheet.WorkSheetParser attribute)
InlineFont (class in openpyxl.cell.text)
InnerShadowEffect (class in openpyxl.drawing.effect)
innerShdw (openpyxl.drawing.effect.EffectList attribute)
insertColumns (openpyxl.worksheet.protection.SheetProtection attribute)
insertHyperlinks (openpyxl.worksheet.protection.SheetProtection attribute)
insertRow (openpyxl.worksheet.table.Table attribute)
insertRows (openpyxl.worksheet.protection.SheetProtection attribute)
insertRowShift (openpyxl.worksheet.table.Table attribute)
InsufficientCoordinatesException
Integer (class in openpyxl.descriptors.base)
intercept (openpyxl.chart.trendline.Trendline attribute)
internal_value (openpyxl.cell.cell.Cell attribute)
(openpyxl.cell.interface.AbstractCell attribute)
(openpyxl.cell.read_only.ReadOnlyCell attribute)
inv (openpyxl.drawing.colors.SystemColor 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.SystemColor attribute)
is_builtin() (in module openpyxl.styles.numbers)
is_date (openpyxl.cell.cell.Cell attribute)
(openpyxl.cell.interface.AbstractCell attribute)
(openpyxl.cell.read_only.EmptyCell attribute)
(openpyxl.cell.read_only.ReadOnlyCell attribute)
is_date_format() (in module openpyxl.styles.numbers)
is_external (openpyxl.workbook.defined_name.DefinedName attribute)
is_reserved (openpyxl.workbook.defined_name.DefinedName attribute)
ISerialisableFile (class in openpyxl.packaging.interface)
isgenerator() (in module openpyxl.worksheet.worksheet)
(in module openpyxl.writer.write_only)
italic (openpyxl.styles.fonts.Font attribute)
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)
iterparse() (in module openpyxl.xml.functions)
J
join_lines (openpyxl.chart.pie_chart.ProjectedPieChart attribute)
justifyLastLine (openpyxl.styles.alignment.Alignment attribute)
justLastX (openpyxl.comments.comment_sheet.Properties attribute)
K
keep_links (openpyxl.workbook.workbook.Workbook attribute)
kern (openpyxl.drawing.text.CharacterProperties attribute)
key (openpyxl.styles.styleable.NamedStyleDescriptor attribute)
(openpyxl.styles.styleable.NumberFormatDescriptor attribute)
keywords (openpyxl.packaging.core.DocumentProperties attribute)
kumimoji (openpyxl.drawing.text.CharacterProperties attribute)
kx (openpyxl.drawing.effect.OuterShadowEffect attribute)
(openpyxl.drawing.effect.ReflectionEffect attribute)
ky (openpyxl.drawing.effect.OuterShadowEffect attribute)
(openpyxl.drawing.effect.ReflectionEffect attribute)
L
l (openpyxl.chart.print_settings.PageMargins attribute)
(openpyxl.drawing.fill.RelativeRect attribute)
(openpyxl.drawing.shapes.GeomRect 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.shapes.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.chartspace.PlotArea attribute)
(openpyxl.chart.legend.Legend 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.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)
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.shapes)
lightRig (openpyxl.drawing.shapes.Scene3D attribute)
lim (openpyxl.drawing.line.LineJoinMiterProperties attribute)
lin (openpyxl.drawing.fill.GradientFillProperties attribute)
line (openpyxl.chart.shapes.GraphicalProperties attribute)
line3DChart (openpyxl.chart.chartspace.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.chartspace.PlotArea attribute)
LineChart3D (class in openpyxl.chart.line_chart)
LineEndProperties (class in openpyxl.drawing.line)
LineJoinMiterProperties (class in openpyxl.drawing.line)
LineProperties (class in openpyxl.drawing.line)
Lines (openpyxl.packaging.extended.ExtendedProperties attribute)
link (openpyxl.drawing.fill.Blip attribute)
LinksUpToDate (openpyxl.packaging.extended.ExtendedProperties attribute)
lIns (openpyxl.drawing.text.RichTextProperties attribute)
ListStyle (class in openpyxl.drawing.text)
ln (openpyxl.chart.shapes.GraphicalProperties attribute)
(openpyxl.drawing.text.CharacterProperties attribute)
lnRef (openpyxl.drawing.shapes.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)
localnames() (openpyxl.workbook.defined_name.DefinedNameList method)
localSheetId (openpyxl.workbook.defined_name.DefinedName attribute)
location (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)
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.shapes.SphereCoords attribute)
longFileNames (openpyxl.workbook.web.WebPublishing attribute)
lowestEdited (openpyxl.workbook.properties.FileVersion attribute)
lstStyle (openpyxl.chart.text.RichText attribute)
lum (openpyxl.drawing.colors.HSLColor 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.SystemColor attribute)
lumOff (openpyxl.drawing.colors.SystemColor attribute)
lvl (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)
lxml_write_cell() (in module openpyxl.writer.etree_worksheet)
M
macro (openpyxl.drawing.graphic.GraphicFrame attribute)
(openpyxl.drawing.graphic.PictureFrame attribute)
(openpyxl.drawing.graphic.Shape 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.PageBreak attribute)
ManualLayout (class in openpyxl.chart.layout)
manualLayout (openpyxl.chart.layout.Layout attribute)
mapId (openpyxl.worksheet.table.XMLColumnProps attribute)
MARGIN_BOTTOM (openpyxl.drawing.shape.Shape attribute)
MARGIN_LEFT (openpyxl.drawing.shape.Shape attribute)
Marker (class in openpyxl.chart.marker)
marker (openpyxl.chart.chartspace.PivotFormat attribute)
(openpyxl.chart.line_chart.LineChart attribute)
(openpyxl.chart.line_chart.LineChart3D attribute)
(openpyxl.chart.marker.DataPoint 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.TextPoint attribute)
(openpyxl.worksheet.dimensions.ColumnDimension attribute)
(openpyxl.worksheet.pagebreak.Break attribute)
max_col (openpyxl.chart.reference.Reference attribute)
max_column (openpyxl.worksheet.read_only.ReadOnlyWorksheet attribute)
(openpyxl.worksheet.worksheet.Worksheet attribute)
max_row (openpyxl.chart.reference.Reference attribute)
(openpyxl.worksheet.read_only.ReadOnlyWorksheet attribute)
(openpyxl.worksheet.worksheet.Worksheet attribute)
maximized (openpyxl.workbook.views.CustomWorkbookView attribute)
maxLength (openpyxl.formatting.rule.DataBar attribute)
maxVal (openpyxl.worksheet.filters.DynamicFilter attribute)
maxValIso (openpyxl.worksheet.filters.DynamicFilter attribute)
merge_cells() (openpyxl.worksheet.worksheet.Worksheet method)
MERGE_TAG (openpyxl.reader.worksheet.WorkSheetParser attribute)
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 attribute)
merged_cells (openpyxl.worksheet.worksheet.Worksheet attribute)
mergeInterval (openpyxl.workbook.views.CustomWorkbookView attribute)
meta (openpyxl.drawing.graphic.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.workbook.external_link.external.ExternalLink attribute)
(openpyxl.workbook.workbook.Workbook attribute)
(openpyxl.worksheet.table.Table attribute)
(openpyxl.worksheet.worksheet.Worksheet attribute)
(openpyxl.writer.write_only.WriteOnlyWorksheet 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.TextPoint attribute)
(openpyxl.worksheet.dimensions.ColumnDimension attribute)
(openpyxl.worksheet.pagebreak.Break attribute)
min_col (openpyxl.chart.reference.Reference attribute)
min_column (openpyxl.worksheet.read_only.ReadOnlyWorksheet attribute)
(openpyxl.worksheet.worksheet.Worksheet attribute)
min_row (openpyxl.chart.reference.Reference attribute)
(openpyxl.worksheet.read_only.ReadOnlyWorksheet attribute)
(openpyxl.worksheet.worksheet.Worksheet 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)
minus (openpyxl.chart.error_bar.ErrorBars attribute)
minute (openpyxl.worksheet.filters.DateGroupItem attribute)
miter (openpyxl.drawing.line.LineProperties attribute)
MMClips (openpyxl.packaging.extended.ExtendedProperties attribute)
modified (openpyxl.packaging.core.DocumentProperties attribute)
month (openpyxl.worksheet.filters.DateGroupItem attribute)
moveWithCells (openpyxl.comments.comment_sheet.ObjectAnchor attribute)
MRUColorList (class in openpyxl.styles.colors)
mruColors (openpyxl.styles.colors.ColorList attribute)
N
name (openpyxl.chart.chartspace.PivotSource attribute)
(openpyxl.chart.trendline.Trendline attribute)
(openpyxl.drawing.effect.EffectContainer attribute)
(openpyxl.drawing.graphic.NonVisualDrawingProps attribute)
(openpyxl.drawing.shapes.GeomGuide attribute)
(openpyxl.drawing.text.EmbeddedWAVAudioFile attribute)
(openpyxl.drawing.text.GeomGuide 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.parser.ChildSheet attribute)
(openpyxl.workbook.smart_tags.SmartTag attribute)
(openpyxl.workbook.views.CustomWorkbookView attribute)
(openpyxl.worksheet.table.Table attribute)
(openpyxl.worksheet.table.TableColumn attribute)
(openpyxl.worksheet.table.TableStyleInfo attribute)
named_styles (openpyxl.workbook.workbook.Workbook attribute)
NamedRangeException
NamedStyle (class in openpyxl.styles.named_styles)
NamedStyleDescriptor (class in openpyxl.styles.styleable)
NamedStyleList (class in openpyxl.styles.named_styles)
names (openpyxl.styles.named_styles.NamedStyleList attribute)
namespace (openpyxl.descriptors.excel.Relation attribute)
(openpyxl.descriptors.serialisable.Serialisable attribute)
(openpyxl.drawing.colors.ColorChoice attribute)
(openpyxl.drawing.fill.Blip attribute)
(openpyxl.drawing.fill.PatternFillProperties attribute)
(openpyxl.drawing.fill.RelativeRect attribute)
(openpyxl.drawing.fill.StretchInfoProperties attribute)
(openpyxl.drawing.graphic.ChartRelation attribute)
(openpyxl.drawing.graphic.GraphicData attribute)
(openpyxl.drawing.graphic.GraphicObject attribute)
(openpyxl.drawing.graphic.PictureLocking attribute)
(openpyxl.drawing.line.DashStop attribute)
(openpyxl.drawing.line.LineEndProperties attribute)
(openpyxl.drawing.line.LineJoinMiterProperties attribute)
(openpyxl.drawing.line.LineProperties attribute)
(openpyxl.drawing.shapes.PresetGeometry2D attribute)
(openpyxl.drawing.text.CharacterProperties attribute)
(openpyxl.drawing.text.Font 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.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)
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.graphic.PictureLocking attribute)
noAutofit (openpyxl.drawing.text.RichTextProperties attribute)
noChangeArrowheads (openpyxl.drawing.fill.Blip attribute)
(openpyxl.drawing.graphic.GroupLocking attribute)
(openpyxl.drawing.graphic.PictureLocking attribute)
noChangeAspect (openpyxl.drawing.fill.Blip attribute)
(openpyxl.drawing.graphic.GraphicFrameLocking attribute)
(openpyxl.drawing.graphic.GroupLocking attribute)
(openpyxl.drawing.graphic.PictureLocking attribute)
noChangeShapeType (openpyxl.drawing.fill.Blip attribute)
(openpyxl.drawing.graphic.PictureLocking attribute)
noCrop (openpyxl.drawing.graphic.PictureLocking attribute)
noDrilldown (openpyxl.drawing.graphic.GraphicFrameLocking attribute)
noEditPoints (openpyxl.drawing.fill.Blip attribute)
(openpyxl.drawing.graphic.PictureLocking 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.graphic.GroupLocking attribute)
(openpyxl.drawing.graphic.PictureLocking attribute)
noMove (openpyxl.drawing.fill.Blip attribute)
(openpyxl.drawing.graphic.GraphicFrameLocking attribute)
(openpyxl.drawing.graphic.GroupLocking attribute)
(openpyxl.drawing.graphic.PictureLocking attribute)
noMultiLvlLbl (openpyxl.chart.axis.TextAxis attribute)
NoneSet (class in openpyxl.descriptors.base)
NonVisualConnectorProperties (class in openpyxl.drawing.graphic)
NonVisualDrawingProps (class in openpyxl.drawing.graphic)
NonVisualDrawingShapeProps (class in openpyxl.drawing.graphic)
NonVisualGraphicFrame (class in openpyxl.drawing.graphic)
NonVisualGraphicFrameProperties (class in openpyxl.drawing.graphic)
NonVisualGroupDrawingShapeProps (class in openpyxl.drawing.graphic)
NonVisualGroupShape (class in openpyxl.drawing.graphic)
NonVisualPictureProperties (class in openpyxl.drawing.graphic)
noProof (openpyxl.drawing.text.CharacterProperties attribute)
noResize (openpyxl.drawing.fill.Blip attribute)
(openpyxl.drawing.graphic.GraphicFrameLocking attribute)
(openpyxl.drawing.graphic.GroupLocking attribute)
(openpyxl.drawing.graphic.PictureLocking attribute)
norm (openpyxl.drawing.shapes.Backdrop attribute)
normalizeH (openpyxl.drawing.text.CharacterProperties attribute)
normAutofit (openpyxl.drawing.text.RichTextProperties attribute)
noRot (openpyxl.drawing.fill.Blip attribute)
(openpyxl.drawing.graphic.GroupLocking attribute)
(openpyxl.drawing.graphic.PictureLocking attribute)
noSelect (openpyxl.drawing.fill.Blip attribute)
(openpyxl.drawing.graphic.GraphicFrameLocking attribute)
(openpyxl.drawing.graphic.GroupLocking attribute)
(openpyxl.drawing.graphic.PictureLocking attribute)
Notes (openpyxl.packaging.extended.ExtendedProperties attribute)
noUngrp (openpyxl.drawing.graphic.GroupLocking attribute)
number_format (openpyxl.cell.interface.AbstractCell attribute)
(openpyxl.cell.read_only.EmptyCell attribute)
(openpyxl.cell.read_only.ReadOnlyCell attribute)
(openpyxl.styles.named_styles.NamedStyle attribute)
(openpyxl.styles.styleable.StyleableObject attribute)
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)
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.styles.cell_style.CellStyle attribute)
(openpyxl.styles.cell_style.StyleArray attribute)
(openpyxl.styles.numbers.NumberFormat 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)
nvGraphicFramePr (openpyxl.drawing.graphic.GraphicFrame attribute)
nvGrpSpPr (openpyxl.drawing.graphic.GroupShape attribute)
nvPicPr (openpyxl.drawing.graphic.PictureFrame attribute)
nvSpPr (openpyxl.drawing.graphic.Shape attribute)
O
ObjectAnchor (class in openpyxl.comments.comment_sheet)
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.graphic.GroupTransform2D attribute)
(openpyxl.drawing.shapes.Transform2D attribute)
offset() (openpyxl.cell.cell.Cell method)
(openpyxl.cell.interface.AbstractCell method)
ofPieChart (openpyxl.chart.chartspace.PlotArea attribute)
ofPieType (openpyxl.chart.pie_chart.ProjectedPieChart attribute)
oleSize (openpyxl.workbook.parser.WorkbookPackage attribute)
OneCellAnchor (class in openpyxl.drawing.spreadsheet_drawing)
oneCellAnchor (openpyxl.drawing.spreadsheet_drawing.SpreadsheetDrawing attribute)
onlySync (openpyxl.workbook.views.CustomWorkbookView attribute)
openpyxl (module)
,
[1]
openpyxl.cell (module)
openpyxl.cell.cell (module)
openpyxl.cell.interface (module)
openpyxl.cell.read_only (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.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.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.drawing (module)
openpyxl.drawing.effect (module)
openpyxl.drawing.fill (module)
openpyxl.drawing.graphic (module)
openpyxl.drawing.image (module)
openpyxl.drawing.line (module)
openpyxl.drawing.shape (module)
openpyxl.drawing.shapes (module)
openpyxl.drawing.spreadsheet_drawing (module)
openpyxl.drawing.text (module)
openpyxl.formatting (module)
openpyxl.formatting.formatting (module)
openpyxl.formatting.rule (module)
openpyxl.packaging (module)
openpyxl.packaging.core (module)
openpyxl.packaging.extended (module)
openpyxl.packaging.interface (module)
openpyxl.packaging.manifest (module)
openpyxl.packaging.relationship (module)
openpyxl.packaging.workbook (module)
openpyxl.reader (module)
openpyxl.reader.excel (module)
openpyxl.reader.strings (module)
openpyxl.reader.worksheet (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.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.interface (module)
openpyxl.workbook.parser (module)
openpyxl.workbook.pivot (module)
openpyxl.workbook.properties (module)
openpyxl.workbook.protection (module)
openpyxl.workbook.read_only (module)
openpyxl.workbook.smart_tags (module)
openpyxl.workbook.views (module)
openpyxl.workbook.web (module)
openpyxl.workbook.workbook (module)
openpyxl.worksheet (module)
openpyxl.worksheet.copier (module)
openpyxl.worksheet.datavalidation (module)
openpyxl.worksheet.dimensions (module)
openpyxl.worksheet.drawing (module)
openpyxl.worksheet.filters (module)
openpyxl.worksheet.header_footer (module)
openpyxl.worksheet.hyperlink (module)
openpyxl.worksheet.merge (module)
openpyxl.worksheet.page (module)
openpyxl.worksheet.pagebreak (module)
openpyxl.worksheet.properties (module)
openpyxl.worksheet.protection (module)
openpyxl.worksheet.read_only (module)
openpyxl.worksheet.related (module)
openpyxl.worksheet.table (module)
openpyxl.worksheet.views (module)
openpyxl.worksheet.worksheet (module)
openpyxl.writer (module)
openpyxl.writer.etree_worksheet (module)
openpyxl.writer.excel (module)
openpyxl.writer.strings (module)
openpyxl.writer.theme (module)
openpyxl.writer.workbook (module)
openpyxl.writer.worksheet (module)
openpyxl.writer.write_only (module)
openpyxl.xml (module)
openpyxl.xml.constants (module)
openpyxl.xml.functions (module)
openpyxl.xml.namespace (module)
operator (openpyxl.formatting.rule.Rule attribute)
(openpyxl.worksheet.datavalidation.DataValidation attribute)
(openpyxl.worksheet.filters.CustomFilter 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)
OuterShadowEffect (class in openpyxl.drawing.effect)
outerShdw (openpyxl.drawing.effect.EffectList attribute)
Outline (class in openpyxl.worksheet.properties)
outline (openpyxl.cell.text.InlineFont attribute)
(openpyxl.styles.borders.Border attribute)
(openpyxl.styles.fonts.Font attribute)
outline_level (openpyxl.worksheet.dimensions.Dimension 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 (class in openpyxl.worksheet.pagebreak)
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)
Pages (openpyxl.packaging.extended.ExtendedProperties 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)
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)
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 attribute)
(openpyxl.styles.styleable.StyleableObject attribute)
parse() (openpyxl.packaging.workbook.WorkbookParser method)
(openpyxl.reader.worksheet.WorkSheetParser method)
parse_cell() (openpyxl.reader.worksheet.WorkSheetParser method)
parse_column_dimensions() (openpyxl.reader.worksheet.WorkSheetParser method)
parse_extensions() (openpyxl.reader.worksheet.WorkSheetParser method)
parse_hyperlinks() (openpyxl.reader.worksheet.WorkSheetParser method)
parse_legacy_drawing() (openpyxl.reader.worksheet.WorkSheetParser method)
parse_merge() (openpyxl.reader.worksheet.WorkSheetParser method)
parse_row() (openpyxl.reader.worksheet.WorkSheetParser method)
parse_sheet_protection() (openpyxl.reader.worksheet.WorkSheetParser method)
parse_tables() (openpyxl.reader.worksheet.WorkSheetParser method)
parser_conditional_formatting() (openpyxl.reader.worksheet.WorkSheetParser method)
PartName (openpyxl.drawing.spreadsheet_drawing.SpreadsheetDrawing attribute)
(openpyxl.packaging.manifest.Override attribute)
path (openpyxl.comments.comment_sheet.CommentSheet attribute)
(openpyxl.drawing.fill.GradientFillProperties attribute)
(openpyxl.drawing.fill.PathShadeProperties attribute)
(openpyxl.drawing.image.Image attribute)
(openpyxl.drawing.shapes.Path2DList attribute)
(openpyxl.drawing.spreadsheet_drawing.SpreadsheetDrawing attribute)
(openpyxl.packaging.manifest.Manifest attribute)
(openpyxl.workbook.external_link.external.ExternalLink attribute)
(openpyxl.workbook.workbook.Workbook attribute)
(openpyxl.worksheet.table.Table attribute)
Path2D (class in openpyxl.drawing.shapes)
Path2DList (class in openpyxl.drawing.shapes)
pathLst (openpyxl.drawing.shapes.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)
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.spreadsheet_drawing.AbsoluteAnchor attribute)
(openpyxl.drawing.spreadsheet_drawing.OneCellAnchor attribute)
(openpyxl.drawing.spreadsheet_drawing.TwoCellAnchor attribute)
picLocks (openpyxl.drawing.graphic.NonVisualPictureProperties attribute)
picture (openpyxl.chartsheet.chartsheet.Chartsheet attribute)
pictureFormat (openpyxl.chart.picture.PictureOptions attribute)
PictureFrame (class in openpyxl.drawing.graphic)
PictureLocking (class in openpyxl.drawing.graphic)
PictureNonVisual (class in openpyxl.drawing.graphic)
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.chartspace.PlotArea attribute)
PieChart (class in openpyxl.chart.pie_chart)
pieChart (openpyxl.chart.chartspace.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)
pivotButton (openpyxl.styles.cell_style.CellStyle attribute)
(openpyxl.styles.cell_style.StyleArray attribute)
(openpyxl.styles.styleable.StyleableObject attribute)
PivotCache (class in openpyxl.workbook.pivot)
pivotCache (openpyxl.workbook.pivot.PivotCacheList attribute)
PivotCacheList (class in openpyxl.workbook.pivot)
pivotCaches (openpyxl.workbook.parser.WorkbookPackage attribute)
pivotFmt (openpyxl.chart.chartspace.PivotFormatList attribute)
pivotFmts (openpyxl.chart.chartspace.ChartContainer attribute)
PivotFormat (class in openpyxl.chart.chartspace)
PivotFormatList (class in openpyxl.chart.chartspace)
PivotSource (class in openpyxl.chart.chartspace)
pivotSource (openpyxl.chart.chartspace.ChartSpace attribute)
pivotTables (openpyxl.worksheet.protection.SheetProtection attribute)
pixels_to_EMU() (in module openpyxl.utils.units)
pixels_to_points() (in module openpyxl.utils.units)
plain (openpyxl.cell.text.Text attribute)
PlotArea (class in openpyxl.chart.chartspace)
plotArea (openpyxl.chart.chartspace.ChartContainer attribute)
plotVisOnly (openpyxl.chart.chartspace.ChartContainer attribute)
plus (openpyxl.chart.error_bar.ErrorBars attribute)
Point2D (class in openpyxl.drawing.shapes)
Point3D (class in openpyxl.drawing.shapes)
point_pos() (openpyxl.worksheet.worksheet.Worksheet method)
points_to_pixels() (in module openpyxl.utils.units)
pop() (openpyxl.chart.reference.Reference method)
pos (openpyxl.drawing.fill.GradientStop attribute)
(openpyxl.drawing.shapes.ConnectionSite attribute)
(openpyxl.drawing.spreadsheet_drawing.AbsoluteAnchor attribute)
(openpyxl.drawing.text.TabStop attribute)
position (openpyxl.chart.legend.Legend attribute)
PositiveSize2D (class in openpyxl.drawing.shapes)
pPr (openpyxl.drawing.text.Paragraph attribute)
(openpyxl.drawing.text.TextField attribute)
preferRelativeResize (openpyxl.drawing.graphic.NonVisualPictureProperties attribute)
PresentationFormat (openpyxl.packaging.extended.ExtendedProperties attribute)
preset (openpyxl.drawing.fill.PatternFillProperties attribute)
PresetGeometry2D (class in openpyxl.drawing.shapes)
PresetShadowEffect (class in openpyxl.drawing.effect)
PresetTextShape (class in openpyxl.drawing.text)
print_area (openpyxl.worksheet.worksheet.Worksheet attribute)
(openpyxl.writer.write_only.WriteOnlyWorksheet attribute)
print_title_cols (openpyxl.worksheet.worksheet.Worksheet attribute)
(openpyxl.writer.write_only.WriteOnlyWorksheet attribute)
print_title_rows (openpyxl.worksheet.worksheet.Worksheet attribute)
(openpyxl.writer.write_only.WriteOnlyWorksheet attribute)
print_titles (openpyxl.worksheet.worksheet.Worksheet 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)
priority (openpyxl.formatting.rule.Rule 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.workbook.parser.WorkbookPackage attribute)
Protection (class in openpyxl.chart.chartspace)
(class in openpyxl.styles.protection)
protection (openpyxl.cell.read_only.ReadOnlyCell attribute)
(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.shapes.Bevel attribute)
(openpyxl.drawing.shapes.Camera attribute)
(openpyxl.drawing.shapes.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.OuterShadowEffect attribute)
(openpyxl.drawing.effect.PresetShadowEffect attribute)
prstDash (openpyxl.drawing.line.LineProperties attribute)
prstGeom (openpyxl.chart.shapes.GraphicalProperties attribute)
prstMaterial (openpyxl.drawing.shapes.Shape3D attribute)
prstShdw (openpyxl.drawing.effect.EffectList attribute)
prstTxWarp (openpyxl.drawing.text.RichTextProperties attribute)
pt (openpyxl.chart.data_source.NumData attribute)
(openpyxl.chart.data_source.StrData attribute)
(openpyxl.worksheet.pagebreak.Break attribute)
ptCount (openpyxl.chart.data_source.NumData attribute)
(openpyxl.chart.data_source.StrData attribute)
published (openpyxl.chartsheet.properties.ChartsheetProperties 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)
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.shapes.GeomRect attribute)
(openpyxl.drawing.text.Paragraph attribute)
(openpyxl.workbook.external_link.external.ExternalCell attribute)
(openpyxl.workbook.external_link.external.ExternalRow attribute)
(openpyxl.worksheet.dimensions.RowDimension 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.chartspace.PlotArea attribute)
radarStyle (openpyxl.chart.radar_chart.RadarChart attribute)
range_boundaries() (in module openpyxl.utils.cell)
range_string (openpyxl.chart.reference.Reference attribute)
range_to_tuple() (in module openpyxl.utils.cell)
rank (openpyxl.formatting.rule.Rule attribute)
read_dimension() (in module openpyxl.worksheet.read_only)
read_external_link() (in module openpyxl.workbook.external_link.external)
read_only (openpyxl.workbook.workbook.Workbook attribute)
read_string_table() (in module openpyxl.reader.strings)
reader() (in module openpyxl.chart.reader)
readingOrder (openpyxl.styles.alignment.Alignment attribute)
ReadOnlyCell (class in openpyxl.cell.read_only)
readOnlyRecommended (openpyxl.workbook.protection.FileSharing attribute)
ReadOnlyWorkbookException
ReadOnlyWorksheet (class in openpyxl.worksheet.read_only)
RECT (openpyxl.drawing.shape.Shape attribute)
rect (openpyxl.drawing.shapes.CustomGeometry2D attribute)
red (openpyxl.drawing.colors.SystemColor attribute)
redMod (openpyxl.drawing.colors.SystemColor attribute)
redOff (openpyxl.drawing.colors.SystemColor attribute)
ref (openpyxl.chart.data_source.NumRef attribute)
(openpyxl.comments.comment_sheet.CommentRecord 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 attribute)
(openpyxl.worksheet.table.Table attribute)
Reference (class in openpyxl.chart.reference)
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)
refreshError (openpyxl.workbook.external_link.external.ExternalSheetData attribute)
RegularTextRun (class in openpyxl.drawing.text)
reindex() (openpyxl.worksheet.dimensions.ColumnDimension method)
Related (class in openpyxl.worksheet.related)
Relation (class in openpyxl.descriptors.excel)
Relationship (class in openpyxl.packaging.relationship)
(openpyxl.packaging.relationship.RelationshipList attribute)
RelationshipList (class in openpyxl.packaging.relationship)
relativeIndent (openpyxl.styles.alignment.Alignment attribute)
RelativeRect (class in openpyxl.drawing.fill)
rels (openpyxl.packaging.workbook.WorkbookParser attribute)
remove() (openpyxl.workbook.workbook.Workbook method)
remove_named_range() (openpyxl.workbook.workbook.Workbook method)
remove_sheet() (openpyxl.workbook.workbook.Workbook method)
repair_central_directory() (in module openpyxl.reader.excel)
repairLoad (openpyxl.workbook.parser.FileRecoveryProperties attribute)
reservationPassword (openpyxl.workbook.protection.FileSharing attribute)
rev (openpyxl.drawing.shapes.SphereCoords attribute)
reverse (openpyxl.formatting.rule.IconSet attribute)
revision (openpyxl.packaging.core.DocumentProperties attribute)
revision_password (openpyxl.workbook.protection.WorkbookProtection attribute)
revisionsAlgorithmName (openpyxl.workbook.protection.WorkbookProtection attribute)
revisionsHashValue (openpyxl.workbook.protection.WorkbookProtection attribute)
revisionsPassword (openpyxl.workbook.protection.WorkbookProtection attribute)
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)
rgb (openpyxl.styles.colors.Color attribute)
(openpyxl.styles.colors.RgbColor attribute)
RgbColor (class in openpyxl.styles.colors)
rgbColor (openpyxl.styles.colors.IndexedColorList attribute)
RGBPercent (class in openpyxl.drawing.colors)
(openpyxl.drawing.colors.ColorChoice 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.shapes.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.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.graphic.GroupTransform2D attribute)
(openpyxl.drawing.shapes.Camera attribute)
(openpyxl.drawing.shapes.LightRig attribute)
(openpyxl.drawing.shapes.Transform2D attribute)
(openpyxl.drawing.text.RichTextProperties attribute)
rotWithShape (openpyxl.drawing.effect.OuterShadowEffect attribute)
(openpyxl.drawing.effect.ReflectionEffect attribute)
(openpyxl.drawing.fill.BlipFillProperties attribute)
(openpyxl.drawing.fill.GradientFillProperties attribute)
round (openpyxl.drawing.line.LineProperties attribute)
ROUND_RECT (openpyxl.drawing.shape.Shape attribute)
roundedCorners (openpyxl.chart.chartspace.ChartSpace attribute)
row (openpyxl.cell.cell.Cell attribute)
(openpyxl.cell.read_only.ReadOnlyCell attribute)
(openpyxl.drawing.spreadsheet_drawing.AnchorMarker attribute)
(openpyxl.workbook.external_link.external.ExternalSheetData attribute)
RowDimension (class in openpyxl.worksheet.dimensions)
rowHidden (openpyxl.comments.comment_sheet.Properties attribute)
rowOff (openpyxl.drawing.spreadsheet_drawing.AnchorMarker attribute)
rows (openpyxl.chart.reference.Reference attribute)
(openpyxl.worksheet.read_only.ReadOnlyWorksheet attribute)
(openpyxl.worksheet.worksheet.Worksheet attribute)
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.worksheet.dimensions.RowDimension attribute)
safe_iterator() (in module openpyxl.xml.functions)
safe_iterparse() (in module openpyxl.xml.functions)
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.SystemColor attribute)
(openpyxl.drawing.effect.HSLEffect attribute)
satMod (openpyxl.drawing.colors.SystemColor attribute)
satOff (openpyxl.drawing.colors.SystemColor attribute)
save() (openpyxl.workbook.workbook.Workbook method)
(openpyxl.writer.excel.ExcelWriter method)
save_dump() (in module openpyxl.writer.write_only)
save_virtual_workbook() (in module openpyxl.writer.excel)
save_workbook() (in module openpyxl.writer.excel)
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.chartspace.PlotArea attribute)
scatterStyle (openpyxl.chart.scatter_chart.ScatterChart attribute)
scenarios (openpyxl.worksheet.protection.SheetProtection attribute)
Scene3D (class in openpyxl.drawing.shapes)
scene3d (openpyxl.chart.shapes.GraphicalProperties attribute)
(openpyxl.drawing.graphic.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.OuterShadowEffect attribute)
(openpyxl.drawing.effect.PresetShadowEffect attribute)
scrgbClr (openpyxl.drawing.colors.ColorChoice attribute)
(openpyxl.drawing.effect.GlowEffect attribute)
(openpyxl.drawing.effect.InnerShadowEffect attribute)
(openpyxl.drawing.effect.OuterShadowEffect attribute)
(openpyxl.drawing.effect.PresetShadowEffect attribute)
second (openpyxl.worksheet.filters.DateGroupItem attribute)
secondPiePt (openpyxl.chart.pie_chart.CustomSplit attribute)
secondPieSize (openpyxl.chart.pie_chart.ProjectedPieChart attribute)
selected_cell (openpyxl.worksheet.worksheet.Worksheet attribute)
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)
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.chartspace.PlotArea attribute)
Serialisable (class in openpyxl.descriptors.serialisable)
Series (class in openpyxl.chart.series)
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)
Set (class in openpyxl.descriptors.base)
set_dimension() (openpyxl.drawing.drawing.Drawing method)
set_explicit_value() (openpyxl.cell.cell.Cell 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)
shade (openpyxl.drawing.colors.SystemColor attribute)
shadow (openpyxl.cell.text.InlineFont attribute)
(openpyxl.styles.fonts.Font attribute)
Shape (class in openpyxl.drawing.graphic)
(class in openpyxl.drawing.shape)
shape (openpyxl.chart.bar_chart.BarChart3D attribute)
(openpyxl.chart.series.Series attribute)
Shape3D (class in openpyxl.drawing.shapes)
shape3D (openpyxl.chart.shapes.GraphicalProperties attribute)
shapeId (openpyxl.comments.comment_sheet.CommentRecord attribute)
ShapeMeta (class in openpyxl.drawing.graphic)
ShapeStyle (class in openpyxl.drawing.shapes)
ShapeWriter (class in openpyxl.comments.shape_writer)
(class in openpyxl.drawing.shape)
shared_strings (openpyxl.cell.read_only.ReadOnlyCell attribute)
SharedDoc (openpyxl.packaging.extended.ExtendedProperties attribute)
sheet (openpyxl.worksheet.protection.SheetProtection attribute)
sheet_properties (openpyxl.worksheet.page.PrintPageSetup attribute)
sheet_state (openpyxl.chartsheet.chartsheet.Chartsheet attribute)
sheet_view (openpyxl.worksheet.worksheet.Worksheet attribute)
SheetBackgroundPicture (class in openpyxl.chartsheet.relation)
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.workbook.external_link.external.ExternalDefinedName attribute)
(openpyxl.workbook.external_link.external.ExternalSheetData attribute)
(openpyxl.workbook.parser.ChildSheet attribute)
sheetname (openpyxl.chart.reference.Reference attribute)
sheetName (openpyxl.workbook.external_link.external.ExternalSheetNames attribute)
sheetNames (openpyxl.workbook.external_link.external.ExternalBook attribute)
sheetnames (openpyxl.workbook.workbook.Workbook attribute)
sheetPr (openpyxl.chartsheet.chartsheet.Chartsheet attribute)
SheetProtection (class in openpyxl.worksheet.protection)
sheetProtection (openpyxl.chartsheet.chartsheet.Chartsheet attribute)
sheets (openpyxl.workbook.parser.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)
short_color() (in module openpyxl.utils.units)
shortcutKey (openpyxl.workbook.defined_name.DefinedName attribute)
show (openpyxl.workbook.smart_tags.SmartTagProperties attribute)
show_gridlines (openpyxl.worksheet.worksheet.Worksheet attribute)
show_summary_below (openpyxl.worksheet.worksheet.Worksheet attribute)
show_summary_right (openpyxl.worksheet.worksheet.Worksheet attribute)
showBorderUnselectedTables (openpyxl.workbook.properties.WorkbookProperties attribute)
showBubbleSize (openpyxl.chart.label.DataLabel attribute)
(openpyxl.chart.label.DataLabelList attribute)
showButton (openpyxl.worksheet.filters.FilterColumn attribute)
showCatName (openpyxl.chart.label.DataLabel attribute)
(openpyxl.chart.label.DataLabelList attribute)
showColumnStripes (openpyxl.worksheet.table.TableStyleInfo attribute)
showComments (openpyxl.workbook.views.CustomWorkbookView attribute)
showDLblsOverMax (openpyxl.chart.chartspace.ChartContainer attribute)
showDropDown (openpyxl.worksheet.datavalidation.DataValidation 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)
showHorizontalScroll (openpyxl.workbook.views.BookView attribute)
(openpyxl.workbook.views.CustomWorkbookView attribute)
showHorzBorder (openpyxl.chart.chartspace.DataTable attribute)
showInkAnnotation (openpyxl.workbook.properties.WorkbookProperties attribute)
showInputMessage (openpyxl.worksheet.datavalidation.DataValidation attribute)
showKeys (openpyxl.chart.chartspace.DataTable attribute)
showLastColumn (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)
showNegBubbles (openpyxl.chart.bubble_chart.BubbleChart attribute)
showObjects (openpyxl.workbook.properties.WorkbookProperties attribute)
(openpyxl.workbook.views.CustomWorkbookView attribute)
showOutline (openpyxl.chart.chartspace.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)
showRowColHeaders (openpyxl.worksheet.views.SheetView attribute)
showRowStripes (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)
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.chartspace.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_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)
sizeRepresents (openpyxl.chart.bubble_chart.BubbleChart attribute)
sizeWithCells (openpyxl.comments.comment_sheet.ObjectAnchor attribute)
Slides (openpyxl.packaging.extended.ExtendedProperties attribute)
SmartTag (class in openpyxl.workbook.smart_tags)
SmartTagList (class in openpyxl.workbook.smart_tags)
smartTagPr (openpyxl.workbook.parser.WorkbookPackage attribute)
SmartTagProperties (class in openpyxl.workbook.smart_tags)
smartTagType (openpyxl.workbook.smart_tags.SmartTagList attribute)
smartTagTypes (openpyxl.workbook.parser.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)
solidFill (openpyxl.chart.shapes.GraphicalProperties attribute)
(openpyxl.drawing.line.LineProperties attribute)
(openpyxl.drawing.text.CharacterProperties attribute)
sort (openpyxl.worksheet.protection.SheetProtection attribute)
sortBy (openpyxl.worksheet.filters.SortCondition attribute)
SortCondition (class in openpyxl.worksheet.filters)
sortCondition (openpyxl.worksheet.filters.SortState attribute)
sortMethod (openpyxl.worksheet.filters.SortState attribute)
SortState (class in openpyxl.worksheet.filters)
sortState (openpyxl.worksheet.filters.AutoFilter attribute)
(openpyxl.worksheet.table.Table 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.shapes)
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.graphic.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.chartspace.DataTable attribute)
(openpyxl.chart.chartspace.PivotFormat attribute)
(openpyxl.chart.chartspace.PlotArea 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.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.graphic.PictureFrame attribute)
(openpyxl.drawing.graphic.Shape attribute)
SpreadsheetDrawing (class in openpyxl.drawing.spreadsheet_drawing)
sqref (openpyxl.formatting.formatting.ConditionalFormatting attribute)
(openpyxl.worksheet.datavalidation.DataValidation 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.OuterShadowEffect attribute)
(openpyxl.drawing.effect.PresetShadowEffect 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)
state (openpyxl.chartsheet.custom.CustomChartsheetView attribute)
(openpyxl.workbook.parser.ChildSheet attribute)
(openpyxl.worksheet.views.Pane attribute)
statusBar (openpyxl.workbook.defined_name.DefinedName attribute)
stCxn (openpyxl.drawing.graphic.NonVisualConnectorProperties attribute)
stdDev (openpyxl.formatting.rule.Rule attribute)
StockChart (class in openpyxl.chart.stock_chart)
stockChart (openpyxl.chart.chartspace.PlotArea attribute)
stop (openpyxl.styles.fills.GradientFill attribute)
stop_list (openpyxl.drawing.fill.GradientFillProperties attribute)
stopIfTrue (openpyxl.formatting.rule.Rule attribute)
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)
strLit (openpyxl.chart.data_source.AxDataSource attribute)
stroke (openpyxl.drawing.shapes.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.cell.interface.AbstractCell attribute)
(openpyxl.chart.chartspace.ChartSpace attribute)
(openpyxl.chart.error_bar.ErrorBars attribute)
(openpyxl.drawing.graphic.PictureFrame attribute)
(openpyxl.drawing.graphic.Shape attribute)
(openpyxl.styles.borders.Side attribute)
(openpyxl.styles.styleable.StyleableObject attribute)
(openpyxl.worksheet.dimensions.Dimension attribute)
style_array (openpyxl.cell.read_only.ReadOnlyCell attribute)
style_id (openpyxl.styles.styleable.StyleableObject attribute)
style_names (openpyxl.workbook.workbook.Workbook attribute)
StyleableObject (class in openpyxl.styles.styleable)
StyleArray (class in openpyxl.styles.cell_style)
StyleDescriptor (class in openpyxl.styles.styleable)
StyleMatrixReference (class in openpyxl.drawing.shapes)
StyleProxy (class in openpyxl.styles.proxy)
styles (openpyxl.styles.differential.DifferentialStyleList attribute)
Stylesheet (class in openpyxl.styles.stylesheet)
subject (openpyxl.packaging.core.DocumentProperties attribute)
summaryBelow (openpyxl.worksheet.properties.Outline attribute)
summaryRight (openpyxl.worksheet.properties.Outline attribute)
surface3DChart (openpyxl.chart.chartspace.PlotArea attribute)
SurfaceChart (class in openpyxl.chart.surface_chart)
surfaceChart (openpyxl.chart.chartspace.PlotArea attribute)
SurfaceChart3D (class in openpyxl.chart.surface_chart)
sx (openpyxl.drawing.effect.OuterShadowEffect attribute)
(openpyxl.drawing.effect.ReflectionEffect attribute)
(openpyxl.drawing.fill.TileInfoProperties attribute)
sy (openpyxl.drawing.effect.OuterShadowEffect 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.OuterShadowEffect attribute)
(openpyxl.drawing.effect.PresetShadowEffect 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.shapes.GeomRect attribute)
(openpyxl.drawing.text.RegularTextRun attribute)
(openpyxl.drawing.text.TextField attribute)
(openpyxl.workbook.external_link.external.ExternalCell 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)
TableFormula (class in openpyxl.worksheet.table)
TableNameDescriptor (class in openpyxl.worksheet.table)
tablePart (openpyxl.worksheet.table.TablePartList attribute)
TablePartList (class in openpyxl.worksheet.table)
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)
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.DataTable attribute)
(openpyxl.chart.chartspace.ExternalData attribute)
(openpyxl.chart.chartspace.PivotFormat attribute)
(openpyxl.chart.chartspace.PivotFormatList attribute)
(openpyxl.chart.chartspace.PivotSource attribute)
(openpyxl.chart.chartspace.PlotArea attribute)
(openpyxl.chart.chartspace.Protection 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.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.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.serialisable.Serialisable attribute)
(openpyxl.drawing.colors.ColorChoice attribute)
(openpyxl.drawing.colors.ColorMapping attribute)
(openpyxl.drawing.colors.HSLColor attribute)
(openpyxl.drawing.colors.RGBPercent attribute)
(openpyxl.drawing.colors.SystemColor attribute)
(openpyxl.drawing.fill.Blip attribute)
(openpyxl.drawing.fill.BlipFillProperties attribute)
(openpyxl.drawing.fill.GradientFillProperties attribute)
(openpyxl.drawing.fill.GradientStop attribute)
(openpyxl.drawing.fill.GradientStopList attribute)
(openpyxl.drawing.fill.PatternFillProperties attribute)
(openpyxl.drawing.fill.RelativeRect attribute)
(openpyxl.drawing.fill.StretchInfoProperties attribute)
(openpyxl.drawing.graphic.ChartRelation attribute)
(openpyxl.drawing.graphic.GraphicData attribute)
(openpyxl.drawing.graphic.GraphicFrame attribute)
(openpyxl.drawing.graphic.GraphicObject attribute)
(openpyxl.drawing.graphic.NonVisualDrawingProps attribute)
(openpyxl.drawing.graphic.NonVisualDrawingShapeProps attribute)
(openpyxl.drawing.graphic.NonVisualGraphicFrame attribute)
(openpyxl.drawing.graphic.NonVisualGraphicFrameProperties attribute)
(openpyxl.drawing.graphic.NonVisualPictureProperties attribute)
(openpyxl.drawing.graphic.PictureFrame attribute)
(openpyxl.drawing.graphic.PictureLocking attribute)
(openpyxl.drawing.graphic.PictureNonVisual attribute)
(openpyxl.drawing.graphic.ShapeMeta attribute)
(openpyxl.drawing.line.DashStop attribute)
(openpyxl.drawing.line.LineEndProperties attribute)
(openpyxl.drawing.line.LineJoinMiterProperties attribute)
(openpyxl.drawing.line.LineProperties attribute)
(openpyxl.drawing.shapes.Transform2D 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.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.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.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.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.parser.ChildSheet attribute)
(openpyxl.workbook.parser.FileRecoveryProperties attribute)
(openpyxl.workbook.parser.WorkbookPackage attribute)
(openpyxl.workbook.pivot.PivotCache attribute)
(openpyxl.workbook.pivot.PivotCacheList 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.WebPublishObject attribute)
(openpyxl.workbook.web.WebPublishObjectList attribute)
(openpyxl.workbook.web.WebPublishing 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.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.page.PageMargins attribute)
(openpyxl.worksheet.page.PrintOptions attribute)
(openpyxl.worksheet.page.PrintPageSetup attribute)
(openpyxl.worksheet.pagebreak.Break attribute)
(openpyxl.worksheet.pagebreak.PageBreak attribute)
(openpyxl.worksheet.properties.Outline attribute)
(openpyxl.worksheet.properties.PageSetupProperties attribute)
(openpyxl.worksheet.properties.WorksheetProperties attribute)
(openpyxl.worksheet.protection.SheetProtection 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)
text (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 attribute)
(openpyxl.drawing.text.Paragraph attribute)
(openpyxl.formatting.rule.Rule attribute)
(openpyxl.worksheet.table.TableFormula attribute)
text_color (openpyxl.drawing.shape.Shape attribute)
text_rotation (openpyxl.styles.alignment.Alignment attribute)
TextAxis (class in openpyxl.chart.axis)
TextBody (openpyxl.chart.chartspace.PivotFormat attribute)
TextField (class in openpyxl.drawing.text)
textHAlign (openpyxl.comments.comment_sheet.Properties attribute)
textlink (openpyxl.drawing.graphic.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_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.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.graphic.NonVisualDrawingProps attribute)
(openpyxl.packaging.core.DocumentProperties attribute)
(openpyxl.workbook.web.WebPublishObject 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)
to_array() (openpyxl.styles.cell_style.CellStyle method)
to_excel() (in module openpyxl.utils.datetime)
to_tree() (openpyxl.chart.chartspace.PlotArea method)
(openpyxl.chart.series.Series method)
(openpyxl.chartsheet.chartsheet.Chartsheet method)
(openpyxl.comments.comment_sheet.CommentSheet method)
(openpyxl.descriptors.nested.EmptyTag method)
(openpyxl.descriptors.nested.Nested method)
(openpyxl.descriptors.nested.NestedText 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.extended.ExtendedProperties method)
(openpyxl.packaging.manifest.Manifest method)
(openpyxl.packaging.relationship.RelationshipList method)
(openpyxl.styles.fills.GradientFill method)
(openpyxl.styles.fills.PatternFill method)
(openpyxl.styles.stylesheet.Stylesheet method)
(openpyxl.workbook.external_link.external.ExternalLink method)
(openpyxl.workbook.parser.WorkbookPackage method)
(openpyxl.worksheet.dimensions.ColumnDimension method)
(openpyxl.worksheet.dimensions.DimensionHolder 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.filters.Top10 attribute)
(openpyxl.worksheet.page.PageMargins attribute)
Top10 (class in openpyxl.worksheet.filters)
top10 (openpyxl.worksheet.filters.FilterColumn 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)
Transform (class in openpyxl.drawing.colors)
transform (openpyxl.chart.shapes.GraphicalProperties attribute)
Transform2D (class in openpyxl.drawing.shapes)
transitionEntry (openpyxl.worksheet.properties.WorksheetProperties attribute)
transitionEvaluation (openpyxl.worksheet.properties.WorksheetProperties 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)
TwoCellAnchor (class in openpyxl.drawing.spreadsheet_drawing)
twoCellAnchor (openpyxl.drawing.spreadsheet_drawing.SpreadsheetDrawing 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.graphic.NonVisualDrawingShapeProps attribute)
txBody (openpyxl.drawing.graphic.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.chartspace.DataTable attribute)
(openpyxl.chart.chartspace.PivotFormat attribute)
(openpyxl.chart.label.DataLabel attribute)
(openpyxl.chart.label.DataLabelList attribute)
(openpyxl.chart.legend.Legend attribute)
(openpyxl.chart.legend.LegendEntry 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.styles.colors.Color attribute)
(openpyxl.styles.fills.GradientFill attribute)
(openpyxl.styles.table.TableStyleElement attribute)
(openpyxl.workbook.defined_name.DefinedName attribute)
(openpyxl.worksheet.datavalidation.DataValidation attribute)
(openpyxl.worksheet.filters.DynamicFilter attribute)
TYPE_BOOL (openpyxl.cell.cell.Cell attribute)
TYPE_ERROR (openpyxl.cell.cell.Cell attribute)
TYPE_FORMULA (openpyxl.cell.cell.Cell attribute)
TYPE_FORMULA_CACHE_STRING (openpyxl.cell.cell.Cell attribute)
TYPE_INLINE (openpyxl.cell.cell.Cell attribute)
TYPE_NULL (openpyxl.cell.cell.Cell attribute)
TYPE_NUMERIC (openpyxl.cell.cell.Cell attribute)
TYPE_STRING (openpyxl.cell.cell.Cell attribute)
Typed (class in openpyxl.descriptors.base)
typeface (openpyxl.drawing.text.Font attribute)
tzname() (openpyxl.utils.datetime.GMT method)
U
u (openpyxl.cell.text.InlineFont attribute)
(openpyxl.drawing.text.CharacterProperties 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)
uLn (openpyxl.drawing.text.CharacterProperties attribute)
uLnTx (openpyxl.drawing.text.CharacterProperties 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)
unescape() (in module openpyxl.utils.escape)
unique (openpyxl.descriptors.sequence.Sequence attribute)
uniqueName (openpyxl.worksheet.table.TableColumn attribute)
UniversalMeasure (class in openpyxl.descriptors.excel)
unmerge_cells() (openpyxl.worksheet.worksheet.Worksheet method)
up (openpyxl.drawing.shapes.Backdrop attribute)
upBars (openpyxl.chart.updown_bars.UpDownBars 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)
upright (openpyxl.drawing.text.RichTextProperties attribute)
uri (openpyxl.descriptors.excel.Extension attribute)
(openpyxl.drawing.graphic.GraphicData attribute)
url (openpyxl.workbook.smart_tags.SmartTag attribute)
useA (openpyxl.drawing.effect.ColorChangeEffect attribute)
useFirstPageNumber (openpyxl.worksheet.page.PrintPageSetup attribute)
usePrinterDefaults (openpyxl.worksheet.page.PrintPageSetup attribute)
userInterface (openpyxl.chart.chartspace.Protection attribute)
userName (openpyxl.workbook.protection.FileSharing attribute)
userShapes (openpyxl.chart.chartspace.ChartSpace attribute)
utcoffset() (openpyxl.utils.datetime.GMT method)
V
v (openpyxl.chart.data_source.NumVal attribute)
(openpyxl.chart.data_source.StrVal attribute)
(openpyxl.chart.series.SeriesLabel attribute)
(openpyxl.workbook.external_link.external.ExternalCell attribute)
val (openpyxl.chart.error_bar.ErrorBars attribute)
(openpyxl.chart.series.Series attribute)
(openpyxl.drawing.colors.SystemColor attribute)
(openpyxl.formatting.rule.FormatObject attribute)
(openpyxl.worksheet.filters.CustomFilter attribute)
(openpyxl.worksheet.filters.DynamicFilter attribute)
(openpyxl.worksheet.filters.Top10 attribute)
valAx (openpyxl.chart.chartspace.PlotArea attribute)
VALID_TYPES (openpyxl.cell.cell.Cell attribute)
validation_type (openpyxl.worksheet.datavalidation.DataValidation attribute)
valIso (openpyxl.worksheet.filters.DynamicFilter attribute)
value (openpyxl.cell.cell.Cell attribute)
(openpyxl.cell.interface.AbstractCell attribute)
(openpyxl.cell.read_only.EmptyCell attribute)
(openpyxl.cell.read_only.ReadOnlyCell attribute)
(openpyxl.chart.series.SeriesLabel attribute)
(openpyxl.drawing.text.RegularTextRun attribute)
(openpyxl.styles.colors.Color attribute)
(openpyxl.workbook.defined_name.DefinedName attribute)
VALUE_TAG (openpyxl.reader.worksheet.WorkSheetParser attribute)
ValueDescriptor (class in openpyxl.formatting.rule)
values (openpyxl.worksheet.worksheet.Worksheet attribute)
ValueSequence (class in openpyxl.descriptors.sequence)
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)
vba_code (openpyxl.worksheet.worksheet.Worksheet attribute)
vbProcedure (openpyxl.workbook.defined_name.DefinedName attribute)
Vector3D (class in openpyxl.drawing.shapes)
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)
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.line.LineEndProperties attribute)
(openpyxl.drawing.line.LineProperties attribute)
(openpyxl.drawing.shapes.Bevel attribute)
(openpyxl.drawing.shapes.Path2D attribute)
W3CDTF_to_datetime() (in module openpyxl.utils.datetime)
WebPublishing (class in openpyxl.workbook.web)
webPublishing (openpyxl.workbook.parser.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.workbook.parser.WorkbookPackage attribute)
width (openpyxl.chart.layout.ManualLayout attribute)
(openpyxl.drawing.drawing.Drawing attribute)
(openpyxl.drawing.line.LineProperties attribute)
(openpyxl.drawing.shapes.PositiveSize2D 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 attribute)
workbookAlgorithmName (openpyxl.workbook.protection.WorkbookProtection attribute)
WorkbookAlreadySaved
workbookHashValue (openpyxl.workbook.protection.WorkbookProtection attribute)
WorkbookPackage (class in openpyxl.workbook.parser)
workbookParameter (openpyxl.workbook.defined_name.DefinedName attribute)
WorkbookParser (class in openpyxl.packaging.workbook)
workbookPassword (openpyxl.workbook.protection.WorkbookProtection attribute)
workbookPasswordCharacterSet (openpyxl.workbook.protection.WorkbookProtection attribute)
workbookPr (openpyxl.workbook.parser.WorkbookPackage attribute)
WorkbookProperties (class in openpyxl.workbook.properties)
WorkbookProtection (class in openpyxl.workbook.protection)
workbookProtection (openpyxl.workbook.parser.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)
WorkSheetParser (class in openpyxl.reader.worksheet)
WorksheetProperties (class in openpyxl.worksheet.properties)
worksheets (openpyxl.workbook.workbook.Workbook 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)
(openpyxl.drawing.shape.ShapeWriter method)
write_cell() (in module openpyxl.writer.etree_worksheet)
write_conditional_formatting() (in module openpyxl.writer.worksheet)
write_data() (openpyxl.writer.excel.ExcelWriter method)
write_drawing() (in module openpyxl.writer.worksheet)
write_hyperlinks() (in module openpyxl.writer.worksheet)
write_mergecells() (in module openpyxl.writer.worksheet)
write_only (openpyxl.workbook.workbook.Workbook attribute)
write_root_rels() (in module openpyxl.writer.workbook)
write_row() (in module openpyxl.writer.etree_worksheet)
write_rows() (in module openpyxl.writer.etree_worksheet)
write_shapes() (openpyxl.comments.comment_sheet.CommentSheet method)
write_string_table() (in module openpyxl.writer.strings)
write_stylesheet() (in module openpyxl.styles.stylesheet)
write_theme() (in module openpyxl.writer.theme)
write_workbook() (in module openpyxl.writer.workbook)
write_workbook_rels() (in module openpyxl.writer.workbook)
write_worksheet() (in module openpyxl.writer.worksheet)
WriteOnlyCell() (in module openpyxl.cell.cell)
WriteOnlyWorksheet (class in openpyxl.writer.write_only)
writer (openpyxl.writer.write_only.WriteOnlyWorksheet attribute)
X
x (openpyxl.chart.layout.ManualLayout attribute)
(openpyxl.drawing.shapes.AdjPoint2D attribute)
(openpyxl.drawing.shapes.Point2D attribute)
(openpyxl.drawing.shapes.Point3D 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)
xf (openpyxl.styles.cell_style.CellStyleList attribute)
xfId (openpyxl.styles.cell_style.CellStyle attribute)
(openpyxl.styles.cell_style.StyleArray attribute)
(openpyxl.styles.named_styles.NamedStyle attribute)
xfrm (openpyxl.chart.shapes.GraphicalProperties attribute)
(openpyxl.drawing.graphic.GraphicFrame attribute)
(openpyxl.drawing.graphic.GroupShapeProperties attribute)
xlm (openpyxl.workbook.defined_name.DefinedName attribute)
xml_source (openpyxl.worksheet.read_only.ReadOnlyWorksheet 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.shapes.AdjPoint2D attribute)
(openpyxl.drawing.shapes.Point2D attribute)
(openpyxl.drawing.shapes.Point3D 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.shapes.Point3D attribute)
(openpyxl.drawing.shapes.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)
zeroHeight (openpyxl.worksheet.dimensions.SheetFormatProperties attribute)
zoom (openpyxl.drawing.shapes.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)
Read the Docs
v: 2.4
Versions
latest
stable
2.6
2.5
2.4
Downloads
htmlzip
On Read the Docs
Project Home
Builds
Free document hosting provided by
Read the Docs
.