Search code examples
pythoniworksourceforge-appscript

How to set value of current Numbers cell using Py-Appscript


This seems like a straightforward operation but I am stumped.

How do you set value of current Numbers cell using Py-Appscript?


Solution

  • Pretty tediously, but working:

    >>> from appscript import *
    >>> app('Numbers').documents.first.sheets.first.tables.first.selection_range.cells.first.value.set(to=42)
    

    That's assuming a simple document. More generally, you can select items by name:

    >>> app('Numbers').documents['MyDocument.numbers'].sheets['MySheet'].tables['MyTable'].selection_range.cells.first.value.set(to='abc')