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

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

lundi 4 février 2019, 22:47 , par MacMost
Gary,
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”);
Numbers.open(“/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?
Thanks,
Dana Stevens
—–
Dana Stevens
https://macmost.com/forum-how-do-i-use-javascript-to-get-values-from-a-numbers-spreadsheet.html
News copyright owned by their original publishers | Copyright © 2004 - 2024 Zicos / 440Network
Date Actuelle
ven. 22 nov. - 15:13 CET