Using AppleScript To Automate In Numbers

The latest version of Numbers restores our ability to use AppleScript to automate some actions in your spreadsheets. You can use AppleScript to create new commands in Numbers and do things that could be difficult or impossible to do otherwise. Take a look at some simple examples that populate cells with random numbers and modify the values of checkboxes.

Comments: 4 Responses to “Using AppleScript To Automate In Numbers”

    Nilesh Parmar
    5 years ago

    Love this, would like to how you would a script from numbers to convert the active sheet to cvs with having to go to export. Or better yet, the AppleScript to do it directly from desktop.

      5 years ago

      You can use Automator to simulate a sequence of menu items commands and mouse clicks. So use that to create a service for Numbers that does the steps you need.

    Relever
    5 years ago

    Anyone seen/ developed an apple script to replicate the “Goal Seek” function in Excel?

      5 years ago

      As far as I can tell there has never been a Goal Seek function in Numbers, in any version. I suppose you could write a script to do it, but that would take some know-how and a lot of work. Probably more cost effective to just get Excel since it has it. Right tool for the right job situation.

Comments Closed.