Catdoc xls2csv converting only one sheet

conversioncsv

I have Catdoc's xls2csv installed on Debian/Squeeze. It used to work beautifully when I copied files to a folder like /var/www/xyz, converting all sheets into .csv format, separated by ^L.

But now, for whatever reason, it converts only the first sheet when I use the command:

xls2csv filename.xls > filename.csv

Any suggestions on what I could be doing wrong here?

Best Answer

This is correct, since CSV does not support multiple sheets.
You can select the sheet by the -b option.

xls2csv -b Sheet filename.xls > filename.csv

Refer man xls2csv for more options.

Related Question