Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

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

by dallen16 (Sexton)
on Nov 02, 2010 at 01:24 UTC ( #868913=note: print w/replies, xml ) Need Help??


in reply to Re: OpenOffice Calc/Spreadsheets & Win32::OLE
in thread 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.

Re^3: OpenOffice Calc/Spreadsheets & Win32::OLE
by choroba (Bishop) 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?

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://868913]
help
Chatterbox?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (6)
As of 2017-12-16 15:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What programming language do you hate the most?




















    Results (454 votes). Check out past polls.

    Notices?