Re^3: xlsmerge - Merge worksheets from different Excel files into one Workbook

Old thread, but wanted to share with other readers. Running command exactly as suggested created an empty results file. There is likely a bug in the script on line 24 and believe it's expecting a different format compared to what's suggested in the example by author.

Solution is to NOT specify the sheet name after the semicolon.

Simply run it as

perl xlsmerge.pl -s -o results-%Y%m%d.xls File1.xls File2.xls
[download]

I have a different question though. Is it possible to simply change the extension to csv in the source code and run this on csv files?

Comment on Re^3: xlsmerge - Merge worksheets from different Excel files into one Workbook Download Code

Replies are listed 'Best First'.
Re^4: xlsmerge - Merge worksheets from different Excel files into one Workbook by Corion (Patriarch) on Nov 08, 2016 at 07:55 UTC
No. This program only reads XLS files in the XLS file format. If you want to depend less on the format of your input files, I recommend using Spreadsheet::Read.	[reply]