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