If I simplify your code, I am able to silence the "Log4perl" message on STDERR. I figured this out by looking at the tests in the Excel::Table distribution (such as t/Excel-Table1a.t). I think the module has Log::Log4perl enabled by default, and apparently it can be disabled by importing :easy. Since I'm not familiar with Log::Log4perl, this is just a guess.

I have a directory named "mydir" and a file in it named "test.xlsx". The following code works for me:

use warnings;
use strict;
use Excel::Table;
use Log::Log4perl qw(:easy);
use Data::Dumper;

my $xs = Excel::Table->new(dir => 'mydir');
$xs->open('test.xlsx');
print Dumper($xs);
[download]

The "Dumper" code shows me the contents of my Excel file (but is quite verbose).

I find it hard to follow the module documentation. Good luck trying to figure out how to extract the data you need from your file.