Exporting data to iWork Numbers

Question

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?

Answer 1

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.

Answer 2

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