Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (2)
As of 2021-12-05 13:20 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    R or B?



    Results (31 votes). Check out past polls.

    Notices?