一图看懂 openpyxl 资料之二, 整理+笔记（大全）

本文由 大侠(AhcaoZhu)原创，转载请声明。
链接: https://blog.csdn.net/Ahcao2008

摘要

全文介绍 openpyxl 的模块、函数、类及类的方法和属性。
前集见一图看懂 openpyxl 资料整理+笔记（大全）
它通过代码抓取并经AI智能翻译和人工校对。
是一部不可多得的权威字典类工具书。它是续集的一部分。后续陆续发布、敬请关注。【原创：AhcaoZhu大侠】

模块图

• 上次我们只给出了一级模块图。
  这次给出全部的。在以前文章讲过，由于模块引用关系的内在逻辑性不是很强，所以意义不太大，这里仅供参考。
• 为什么过了这么久才发第二集？
  因为大侠对以前的对象研究工具不太满意，花了一周多的时间进行了改版。所以本文素材、包括图等，都是改版后的第四版做的。这个版本也应该是文字版的终版了，考虑明年底之前可能做出可视化的图形版（假如那时还在坚持学习、并且水平够的话）。
  

图2-module-level4

模块全展开清单

1	openpyxl
2	openpyxl.compat
3	openpyxl.compat.numbers
4	openpyxl.compat.strings
5	openpyxl.xml
6	openpyxl.xml.constants
7	openpyxl.xml.functions
8	openpyxl.worksheet
9	openpyxl.worksheet.hyperlink
10	openpyxl.worksheet.formula
11	openpyxl.worksheet.cell_range
12	openpyxl.worksheet.header_footer
13	openpyxl.worksheet.datavalidation
14	openpyxl.worksheet.page
15	openpyxl.worksheet.dimensions
16	openpyxl.worksheet.protection
17	openpyxl.worksheet.filters
18	openpyxl.worksheet.views
19	openpyxl.worksheet.merge
20	openpyxl.worksheet.properties
21	openpyxl.worksheet.pagebreak
22	openpyxl.worksheet.scenario
23	openpyxl.worksheet.related
24	openpyxl.worksheet.table
25	openpyxl.worksheet.print_settings
26	openpyxl.worksheet.worksheet
27	openpyxl.worksheet._reader
28	openpyxl.worksheet._read_only
29	openpyxl.worksheet._writer
30	openpyxl.worksheet._write_only
31	openpyxl.worksheet.copier
32	openpyxl.worksheet.drawing
33	openpyxl.formula
34	openpyxl.formula.tokenizer
35	openpyxl.formula.translate
36	openpyxl.utils
37	openpyxl.utils.exceptions
38	openpyxl.utils.cell
39	openpyxl.utils.formulas
40	openpyxl.utils.datetime
41	openpyxl.utils.indexed_list
42	openpyxl.utils.escape
43	openpyxl.utils.units
44	openpyxl.utils.bound_dictionary
45	openpyxl.utils.protection
46	openpyxl.descriptors
47	openpyxl.descriptors.namespace
48	openpyxl.descriptors.base
49	openpyxl.descriptors.sequence
50	openpyxl.descriptors.serialisable
51	openpyxl.descriptors.nested
52	openpyxl.descriptors.excel
53	openpyxl.styles
54	openpyxl.styles.alignment
55	openpyxl.styles.colors
56	openpyxl.styles.borders
57	openpyxl.styles.fills
58	openpyxl.styles.fonts
59	openpyxl.styles.numbers
60	openpyxl.styles.protection
61	openpyxl.styles.cell_style
62	openpyxl.styles.named_styles
63	openpyxl.styles.proxy
64	openpyxl.styles.builtins
65	openpyxl.styles.styleable
66	openpyxl.styles.differential
67	openpyxl.styles.table
68	openpyxl.styles.stylesheet
69	openpyxl.cell
70	openpyxl.cell.text
71	openpyxl.cell.rich_text
72	openpyxl.cell.cell
73	openpyxl.cell.read_only
74	openpyxl.cell._writer
75	openpyxl.formatting
76	openpyxl.formatting.rule
77	openpyxl.formatting.formatting
78	openpyxl.packaging
79	openpyxl.packaging.relationship
80	openpyxl.packaging.manifest
81	openpyxl.packaging.extended
82	openpyxl.packaging.workbook
83	openpyxl.packaging.core
84	openpyxl.packaging.custom
85	openpyxl.comments
86	openpyxl.comments.comments
87	openpyxl.comments.author
88	openpyxl.comments.shape_writer
89	openpyxl.comments.comment_sheet
90	openpyxl.writer
91	openpyxl.writer.theme
92	openpyxl.writer.excel
93	openpyxl.drawing
94	openpyxl.drawing.drawing
95	openpyxl.drawing.image
96	openpyxl.drawing.colors
97	openpyxl.drawing.effect
98	openpyxl.drawing.fill
99	openpyxl.drawing.line
100	openpyxl.drawing.geometry
101	openpyxl.drawing.text
102	openpyxl.drawing.xdr
103	openpyxl.drawing.properties
104	openpyxl.drawing.connector
105	openpyxl.drawing.picture
106	openpyxl.drawing.relation
107	openpyxl.drawing.graphic
108	openpyxl.drawing.spreadsheet_drawing
109	openpyxl.chart
110	openpyxl.chart.layout
111	openpyxl.chart.picture
112	openpyxl.chart.shapes
113	openpyxl.chart.data_source
114	openpyxl.chart.text
115	openpyxl.chart.error_bar
116	openpyxl.chart.marker
117	openpyxl.chart._3d
118	openpyxl.chart.legend
119	openpyxl.chart.reference
120	openpyxl.chart.label
121	openpyxl.chart.trendline
122	openpyxl.chart.series
123	openpyxl.chart.series_factory
124	openpyxl.chart.title
125	openpyxl.chart._chart
126	openpyxl.chart.descriptors
127	openpyxl.chart.axis
128	openpyxl.chart.area_chart
129	openpyxl.chart.bar_chart
130	openpyxl.chart.bubble_chart
131	openpyxl.chart.updown_bars
132	openpyxl.chart.line_chart
133	openpyxl.chart.pie_chart
134	openpyxl.chart.radar_chart
135	openpyxl.chart.scatter_chart
136	openpyxl.chart.stock_chart
137	openpyxl.chart.surface_chart
138	openpyxl.chart.plotarea
139	openpyxl.chart.pivot
140	openpyxl.chart.print_settings
141	openpyxl.chart.chartspace
142	openpyxl.chart.reader
143	openpyxl.chartsheet
144	openpyxl.chartsheet.relation
145	openpyxl.chartsheet.properties
146	openpyxl.chartsheet.protection
147	openpyxl.chartsheet.views
148	openpyxl.chartsheet.custom
149	openpyxl.chartsheet.publish
150	openpyxl.chartsheet.chartsheet
151	openpyxl.workbook
152	openpyxl.workbook.child
153	openpyxl.workbook.defined_name
154	openpyxl.workbook.external_reference
155	openpyxl.workbook.function_group
156	openpyxl.workbook.properties
157	openpyxl.workbook.protection
158	openpyxl.workbook.smart_tags
159	openpyxl.workbook.views
160	openpyxl.workbook.web
161	openpyxl.workbook._writer
162	openpyxl.workbook.workbook
163	openpyxl.workbook.external_link
164	openpyxl.workbook.external_link.external
165	openpyxl.reader
166	openpyxl.reader.strings
167	openpyxl.reader.workbook
168	openpyxl.reader.drawings
169	openpyxl.reader.excel
170	openpyxl.pivot
171	openpyxl.pivot.fields
172	openpyxl.pivot.table
173	openpyxl.pivot.cache
174	openpyxl.pivot.record
175	openpyxl._constants

