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.

Added in version 0.23.0.

property api

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

Added 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

Added 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

Added in version 0.23.0.