February 12th, 2013, 03:27 PM
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??
February 13th, 2013, 07:37 AM
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.
April 29th, 2014, 07:05 AM
There is a special component that helps to fully automate the work OpenOffice
April 29th, 2014, 01:51 PM
It would be nicer if you said which one (if you know it).
April 30th, 2014, 06:09 AM
Do you have a link?
Originally Posted by kmi_4k
It appears he's talking about the library here: libopenoffice (4k.com)
Originally Posted by Alex_
(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.
But as I said more than a year ago, the OpenOffice document format is XML, and so is accessible without requiring special modules.
Thanks, keath. I will try better ready and proven component/module rather than learn XML struct.
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.