openpyxl.workbook.defined_name module¶
-
class
openpyxl.workbook.defined_name.
DefinedName
(name=None, comment=None, customMenu=None, description=None, help=None, statusBar=None, localSheetId=None, hidden=None, function=None, vbProcedure=None, xlm=None, functionGroupId=None, shortcutKey=None, publishToServer=None, workbookParameter=None, attr_text=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
attr_text
¶
-
comment
¶ Values must be of type <class ‘str’>
-
customMenu
¶ Values must be of type <class ‘str’>
-
description
¶ Values must be of type <class ‘str’>
-
destinations
¶
-
function
¶ Values must be of type <class ‘bool’>
-
functionGroupId
¶ Values must be of type <class ‘int’>
-
help
¶ Values must be of type <class ‘str’>
Values must be of type <class ‘bool’>
-
is_external
¶
-
is_reserved
¶
-
localSheetId
¶ Values must be of type <class ‘int’>
-
name
¶ Values must be of type <class ‘str’>
-
publishToServer
¶ Values must be of type <class ‘bool’>
-
shortcutKey
¶ Values must be of type <class ‘str’>
-
statusBar
¶ Values must be of type <class ‘str’>
-
tagname
= 'definedName'¶
-
type
¶
-
value
¶ Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptive name is desired (eg. “underline” for “u”)
-
vbProcedure
¶ Values must be of type <class ‘bool’>
-
workbookParameter
¶ Values must be of type <class ‘bool’>
-
xlm
¶ Values must be of type <class ‘bool’>
-
-
class
openpyxl.workbook.defined_name.
DefinedNameDict
[source]¶ Bases:
dict
Utility class for storing defined names. Allows access by name and separation of global and scoped names
-
class
openpyxl.workbook.defined_name.
DefinedNameList
(definedName=())[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
definedName
¶ A sequence (list or tuple) that may only contain objects of the declared type
-
tagname
= 'definedNames'¶
-