MacMusic  |  PcMusic  |  440 Software  |  440 Forums  |  440TV  |  Zicos

How Do I Use Javascript To Get Values From a Numbers Spreadsheet?

Monday February 4, 2019. 10:47 PM , from MacMost
I am trying to use javascript in script editor to get the value of a range of cells from a Numbers spreadsheet. AppleScript does it with:
tell application “Numbers”
open alias “Macintosh HD:Users:danaeugene:Documents:Numbers Files:AppleScript PRACTICE2.numbers”
tell the first table of the active sheet of document 1
set theNames to value of cells in range “A1:C1”
end tell
end tell
result: {“AA1”, “BB1”, “CC1”}
I can get javascript to open the spreadsheet using:
Numbers = Application (“Numbers”);“/Users/danaeugene/Documents/Numbers Files/AppleScript PRACTICE2.numbers”);
However I have been unable to get values from cells or a range of cells. I know it must be some simple syntax error but I am stumped. I have studied the dictionary. And searched every resource that I can think of and have not come up with an example using Javascript to get cell values from a Numbers spreadsheet. Do you have any suggestions?
Dana Stevens
Dana Stevens

Related News

News copyright owned by their original publishers | Copyright © 2004 - 2019 Zicos / 440Network
Current Date
Apr, Fri 19 - 07:19 CEST