HT2488: Mac Basics: Automator
Learn about Mac Basics: Automator
-
All replies
-
Helpful answers
-
Feb 18, 2012 3:17 PM in response to gingermogwaiby twtwtw,well, this can be done in applescript t least partway (I am not aware of any automator actions having been made for iWork). Can't really do it in the abstract, though. in principle, you'll need to specify the range of numbers you want to process, run whatever calculations you want to run, save the result to a text file, and then send it through cupsfilter to generate a pdf. skeleton looks something like the following:
tell application "Numbers"
tell document 1
tell sheet 1
tell table 1
--select the data you want to process and process it
end tell
end tell
end tell
end tell
tell application "Pages"
--insert data as appropriate, and save as a text file in variable filePath
--might be easier to do this without pages if it's just a simply lightly formatted list of numbers
end tell
do shell script "cupsfilter " & filePath
but I can't really be more specific unless you are.