Re: [MLUG] good Excel to text converter?

["Jonathan King" <EMAIL:PROTECTED>]

On 1/4/07, Mike Miller <EMAIL:PROTECTED> wrote:
> I want to be able to convert Excel to tab-delimited text (or comma
> delimited) on my Solaris machine.  I found one program that looks good but
> I haven't been able to compile it on Solaris:
>
> http://wizard.ae.krakow.pl/~jb/xls2txt/
>
> Best for me would be something portable, like something in perl.  Anybody
> know of such a thing?

Others have given lots of suggestions. Another interesting idea is to
upload the data to Google Docs and Spreadsheets and then download it
as csv or use their API to do stuff with it. Probably overkill for
your purpose, although a neat feature is that you can share out data
to many different people all over the place this way without hosting
it yourself.

I remember that one gotcha with a lot of these solutions is their
weird treatment of macros. Which you might think wouldn't bother you
since you just want the csv data, but, man, there are some pretty
psychotic macros around here at NIH that do all sorts of things to the
data you actually see that you wouldn't expect.

jking

_______________________________________________
members mailing list
EMAIL:PROTECTED
http://mlug.missouri.edu/mailman/listinfo/members