Names#
- class Names(impl)#
A collection of all
name
objects in the workbook:>>> import xlwings as xw >>> book = xw.books['Book1'] # book scope and sheet scope >>> book.names [<Name 'MyName': =Sheet1!$A$3>] >>> book.sheets[0].names # sheet scope only
New in version 0.9.0.
- add(name, refers_to)#
Defines a new name for a range of cells.
Parameters#
- namestr
Specifies the text to use as the name. Names cannot include spaces and cannot be formatted as cell references.
- refers_tostr
Describes what the name refers to, in English, using A1-style notation.
Returns#
Name
New in version 0.9.0.
- property api#
Returns the native object (
pywin32
orappscript
obj) of the engine beingused.New in version 0.9.0.
- property count#
Returns the number of objects in the collection.