OT:converting csv to xls with Rev
Bill Marriott
wjm at wjm.org
Wed Jan 9 08:25:05 EST 2008
Hi Matthias,
> does anyone know a way to convert a csv to xls with Rev under Windows?
Before Office 2007, Excel used a closed binary format. There's been some
attempts at reverse-engineering this....
http://chicago.sourceforge.net/devel/docs/excel/
http://sc.openoffice.org/excelfileformat.pdf
Excel 2002 and later support "XML Spreadsheet," which can specify almost all
formulas and formatting in the spreadsheet. Excel 2007 has "OOXML" (Office
Open XML) as its native file format.
Although it's quite possible to create the binary version of the file
format, I'd recommend going the XML route if you can, since it's better
documented and easier to generate.
More information about the use-livecode
mailing list