On Wed, 5 May 2010 19:57:16 -0600 "Doran L. Barton" <[email protected]> wrote:
> On Wednesday 05 May 2010 05:14:19 pm Charles Curley wrote: > > Is anyone out there using OpenOffice::OODoc? I'd like to create a > > spreadsheet with several sheets, then populate it with data. > > > > Can you point me at one or more relevant tutorials? > > Charles, > > I've not used this module, but I have used Spreadsheet::Read and > Spreadsheet::ReadSXC to parse oocalc spreadsheets from a Perl script. > It works pretty well. I wonder if you could manipulate/create > spreadsheets the same way. I search cpan for spreadsheet:: modules, and didn't see any for writing odf documents. I may try Spreadsheet::Write - "Simplified writer for CSV or XLS (MS Excel) files". I can then read either one in OOo. Much as I hate using an MS proprietary file format. > > CPAN shows OpenOffice::OOCBuilder as something with promise. Is that > part of the package you named? > There is a review of it: This module does not handle Unicode properly, and it has monolithic functions, so it's impossible to fix by inheritance, without duplicating a lot of code. This makes it a non-starter. It also generates the older .sxc format instead of the newer .ods format. The reviewer suggests OpenOffice::OODoc instead. I'm pretty sure OpenOffice::OODoc will do what I want; I just can't figure out how. Gnrrr. -- Charles Curley /"\ ASCII Ribbon Campaign Looking for fine software \ / Respect for open standards and/or writing? X No HTML/RTF in email http://www.charlescurley.com / \ No M$ Word docs in email Key fingerprint = CE5C 6645 A45A 64E4 94C0 809C FFF6 4C48 4ECD DFDB
signature.asc
Description: PGP signature
/* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
