types-openpyxl 3.1.5.20260316

PyPI https://pypi.org/project/types-openpyxl/

Repository https://github.com/python/typeshed
py.typed

stubs-only typeshed

Coverage

%%{init: {"pie": {"textPosition": 0.85}, "theme": "neutral", "themeVariables": {"pieStrokeWidth": "1px"}}}%%
pie title
    "Typed" : 7371
    "Any" : 368
    "Untyped" : 555

93.3% coverage
88.9% coverage (strict)
8294 typable
- 7371 typed
- 555 untyped
- 368 Any

Typables

%%{init: {"pie": {"textPosition": 0.85}, "theme": "neutral", "themeVariables": {"pieStrokeWidth": "1px"}}}%%
pie title
    "functions" : 297
    "classes" : 3812
    "other" : 314

103 functions (+9 overloads)
- 194 parameters
596 classes
- 850 methods (+0 overloads)
  - 2728 parameters
- 204 properties
168 modules
- 314 attrs

Modules

Module	Coverage	Coverage (strict)	Typables	Ignores
`openpyxl`	100.0%	100.0%	1	0
`openpyxl._constants`	100.0%	100.0%	6	0
`openpyxl.cell.cell`	100.0%	100.0%	103	0
`openpyxl.cell.read_only`	91.0%	73.1%	67	0
`openpyxl.cell.rich_text`	100.0%	100.0%	18	2
`openpyxl.cell.text`	96.7%	93.4%	61	0
`openpyxl.chart._chart`	84.6%	71.8%	39	1
`openpyxl.chart.area_chart`	83.3%	77.8%	36	0
`openpyxl.chart.axis`	96.3%	96.3%	107	1
`openpyxl.chart.bar_chart`	90.6%	75.0%	64	0
`openpyxl.chart.bubble_chart`	91.3%	87.0%	46	0
`openpyxl.chart.chartspace`	98.5%	95.5%	67	0
`openpyxl.chart.data_source`	93.6%	88.3%	94	1
`openpyxl.chart.descriptors`	90.9%	90.9%	11	0
`openpyxl.chart.error_bar`	100.0%	100.0%	25	0
`openpyxl.chart.label`	78.6%	71.4%	14	0
`openpyxl.chart.layout`	100.0%	100.0%	32	0
`openpyxl.chart.legend`	96.8%	93.5%	31	0
`openpyxl.chart.line_chart`	91.2%	88.2%	68	0
`openpyxl.chart.marker`	100.0%	100.0%	32	0
`openpyxl.chart.picture`	100.0%	100.0%	13	0
`openpyxl.chart.pie_chart`	90.1%	86.8%	91	0
`openpyxl.chart.pivot`	100.0%	100.0%	23	0
`openpyxl.chart.plotarea`	96.6%	62.1%	58	0
`openpyxl.chart.print_settings`	100.0%	100.0%	27	0
`openpyxl.chart.radar_chart`	88.9%	83.3%	36	0
`openpyxl.chart.reader`	0.0%	0.0%	2	0
`openpyxl.chart.reference`	93.1%	93.1%	29	0
`openpyxl.chart.scatter_chart`	88.2%	82.4%	34	0
`openpyxl.chart.series`	98.4%	93.7%	63	0
`openpyxl.chart.series_factory`	83.3%	83.3%	6	0
`openpyxl.chart.shapes`	96.7%	96.7%	30	0
`openpyxl.chart.stock_chart`	89.5%	84.2%	38	0
`openpyxl.chart.surface_chart`	87.2%	84.6%	39	0
`openpyxl.chart.text`	95.5%	90.9%	22	0
`openpyxl.chart.title`	96.0%	96.0%	25	0
`openpyxl.chart.trendline`	100.0%	100.0%	45	0
`openpyxl.chart.updown_bars`	100.0%	90.9%	11	0
`openpyxl.chartsheet.chartsheet`	97.3%	97.3%	74	2
`openpyxl.chartsheet.custom`	92.9%	78.6%	14	0
`openpyxl.chartsheet.properties`	100.0%	100.0%	9	0
`openpyxl.chartsheet.protection`	82.4%	64.7%	17	0
`openpyxl.chartsheet.publish`	93.8%	87.5%	16	0
`openpyxl.chartsheet.relation`	96.7%	93.4%	61	0
`openpyxl.chartsheet.views`	95.0%	90.0%	20	0
`openpyxl.comments.author`	80.0%	60.0%	5	0
`openpyxl.comments.comment_sheet`	88.1%	81.4%	59	1
`openpyxl.comments.comments`	77.8%	50.0%	36	1
`openpyxl.comments.shape_writer`	72.2%	55.6%	18	0
`openpyxl.compat`	33.3%	0.0%	3	0
`openpyxl.compat.abc`	0.0%	0.0%	0	0
`openpyxl.compat.numbers`	100.0%	100.0%	5	0
`openpyxl.compat.product`	0.0%	0.0%	2	0
`openpyxl.compat.singleton`	100.0%	0.0%	5	0
`openpyxl.compat.strings`	100.0%	100.0%	5	0
`openpyxl.descriptors`	100.0%	100.0%	8	0
`openpyxl.descriptors.base`	97.5%	97.5%	81	2
`openpyxl.descriptors.container`	100.0%	100.0%	7	0
`openpyxl.descriptors.excel`	88.5%	84.6%	26	0
`openpyxl.descriptors.namespace`	100.0%	100.0%	4	0
`openpyxl.descriptors.nested`	100.0%	100.0%	40	9
`openpyxl.descriptors.sequence`	94.9%	89.8%	59	0
`openpyxl.descriptors.serialisable`	87.5%	87.5%	24	0
`openpyxl.descriptors.slots`	100.0%	100.0%	4	0
`openpyxl.drawing.colors`	99.4%	98.8%	167	0
`openpyxl.drawing.connector`	100.0%	100.0%	51	0
`openpyxl.drawing.drawing`	100.0%	95.0%	40	0
`openpyxl.drawing.effect`	97.8%	97.8%	135	0
`openpyxl.drawing.fill`	96.4%	92.9%	196	0
`openpyxl.drawing.geometry`	94.3%	90.5%	211	0
`openpyxl.drawing.graphic`	96.8%	96.8%	63	1
`openpyxl.drawing.image`	100.0%	100.0%	9	0
`openpyxl.drawing.line`	98.3%	96.6%	59	0
`openpyxl.drawing.picture`	98.3%	98.3%	60	0
`openpyxl.drawing.properties`	97.2%	94.4%	72	1
`openpyxl.drawing.relation`	80.0%	60.0%	5	0
`openpyxl.drawing.spreadsheet_drawing`	89.5%	80.7%	57	0
`openpyxl.drawing.text`	98.6%	97.4%	347	0
`openpyxl.drawing.xdr`	100.0%	100.0%	3	3
`openpyxl.formatting.formatting`	74.2%	71.0%	31	0
`openpyxl.formatting.rule`	72.3%	67.5%	166	0
`openpyxl.formula.tokenizer`	76.5%	63.2%	68	0
`openpyxl.formula.translate`	29.2%	25.0%	24	0
`openpyxl.packaging.core`	92.5%	85.0%	40	3
`openpyxl.packaging.custom`	81.8%	81.8%	22	2
`openpyxl.packaging.extended`	100.0%	100.0%	64	1
`openpyxl.packaging.interface`	100.0%	100.0%	1	0
`openpyxl.packaging.manifest`	82.4%	73.5%	34	1
`openpyxl.packaging.relationship`	91.3%	91.3%	23	0
`openpyxl.packaging.workbook`	90.5%	81.1%	74	1
`openpyxl.pivot.cache`	97.6%	91.7%	373	1
`openpyxl.pivot.fields`	91.2%	78.7%	136	0
`openpyxl.pivot.record`	71.0%	45.2%	31	1
`openpyxl.pivot.table`	97.3%	92.6%	488	2
`openpyxl.reader.drawings`	100.0%	100.0%	3	0
`openpyxl.reader.excel`	97.8%	97.8%	45	0
`openpyxl.reader.strings`	100.0%	100.0%	4	0
`openpyxl.reader.workbook`	100.0%	100.0%	15	0
`openpyxl.styles.alignment`	79.3%	79.3%	58	0
`openpyxl.styles.borders`	95.5%	93.3%	89	0
`openpyxl.styles.builtins`	100.0%	98.0%	51	0
`openpyxl.styles.cell_style`	92.1%	88.2%	76	1
`openpyxl.styles.colors`	96.6%	93.1%	58	0
`openpyxl.styles.differential`	96.9%	93.8%	32	0
`openpyxl.styles.fills`	97.5%	94.9%	118	1
`openpyxl.styles.fonts`	100.0%	100.0%	100	0
`openpyxl.styles.named_styles`	93.7%	90.5%	63	1
`openpyxl.styles.numbers`	96.2%	94.9%	78	0
`openpyxl.styles.protection`	100.0%	100.0%	12	0
`openpyxl.styles.proxy`	50.0%	50.0%	16	0
`openpyxl.styles.styleable`	100.0%	100.0%	51	0
`openpyxl.styles.stylesheet`	88.1%	66.7%	42	0
`openpyxl.styles.table`	93.9%	87.9%	33	0
`openpyxl.utils.bound_dictionary`	60.0%	60.0%	5	0
`openpyxl.utils.cell`	100.0%	100.0%	52	0
`openpyxl.utils.dataframe`	71.4%	71.4%	7	0
`openpyxl.utils.datetime`	28.0%	28.0%	25	0
`openpyxl.utils.escape`	100.0%	100.0%	4	0
`openpyxl.utils.exceptions`	0.0%	0.0%	0	0
`openpyxl.utils.formulas`	100.0%	100.0%	4	0
`openpyxl.utils.indexed_list`	100.0%	100.0%	11	1
`openpyxl.utils.inference`	33.3%	33.3%	9	0
`openpyxl.utils.protection`	100.0%	100.0%	2	0
`openpyxl.utils.units`	21.1%	21.1%	38	0
`openpyxl.workbook.child`	100.0%	100.0%	4	0
`openpyxl.workbook.defined_name`	98.0%	96.0%	50	0
`openpyxl.workbook.external_link.external`	92.2%	84.4%	77	1
`openpyxl.workbook.external_reference`	75.0%	50.0%	4	0
`openpyxl.workbook.function_group`	90.9%	81.8%	11	0
`openpyxl.workbook.properties`	98.8%	97.5%	80	0
`openpyxl.workbook.protection`	84.5%	72.4%	58	0
`openpyxl.workbook.smart_tags`	94.7%	89.5%	19	0
`openpyxl.workbook.views`	100.0%	98.3%	58	0
`openpyxl.workbook.web`	97.1%	94.1%	34	0
`openpyxl.workbook.workbook`	100.0%	86.0%	214	2
`openpyxl.worksheet.cell_range`	80.5%	79.2%	77	2
`openpyxl.worksheet.cell_watch`	88.9%	77.8%	9	0
`openpyxl.worksheet.controls`	95.6%	91.1%	45	0
`openpyxl.worksheet.copier`	100.0%	100.0%	6	0
`openpyxl.worksheet.custom`	88.9%	77.8%	9	0
`openpyxl.worksheet.datavalidation`	86.4%	84.8%	66	1
`openpyxl.worksheet.dimensions`	94.4%	94.4%	108	2
`openpyxl.worksheet.drawing`	75.0%	50.0%	4	0
`openpyxl.worksheet.errors`	92.1%	84.2%	38	0
`openpyxl.worksheet.filters`	91.6%	86.5%	155	4
`openpyxl.worksheet.formula`	77.8%	70.4%	27	0
`openpyxl.worksheet.header_footer`	100.0%	100.0%	41	0
`openpyxl.worksheet.hyperlink`	94.7%	89.5%	19	0
`openpyxl.worksheet.merge`	78.3%	73.9%	23	0
`openpyxl.worksheet.ole`	97.5%	95.0%	40	0
`openpyxl.worksheet.page`	94.7%	90.8%	76	0
`openpyxl.worksheet.pagebreak`	92.9%	89.3%	28	0
`openpyxl.worksheet.picture`	100.0%	100.0%	1	0
`openpyxl.worksheet.print_settings`	93.9%	93.9%	33	1
`openpyxl.worksheet.properties`	100.0%	100.0%	43	0
`openpyxl.worksheet.protection`	93.9%	87.8%	49	0
`openpyxl.worksheet.related`	83.3%	66.7%	6	1
`openpyxl.worksheet.scenario`	93.3%	86.7%	30	0
`openpyxl.worksheet.smart_tag`	91.7%	79.2%	24	0
`openpyxl.worksheet.table`	90.8%	86.9%	130	1
`openpyxl.worksheet.views`	98.6%	97.3%	74	0
`openpyxl.worksheet.worksheet`	99.1%	99.1%	115	0
`openpyxl.writer.excel`	100.0%	100.0%	13	0
`openpyxl.writer.theme`	50.0%	50.0%	2	0
`openpyxl.xml`	100.0%	100.0%	8	0
`openpyxl.xml._functions_overloads`	94.6%	94.6%	37	0
`openpyxl.xml.constants`	100.0%	100.0%	76	0
`openpyxl.xml.functions`	100.0%	83.3%	6	0

