Must convert 500+ xls files to txt (tsv)
 

I need to convert 500+ xls spreadsheet files to tab-separated text
files. How can I automate this process? I am VB illiterate, though
I'm handy with Perl, so if there's a way to convert an xls file to
tsv on the command line I could use Perl to automate this. Anyway,
any advice appreciated.

Karl

--
Sent from a spam-bucket account; I check it once in a blue moon. If
you still want to e-mail me, cut out the extension from my address,
and make the obvious substitutions on what's left.

Hi Karl

AFAIK you need Excel (or an Excel compatible application) to actually open
and read each file. So you should use Excel for it. Excel with VBA macros is
a very powerful tool, so this ought to be pretty easy.

HTH. Best wishes Harald

"KKramsch" skrev i melding
...



I need to convert 500+ xls spreadsheet files to tab-separated text
files. How can I automate this process? I am VB illiterate, though
I'm handy with Perl, so if there's a way to convert an xls file to
tsv on the command line I could use Perl to automate this. Anyway,
any advice appreciated.

Karl

--
Sent from a spam-bucket account; I check it once in a blue moon. If
you still want to e-mail me, cut out the extension from my address,
and make the obvious substitutions on what's left.