Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

Parse Star Office?

by csuhockey3 (Curate)
on Aug 16, 2004 at 21:11 UTC ( #383459=perlquestion: print w/replies, xml ) Need Help??

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?

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 software. It provides a high-level, document-oriented language, and isolates the programmer from the details of the XML dialect and file format.


      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.
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.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://383459]
Approved by Fletch
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (7)
As of 2021-03-07 12:23 GMT
Find Nodes?
    Voting Booth?
    My favorite kind of desktop background is:

    Results (121 votes). Check out past polls.