Merging Multiple XLS into Different tabs in xls/ xlsx

Shell Programming and Scripting
1

HI,

I have multiple files per dept in folder

for eg : In a folder

File1_Dept100.xls
File2_Dept100.xls
File3_Dept100.xls

File1_Dept200.xls
File2_Dept200.xls
File3_Dept200.xls

Output should be :

Dept100.xls which has File1, File2, File3 in different tabs
Dept200.xls which has File1, File2, File3 in different tabs

I'm new to scripting so need some help here.

Thanks,
V

2

If these are expected to be Excel or compatible input & output files, then you will find this difficult. Normally you would work with fixed width or delimited data that Excel or other spreadsheets can read in. These are just text files (the suffix has no meaning in unix except what you decide)

If you open your input files with an editor on unix, it is unlikely to be very usable. There may be some commercial (perhaps free) software that will let you work with them a little, but merging input together to create tabs in a full spreadsheet may still not be an option, especially if you want to automate the process.

There are some threads on other boards suggesting how to do this. I put "unix spreadsheet tab" into a search engine and got a few hits. I cannot say if any of them will do what you are after though.

Sorry about that,
Robin