Parse Star Office?

csuhockey3 has asked for the wisdom of the Perl Monks concerning the following question:

Hey Monks
looking for something like Spreadsheet::ParseExcel for Star Office.

I am trying to parse through a large number of names that might have duplicate accounts mapped to the same (login)name. I need to go through and send a notice to those people that they need to cancel one or more of those accounts. (People were forgetting login names and making new accounts -- I just added a 'remember me' for login, so this won't happen again). If nothing is available for SO, I was going to just go the flat file route. Any advice?
Thanks!

Comment on Parse Star Office?

Replies are listed 'Best First'.
Re: Parse Star Office? by jmcnamara (Monsignor) on Aug 16, 2004 at 21:40 UTC
Try OpenOffice::OODoc. From the pod: This toolbox allows direct read/write operations on documents, without using the OpenOffice.org software. It provides a high-level, document-oriented language, and isolates the programmer from the details of the OpenOffice.org XML dialect and file format. -- John.	[reply]
Re^2: Parse Star Office? by csuhockey3 (Curate) on Aug 16, 2004 at 21:51 UTC
Thank you both for the quick replies -- I will have a look and see what I come up with. I have used XML::Twig in the past, so I will start there and see how ugly I can make it.	[reply]
Re: Parse Star Office? by Fletch (Chancellor) on Aug 16, 2004 at 21:16 UTC
SO / OO files are actually XML contained in zip files. While it's not pretty, it's possible to use something like XML::Twig to muck with the contents (after you've unzip'd the archive). You can find out more about the XML here; specifically you want the XML File Format Specification PDF located under the "General Information" link on the main page.	[reply]


good chemistry is complicated, and a little bit messy -LW
	PerlMonks