How to combine different Excel sheets into a single work book using UNIX

Shell Programming and Scripting
1

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..

2

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.

3

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.
4

PERL and Spreadsheet::ParseExcel, and Spreadsheet::WriteExcel