Re^2: OpenOffice Calc/Spreadsheets & Win32::OLE

I've used Spreadsheet::WriteExcel as well as Win32:OLE to create Excel spreadsheet files (.xls). And over time, I've grown to prefer Win32::OLE to Spreadsheet::WriteExcel. For example, with Win32::OLE, you can use "AutoFit" to set the column width which is not available in Spreadsheet::WriteExcel. In Win32::OLE, you can set "AutoFilter"...

The challenge is to create OpenOffice / StarOffice / Lotus Symphony format ".ods" files directly. Yes, it's certainly possible to create .xls files and then convert them using OpenOffice / StarOffice / Symphony to it's native ".ods" format but that's kinda cheating isn't it?

Comment on Re^2: OpenOffice Calc/Spreadsheets & Win32::OLE

Replies are listed 'Best First'.
Re^3: OpenOffice Calc/Spreadsheets & Win32::OLE by jmcnamara (Monsignor) on Nov 02, 2010 at 09:46 UTC
Spreadsheet::WriteExcel isn't suitable for your task but to set the record straight you can use it to Autofit and Autofilter. -- John.	[reply]
Re^3: OpenOffice Calc/Spreadsheets & Win32::OLE by choroba (Cardinal) on Nov 02, 2010 at 08:52 UTC
A .ods file is just a zip file, containing several files. One of them is an XML document containing the actual spreadsheet. Maybe it would be easier to read the documentation of the XML format or study some examples, and then create the XML file directly using some XML modules?	[reply]