macOS Numbers and Apple script

[Tech198]

How do u read cell value as text in Apple script.. ?

I have a bunch of songs and have the same songs in Numbers... (track, song name and other meta-data..)

I want to use Apple script to pass cell data and open iTunes with cosponsoring songname to place the value in the said fields.

the columns are all there in Numbers,, i just need to read them... I'm guessing i'll need to read row to match song name then go from there.. however i can't even read cell data as text yet..


Looks my programming may need a bit of work..

 

[superscape]

Hi,

Something like this:

tell application "Numbers"
   tell its document "Untitled.numbers"
       tell its sheet "Sheet 1"
           tell its table "Table 1"
               set theCellValue to formatted value of cell "B2"
           end tell
       end tell
   end tell
end tell

...obviously substituting your own values for document, sheet, table and cell!

Good luck!