Navigation
Search
|
How Do I Use Javascript To Get Values From a Numbers Spreadsheet?
Monday February 4, 2019. 10:47 PM , from 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
|
46 sources
Current Date
Nov, Fri 22 - 09:25 CET
|