Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

Re: Help with Excel::Table

by toolic (Bishop)
on Sep 25, 2020 at 23:59 UTC ( #11122225=note: print w/replies, xml ) Need Help??

in reply to Help with Excel::Table

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);

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.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11122225]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (4)
As of 2022-01-28 19:51 GMT
Find Nodes?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:

    Results (73 votes). Check out past polls.