Incomplete Annotations

openpyxl.cell.read_only (6 missing, 12 any)

	Symbol	Typable	Typed	Any
`meth`	`ReadOnlyCell.init`	7	4	0
`attr`	`ReadOnlyCell.row`	1	1	1
`attr`	`ReadOnlyCell.column`	1	1	1
`attr`	`ReadOnlyCell.data_type`	1	1	1
`meth`	`ReadOnlyCell.init`	7	4	0
`attr`	`ReadOnlyCell.row`	1	1	1
`attr`	`ReadOnlyCell.column`	1	1	1
`attr`	`ReadOnlyCell.data_type`	1	1	1
`attr`	`EmptyCell.value`	1	1	1
`attr`	`EmptyCell.font`	1	1	1
`attr`	`EmptyCell.border`	1	1	1
`attr`	`EmptyCell.fill`	1	1	1
`attr`	`EmptyCell.number_format`	1	1	1
`attr`	`EmptyCell.alignment`	1	1	1

openpyxl.cell.text (2 missing, 2 any)

	Symbol	Typable	Typed	Any
`meth`	`Text.init`	5	3	0
`attr`	`Text.r`	1	1	1
`attr`	`Text.rPh`	1	1	1

openpyxl.chart._chart (6 missing, 5 any)

	Symbol	Typable	Typed	Any
`meth`	`ChartBase.init`	3	2	0
`meth`	`ChartBase.iadd`	2	0	0
`meth`	`ChartBase.set_categories`	2	1	0
`meth`	`ChartBase.add_data`	4	3	0
`meth`	`ChartBase.append`	2	1	0
`attr`	`ChartBase.axId`	1	1	1
`attr`	`ChartBase.ser`	1	1	1
`attr`	`ChartBase.plot_area`	1	1	1
`attr`	`ChartBase.pivotSource`	1	1	1
`attr`	`ChartBase.pivotFormats`	1	1	1

openpyxl.chart.area_chart (6 missing, 2 any)

	Symbol	Typable	Typed	Any
`meth`	`AreaChart.init`	4	3	0
`meth`	`AreaChart3D.init`	3	1	0
`attr`	`AreaChart3D.gapDepth`	1	1	1
`meth`	`AreaChart3D.init`	3	1	0
`attr`	`AreaChart3D.gapDepth`	1	1	1
`meth`	`AreaChart.init`	4	3	0

openpyxl.chart.axis (4 missing, 0 any)

	Symbol	Typable	Typed
`meth`	`SeriesAxis.init`	5	4
`meth`	`DateAxis.init`	10	9
`meth`	`TextAxis.init`	9	8
`meth`	`NumericAxis.init`	7	6

openpyxl.chart.bar_chart (6 missing, 10 any)

	Symbol	Typable	Typed	Any
