[Tfug] Bulk OpenOffice Conversion

[Claude Rubinson]

On Thu, May 24, 2007 at 07:45:32AM -0700, Jim Secan wrote:
> I need to convert a large number of ASCII data files (column format, space
> delimited) to OO Calc format, and from there to Excel format (customer is
> tied to MS products).  Far too many to use the GUI approach.  After some
> fruitless googling, I thought I'd ask if anyone has used, or know of, shell
> or python tools that can do this conversion from the command line.

Here's a tutorial using Perl:

http://www.ibm.com/developerworks/linux/library/l-pexcel/

and here's a Python library:

http://sourceforge.net/projects/pyexcelerator

Hope this helps.

Claude