Dealing with Excel file multiple worksheets in BASH/PERL

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
Check out the Spreadsheet::ParseExcel module, it's very well documented. See Installing Modules from tutorials if you need help with module installation.	[reply]
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` [download] Enjoy, Have FUN! H.Merijn	[reply] [d/l]
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	[reply]