`meth`	`BarChart.init`	6	4	0
`attr`	`BarChart.gapWidth`	1	1	1
`attr`	`BarChart.overlap`	1	1	1
`attr`	`BarChart.legend`	1	1	1
`meth`	`BarChart3D.init`	7	6	0
`attr`	`BarChart3D.gapWidth`	1	1	1
`attr`	`BarChart3D.gapDepth`	1	1	1
`meth`	`BarChart.init`	6	4	0
`attr`	`BarChart.gapWidth`	1	1	1
`attr`	`BarChart.overlap`	1	1	1
`attr`	`BarChart.legend`	1	1	1
`meth`	`BarChart3D.init`	7	6	0
`attr`	`BarChart3D.gapWidth`	1	1	1
`attr`	`BarChart3D.gapDepth`	1	1	1

openpyxl.chart.bubble_chart (4 missing, 2 any)

	Symbol	Typable	Typed	Any
`meth`	`BubbleChart.init`	10	8	0
`attr`	`BubbleChart.ser`	1	1	1
`meth`	`BubbleChart.init`	10	8	0
`attr`	`BubbleChart.ser`	1	1	1

openpyxl.chart.chartspace (1 missing, 2 any)

	Symbol	Typable	Typed	Any
`meth`	`ChartContainer.init`	14	13	0
`attr`	`ChartContainer.pivotFmts`	1	1	1
`attr`	`ChartSpace.userShapes`	1	1	1

openpyxl.chart.data_source (6 missing, 5 any)

	Symbol	Typable	Typed	Any
`meth`	`NumData.init`	5	4	0
`attr`	`NumData.pt`	1	1	1
`meth`	`NumVal.init`	4	3	0
`attr`	`NumVal.v`	1	1	1
`meth`	`Level.init`	2	1	0
`attr`	`Level.pt`	1	1	1
`meth`	`StrData.init`	4	3	0
`attr`	`StrData.pt`	1	1	1
`meth`	`NumberValueDescriptor.set`	3	2	0
`meth`	`MultiLevelStrData.init`	4	3	0
`attr`	`MultiLevelStrData.lvl`	1	1	1

openpyxl.chart.descriptors (1 missing, 0 any)

	Symbol	Typable	Typed	Any
`meth`	`NumberFormatDescriptor.set`	3	2	0

