Convert Excel to CSV

Shawn Tayler stayler
Mon May 17 12:01:45 PDT 2004


On Wed, 28 Apr 2004 13:03:04 -0500 "R. Quenett"<qcal at quen.net> exclaimed:

> This won't help if the command line is a critical requirement but OOo 
> has an export to cvs option. I don't know how well it works. I've had 
> good luck importing and converting m$ files with OOo).  Excel might 
> also.
> 
> R

I've been doing this as well.  The issue I've run into and would dearly
love the (most likely simple and obvious) solution too is, When I export
spreadsheets, xls, to cvs using OO, the numeric contents of the cells are
placed with double quotes ".  I'd like to remove the quotes but lack the
traing, and mostly the time to fiddle.  Is there some group of scripts,
awk, su, regular expressions, or perl that do this sort of thing?

Shawn



More information about the Linux-users mailing list