I think its hard or we don’t have any way to handle xls files form command line.
Some times we may forced ourselves to use command line options to handle xls files for quick solution.
Recently I fond xls2csv tool which will convert xls to csv file. I hope csv will give us lot of control while handling form command line.
How to install xls2csv:
xls2csv module is available in catdoc. Install catdoc with following command.
$ sudo apt-get install catdoc
We also can use catdoc to read MS-Word file and it puts content as plain text on standard output.
How to convert xls to csv:
Use following command to convert
$ xls2csv input.xls
The command will print text on standard output. You can redirect it to a csv file and use them for processing.