#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2010
    Posts
    81
    Rep Power
    5

    Use perl to ceate Open Office Letters??


    Would like to read from an open office spread sheet >> names and address and then place that into a open office writer template and create a letter from each name and address from spread sheet.

    Is this possible??
  2. #2
  3. !~ /m$/
    Devshed Specialist (4000 - 4499 posts)

    Join Date
    May 2004
    Location
    Reno, NV
    Posts
    4,264
    Rep Power
    1810
    I'm sure that it is.

    A few years ago I parsed an OpenOffice spreadsheet that was saved in an XML format. An XML word processing document could exist as a perl template.

    There's also this set of modules on CPAN, though I haven't used them.

    http://search.cpan.org/~jmgdoc/OpenOffice-OODoc/
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2014
    Posts
    4
    Rep Power
    0
    There is a special component that helps to fully automate the work OpenOffice
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Jun 2012
    Location
    Paris area, France
    Posts
    843
    Rep Power
    496
    It would be nicer if you said which one (if you know it).
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2014
    Posts
    4
    Rep Power
    0
    Yes, it's LibOpenOffice
  10. #6
  11. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2014
    Posts
    2
    Rep Power
    0
    Originally Posted by kmi_4k
    Yes, it's LibOpenOffice
    Do you have a link?
  12. #7
  13. !~ /m$/
    Devshed Specialist (4000 - 4499 posts)

    Join Date
    May 2004
    Location
    Reno, NV
    Posts
    4,264
    Rep Power
    1810
    Originally Posted by Alex_
    Do you have a link?
    It appears he's talking about the library here: libopenoffice (4k.com)

    (The company name coincidentally reflecting his username)

    It's a commercial product, and I couldn't find any information referring to perl support. The most recent comment there says it is Windows only.

    There was a little more information at another site which says the library includes headers for C/C++ and C#.

    For a perl solution, there are free modules at CPAN.

    OpenOffice-OODoc

    But as I said more than a year ago, the OpenOffice document format is XML, and so is accessible without requiring special modules.
  14. #8
  15. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2014
    Posts
    2
    Rep Power
    0
    Thanks, keath. I will try better ready and proven component/module rather than learn XML struct.
  16. #9
  17. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2014
    Posts
    2
    Rep Power
    0
    I particularly know of one from codebasket.net under the perl category in which I use most of the scripts there. I do not remember the exact url, but you can have a search on their searchbar.

IMN logo majestic logo threadwatch logo seochat tools logo