There is a rich scripting model for Microsoft Office, but not so with Apple iWork, and specifically the word processor Pages. While there are some AppleScript hooks, it looks like the best approach is to manipulate the underlying XML data. This turns out to be pretty ugly because (for example) page breaks are stored in XML. So for examp...
I'm trying a access the complete reference for a cell in Applescript. So far I've managed to get the cell reference and the table reference using a script like: tell application "Numbers" tell document 1 repeat with i from 1 to count of sheets tell sheet i repeat with j from 1 to count of tables tell table j try set currentCell to the f...
I am having trouble creating a new table on a specific sheet using Applescript unless the sheet I want insert the new table in is either new or current selected. The general form of the code I am using is: tell application "Numbers" tell document 1 tell sheet "This is the sheet I want to use" make new table with proper...
I am working with Numbers 09 and Applescript. I want to add a value in one cell to an existing value in another cell, replacing the existing value with the sum as a value. This would be similar to the copy/paste-add command in Excel. Thanks for your help. -Rob ...
I was wondering what the mime type for iWork's Pages is? And also what the mime type is for the rest of the software in the iWork suite? I looked around online and I didn't see it anywhere. Thanks! ...
How do I access the current table in Numbers using py-appscript? For posterity, the program I created using this information clears all the cells of the current table and returns the selection to cell A1. I turned it into a Service using a python Run Shell Script in Automator and attached it to Numbers. from appscript import * N...
How do you set the selection for a table in Numbers using py-appscript? This seems like it should be really simple to do but the solution is frustratingly evasive. I can get the current selection: current_table.selection_range and I can get its cells: current_table.selection_range.cells() but trying to set() either of them gets...
This seems like a straightforward operation but I am stumped. How do you set value of current Numbers cell using Py-Appscript? ...
iWork has the ability to highlight text and then tag a comment to that text. The comment then is linked with a line to the highlighted text. I'm curious if something like this could be implemented in JQUERY. What has me puzzled is: A. How to draw a line and have it update when a user changes the text B. How to highlight text and have ...
Has anyone tried exporting data to Numbers in iWork? I want to generate a spreadsheet programmatically but I'm not having much success. I've tried unzipping a .numbers document and analysing the XML to see if I could interpret it but it's far too complicated. Also, I couldn't find the DTDs used by Apple. Judging by what's out there thi...
I know it is possible with the .NET framework of Microsoft to do some interoperability with Microsoft Office. Is there something that exist that resembles to it for iWork and the Cocoa framework? Edit: Here are more details. I would like to create an application that has a GUI and that can generate Pages/Keynote/Numbers documents. ...
I know I can use the RODBC library for accessing excel (.xls) docs from within Windows, but is there something similar for the Numbers program that come with iWorks? If not, what other solutions are there for easily editing a spreadsheet (like a lookup table) and accessing it within R? I know there the is an internal R editor, but I d...
I want to display some iWork file in iphone? Is there any apis to help to display it? ...
I have specific formulas that I'd like to write (in Objective-C perhaps) and integrate with Numbers'09 of Apple's iWork suite in iPad and wonder if there is such a way to do so? ...
I wonder if it is possible to embed dynamic text into Keynote'09? I want to create a new presentation and run this presentation with different text messages (depending on the time of the day and day of the month). ...
Hi We have a simple macro that connects Access and Excel (Office 2007 on Windows) with some forms and we are trying to create the iWork version, but I cant find how to create a macro or something, does anyone knows some manual or links to do this? Im using iWork 09 on Snow Leopard. Thanks! ...
I've been asked to convert several hundred MS Word 2002 Templates (on the PC) to work on the Macintosh. I have to evaluate whether the Word Templates can be run in iWork Pages and Microsoft Word for the Mac. The biggest issues that I've found thus far are that I'm unable to convert the following - Macros WordBasic code Visual Basic H...
Our app can deal with say Pages files as an example and needs to both hand off files to other applications as well as receive files from other applications. So we edit the plist CFBundleDocumentTypes to say that we can deal with Pages files. ('Default') mode. When the user wants to send a .pages file onto another application (Likely t...
Hi, I am trying to create a spreadsheet in iwork 09 Numbers. I have values in cells along with dates, however until this date is passed I don't want the corresponding value to be included in the final "total" formula which adds all the values together. Below is the formula for one of the cells, this works fine but it shows the cell va...
I'm working on an ebook that I'm writing as plain text/Markdown. I converted that into HTML and would like to import the generated HTML document into a Pages document to do the final formatting. I created a Pages template and defined styles for headings, lists, etc. However, when I copy/paste the HTML file from Safari into Pages, the pa...