Characters

object is a Range or Shape object.

class Characters(impl: Any)

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: Any

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

Added in version 0.23.0.

property font: 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: str

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.