Read Ms-excel file in unix

Shell Programming and Scripting
1

Hi,
I have the Ms Excel file(test.xls) in my UNIX box. I would like to read the excel file and create files for each column.

Please find an example.
My excel file like this data:

Num Data
1 a1
2 b2
3 c3
4 d4
5 e5
6 f6
7 h7

My output:

I want create 2 files(num.log and data.log)

Data in num.log file:
1
2
3
4
5
6
7

Data in Data.log file:

a1
b2
c3
d4
e5
f6
h7

Thanks
Koti.

2

You can not do it using just sh.

3

Go to Advance Search and do a search on Excel. You should find many post on how you may be able to resolve your problem. Good luck.

4

Instead of saving the excel spreadsheet as xls (or xlsx for 2007), save as a csv file. From there, breaking the file info columns is fairly straight-forward.

Otherwise, as said in other post(s), read up on how to decipher an xls file.