Hi,

Can any one tell me how to copy data using shell script to a excel file from text file to other columns of excel file,leaving first column unaffected i.e it should not overwrite data in first column.

Say my text file data is:

15-dec-2008 15-dec-2009
16-dec-2008 16-dec-2009


say my first excel column is:

column1 column2 column3
server1
server2


I want output as below:

column1 | column2 | column3
server1 | 15-dec-2008 | 15-dec-2009
server2 | 16-dec-2008 | 16-dec-2009

Thanks in advance........

This has nothing to do with Unix, try posting in one of the WinDoze "excel" forums.

Hey man...Its related to Unix only.....and I got the solution as well.....

Hi,

Can any one tell me how to copy data using shell script to a excel file from text file to other columns of excel file,leaving first column unaffected i.e it should not overwrite data in first column.

Please help..

Thakx,
Amin

well if his output example is meant literally, we can create a shell script that produces a pipe-delimited flat file as a result, easily importable in excel.

But the solution is apparently already found. Would be nice to actually post it here too.