tags:

views:

216

answers:

2
+2  Q: 

Exporting data to iWork Numbers

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 this is an almost impossible task. Does anyone have any ideas?

A: 

If they're pure number in one sheet, export them into a CSV or tab-separated text file.

KennyTM  2010-02-16 16:01:02
I want to generate a spreadsheet programmatically. I'd like to give my users the ability to double click on a file and have it open in numbers without any fuss.
Rui Pacheco  2010-02-16 16:06:44
A: 

I have a number of Applescript scripts in my application for generating Numbers spreadsheets. It works fairly well although it's not very quick and you don't have much control over formatting and can't insert things like Charts.

Ian Turner  2010-02-17 02:15:21
That would be enough for me. Do you need to have iWorks installed for the scripts to work?
Rui Pacheco  2010-02-18 23:38:17
Yes, you will need to install iWork to see the Applescript dictionary for the iWork applications and to try them out. It's usually much easier to get them working in Script Editor before moving them over to Cocoa.
Ian Turner  2010-03-16 22:49:56

related questions

Is there a VB.NET function to format a number as an Ordinal
Defining different types of numbers in C#
Replace non-numeric with empty string
.Net Converting a number from one culture to another
Need a simple RegEx to find a number in a single word
How do I round a number in javascript?
random number with ratio 1:2
How to count unique records and get number of these uniques in table using SQL?
Is there a difference between is_int() and ctype_digit()?
Parse Phone Number into component parts
How to get the Nth digit of an integer with bit-wise operations?
Unique random numbers in O(1)?
What is the best way to validate a credit card in PHP?
String to Int in java - Likely bad data, need to avoid exceptions.
How can I convert a number to its multiple form in Perl?
How to convert floats to human-readable fractions?
Single most effective practice to prevent arithmetic overflow and underflow
Determine if a string is an integer or a float in ANSI C
How to read values from numbers written as words?
Octal number literals: when? why? ever?
Searching for phone numbers in mysql
Validate numbers in JavaScript - IsNumeric()
How do I tell if a variable has a numeric value in Perl?
SQL, Auxiliary table of numbers
Most efficient code for the first 10000 prime numbers?