The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
How to Merge Two .xls files side by side into a single .xls How to Merge Two .xls files side by side into a single .xls
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
How to cut a file name from back side Prat007 Shell Programming and Scripting 4 07-28-2008 03:57 AM
How to print two sql query outputs side by side in excel prasee Shell Programming and Scripting 6 09-08-2007 02:20 AM
checking missing files in side a folder Nayanajith UNIX for Dummies Questions & Answers 4 06-26-2006 06:05 AM
Server side scripting paladyn_2002 Shell Programming and Scripting 1 04-20-2004 12:04 PM
Having a Unix system installed side to side with Windows? Pcslider UNIX for Dummies Questions & Answers 14 01-29-2002 06:21 AM

Closed Thread
English Japanese Spanish French German Portuguese Italian Dutch Swedish Russian Norwegian Hungarian Hebrew Danish Powered by Powered by Google
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 08-27-2008
jagadish99 jagadish99 is offline
Registered User
  
 

Join Date: Aug 2008
Location: Chennai
Posts: 3
How to Merge Two .xls files side by side into a single .xls
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 (permalink)  
Old 08-27-2008
era era is offline Forum Advisor  
Herder of Useless Cats (On Sabbatical)
  
 

Join Date: Mar 2008
Location: /there/is/only/bin/sh
Posts: 3,652
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 (permalink)  
Old 09-24-2008
vramana2003 vramana2003 is offline
Registered User
  
 

Join Date: Sep 2008
Posts: 6
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
Sponsored Links
Closed Thread

Bookmarks

« Shell script help | Convert Variable file to fixed file. »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Linear Mode Linear Mode
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 07:46 AM.

The UNIX and Linux Forums - Learn UNIX and UNIX Commands RSS Feeds - Contact Us - The UNIX and Linux Forums - Learn UNIX and UNIX Commands - Archive - Top

Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited. Language Translations Powered by .
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
The UNIX and Linux Forums Content Copyright ©1993-2009. All Rights Reserved.Ad Management by RedTyger

Content Relevant URLs by vBSEO 3.2.0