Re: Make AppleScript Create an AppleWorks Spreadsheet?
Re: Make AppleScript Create an AppleWorks Spreadsheet?
- Subject: Re: Make AppleScript Create an AppleWorks Spreadsheet?
- From: pete boardman <email@hidden>
- Date: Mon, 10 Oct 2005 14:29:05 +0100
On 10 Oct 2005, at 13:56, Jonathan Levi MD wrote:
Would someone please help -- how to script AppleWorks's creating,
say, a new 20-column x 10-row spreadsheet, without using System
Events? (I've done it already using SE, but would rather do it
without.
set {colCount, rowCount} to {20, 10}
tell application "AppleWorks 6"
set newSpread to make new document with properties {document
kind:spreadsheet document}
tell newSpread
repeat with c from 1 to colCount
tell column c
repeat with r from 1 to rowCount
set row r to (random number) * 100
end repeat
set formula of row (rowCount + 1) to "=SUM(" & row
1's name & ".." & row rowCount's name
end tell
end repeat
end tell
end tell
hth
Pete
(And whatever happened to the successor of AppleWorks' spreadsheet
and database modules ? :-/)
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden