Re: Scripting Numbers
Re: Scripting Numbers
- Subject: Re: Scripting Numbers
- From: Yvan KOENIG <email@hidden>
- Date: Mon, 10 May 2010 19:23:44 +0200
Le 10 mai 2010 à 19:10, Christian Prinoth a écrit : I am trying to make some simple scripts to get data from a database into Numbers. Ideally, I would run the script, and the data gets written into the currently selected table. I realize that there is a selection range property, but am unable to understand how I reference current document/sheet/table.
If I do: tell application "Numbers" get selection range of tables of sheets of documents end tell
I get: {{{missing value, «class » "E4:E4" of table "Table 2" of sheet "Sheet 1" of document "Untitled" of application "Numbers"}}}
which I do not know how to handle.
In other words, how do I write in the currently selected cell of the currently selected table of the currently selected sheet etc.?
Thanks Chris tell application "Numbers" to tell document myDoc tell sheet mySheet tell table myTable set value of cell myRow of column myColumn to myValue end tell -- table end tell -- sheet end tell -Numbers
You may go to my iDisk : <http://public.me.com/koenigyvan> and enter the folder : For_iWork:iWork '09:for_Numbers09:
You will find a lot of scripts for Numbers '09.
And remember that the first source of informations is the Numbers 's AppleScript's dictionary.
Yvan KOENIG (VALLAURIS, France) lundi 10 mai 2010 19:21:54
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden