Apple script to return value of a cell in Numbers

Question

Level 4

2,879 points

Apple script to return value of a cell in Numbers

I am trying to figure out how to have an apple script return the value of a cell in a numbers document. I have a numbers spreadsheet where I monitor my body weight. I would like to run a script and return back my current weight (to use with geek tools as a desktop reminder). Do any of your Numbers "Guru's" know how to do this? How to have apple script return the contents of a cell in a numbers document?

Mac Pro, OS X Mavericks (10.9.2), 5,1 3.33 6-core 32GB GTX680

Posted on May 8, 2015 5:50 AM

Reply

Answer 1

jaxjason

Level 5

5,063 points

May 8, 2015 1:42 PM in response to ssls6

I take it you already have knowledge of applescript and are just missing the numbers portion. I would suggest looking at iworkautomation.com it has many example of what you are trying to do.

jason

Reply

Answer 2

Hiroto

Level 5

7,467 points

May 8, 2015 3:38 PM in response to ssls6

Hello

Here's basic statements to retrieve value(s) from Numbers document.

tell application "Numbers" tell document 1's sheet 1's table 1 -- (1) value of cell A2 return cell "A2"'s value --return row 2's cell 1's value --return column 1's cell 2's value -- (2) return list of values of row 1's cells --return row 1's cells's value -- (3) return list of value of column 1's cells --return column 1's cells's value -- (4) return list of list of values of each row's cells --return rows's cells's value -- (5) return list of list of values of each column's cells --return columns's cells's value -- (6) return list of values of cells --return cells's value end tell end tell

Regards,

H

Reply