类关系图

图3-class-relationship-openpyxl

图4-class-relationship-all

全展开

统计

序号	类别	数量
2	bool	4
4	str	10
6	list	1
8	dict	1
9	module	20
10	class	1
11	function	2
13	residual	3
14	system	15
15	private	1
16	all	42

【openpyxl】

openpyxl, fullname=openpyxl, file=openpyxl_init_.py

常量

bool

1 DEBUG False
2 NUMPY True
3 DEFUSEDXML False
4 LXML True

模块

5 openpyxl.compat

compat, fullname=openpyxl.compat, file=openpyxl\compat_init_.py

6 openpyxl.xml

xml, fullname=openpyxl.xml, file=openpyxl\xml_init_.py

跨不同Python版本兼容的XML资源集合

7 openpyxl.worksheet

worksheet, fullname=openpyxl.worksheet, file=openpyxl\worksheet_init_.py

8 openpyxl.formula

formula, fullname=openpyxl.formula, file=openpyxl\formula_init_.py

9 openpyxl.utils

utils, fullname=openpyxl.utils, file=openpyxl\utils_init_.py

10 openpyxl.descriptors

descriptors, fullname=openpyxl.descriptors, file=openpyxl\descriptors_init_.py

11 openpyxl.styles

styles, fullname=openpyxl.styles, file=openpyxl\styles_init_.py

