How to Merge Two .xls files side by side into a single .xls

Shell Programming and Scripting
1

Hi all,

   please help me out in below requirement.

I have two .xls files say abc.xls and bbc.xls , i want to merge these two files into a single file ..say xyz.xls side by side

Ex:

abc.xls bbc.xls

Eno Ename Eno Ename
101 hello 201 delhi
102 hero 202 Hyd
103 india 203 bombay

My o/p file should be like this

xyz.xls

Eno Ename Eno Ename
101 hello 201 delhi
102 hero 202 Hyd
103 india 203 bombay

between these two one empty column should be there to distinguish..

please help me.. how do we do in unix..

2

If they are just text files, then the paste command can do this. If you really have Excel files, you might actually want to convert them to text files first.

3

Yes. As era mentioned you can try something like below:

$paste abc.xls bbc.xls > xyz.xls

output
-----
Eno Ename Eno Ename
101 hello 201 delhi
102 hero 202 Hyd
103 india 203 bombay