Shell Programming and Scripting

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.

You can not do it using just sh.

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.

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.