56
Making Excel Spreadsheets with AppleScript
Using AppleScript to create Excel 2004 spreadsheets is as simple as you want to make it. This tutorial stores some values in cells using different addressing methods, creates a formula, and saves the result.
tell application “Microsoft Excel"
activate
set newBook to make new workbook
set update remote references of newBook to true
set value of cell 5 of column 1 of active sheet to “Sales Figures"
set value of cell 6 of column 1 of active sheet to 10
set value of cell 7 of column 1 of active sheet to 20
set value of cell 8 of column 1 of active sheet to 30 set formula of range “A9" ...
Get Developing Quality Metadata now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.