fastpyxl.workbook.defined_name module

class fastpyxl.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: Serialisable

attr_text: str | None
comment: str | None
customMenu: str | None
description: str | None
property destinations
function: bool | None
functionGroupId: int | None
help: str | None
hidden: bool | None
property is_external
property is_reserved
localSheetId: int | None
name: str | None
publishToServer: bool | None
shortcutKey: str | None
statusBar: str | None
tagname = 'definedName'
to_tree(tagname=None, idx=None, namespace=None)[source]
property type
property value
vbProcedure: bool | None
workbookParameter: bool | None
xlm: bool | None
class fastpyxl.workbook.defined_name.DefinedNameDict[source]

Bases: dict

Utility class for storing defined names. Allows access by name and separation of global and scoped names

add(value)[source]

Add names without worrying about key and name matching.

class fastpyxl.workbook.defined_name.DefinedNameList(definedName=())[source]

Bases: Serialisable

by_sheet()[source]

Break names down into sheet locals and globals

definedName: list[DefinedName]
tagname = 'definedNames'