12 openpyxl.cell

cell, fullname=openpyxl.cell, file=openpyxl\cell_init_.py

13 openpyxl.formatting

formatting, fullname=openpyxl.formatting, file=openpyxl\formatting_init_.py

14 openpyxl.packaging

packaging, fullname=openpyxl.packaging, file=openpyxl\packaging_init_.py

与Office OpenXML打包相关的东西:关系、归档、内容类型。

15 openpyxl.comments

comments, fullname=openpyxl.comments, file=openpyxl\comments_init_.py

16 openpyxl.writer

writer, fullname=openpyxl.writer, file=openpyxl\writer_init_.py

17 openpyxl.drawing

drawing, fullname=openpyxl.drawing, file=openpyxl\drawing_init_.py

18 openpyxl.chart

chart, fullname=openpyxl.chart, file=openpyxl\chart_init_.py

19 openpyxl.chartsheet

chartsheet, fullname=openpyxl.chartsheet, file=openpyxl\chartsheet_init_.py

20 openpyxl.workbook

workbook, fullname=openpyxl.workbook, file=openpyxl\workbook_init_.py

21 openpyxl.reader

reader, fullname=openpyxl.reader, file=openpyxl\reader_init_.py

22 openpyxl.pivot

pivot, fullname=openpyxl.pivot, file=openpyxl\pivot_init_.py

23 openpyxl._constants

_constants, fullname=openpyxl._constants, file=openpyxl_constants.py

包元数据

函数

24 load_workbook(filename, read_only=False, keep_vba=False, data_only=False, keep_links=True, rich_text=False)

load_workbook(filename, read_only=False, keep_vba=False, data_only=False, keep_links=True, rich_text=False), module=openpyxl.reader.excel, line:314 at site-packages\openpyxl\reader\excel.py

打开给定的文件名并返回工作簿
    :param filename: 打开的路径或类文件对象
    :type filename: string或以二进制模式打开的类文件对象。例如, :class:`zipfile.ZipFile`
    :param read_only: 为读取优化，内容不能被编辑
    :type read_only: bool
    :param keep_vba: 保留vba内容(这并不意味着你可以使用它)
    :type keep_vba: bool
    :param data_only: 控制带公式的单元格是否有公式(默认值)或Excel上次读取表时存储的值
    :type data_only: bool
    :param keep_links: 是否应该保留外部工作簿的链接。默认值是True。
    :type keep_links: bool
    :param rich_text: 如果设置为True, openpyxl将在单元格中保留任何富文本格式。默认值是False。
    :type rich_text: bool
    :rtype: :class:`openpyxl.workbook.Workbook`
    .. note::
        当使用惰性加载时，所有的工作表将是:class:`openpyxl.worksheet.iter_worksheet.IterableWorksheet`
        而返回的工作簿将是只读的。

类

26 openpyxl.workbook.workbook.Workbook

Workbook, openpyxl.workbook.workbook.Workbook, module=openpyxl.workbook.workbook, line:51 at site-packages\openpyxl\workbook\workbook.py

工作簿是文档所有其他部分的容器。

data

1 path=/xl/workbook.xml kind:data type:str class:<class ‘openpyxl.workbook.workbook.Workbook’>
2 template=False kind:data type:bool class:<class ‘openpyxl.workbook.workbook.Workbook’>

property

