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)[源代码]

基类: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’>

property 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’>

hidden

Values must be of type <class ‘bool’>

property is_external
property 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'
property type
value

Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptve 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.DefinedNameList(definedName=())[源代码]

基类:openpyxl.descriptors.serialisable.Serialisable

append(defn)[源代码]
definedName

A sequence (list or tuple) that may only contain objects of the declared type

delete(name, scope=None)[源代码]

Delete a name assigned to a specific or global

get(name, scope=None)[源代码]

Get the name assigned to a specicic sheet or global

localnames(scope)[源代码]

Provide a list of all names for a particular worksheet

tagname = 'definedNames'