setting rows and columns of applework spreadsheet
setting rows and columns of applework spreadsheet
- Subject: setting rows and columns of applework spreadsheet
- From: paul withey <email@hidden>
- Date: Fri, 10 May 2002 10:54:06 +0100
hi all,
i am working on a small script to extract infomation from itunes and
place it in an appleworks spreadsheet. I can create a new spreadsheet
using
tell app "appleworks 6"
set makess to make new document at front with properties {document
kind:spreadsheet document, name:"Summary of your playlists " &
relationship & " relationships", spreadsheet:"relate"}
end tell
Is there a method to define the number of rows and columns the
spreadsheet will contain. Currently the sheet created defaults to 500
rows and 40 columns (my appleworks default) but since the script also
populates the cells with data i know how many rows/columns are required..
if its not possible to set rows/columns on creation, is there a method
to delete the unwanted rows/columns after the sheet has been populated ?
its not possible to create a template in appleworks with the required
rows/columns since this will vary depending on itunes library contents
and the selection criteria chosen by the person running the script...
thanks
paul
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.