3 active=<property object at 0x000000000B363818> kind:property type:property class:<class ‘openpyxl.workbook.workbook.Workbook’>
4 chartsheets=<property object at 0x000000000B36DB38> kind:property type:property class:<class ‘openpyxl.workbook.workbook.Workbook’>
5 data_only=<property object at 0x000000000AD1E098> kind:property type:property class:<class ‘openpyxl.workbook.workbook.Workbook’>
6 epoch=<property object at 0x000000000AD1AF98> kind:property type:property class:<class ‘openpyxl.workbook.workbook.Workbook’>
7 excel_base_date=<property object at 0x000000000B3693B8> kind:property type:property class:<class ‘openpyxl.workbook.workbook.Workbook’>
8 mime_type=<property object at 0x000000000B36DD18> kind:property type:property class:<class ‘openpyxl.workbook.workbook.Workbook’>
9 named_styles=<property object at 0x000000000B36DCC8> kind:property type:property class:<class ‘openpyxl.workbook.workbook.Workbook’>
10 read_only=<property object at 0x0000000002724098> kind:property type:property class:<class ‘openpyxl.workbook.workbook.Workbook’>
11 sheetnames=<property object at 0x000000000B36DB88> kind:property type:property class:<class ‘openpyxl.workbook.workbook.Workbook’>
12 style_names=<property object at 0x000000000B36DD68> kind:property type:property class:<class ‘openpyxl.workbook.workbook.Workbook’>
13 worksheets=<property object at 0x000000000B36DAE8> kind:property type:property class:<class ‘openpyxl.workbook.workbook.Workbook’>
14 write_only=<property object at 0x000000000B34CC78> kind:property type:property class:<class ‘openpyxl.workbook.workbook.Workbook’>

method

15 add_named_style(self, style)

kind:method class:<class ‘openpyxl.workbook.workbook.Workbook’> 343 at site-packages\openpyxl\workbook\workbook.py

添加命名样式

16 close(self)

kind:method class:<class ‘openpyxl.workbook.workbook.Workbook’> 417 at site-packages\openpyxl\workbook\workbook.py

关闭工作簿文件，如果打开。仅影响只读和只写模式。

17 copy_worksheet(self, from_worksheet)

kind:method class:<class ‘openpyxl.workbook.workbook.Workbook’> 397 at site-packages\openpyxl\workbook\workbook.py

复制当前工作簿中的现有工作表。
警告:此函数不能在工作簿之间复制工作表。工作表只能在其所属的工作簿内复制
:param from worksheet:要复制的工作表
:return:初始工作表的副本

18 create_chartsheet(self, title=None, index=None)

kind:method class:<class ‘openpyxl.workbook.workbook.Workbook’> 244 at site-packages\openpyxl\workbook\workbook.py

19 create_named_range(self, name, worksheet=None, value=None, scope=None)

kind:method class:<class ‘openpyxl.workbook.workbook.Workbook’> 30 at site-packages\openpyxl\compat_init_.py

在工作表上创建一个新的命名范围。
注意:已弃用:直接将有作用域的命名范围分配给工作表，或将全局范围分配给工作簿。3.1已弃用

20 create_sheet(self, title=None, index=None)

kind:method class:<class ‘openpyxl.workbook.workbook.Workbook’> 184 at site-packages\openpyxl\workbook\workbook.py

创建工作表(在可选索引处)。
    :param title:表的可选标题
    :type title: str
    :param index:表将插入的可选位置
    :type index: int

21 get_index(self, worksheet)

kind:method class:<class ‘openpyxl.workbook.workbook.Workbook’> 30 at site-packages\openpyxl\compat_init_.py

返回工作表的索引。
已弃用:请使用 wb.index(worksheet)

22 get_sheet_by_name(self, name)

kind:method class:<class ‘openpyxl.workbook.workbook.Workbook’> 30 at site-packages\openpyxl\compat_init_.py

按名称返回工作表。
    :参数名称:要查找的工作表的名称
    :类型名称:字符串
    ..注意::已弃用:使用 wb[sheetname]

23 get_sheet_names(self)

kind:method class:<class ‘openpyxl.workbook.workbook.Workbook’> 30 at site-packages\openpyxl\compat_init_.py

..注意::已弃用:使用wb.sheetnames

24 index(self, worksheet)

kind:method class:<class ‘openpyxl.workbook.workbook.Workbook’> 267 at site-packages\openpyxl\workbook\workbook.py

返回工作表的索引。

25 move_sheet(self, sheet, offset=0)

kind:method class:<class ‘openpyxl.workbook.workbook.Workbook’> 220 at site-packages\openpyxl\workbook\workbook.py

移动工作表或sheetname
        

26 remove(self, worksheet)

kind:method class:<class ‘openpyxl.workbook.workbook.Workbook’> 232 at site-packages\openpyxl\workbook\workbook.py

从工作簿中删除`worksheet`。

