What I want to do is:
Open a Numbers file
Search for a specific value in Column E. There will be many rows with the same value.
Create a list of all the values in column I using only the rows found in the search.
The list needs each Column I value separated with a semicolon and a space
So far I have Numbers open and the document open.
When I try to reference the sheet I am constantly getting “can’t find sheet “MyData” “
There is a sheet with that name.
I even created a new sheet “Sheet 1” and tried to reference it just like all the example do.
This gives me the same error “can’t find sheet 1”
What am I doing wrong?
Here’s my test script so far:
set TestFile to “Macintosh HD:Users:UserName:MyFile.numbers”
tell application “Numbers”
open TestFile
tell sheet “MyData” to tell table 1
set DataVar to value of cell “A2”
end tell
When you referring to sheet, you should know that its parent object is not Numbers.app but opened document in the Numbers.app. It is hierarchy of Numbers.app (object model). So, to access some object of this hierarchy you should go thru all its parent objects:
set TestFile to "Macintosh HD:Users:UserName:MyFile.numbers"
set MyTest to "Testing Numbers.app"
tell application "Numbers"
set openedDocument to open TestFile -- parent object of sheet and child object of app
tell openedDocument to tell sheet "MyData" to tell table 1
set DataVar to value of cell "A2"
end tell
display dialog MyTest
end tell
Absent of telling to document 1 (openedDocument, in my script) raises your error, because doesn’t exist
sheet “MyData” of application “Numbers”, but exists only: sheet “MyData” of document 1 of application “Numbers”
I’m now trying to FIND a value in a specific column (E).
There does not appear to be any commands to “find” or “search” for values in a table/row/column.
I’ve been trying to first select the column then find the row address by column E’s cell value.
…which is not working
This is what I’m trying:
set TestData to “data 123”
tell application “Numbers”
set MyDoc to open TestFile
tell MyDoc to tell sheet “MyData” to tell table 1
set the selection range to column "E"
set DataVar to address of the row of cell whose value is TestData
end tell
display dialog DataVar
set TestData to "data 123"
tell application "Numbers"
set MyDoc to open TestFile
tell MyDoc to tell sheet "MyData" to tell table 1
--set the selection range to column "E"
set DataVar to address of the row of first cell of column "E" whose value is TestData
end tell
display dialog DataVar
end tell
Yvan KOENIG running High Sierra 10.13.6 in French (VALLAURIS, France) dimanche 26 avril 2020 21:23:05
