Can somebody please help how to combine multiple excel files into single sheet (in Linux) with multiple tabs. I can use either python or perl.I have used below perl script, but getting blank output, with error Worksheet name 'Sheet1', with case ignored, is already in use at xlsmerge.pl line 49.#!/usr/bin/perl -wuse strict;use Spreadsheet::ParseExcel;use Spreadsheet::WriteExcel;use File::Glob qw(bsd_glob);use Getopt::Long;use POSIX qw(strftime);GetOptions(    'output|o=s' => \my $outfile,    'strftime|t' => \my $do_strftime,) or die;if ($do_strftime) {    $outfile = strftime $outfile, localtime;};my $output = Spreadsheet::WriteExcel->new($outfile)    or die Couldn't create '$outfile': $!;for (@ARGV) {    my ($filename,$sheetname,$targetname);    my @files;    if (m!^(.*\.xls):(.*?)(?::([\w ]+))$!) {        ($filename,$sheetname,$targetname) = ($1,qr($2),$3);        warn $filename;        if ($do_strftime) {            $filename = strftime $filename, localtime;        };        @files = glob $filename;    } else {        ($filename,$sheetname,$targetname) = ($_,qr(.*),undef);        if ($do_strftime) {            $filename = strftime $filename, localtime;        };        push @files, glob $filename;    };    for my $f (@files) {        my $excel = Spreadsheet::ParseExcel::Workbook->Parse($f);        foreach my $sheet (@{$excel->{Worksheet}}) {            if ($sheet->{Name} !~ /$sheetname/) {                warn Skipping ' . $sheet->{Name} . ' (/$sheetname/);                next;            };            $targetname ||= $sheet->{Name};            #warn sprintf Copying %s to %s\n, $sheet->{Name}, $targetname;            my $s = $output->add_worksheet($targetname);            $sheet->{MaxRow} ||= $sheet->{MinRow};            foreach my $row ($sheet->{MinRow} .. $sheet->{MaxRow}) {                my @rowdata = map {                    $sheet->{Cells}->[$row]->[$_]->{Val};                } $sheet->{MinCol} ..  $sheet->{MaxCol};                $s->write($row,0,\@rowdata);            }        }    };};$output->close;Please suggest possible solutions.
How To Combine Multiple Excel Files With Multiple Tabs
linux;shell;python;perl