27 remove_sheet(self, worksheet)

kind:method class:<class ‘openpyxl.workbook.workbook.Workbook’> 30 at site-packages\openpyxl\compat_init_.py

从工作簿中删除“工作表”。
注意::已弃用:使用 wb.remove(worksheet) 或 del wb[sheetname]

28 save(self, filename)

kind:method class:<class ‘openpyxl.workbook.workbook.Workbook’> 373 at site-packages\openpyxl\workbook\workbook.py

将当前工作簿保存在给定的`filename`下。
使用这个函数而不是使用' ExcelWriter '
 ..警告:当创建你的工作簿使用' write only '设置为True时，你只能调用这个函数一次。
 后续尝试修改或保存该文件将引发一个:class:`openpyxl.shared.exc.WorkbookAlreadySaved`的例外。

统计

序号	类别	数量
4	str	4
5	tuple	2
6	list	1
8	dict	1
9	module	4
10	class	1
11	function	3
13	residual	3
14	system	9
16	all	19

【openpyxl.compat】

compat, fullname=openpyxl.compat, file=openpyxl\compat_init_.py

常量

tuple

1 NUMERIC_TYPES (<class ‘int’>, <class ‘float’>, <class ‘decimal.Decimal’>, <class ‘numpy.int16’…
2 string_types (<class ‘bytes’>, <class ‘str’>)

统计

序号	类别	数量
2	bool	1
4	str	4
5	tuple	1
8	dict	1
9	module	1
10	class	1
13	residual	3
14	system	8
16	all	12

【openpyxl.compat.numbers】

numbers, fullname=openpyxl.compat.numbers, file=openpyxl\compat\numbers.py

常量

bool

1 NUMPY True

tuple

2 NUMERIC_TYPES (<class ‘int’>, <class ‘float’>, <class ‘decimal.Decimal’>, <class ‘numpy.int16’…

统计

序号	类别	数量
4	str	4
5	tuple	1
8	dict	1
9	module	1
10	class	1
11	function	1
12	builtin_function_or_method	2
13	residual	4
14	system	8
16	all	15

【openpyxl.compat.strings】

strings, fullname=openpyxl.compat.strings, file=openpyxl\compat\strings.py

常量

tuple

1 NUMERIC_TYPES (<class ‘int’>, <class ‘float’>, <class ‘decimal.Decimal’>, <class ‘numpy.int16’…

剩余

2 doc None
3 loader <_frozen_importlib_external.SourceFileLoader object at 0x0000000003950488>
4 spec ModuleSpec(name=‘openpyxl.compat.strings’, loader=<_frozen_importlib_external.SourceFileLoader object at 0x0000000003950488>, origin=‘…\lib\site-packages\openpyxl\compat\strings.py’)
5 VER sys.version_info(major=3, minor=7, micro=8, releaselevel=‘final’, serial=0)

统计

序号	类别	数量
2	bool	2
4	str	5
6	list	1
8	dict	1
9	module	3
11	function	4
13	residual	2
14	system	9
16	all	18

【openpyxl.xml】

xml, fullname=openpyxl.xml, file=openpyxl\xml_init_.py

跨不同Python版本兼容的XML资源集合

常量

bool

1 LXML True
2 DEFUSEDXML False

统计

序号	类别	数量
1	int	4
4	str	75
8	dict	3
13	residual	2
14	system	8
16	all	84

【openpyxl.xml.constants】

constants, fullname=openpyxl.xml.constants, file=openpyxl\xml\constants.py

用于文件中固定路径和xml名称空间url的常量。

常量

int

1 MIN_ROW 0
2 MIN_COLUMN 0
3 MAX_COLUMN 16384
4 MAX_ROW 1048576

str

5 PACKAGE_PROPS docProps
6 PACKAGE_XL xl
7 PACKAGE_RELS _rels
8 PACKAGE_THEME xl/theme
9 PACKAGE_WORKSHEETS xl/worksheets
10 PACKAGE_CHARTSHEETS xl/chartsheets
11 PACKAGE_DRAWINGS xl/drawings
12 PACKAGE_CHARTS xl/charts
13 PACKAGE_IMAGES xl/media
14 PACKAGE_WORKSHEET_RELS xl/worksheets/_rels
15 PACKAGE_CHARTSHEETS_RELS xl/chartsheets/_rels
16 PACKAGE_PIVOT_TABLE xl/pivotTables
17 PACKAGE_PIVOT_CACHE xl/pivotCache
18 ARC_CONTENT_TYPES [Content_Types].xml
19 ARC_ROOT_RELS _rels/.rels
20 ARC_WORKBOOK_RELS xl/_rels/workbook.xml.rels
21 ARC_CORE docProps/core.xml
22 ARC_APP docProps/app.xml
23 ARC_CUSTOM docProps/custom.xml
24 ARC_WORKBOOK xl/workbook.xml
25 ARC_STYLE xl/styles.xml
26 ARC_THEME xl/theme/theme1.xml
27 ARC_SHARED_STRINGS xl/sharedStrings.xml
28 ARC_CUSTOM_UI customUI/customUI.xml
29 XML_NS
30 DCORE_NS
31 DCTERMS_NS
32 DCTERMS_PREFIX dcterms
33 DOC_NS
34 REL_NS
35 COMMENTS_NS
36 IMAGE_NS
37 VML_NS
38 VTYPES_NS
39 XPROPS_NS
40 CUSTPROPS_NS
41 EXTERNAL_LINK_NS
42 CPROPS_FMTID {D5CDD505-2E9C-101B-9397-08002B2CF9AE}
43 PKG_NS
44 PKG_REL_NS
45 COREPROPS_NS
46 CONTYPES_NS
47 XSI_NS
48 SHEET_MAIN_NS
49 CHART_NS
50 DRAWING_NS
51 SHEET_DRAWING_NS
52 CHART_DRAWING_NS
53 CUSTOMUI_NS
54 WORKBOOK_MACRO application/vnd.ms-excel.%s.macroEnabled.main+xml
55 WORKBOOK application/vnd.openxmlformats-officedocument.spreadsheetml.%s.main+xml
56 SPREADSHEET application/vnd.openxmlformats-officedocument.spreadsheetml.%s+xml
57 SHARED_STRINGS application/vnd.openxmlformats-officedocument.spreadsheetml.sharedStrings+xml
58 EXTERNAL_LINK application/vnd.openxmlformats-officedocument.spreadsheetml.externalLink+xml
59 WORKSHEET_TYPE application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml
60 COMMENTS_TYPE application/vnd.openxmlformats-officedocument.spreadsheetml.comments+xml
61 STYLES_TYPE application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml
62 CHARTSHEET_TYPE application/vnd.openxmlformats-officedocument.spreadsheetml.chartsheet+xml
63 DRAWING_TYPE application/vnd.openxmlformats-officedocument.drawing+xml
64 CHART_TYPE application/vnd.openxmlformats-officedocument.drawingml.chart+xml
65 CHARTSHAPE_TYPE application/vnd.openxmlformats-officedocument.drawingml.chartshapes+xml
66 THEME_TYPE application/vnd.openxmlformats-officedocument.theme+xml
67 CPROPS_TYPE application/vnd.openxmlformats-officedocument.custom-properties+xml
68 XLTM application/vnd.ms-excel.template.macroEnabled.main+xml
69 XLSM application/vnd.ms-excel.sheet.macroEnabled.main+xml
70 XLTX application/vnd.openxmlformats-officedocument.spreadsheetml.template.main+xml
71 XLSX application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml
72 CTRL application/vnd.ms-excel.controlproperties+xml
73 ACTIVEX application/vnd.ms-office.activeX+xml
74 VBA application/vnd.ms-office.vbaProject

dict

75 NAMESPACES {‘cp’: ‘http://schemas.openxmlformats.org/package/2006/metadata/core-properties’…
76 EXT_TYPES {‘{78C0D931-6437-407D-A8EE-F0AAD7539E65}’: ‘Conditional Formatting’, '{CCE6A557-…

统计

序号	类别	数量
2	bool	2
4	str	17
8	dict	1
9	module	1
10	class	4
11	function	3
13	residual	9
14	system	8
16	all	37

【openpyxl.xml.functions】

functions, fullname=openpyxl.xml.functions, file=openpyxl\xml\functions.py

XML兼容函数

常量

bool

1 DEFUSEDXML False
2 LXML True

str

3 CHART_NS
4 DRAWING_NS
5 SHEET_DRAWING_NS
6 CHART_DRAWING_NS
7 SHEET_MAIN_NS
8 REL_NS
9 VTYPES_NS
10 COREPROPS_NS
11 CUSTPROPS_NS
12 DCTERMS_NS
13 DCTERMS_PREFIX dcterms
14 XML_NS

剩余

15 loader <_frozen_importlib_external.SourceFileLoader object at 0x000000000AF1DF08>
16 spec ModuleSpec(name=‘openpyxl.xml.functions’, loader=<_frozen_importlib_external.SourceFileLoader object at 0x000000000AF1DF08>, origin=‘…\lib\site-packages\openpyxl\xml\functions.py’)
17 Element <cyfunction Element at 0x000000000A4D8EE8>
18 SubElement <cyfunction SubElement at 0x000000000A4DA2B8>
19 register_namespace <cyfunction register_namespace at 0x000000000A4D1A08>
20 fromstring functools.partial(<cyfunction fromstring at 0x000000000A4DA5F8>, parser=<lxml.etree.XMLParser object at 0x000000000AF0A5E8>)
21 tostring functools.partial(<cyfunction tostring at 0x000000000A4DAA08>, encoding=‘utf-8’)
22 safe_parser <lxml.etree.XMLParser object at 0x000000000AF0A5E8>
23 NS_REGEX re.compile(‘({(?P.)})?(?P.)’)

统计

序号	类别	数量
4	str	4
6	list	1
8	dict	1
9	module	24
13	residual	3
14	system	9
15	private	4
16	all	33

【openpyxl.worksheet】

worksheet, fullname=openpyxl.worksheet, file=openpyxl\worksheet_init_.py

统计

序号	类别	数量
4	str	4
8	dict	1
10	class	6
13	residual	3
14	system	8
16	all	14

【openpyxl.worksheet.hyperlink】

hyperlink, fullname=openpyxl.worksheet.hyperlink, file=openpyxl\worksheet\hyperlink.py

统计

序号	类别	数量
4	str	4
8	dict	1
10	class	2
11	function	1
13	residual	3
14	system	8
16	all	11

【openpyxl.worksheet.formula】

formula, fullname=openpyxl.worksheet.formula, file=openpyxl\worksheet\formula.py

统计

序号	类别	数量
4	str	4
8	dict	1
10	class	7
11	function	5
13	residual	3
14	system	8
16	all	20

【openpyxl.worksheet.cell_range】

cell_range, fullname=openpyxl.worksheet.cell_range, file=openpyxl\worksheet\cell_range.py

统计

序号	类别	数量
4	str	7
8	dict	1
9	module	1
10	class	11
11	function	3
12	builtin_function_or_method	1
13	residual	5
14	system	8
15	private	2
16	all	29

【openpyxl.worksheet.header_footer】

header_footer, fullname=openpyxl.worksheet.header_footer, file=openpyxl\worksheet\header_footer.py

常量

str

1 FONT_PATTERN &“(?P.+)”
2 COLOR_PATTERN &K(?P[A-F0-9]{6})
3 SIZE_REGEX &(?P\d+\s?)

剩余

4 doc None
5 loader <_frozen_importlib_external.SourceFileLoader object at 0x000000000B01C3C8>
6 spec ModuleSpec(name=‘openpyxl.worksheet.header_footer’, loader=<_frozen_importlib_external.SourceFileLoader object at 0x000000000B01C3C8>, origin=‘…\lib\site-packages\openpyxl\worksheet\header_footer.py’)
7 Element <cyfunction Element at 0x000000000A4D8EE8>
8 FORMAT_REGEX re.compile(‘&“(?P.+)”|&K(?P[A-F0-9]{6})|&(?P\d+\s?)’)

统计

序号	类别	数量
4	str	4
8	dict	1
10	class	15
11	function	5
13	residual	3
14	system	8
16	all	28

【openpyxl.worksheet.datavalidation】

datavalidation, fullname=openpyxl.worksheet.datavalidation, file=openpyxl\worksheet\datavalidation.py

统计

序号	类别	数量
4	str	4
8	dict	1
10	class	10
13	residual	3
14	system	8
16	all	18

【openpyxl.worksheet.page】

page, fullname=openpyxl.worksheet.page, file=openpyxl\worksheet\page.py

统计

序号	类别	数量
1	int	1
4	str	4
8	dict	1
10	class	15
11	function	5
13	residual	4
14	system	8
16	all	30

【openpyxl.worksheet.dimensions】

dimensions, fullname=openpyxl.worksheet.dimensions, file=openpyxl\worksheet\dimensions.py

常量

int

1 DEFAULT_COLUMN_WIDTH 13

统计

序号	类别	数量
4	str	4
8	dict	1
10	class	8
11	function	1
13	residual	3
14	system	8
15	private	1
16	all	17

【openpyxl.worksheet.protection】

protection, fullname=openpyxl.worksheet.protection, file=openpyxl\worksheet\protection.py

统计

序号	类别	数量
4	str	4
8	dict	1
9	module	1
10	class	29
11	function	1
13	residual	3
14	system	8
16	all	39

【openpyxl.worksheet.filters】

filters, fullname=openpyxl.worksheet.filters, file=openpyxl\worksheet\filters.py

统计

序号	类别	数量
4	str	4
8	dict	1
10	class	14
13	residual	3
14	system	8
16	all	22

【openpyxl.worksheet.views】

views, fullname=openpyxl.worksheet.views, file=openpyxl\worksheet\views.py

统计

序号	类别	数量
4	str	4
8	dict	1
9	module	1
10	class	9
13	residual	3
14	system	8
16	all	18

【openpyxl.worksheet.merge】

merge, fullname=openpyxl.worksheet.merge, file=openpyxl\worksheet\merge.py

统计

序号	类别	数量
4	str	5
8	dict	1
10	class	8
13	residual	2
14	system	8
16	all	16

【openpyxl.worksheet.properties】

properties, fullname=openpyxl.worksheet.properties, file=openpyxl\worksheet\properties.py

工作表的属性

统计

序号	类别	数量
4	str	4
8	dict	1
10	class	8
13	residual	3
14	system	8
16	all	16

【openpyxl.worksheet.pagebreak】

pagebreak, fullname=openpyxl.worksheet.pagebreak, file=openpyxl\worksheet\pagebreak.py

统计

序号	类别	数量
4	str	4
8	dict	1
10	class	10
13	residual	3
14	system	8
16	all	18

【openpyxl.worksheet.scenario】

scenario, fullname=openpyxl.worksheet.scenario, file=openpyxl\worksheet\scenario.py

统计

序号	类别	数量
4	str	4
8	dict	1
10	class	3
13	residual	3
14	system	8
16	all	11

【openpyxl.worksheet.related】

related, fullname=openpyxl.worksheet.related, file=openpyxl\worksheet\related.py

统计

序号	类别	数量
4	str	6
5	tuple	2
8	dict	1
10	class	23
11	function	3
13	residual	4
14	system	8
16	all	39

【openpyxl.worksheet.table】

table, fullname=openpyxl.worksheet.table, file=openpyxl\worksheet\table.py

常量

str

1 SHEET_MAIN_NS
2 REL_NS

tuple

3 TABLESTYLES (‘TableStyleMedium1’, ‘TableStyleMedium2’, ‘TableStyleMedium3’, 'TableStyleMediu…
4 PIVOTSTYLES (‘PivotStyleMedium1’, ‘PivotStyleMedium2’, ‘PivotStyleMedium3’, 'PivotStyleMediu…

剩余

5 doc None
6 loader <_frozen_importlib_external.SourceFileLoader object at 0x000000000B071048>
7 spec ModuleSpec(name=‘openpyxl.worksheet.table’, loader=<_frozen_importlib_external.SourceFileLoader object at 0x000000000B071048>, origin=‘…\lib\site-packages\openpyxl\worksheet\table.py’)
8 tostring functools.partial(<cyfunction tostring at 0x000000000A4DAA08>, encoding=‘utf-8’)

统计

序号	类别	数量
4	str	8
8	dict	1
9	module	1
10	class	9
11	function	2
13	residual	8
14	system	8
16	all	29

【openpyxl.worksheet.print_settings】

print_settings, fullname=openpyxl.worksheet.print_settings, file=openpyxl\worksheet\print_settings.py

常量

str

1 SHEET_TITLE
((‘(?P([^{‘]|’‘)*)’)|(?P<notquoted>[}’^ ^!]*))!
2 RANGE_EXPR
[$]?(?P<mi{n}_{c}ol>[A-Za-z]1,3)?[$]?(?P<min_row>\d+)?
(:[$]?(?P<ma{x}_{c}ol>$