ZWcarp has asked for the wisdom of the Perl Monks concerning the following question:

Hey all, I am dealing with a Excel file that has a good deal of tabbed worksheets associated with it. I just want them all to be separate tab delimited text files, but do not want to manually copy each one out as this would take forever. Does anyone know how to handle this sort of file in unix ? thanks!!
  • Comment on Dealing with Excel file multiple worksheets in BASH/PERL

Replies are listed 'Best First'.
Re: Dealing with Excel file multiple worksheets in BASH/PERL
by marto (Cardinal) on Dec 13, 2011 at 19:29 UTC
Re: Dealing with Excel file multiple worksheets in BASH/PERL
by Tux (Canon) on Dec 13, 2011 at 19:31 UTC

    Install Spreadsheet::Read and use xlscat:

    $ for sheet in 1 2 3 4 5 ; do > xlscat -s'\t' -S$sheet file.xls >file-$sheet.tsv > done

    Enjoy, Have FUN! H.Merijn
Re: Dealing with Excel file multiple worksheets in BASH/PERL
by MidLifeXis (Monsignor) on Dec 13, 2011 at 18:58 UTC

    You might want to search CPAN for spreadsheet and see what it gives you.

    --MidLifeXis