Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | 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 |
| combine 3 excel files using shell. | radhika | Shell Programming and Scripting | 11 | 05-06-2009 07:18 AM |
| Help needed to combine files to excel sheet | ahjiefreak | Shell Programming and Scripting | 5 | 03-30-2008 06:10 AM |
| How to format excel sheets in UNIX?? | Vijay06 | Shell Programming and Scripting | 2 | 05-16-2007 10:01 AM |
| Multiple excel work sheets through UNIX | puspendu | Shell Programming and Scripting | 1 | 05-03-2006 05:28 AM |
| creating more than 2 excel sheets in C | manceryder | High Level Programming | 7 | 12-20-2005 06:10 PM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
08-27-2008
|
||||
|
||||
|
How to combine different Excel sheets into a single work book using UNIX
Hi All,
I have 4 excel files and i want to combine these 4 files into a single workbook .. my constraints is each work sheet should go to a seperate sheet or tab with sheet name .. my final workbook should have 4 tabs(sheets) each for one. Thanks in Advance.. |
|
08-27-2008
|
||||
|
||||
|
useing the xml format (which is an acceptable XLS file, I have in oracle, created a spreadsheet with as many as 10 different workbooks.
Not having the Excel file in excel's XML format, I don't think I would even try. Basically, and you can see the information easily in XML, there is a separate WORKBOOK tag for each. Cut and paste would do it. By if they are XLS native, send to a PC and combine there. Quote:
|
|
08-27-2008
|
||||
|
||||
|
The easiest way would be to save the input files as XML Spreadsheet format instead of XLS. Then create a new XML File as follows:
1. Remove the tags <Workbook> </Workbook> from all the input files. 2. After step - 1, Extract all the remaining contents of the input files and paste it between the tags <Workbook> </Workbook> in the new XML file. The final XML file when opened in excel will show multiple worksheets as expected. |
|
08-27-2008
|
||||
|
||||
|
maybe?
PERL and Spreadsheet::ParseExcel, and Spreadsheet::WriteExcel
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Hybrid Mode
