Ed Centanni wrote:
>
> Kevin Fogleman wrote:
> >
> > Can anyone here recommend an program for linux that would dump the
> > contents of an MS Excel .xls file into some kind of delimited text
> > file? I'm trying to enter a huge amount of data into MySQL and
> > unfortunately, the only data source is in .xls format.
> >
> > Thanks,
> > --Kevin
>
> StarOffice.
>
> Ed.
I guess I should give some better answers, StarOffic was a knee-jerk
reaction since that's what I use.
There's a perl module that reads .xls files and more.
http://www.patoche.org/LTT/all/00000189.html Using perl you could
probably automate the process if you have to do it regularly. There
seems to be a perl module for just about everything. One day I'm gonna
find that perl module that answers SLUG list questions!
Xess 4.1 can read Excel 97 and 2000 spreadsheets and export in delimited
text.
Gnumeric can import and export Excel sheets.
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 17:42:17 EDT