Characters#

object is a Range or Shape object.

class Characters(impl)#

The characters object can be accessed as an attribute of the range or shape object.

  • mysheet['A1'].characters

  • mysheet.shapes[0].characters

Note

On macOS, characters are currently not supported due to bugs/lack of support in AppleScript.

New in version 0.23.0.

property api#

Returns the native object (pywin32 or appscript obj) of the engine being used.

New in version 0.23.0.

property font#

Returns or sets the text property of a characters object.

>>> sheet['A1'].characters[1:3].font.bold = True
>>> sheet['A1'].characters[1:3].font.bold
True

New in version 0.23.0.

property text#

Returns or sets the text property of a characters object.

>>> sheet['A1'].value = 'Python'
>>> sheet['A1'].characters[:3].text
Pyt

New in version 0.23.0.