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.
Refer
man xls2csv
for more options.