[Tfug] Bulk OpenOffice Conversion

[Andrew Ayre]

Do you need to manipulate the data in OO Calc? If not then perl is very good
at parsing ASCII files and outputting CSV which can then be imported in
Excel. For example I use rtrim() to parse an ASCII file that uses fixed
column widths. split() can be used to split a line on spaces, etc.

Andy


-----Original Message-----
From: tfug-bounces at tfug.org [mailto:tfug-bounces at tfug.org]On Behalf Of
Jim Secan
Sent: Thursday, May 24, 2007 7:46 AM
To: tfug at tfug.org
Subject: [Tfug] Bulk OpenOffice Conversion


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.

TIA
Jim
*---------------------*-------------------------------*
| Jim Secan           | Northwest Research Assoc, Inc |
| (jim at nwra.com)      | 2455 E. Speedway, Suite 204   |
| (520) 319-7773      | Tucson, Arizona 85719         |
*---------------------*-------------------------------*


_______________________________________________
Tucson Free Unix Group - tfug at tfug.org
Subscription Options:
http://www.tfug.org/mailman/listinfo/tfug_tfug.org