openpyxl.chart.label (3 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`DataLabelList.init`	4	2	0
`attr`	`DataLabelList.dLbl`	1	1	1
`meth`	`DataLabel.init`	3	2	0

openpyxl.chart.legend (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`Legend.init`	8	7	0
`attr`	`Legend.legendEntry`	1	1	1

openpyxl.chart.line_chart (6 missing, 2 any)

	Symbol	Typable	Typed	Any
`meth`	`LineChart3D.init`	7	5	0
`attr`	`LineChart3D.gapDepth`	1	1	1
`meth`	`LineChart.init`	7	6	0
`meth`	`LineChart3D.init`	7	5	0
`attr`	`LineChart3D.gapDepth`	1	1	1
`meth`	`LineChart.init`	7	6	0

openpyxl.chart.pie_chart (9 missing, 3 any)

	Symbol	Typable	Typed	Any
`meth`	`PieChart.init`	4	3	0
`meth`	`DoughnutChart.init`	5	4	0
`meth`	`ProjectedPieChart.init`	10	8	0
`attr`	`ProjectedPieChart.gapWidth`	1	1	1
`meth`	`CustomSplit.init`	2	1	0
`attr`	`CustomSplit.secondPiePt`	1	1	1
`meth`	`PieChart.init`	4	3	0
`meth`	`DoughnutChart.init`	5	4	0
`meth`	`ProjectedPieChart.init`	10	8	0
`attr`	`ProjectedPieChart.gapWidth`	1	1	1

openpyxl.chart.plotarea (2 missing, 20 any)

	Symbol	Typable	Typed	Any
`meth`	`PlotArea.init`	7	5	0
`attr`	`PlotArea.areaChart`	1	1	1
`attr`	`PlotArea.area3DChart`	1	1	1
`attr`	`PlotArea.lineChart`	1	1	1
`attr`	`PlotArea.line3DChart`	1	1	1
`attr`	`PlotArea.stockChart`	1	1	1
`attr`	`PlotArea.radarChart`	1	1	1
`attr`	`PlotArea.scatterChart`	1	1	1
`attr`	`PlotArea.pieChart`	1	1	1
`attr`	`PlotArea.pie3DChart`	1	1	1
`attr`	`PlotArea.doughnutChart`	1	1	1
`attr`	`PlotArea.barChart`	1	1	1
`attr`	`PlotArea.bar3DChart`	1	1	1
`attr`	`PlotArea.ofPieChart`	1	1	1
`attr`	`PlotArea.surfaceChart`	1	1	1
`attr`	`PlotArea.surface3DChart`	1	1	1
`attr`	`PlotArea.bubbleChart`	1	1	1
`attr`	`PlotArea.valAx`	1	1	1
`attr`	`PlotArea.catAx`	1	1	1
`attr`	`PlotArea.dateAx`	1	1	1
`attr`	`PlotArea.serAx`	1	1	1

openpyxl.chart.radar_chart (4 missing, 2 any)

	Symbol	Typable	Typed	Any
`meth`	`RadarChart.init`	7	5	0
`attr`	`RadarChart.ser`	1	1	1
`meth`	`RadarChart.init`	7	5	0
`attr`	`RadarChart.ser`	1	1	1

openpyxl.chart.reader (2 missing, 0 any)

	Symbol	Typable	Typed	Any
`func`	`openpyxl.chart.reader.read_chart`	2	0	0

openpyxl.chart.reference (2 missing, 0 any)

	Symbol	Typable	Typed	Any
`meth`	`Reference.pop`	1	0	0
`meth`	`Reference.pop`	1	0	0

openpyxl.chart.scatter_chart (4 missing, 2 any)

	Symbol	Typable	Typed	Any
`meth`	`ScatterChart.init`	7	5	0
`attr`	`ScatterChart.ser`	1	1	1
`meth`	`ScatterChart.init`	7	5	0
`attr`	`ScatterChart.ser`	1	1	1

openpyxl.chart.series (1 missing, 3 any)

	Symbol	Typable	Typed	Any
`attr`	`openpyxl.chart.series.attribute_mapping`	1	1	1
`meth`	`Series.init`	22	21	0
`attr`	`Series.graphicalProperties`	1	1	1
`attr`	`Series.dPt`	1	1	1

openpyxl.chart.series_factory (1 missing, 0 any)

	Symbol	Typable	Typed	Any
`func`	`openpyxl.chart.series_factory.SeriesFactory`	6	5	0

openpyxl.chart.shapes (1 missing, 0 any)

	Symbol	Typable	Typed	Any
`meth`	`GraphicalProperties.init`	13	12	0

openpyxl.chart.stock_chart (4 missing, 2 any)

	Symbol	Typable	Typed	Any
`meth`	`StockChart.init`	8	6	0
`attr`	`StockChart.ser`	1	1	1
`meth`	`StockChart.init`	8	6	0
`attr`	`StockChart.ser`	1	1	1

openpyxl.chart.surface_chart (5 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`SurfaceChart.init`	2	1	0
`meth`	`SurfaceChart3D.init`	2	1	0
`meth`	`SurfaceChart3D.init`	2	1	0
`meth`	`SurfaceChart.init`	2	1	0
`meth`	`BandFormatList.init`	2	1	0
`attr`	`BandFormatList.bandFmt`	1	1	1

openpyxl.chart.text (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`RichText.init`	4	3	0
`attr`	`RichText.p`	1	1	1

openpyxl.chart.title (1 missing, 0 any)

	Symbol	Typable	Typed	Any
`func`	`openpyxl.chart.title.title_maker`	2	1	0

openpyxl.chart.updown_bars (0 missing, 1 any)

	Symbol	Typable	Typed	Any
`attr`	`UpDownBars.gapWidth`	1	1	1

openpyxl.chartsheet.chartsheet (2 missing, 0 any)

	Symbol	Typable	Typed	Any
`meth`	`Chartsheet.add_chart`	2	1	0
`meth`	`Chartsheet.add_chart`	2	1	0

openpyxl.chartsheet.custom (1 missing, 2 any)

	Symbol	Typable	Typed	Any
`attr`	`CustomChartsheetView.guid`	1	1	1
`meth`	`CustomChartsheetViews.init`	2	1	0
`attr`	`CustomChartsheetViews.customSheetView`	1	1	1

openpyxl.chartsheet.protection (3 missing, 3 any)

	Symbol	Typable	Typed	Any
`meth`	`ChartsheetProtection.init`	8	5	0
`attr`	`ChartsheetProtection.hashValue`	1	1	1
`attr`	`ChartsheetProtection.saltValue`	1	1	1
`attr`	`ChartsheetProtection.password`	1	1	1

openpyxl.chartsheet.publish (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`WebPublishItems.init`	3	2	0
`attr`	`WebPublishItems.webPublishItem`	1	1	1

openpyxl.chartsheet.relation (2 missing, 2 any)

	Symbol	Typable	Typed	Any
`meth`	`SheetBackgroundPicture.init`	2	1	0
`attr`	`SheetBackgroundPicture.id`	1	1	1
`meth`	`DrawingHF.init`	20	19	0
`attr`	`DrawingHF.id`	1	1	1

openpyxl.chartsheet.views (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`ChartsheetViewList.init`	3	2	0
`attr`	`ChartsheetViewList.sheetView`	1	1	1

openpyxl.comments.author (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`AuthorList.init`	2	1	0
`attr`	`AuthorList.author`	1	1	1

openpyxl.comments.comment_sheet (7 missing, 4 any)

	Symbol	Typable	Typed	Any
`meth`	`CommentSheet.init`	4	3	0
`meth`	`CommentSheet.from_comments`	2	0	0
`meth`	`CommentSheet.write_shapes`	2	0	0
`attr`	`CommentSheet.commentList`	1	1	1
`meth`	`CommentRecord.init`	10	9	0
`meth`	`CommentRecord.from_cell`	2	1	0
`attr`	`CommentRecord.guid`	1	1	1
`attr`	`CommentRecord.height`	1	1	1
`attr`	`CommentRecord.width`	1	1	1

openpyxl.comments.comments (8 missing, 10 any)

	Symbol	Typable	Typed	Any
`meth`	`Comment.init`	5	3	0
`meth`	`Comment.copy`	1	0	0
`meth`	`Comment.bind`	2	1	0
`prop`	`Comment.parent`	1	1	1
`attr`	`Comment.content`	1	1	1
`attr`	`Comment.author`	1	1	1
`attr`	`Comment.height`	1	1	1
`attr`	`Comment.width`	1	1	1
`meth`	`Comment.init`	5	3	0
`meth`	`Comment.copy`	1	0	0
`meth`	`Comment.bind`	2	1	0
`prop`	`Comment.parent`	1	1	1
`attr`	`Comment.content`	1	1	1
`attr`	`Comment.author`	1	1	1
`attr`	`Comment.height`	1	1	1
`attr`	`Comment.width`	1	1	1

openpyxl.comments.shape_writer (5 missing, 3 any)

	Symbol	Typable	Typed	Any
`meth`	`ShapeWriter.init`	2	1	0
`meth`	`ShapeWriter.add_comment_shape`	6	2	0
`attr`	`ShapeWriter.vml`	1	1	1
`attr`	`ShapeWriter.vml_path`	1	1	1
`attr`	`ShapeWriter.comments`	1	1	1

openpyxl.compat (2 missing, 1 any)

	Symbol	Typable	Typed	Any
`attr`	`openpyxl.compat.string_types`	1	1	1
`func`	`openpyxl.compat.deprecated`	2	0	0

openpyxl.compat.product (2 missing, 0 any)

	Symbol	Typable	Typed	Any
`func`	`openpyxl.compat.product.product`	2	0	0

openpyxl.compat.singleton (0 missing, 5 any)

	Symbol	Typable	Typed	Any
`meth`	`Singleton.call`	3	3	3
`meth`	`Cached.call`	2	2	2

openpyxl.descriptors.base (2 missing, 0 any)

	Symbol	Typable	Typed	Any
`meth`	`Alias.set`	3	2	0
`meth`	`Alias.get`	3	2	0

openpyxl.descriptors.excel (3 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`Percentage.set`	3	2	0
`meth`	`ExtensionList.init`	2	1	0
`attr`	`ExtensionList.ext`	1	1	1
`meth`	`CellRange.set`	3	2	0

openpyxl.descriptors.sequence (3 missing, 3 any)

	Symbol	Typable	Typed	Any
`meth`	`Sequence.set`	3	3	1
`meth`	`MultiSequencePart.init`	3	1	0
`meth`	`MultiSequencePart.set`	3	2	0
`attr`	`MultiSequencePart.store`	1	1	1
`meth`	`Sequence.set`	3	3	1

openpyxl.descriptors.serialisable (3 missing, 0 any)

	Symbol	Typable	Typed	Any
`meth`	`Serialisable.add`	2	0	0
`meth`	`Serialisable.copy`	1	0	0

openpyxl.drawing.colors (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`SystemColor.init`	31	30	0
`attr`	`SystemColor.lastClr`	1	1	1

openpyxl.drawing.drawing (0 missing, 2 any)

	Symbol	Typable	Typed	Any
`attr`	`Drawing.coordinates`	1	1	1
`attr`	`Drawing.coordinates`	1	1	1

openpyxl.drawing.effect (3 missing, 0 any)

	Symbol	Typable	Typed
`meth`	`GlowEffect.init`	3	2
`meth`	`InnerShadowEffect.init`	5	4
`meth`	`PresetShadowEffect.init`	5	4

openpyxl.drawing.fill (7 missing, 7 any)

	Symbol	Typable	Typed	Any
`meth`	`Blip.init`	32	30	0
`attr`	`Blip.embed`	1	1	1
`attr`	`Blip.link`	1	1	1
`meth`	`RelativeRect.init`	5	1	0
`attr`	`RelativeRect.l`	1	1	1
`attr`	`RelativeRect.t`	1	1	1
`attr`	`RelativeRect.r`	1	1	1
`attr`	`RelativeRect.b`	1	1	1
`meth`	`GradientFillProperties.init`	7	6	0
`attr`	`GradientFillProperties.gsLst`	1	1	1

openpyxl.drawing.geometry (12 missing, 8 any)

	Symbol	Typable	Typed	Any
`meth`	`GeomRect.init`	5	1	0
`attr`	`GeomRect.l`	1	1	1
`attr`	`GeomRect.t`	1	1	1
`attr`	`GeomRect.r`	1	1	1
`attr`	`GeomRect.b`	1	1	1
`meth`	`AdjPoint2D.init`	3	1	0
`attr`	`AdjPoint2D.x`	1	1	1
`attr`	`AdjPoint2D.y`	1	1	1
`attr`	`GroupTransform2D.off`	1	0	0
`attr`	`GroupTransform2D.ext`	1	0	0
`attr`	`GroupTransform2D.chOff`	1	0	0
`attr`	`GroupTransform2D.chExt`	1	0	0
`meth`	`Point2D.init`	3	1	0
`attr`	`Point2D.x`	1	1	1
`attr`	`Point2D.y`	1	1	1

openpyxl.drawing.graphic (2 missing, 0 any)

	Symbol	Typable	Typed	Any
`meth`	`NonVisualGraphicFrame.init`	3	1	0

openpyxl.drawing.line (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`DashStopList.init`	2	1	0
`attr`	`DashStopList.ds`	1	1	1

openpyxl.drawing.picture (1 missing, 0 any)

	Symbol	Typable	Typed	Any
`meth`	`NonVisualPictureProperties.init`	4	3	0

openpyxl.drawing.properties (2 missing, 2 any)

	Symbol	Typable	Typed	Any
`meth`	`NonVisualGroupDrawingShapeProps.init`	3	2	0
`attr`	`NonVisualDrawingProps.id`	1	1	1
`meth`	`NonVisualDrawingShapeProps.init`	4	3	0
`attr`	`NonVisualDrawingShapeProps.txBox`	1	1	1

openpyxl.drawing.relation (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`ChartRelation.init`	2	1	0
`attr`	`ChartRelation.id`	1	1	1

openpyxl.drawing.spreadsheet_drawing (6 missing, 5 any)

	Symbol	Typable	Typed	Any
`meth`	`AbsoluteAnchor.init`	4	3	0
`meth`	`TwoCellAnchor.init`	5	4	0
`meth`	`OneCellAnchor.init`	4	3	0
`meth`	`SpreadsheetDrawing.init`	4	1	0
`attr`	`SpreadsheetDrawing.twoCellAnchor`	1	1	1
`attr`	`SpreadsheetDrawing.oneCellAnchor`	1	1	1
`attr`	`SpreadsheetDrawing.absoluteAnchor`	1	1	1
`attr`	`SpreadsheetDrawing.charts`	1	1	1
`attr`	`SpreadsheetDrawing.images`	1	1	1

openpyxl.drawing.text (5 missing, 4 any)

	Symbol	Typable	Typed	Any
`meth`	`TabStopList.init`	2	1	0
`meth`	`Hyperlink.init`	11	10	0
`attr`	`Hyperlink.id`	1	1	1
`meth`	`Font.init`	5	4	0
`attr`	`Font.panose`	1	1	1
`meth`	`GeomGuideList.init`	2	1	0
`attr`	`GeomGuideList.gd`	1	1	1
`meth`	`Paragraph.init`	6	5	0
`attr`	`Paragraph.r`	1	1	1

openpyxl.formatting.formatting (8 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`ConditionalFormatting.init`	5	4	0
`attr`	`ConditionalFormatting.cfRule`	1	1	1
`meth`	`ConditionalFormattingList.add`	3	1	0
`meth`	`ConditionalFormattingList.getitem`	2	0	0
`meth`	`ConditionalFormattingList.delitem`	2	1	0
`meth`	`ConditionalFormattingList.setitem`	3	1	0

openpyxl.formatting.rule (46 missing, 8 any)

	Symbol	Typable	Typed	Any
`meth`	`Rule.init`	20	19	0
`attr`	`Rule.formula`	1	1	1
`attr`	`DataBar.cfvo`	1	1	1
`attr`	`RuleType.cfvo`	1	1	1
`func`	`openpyxl.formatting.rule.IconSetRule`	7	0	0
`meth`	`FormatObject.init`	5	4	0
`attr`	`FormatObject.val`	1	1	1
`func`	`openpyxl.formatting.rule.ColorScaleRule`	10	0	0
`func`	`openpyxl.formatting.rule.FormulaRule`	6	0	0
`func`	`openpyxl.formatting.rule.CellIsRule`	7	0	0
`meth`	`ValueDescriptor.set`	3	2	0
`meth`	`IconSet.init`	6	5	0
`attr`	`IconSet.cfvo`	1	1	1
`meth`	`ColorScale.init`	3	1	0
`attr`	`ColorScale.color`	1	1	1
`attr`	`ColorScale.cfvo`	1	1	1
`meth`	`Rule.init`	20	19	0
`attr`	`Rule.formula`	1	1	1
`func`	`openpyxl.formatting.rule.DataBarRule`	9	0	0

openpyxl.formula.tokenizer (16 missing, 9 any)

	Symbol	Typable	Typed	Any
`meth`	`Tokenizer.init`	2	1	0
`meth`	`Tokenizer.check_scientific_notation`	1	0	0
`meth`	`Tokenizer.assert_empty_token`	2	1	0
`meth`	`Tokenizer.render`	1	0	0
`attr`	`Tokenizer.formula`	1	1	1
`attr`	`Tokenizer.items`	1	1	1
`attr`	`Tokenizer.token_stack`	1	1	1
`attr`	`Tokenizer.token`	1	1	1
`meth`	`Tokenizer.init`	2	1	0
`meth`	`Tokenizer.check_scientific_notation`	1	0	0
`meth`	`Tokenizer.assert_empty_token`	2	1	0
`meth`	`Tokenizer.render`	1	0	0
`attr`	`Tokenizer.formula`	1	1	1
`attr`	`Tokenizer.items`	1	1	1
`attr`	`Tokenizer.token_stack`	1	1	1
`attr`	`Tokenizer.token`	1	1	1
`meth`	`Token.init`	4	3	0
`meth`	`Token.make_operand`	2	0	0
`meth`	`Token.make_subexp`	3	1	0
`meth`	`Token.get_closer`	1	0	0
`meth`	`Token.make_separator`	2	0	0
`attr`	`Token.value`	1	1	1

openpyxl.formula.translate (17 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`Translator.init`	3	1	0
`meth`	`Translator.get_tokens`	1	0	0
`meth`	`Translator.translate_row`	3	0	0
`meth`	`Translator.translate_col`	3	0	0
`meth`	`Translator.strip_ws_name`	2	0	0
`meth`	`Translator.translate_range`	4	0	0
`meth`	`Translator.translate_formula`	4	2	0
`attr`	`Translator.tokenizer`	1	1	1

openpyxl.packaging.core (3 missing, 3 any)

	Symbol	Typable	Typed	Any
`meth`	`DocumentProperties.init`	16	13	0
`attr`	`DocumentProperties.lastPrinted`	1	1	1
`attr`	`DocumentProperties.created`	1	1	1
`attr`	`DocumentProperties.modified`	1	1	1

openpyxl.packaging.custom (4 missing, 0 any)

	Symbol	Typable	Typed
`meth`	`CustomPropertyList.append`	2	1
`meth`	`CustomPropertyList.getitem`	2	0
`meth`	`CustomPropertyList.delitem`	2	1

openpyxl.packaging.manifest (6 missing, 3 any)

	Symbol	Typable	Typed	Any
`attr`	`openpyxl.packaging.manifest.mimetypes`	1	1	1
`meth`	`Manifest.init`	3	1	0
`meth`	`Manifest.find`	2	0	0
`meth`	`Manifest.findall`	2	1	0
`meth`	`Manifest.append`	2	1	0
`attr`	`Manifest.Default`	1	1	1
`attr`	`Manifest.Override`	1	1	1

openpyxl.packaging.relationship (2 missing, 0 any)

	Symbol	Typable	Typed	Any
`func`	`openpyxl.packaging.relationship.get_rels_path`	2	0	0

openpyxl.packaging.workbook (7 missing, 7 any)

	Symbol	Typable	Typed	Any
`meth`	`ChildSheet.init`	5	4	0
`attr`	`ChildSheet.id`	1	1	1
`meth`	`WorkbookPackage.init`	22	17	0
`attr`	`WorkbookPackage.bookViews`	1	1	1
`attr`	`WorkbookPackage.sheets`	1	1	1
`attr`	`WorkbookPackage.externalReferences`	1	1	1
`attr`	`WorkbookPackage.customWorkbookViews`	1	1	1
`attr`	`WorkbookPackage.pivotCaches`	1	1	1
`meth`	`PivotCache.init`	3	2	0
`attr`	`PivotCache.id`	1	1	1

openpyxl.pivot.cache (9 missing, 22 any)

	Symbol	Typable	Typed	Any
`meth`	`OLAPSet.init`	8	7	0
`attr`	`OLAPSet.sortType`	1	1	1
`meth`	`SharedItems.init`	16	15	0
`attr`	`SharedItems.m`	1	1	1
`attr`	`SharedItems.n`	1	1	1
`attr`	`SharedItems.b`	1	1	1
`attr`	`SharedItems.e`	1	1	1
`attr`	`SharedItems.s`	1	1	1
`attr`	`SharedItems.d`	1	1	1
`attr`	`CacheDefinition.records`	1	1	1
`attr`	`CacheDefinition.cacheFields`	1	1	1
`attr`	`CacheDefinition.cacheHierarchies`	1	1	1
`attr`	`CacheDefinition.calculatedItems`	1	1	1
`attr`	`CacheDefinition.calculatedMembers`	1	1	1
`attr`	`CacheDefinition.dimensions`	1	1	1
`attr`	`CacheDefinition.measureGroups`	1	1	1
`attr`	`CacheDefinition.maps`	1	1	1
`attr`	`CacheDefinition.id`	1	1	1
`meth`	`GroupItems.init`	8	1	0
`attr`	`GroupItems.m`	1	1	1
`attr`	`GroupItems.n`	1	1	1
`attr`	`GroupItems.b`	1	1	1
`attr`	`GroupItems.e`	1	1	1
`attr`	`GroupItems.s`	1	1	1
`attr`	`GroupItems.d`	1	1	1

openpyxl.pivot.fields (12 missing, 17 any)

	Symbol	Typable	Typed	Any
`meth`	`Boolean.init`	7	6	0
`attr`	`Boolean.x`	1	1	1
`attr`	`Error.x`	1	1	1
`attr`	`Error.bc`	1	1	1
`attr`	`Error.fc`	1	1	1
`attr`	`Number.tpls`	1	1	1
`attr`	`Number.x`	1	1	1
`attr`	`Number.bc`	1	1	1
`attr`	`Number.fc`	1	1	1
`meth`	`Missing.init`	14	10	0
`attr`	`Missing.tpls`	1	1	1
`attr`	`Missing.x`	1	1	1
`attr`	`Missing.bc`	1	1	1
`attr`	`Missing.fc`	1	1	1
`meth`	`Text.init`	15	9	0
`attr`	`Text.tpls`	1	1	1
`attr`	`Text.x`	1	1	1
`attr`	`Text.bc`	1	1	1
`attr`	`Text.fc`	1	1	1
`meth`	`DateTimeField.init`	7	6	0
`attr`	`DateTimeField.x`	1	1	1

openpyxl.pivot.record (9 missing, 8 any)

	Symbol	Typable	Typed	Any
`meth`	`RecordList.init`	4	3	0
`attr`	`RecordList.r`	1	1	1
`meth`	`Record.init`	9	1	0
`attr`	`Record.m`	1	1	1
`attr`	`Record.n`	1	1	1
`attr`	`Record.b`	1	1	1
`attr`	`Record.e`	1	1	1
`attr`	`Record.s`	1	1	1
`attr`	`Record.d`	1	1	1
`attr`	`Record.x`	1	1	1

openpyxl.pivot.table (13 missing, 23 any)

	Symbol	Typable	Typed	Any
`meth`	`MemberList.init`	4	2	0
`attr`	`MemberList.member`	1	1	1
`meth`	`RowColItem.init`	5	4	0
`attr`	`RowColItem.x`	1	1	1
`meth`	`ColHierarchiesUsage.init`	3	1	0
`attr`	`ColHierarchiesUsage.colHierarchyUsage`	1	1	1
`meth`	`PivotField.init`	52	51	0
`attr`	`PivotField.items`	1	1	1
`attr`	`Reference.x`	1	1	1
`meth`	`PivotArea.init`	15	14	0
`attr`	`PivotArea.references`	1	1	1
`meth`	`RowHierarchiesUsage.init`	3	1	0
`attr`	`RowHierarchiesUsage.rowHierarchyUsage`	1	1	1
`meth`	`PivotHierarchy.init`	15	14	0
`attr`	`PivotHierarchy.mps`	1	1	1
`attr`	`TableDefinition.cache`	1	1	1
`attr`	`TableDefinition.pivotFields`	1	1	1
`attr`	`TableDefinition.rowFields`	1	1	1
`attr`	`TableDefinition.rowItems`	1	1	1
`attr`	`TableDefinition.colFields`	1	1	1
`attr`	`TableDefinition.colItems`	1	1	1
`attr`	`TableDefinition.pageFields`	1	1	1
`attr`	`TableDefinition.dataFields`	1	1	1
`attr`	`TableDefinition.formats`	1	1	1
`attr`	`TableDefinition.chartFormats`	1	1	1
`attr`	`TableDefinition.pivotHierarchies`	1	1	1
`attr`	`TableDefinition.filters`	1	1	1
`attr`	`TableDefinition.id`	1	1	1
`meth`	`ConditionalFormatList.init`	3	1	0
`meth`	`ConditionalFormatList.by_priority`	1	0	0
`attr`	`ConditionalFormatList.conditionalFormat`	1	1	1
`attr`	`ConditionalFormat.pivotAreas`	1	1	1

openpyxl.reader.excel (1 missing, 0 any)

	Symbol	Typable	Typed	Any
`attr`	`openpyxl.reader.excel.KEEP_VBA`	1	0	0

openpyxl.styles.alignment (12 missing, 0 any)

	Symbol	Typable	Typed	Any
`meth`	`Alignment.init`	14	8	0
`meth`	`Alignment.init`	14	8	0

openpyxl.styles.borders (4 missing, 2 any)

	Symbol	Typable	Typed	Any
`meth`	`Border.init`	14	13	0
`attr`	`Border.diagonal_direction`	1	1	1
`meth`	`Side.init`	4	3	0
`meth`	`Border.init`	14	13	0
`attr`	`Border.diagonal_direction`	1	1	1
`meth`	`Side.init`	4	3	0

openpyxl.styles.builtins (0 missing, 1 any)

	Symbol	Typable	Typed	Any
`attr`	`openpyxl.styles.builtins.styles`	1	1	1

openpyxl.styles.cell_style (6 missing, 3 any)

	Symbol	Typable	Typed	Any
`meth`	`CellStyle.to_array`	1	0	0
`meth`	`CellStyle.from_array`	2	0	0
`meth`	`CellStyleList.init`	3	2	0
`meth`	`CellStyleList.getitem`	2	0	0
`attr`	`CellStyleList.xf`	1	1	1
`attr`	`CellStyleList.alignment`	1	1	1
`attr`	`CellStyleList.protection`	1	1	1

openpyxl.styles.colors (2 missing, 2 any)

	Symbol	Typable	Typed	Any
`meth`	`Color.init`	8	7	0
`meth`	`Color.init`	8	7	0
`attr`	`ColorList.indexedColors`	1	1	1
`attr`	`ColorList.mruColors`	1	1	1

openpyxl.styles.differential (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`DifferentialStyleList.init`	3	2	0
`attr`	`DifferentialStyleList.dxf`	1	1	1

openpyxl.styles.fills (3 missing, 3 any)

	Symbol	Typable	Typed	Any
`meth`	`GradientFill.init`	8	7	0
`attr`	`GradientFill.stop`	1	1	1
`meth`	`GradientFill.init`	8	7	0
`attr`	`GradientFill.stop`	1	1	1
`meth`	`Stop.init`	3	2	0
`attr`	`Stop.color`	1	1	1

openpyxl.styles.named_styles (4 missing, 2 any)

	Symbol	Typable	Typed	Any
`meth`	`NamedStyle.init`	10	9	0
`meth`	`NamedStyle.setattr`	3	2	0
`attr`	`NamedStyle.number_format`	1	1	1
`meth`	`NamedStyle.init`	10	9	0
`meth`	`NamedStyle.setattr`	3	2	0
`attr`	`NamedStyle.number_format`	1	1	1

openpyxl.styles.numbers (3 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`NumberFormatDescriptor.set`	3	2	0
`meth`	`NumberFormatList.init`	3	2	0
`attr`	`NumberFormatList.numFmt`	1	1	1
`meth`	`NumberFormatDescriptor.set`	3	2	0

openpyxl.styles.proxy (8 missing, 0 any)

	Symbol	Typable	Typed
`meth`	`StyleProxy.init`	2	1
`meth`	`StyleProxy.getattr`	2	1
`meth`	`StyleProxy.setattr`	3	2
`meth`	`StyleProxy.copy`	1	0
`meth`	`StyleProxy.add`	2	0
`meth`	`StyleProxy.copy`	2	0

openpyxl.styles.stylesheet (5 missing, 9 any)

	Symbol	Typable	Typed	Any
`meth`	`Stylesheet.init`	12	8	0
`attr`	`Stylesheet.fonts`	1	1	1
`attr`	`Stylesheet.fills`	1	1	1
`attr`	`Stylesheet.borders`	1	1	1
`attr`	`Stylesheet.dxfs`	1	1	1
`attr`	`Stylesheet.number_formats`	1	1	1
`attr`	`Stylesheet.cell_styles`	1	1	1
`attr`	`Stylesheet.alignments`	1	1	1
`attr`	`Stylesheet.protections`	1	1	1
`attr`	`Stylesheet.named_styles`	1	1	1
`func`	`openpyxl.styles.stylesheet.write_stylesheet`	2	1	0

openpyxl.styles.table (2 missing, 2 any)

	Symbol	Typable	Typed	Any
`meth`	`TableStyle.init`	6	5	0
`attr`	`TableStyle.tableStyleElement`	1	1	1
`meth`	`TableStyleList.init`	5	4	0
`attr`	`TableStyleList.tableStyle`	1	1	1

openpyxl.utils.bound_dictionary (2 missing, 0 any)

	Symbol	Typable	Typed	Any
`meth`	`BoundDictionary.init`	4	2	0

openpyxl.utils.dataframe (2 missing, 0 any)

	Symbol	Typable	Typed	Any
`func`	`openpyxl.utils.dataframe.dataframe_to_rows`	4	3	0
`func`	`openpyxl.utils.dataframe.expand_index`	3	2	0

openpyxl.utils.datetime (18 missing, 0 any)

	Symbol	Typable	Typed
`func`	`openpyxl.utils.datetime.to_ISO8601`	2	0
`func`	`openpyxl.utils.datetime.days_to_time`	2	0
`func`	`openpyxl.utils.datetime.to_excel`	3	0
`func`	`openpyxl.utils.datetime.time_to_days`	2	0
`func`	`openpyxl.utils.datetime.from_excel`	4	1
`func`	`openpyxl.utils.datetime.timedelta_to_days`	2	0
`func`	`openpyxl.utils.datetime.from_ISO8601`	2	0
`attr`	`openpyxl.utils.datetime.CALENDAR_MAC_1904`	1	0
`attr`	`openpyxl.utils.datetime.CALENDAR_WINDOWS_1900`	1	0

openpyxl.utils.inference (6 missing, 0 any)

	Symbol	Typable
`func`	`openpyxl.utils.inference.cast_percentage`	2
`func`	`openpyxl.utils.inference.cast_numeric`	2
`func`	`openpyxl.utils.inference.cast_time`	2

openpyxl.utils.units (30 missing, 0 any)

	Symbol	Typable	Typed
`func`	`openpyxl.utils.units.cm_to_dxa`	2	0
`func`	`openpyxl.utils.units.cm_to_EMU`	2	0
`func`	`openpyxl.utils.units.dxa_to_cm`	2	0
`func`	`openpyxl.utils.units.angle_to_degrees`	2	0
`func`	`openpyxl.utils.units.dxa_to_inch`	2	0
`func`	`openpyxl.utils.units.inch_to_EMU`	2	0
`func`	`openpyxl.utils.units.pixels_to_points`	3	1
`func`	`openpyxl.utils.units.EMU_to_cm`	2	0
`func`	`openpyxl.utils.units.EMU_to_pixels`	2	0
`func`	`openpyxl.utils.units.pixels_to_EMU`	2	0
`func`	`openpyxl.utils.units.degrees_to_angle`	2	0
`func`	`openpyxl.utils.units.short_color`	2	0
`func`	`openpyxl.utils.units.points_to_pixels`	3	1
`func`	`openpyxl.utils.units.inch_to_dxa`	2	0
`func`	`openpyxl.utils.units.EMU_to_inch`	2	0

openpyxl.workbook.defined_name (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`DefinedName.init`	17	16	0
`attr`	`DefinedName.attr_text`	1	1	1

openpyxl.workbook.external_link.external (6 missing, 6 any)

	Symbol	Typable	Typed	Any
`meth`	`ExternalSheetDataSet.init`	2	1	0
`attr`	`ExternalSheetDataSet.sheetData`	1	1	1
`meth`	`ExternalBook.init`	5	3	0
`attr`	`ExternalBook.definedNames`	1	1	1
`attr`	`ExternalBook.id`	1	1	1
`meth`	`ExternalRow.init`	3	2	0
`attr`	`ExternalRow.cell`	1	1	1
`meth`	`ExternalSheetNames.init`	2	1	0
`attr`	`ExternalSheetNames.sheetName`	1	1	1
`meth`	`ExternalSheetData.init`	4	3	0
`attr`	`ExternalSheetData.row`	1	1	1

openpyxl.workbook.external_reference (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`ExternalReference.init`	2	1	0
`attr`	`ExternalReference.id`	1	1	1

openpyxl.workbook.function_group (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`FunctionGroupList.init`	3	2	0
`attr`	`FunctionGroupList.functionGroup`	1	1	1

openpyxl.workbook.properties (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`FileVersion.init`	6	5	0
`attr`	`FileVersion.codeName`	1	1	1

openpyxl.workbook.protection (9 missing, 7 any)

	Symbol	Typable	Typed	Any
`meth`	`WorkbookProtection.init`	16	10	0
`attr`	`WorkbookProtection.revisionsHashValue`	1	1	1
`attr`	`WorkbookProtection.revisionsSaltValue`	1	1	1
`attr`	`WorkbookProtection.workbookHashValue`	1	1	1
`attr`	`WorkbookProtection.workbookSaltValue`	1	1	1
`meth`	`FileSharing.init`	8	5	0
`attr`	`FileSharing.reservationPassword`	1	1	1
`attr`	`FileSharing.hashValue`	1	1	1
`attr`	`FileSharing.saltValue`	1	1	1

openpyxl.workbook.smart_tags (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`SmartTagList.init`	2	1	0
`attr`	`SmartTagList.smartTagType`	1	1	1

openpyxl.workbook.views (0 missing, 1 any)

	Symbol	Typable	Typed	Any
`attr`	`CustomWorkbookView.guid`	1	1	1

openpyxl.workbook.web (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`WebPublishObjectList.init`	3	2	0
`attr`	`WebPublishObjectList.webPublishObject`	1	1	1

openpyxl.workbook.workbook (0 missing, 30 any)

	Symbol	Typable	Typed	Any
`meth`	`Workbook.create_sheet`	3	3	1
`attr`	`Workbook.defined_names`	1	1	1
`attr`	`Workbook.properties`	1	1	1
`attr`	`Workbook.security`	1	1	1
`attr`	`Workbook.loaded_theme`	1	1	1
`attr`	`Workbook.code_name`	1	1	1
`attr`	`Workbook.iso_dates`	1	1	1
`attr`	`Workbook.rels`	1	1	1
`attr`	`Workbook.calculation`	1	1	1
`attr`	`Workbook.views`	1	1	1
`meth`	`Workbook.create_sheet`	3	3	1
`attr`	`Workbook.defined_names`	1	1	1
`attr`	`Workbook.properties`	1	1	1
`attr`	`Workbook.security`	1	1	1
`attr`	`Workbook.loaded_theme`	1	1	1
`attr`	`Workbook.code_name`	1	1	1
`attr`	`Workbook.iso_dates`	1	1	1
`attr`	`Workbook.rels`	1	1	1
`attr`	`Workbook.calculation`	1	1	1
`attr`	`Workbook.views`	1	1	1
`meth`	`Workbook.create_sheet`	3	3	1
`attr`	`Workbook.defined_names`	1	1	1
`attr`	`Workbook.properties`	1	1	1
`attr`	`Workbook.security`	1	1	1
`attr`	`Workbook.loaded_theme`	1	1	1
`attr`	`Workbook.code_name`	1	1	1
`attr`	`Workbook.iso_dates`	1	1	1
`attr`	`Workbook.rels`	1	1	1
`attr`	`Workbook.calculation`	1	1	1
`attr`	`Workbook.views`	1	1	1

openpyxl.worksheet.cell_range (15 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`MultiCellRange.init`	2	1	0
`meth`	`MultiCellRange.add`	2	1	0
`meth`	`MultiCellRange.iadd`	2	0	0
`meth`	`MultiCellRange.remove`	2	1	0
`meth`	`MultiCellRange.copy`	1	0	0
`attr`	`MultiCellRange.ranges`	1	1	1
`meth`	`CellRange.copy`	1	0	0
`meth`	`CellRange.intersection`	2	0	0
`meth`	`CellRange.and`	2	0	0
`meth`	`CellRange.union`	2	0	0
`meth`	`CellRange.or`	2	0	0

openpyxl.worksheet.cell_watch (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`CellWatches.init`	2	1	0
`attr`	`CellWatches.cellWatch`	1	1	1

openpyxl.worksheet.controls (2 missing, 2 any)

	Symbol	Typable	Typed	Any
`meth`	`ControlProperty.init`	17	16	0
`attr`	`ControlProperty.id`	1	1	1
`meth`	`Controls.init`	2	1	0
`attr`	`Controls.control`	1	1	1

openpyxl.worksheet.custom (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`CustomProperties.init`	2	1	0
`attr`	`CustomProperties.customPr`	1	1	1

openpyxl.worksheet.datavalidation (9 missing, 1 any)

	Symbol	Typable	Typed	Any
`func`	`openpyxl.worksheet.datavalidation.expand_cell_ranges`	2	0	0
`meth`	`DataValidationList.init`	6	4	0
`meth`	`DataValidationList.append`	2	1	0
`attr`	`DataValidationList.dataValidation`	1	1	1
`func`	`openpyxl.worksheet.datavalidation.collapse_cell_addresses`	3	0	0
`meth`	`DataValidation.add`	2	1	0

openpyxl.worksheet.dimensions (6 missing, 0 any)

	Symbol	Typable	Typed
`meth`	`ColumnDimension.init`	15	14
`meth`	`RowDimension.init`	18	14
`meth`	`Dimension.init`	8	7

openpyxl.worksheet.drawing (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`Drawing.init`	2	1	0
`attr`	`Drawing.id`	1	1	1

openpyxl.worksheet.errors (3 missing, 3 any)

	Symbol	Typable	Typed	Any
`meth`	`IgnoredErrors.init`	3	2	0
`attr`	`IgnoredErrors.ignoredError`	1	1	1
`meth`	`ExtensionList.init`	2	1	0
`attr`	`ExtensionList.ext`	1	1	1
`meth`	`IgnoredError.init`	11	10	0
`attr`	`IgnoredError.sqref`	1	1	1

openpyxl.worksheet.filters (13 missing, 8 any)

	Symbol	Typable	Typed	Any
`meth`	`Filters.init`	5	3	0
`attr`	`Filters.filter`	1	1	1
`attr`	`Filters.dateGroupItem`	1	1	1
`meth`	`AutoFilter.init`	5	3	0
`meth`	`AutoFilter.add_filter_column`	4	2	0
`meth`	`AutoFilter.add_sort_condition`	3	2	0
`attr`	`AutoFilter.ref`	1	1	1
`attr`	`AutoFilter.filterColumn`	1	1	1
`meth`	`FilterColumn.init`	13	11	0
`meth`	`SortCondition.init`	8	7	0
`attr`	`SortCondition.ref`	1	1	1
`meth`	`CustomFilters.init`	3	2	0
`attr`	`CustomFilters.customFilter`	1	1	1
`meth`	`SortState.init`	7	5	0
`attr`	`SortState.ref`	1	1	1
`attr`	`SortState.sortCondition`	1	1	1

openpyxl.worksheet.formula (6 missing, 2 any)

	Symbol	Typable	Typed	Any
`meth`	`ArrayFormula.init`	3	1	0
`attr`	`ArrayFormula.ref`	1	1	1
`meth`	`DataTableFormula.init`	10	6	0
`attr`	`DataTableFormula.ref`	1	1	1

openpyxl.worksheet.hyperlink (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`Hyperlink.init`	7	6	0
`attr`	`Hyperlink.id`	1	1	1

openpyxl.worksheet.merge (5 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`MergeCells.init`	3	2	0
`attr`	`MergeCells.mergeCell`	1	1	1
`meth`	`MergeCell.init`	2	1	0
`meth`	`MergeCell.copy`	1	0	0
`meth`	`MergedCellRange.init`	3	2	0
`meth`	`MergedCellRange.copy`	1	0	0

openpyxl.worksheet.ole (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`OleObjects.init`	2	1	0
`attr`	`OleObjects.oleObject`	1	1	1

openpyxl.worksheet.page (4 missing, 3 any)

	Symbol	Typable	Typed	Any
`meth`	`PrintPageSetup.init`	21	17	0
`attr`	`PrintPageSetup.paperHeight`	1	1	1
`attr`	`PrintPageSetup.paperWidth`	1	1	1
`attr`	`PrintPageSetup.id`	1	1	1

openpyxl.worksheet.pagebreak (2 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`RowBreak.init`	4	3	0
`meth`	`RowBreak.append`	2	1	0
`attr`	`RowBreak.brk`	1	1	1

openpyxl.worksheet.print_settings (2 missing, 0 any)

	Symbol	Typable	Typed	Any
`meth`	`PrintArea.from_string`	2	1	0
`meth`	`PrintArea.init`	3	2	0

openpyxl.worksheet.protection (3 missing, 3 any)

	Symbol	Typable	Typed	Any
`meth`	`SheetProtection.init`	22	19	0
`attr`	`SheetProtection.saltValue`	1	1	1
`attr`	`SheetProtection.hashValue`	1	1	1
`attr`	`SheetProtection.password`	1	1	1

openpyxl.worksheet.related (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`Related.init`	2	1	0
`attr`	`Related.id`	1	1	1

openpyxl.worksheet.scenario (2 missing, 2 any)

	Symbol	Typable	Typed	Any
`meth`	`ScenarioList.init`	5	4	0
`meth`	`ScenarioList.append`	2	1	0
`attr`	`ScenarioList.scenario`	1	1	1
`attr`	`Scenario.inputCells`	1	1	1

openpyxl.worksheet.smart_tag (2 missing, 3 any)

	Symbol	Typable	Typed	Any
`meth`	`CellSmartTags.init`	3	2	0
`attr`	`CellSmartTags.cellSmartTag`	1	1	1
`meth`	`SmartTags.init`	2	1	0
`attr`	`SmartTags.cellSmartTags`	1	1	1
`attr`	`CellSmartTag.cellSmartTagPr`	1	1	1

openpyxl.worksheet.table (12 missing, 5 any)

	Symbol	Typable	Typed	Any
`meth`	`Table.init`	28	25	0
`attr`	`Table.displayName`	1	1	1
`attr`	`Table.ref`	1	1	1
`attr`	`Table.tableColumns`	1	1	1
`meth`	`TablePartList.init`	3	2	0
`meth`	`TablePartList.append`	2	1	0
`attr`	`TablePartList.tablePart`	1	1	1
`meth`	`TableNameDescriptor.set`	3	2	0
`meth`	`TableFormula.init`	3	2	0
`attr`	`TableFormula.attr_text`	1	1	1
`meth`	`TableList.add`	2	1	0
`meth`	`TableList.get`	3	0	0
`meth`	`TableList.items`	1	0	0

openpyxl.worksheet.views (1 missing, 1 any)

	Symbol	Typable	Typed	Any
`meth`	`SheetView.init`	23	22	0
`attr`	`SheetView.selection`	1	1	1

openpyxl.worksheet.worksheet (1 missing, 0 any)

	Symbol	Typable	Typed	Any
`meth`	`Worksheet.add_pivot`	2	1	0

openpyxl.writer.theme (1 missing, 0 any)

	Symbol	Typable	Typed	Any
`func`	`openpyxl.writer.theme.write_theme`	1	0	0

openpyxl.xml._functions_overloads (2 missing, 0 any)

	Symbol	Typable	Typed	Any
`func`	`openpyxl.xml.functions.tostring`	14	13	0
`attr`	`openpyxl.xml.functions.safe_parser`	1	0	0

openpyxl.xml.functions (0 missing, 1 any)

	Symbol	Typable	Typed	Any
`attr`	`openpyxl.xml.functions.xmlfile`	1	1	1

Type-Ignore Comments

Flavor	Count
`type: ignore[override]`	34
`type: ignore[assignment]`	11
`type: ignore[misc]`	11

PyPI	https://pypi.org/project/types-openpyxl/
Repository	https://github.com/python/typeshed

`py.typed`
stubs-only	typeshed