in reply to Unable to read values from Excel file

I tested your code with Spreadsheet::Read 0.63 on my Win XP Active Perl 5.20 installation and it works fine. I did have Spreadsheet::ParseExcel already for other reasons. That may be the "trick".
$Options = { 'dtfmt' => 'yyyy-mm-dd', 'attr' => 0, 'strip' => 0, 'rc' => 1, 'cells' => 1, 'clip' => 1, 'debug' => 5 }; Opening XLS $txt 1 sheets Sheet 2 'test' 2 x 7 -35,-39,-39,-60,-35,-39, -36,-40,-40,-59,-36,-40,
I've been using a different reader, Spreadsheet::DataFromExcel for simple .XLS files (won't work for .XLSX), real easy to use, here is demo:
#!usr/bin/perl use strict; use warnings; use Spreadsheet::DataFromExcel; use Data::Dumper; my $p = Spreadsheet::DataFromExcel->new; my $data = $p->load('Test.xls', 'test',0) or die $p->error; foreach my $rowref (@$data) #$data is ref to an Array of Array { print join (',',@$rowref), "\n"; } __END__ -35,-39,-39,-60,-35,-39,-39 -36,-40,-40,-59,-36,-40,-40

Replies are listed 'Best First'.
Re^2: Unable to read values from Excel file
by youhaveaBigEgo (Novice) on Aug 22, 2016 at 22:15 UTC
    With DataFromExcel , I am unable to do certain tasks that Spreadsheet::Read would give me , functions such as : cr2cell cell2cr row cellrow rows That said after installing Spreadsheet::ParseExcel I am able to get my result. Thanks you guys.
      Great to hear back that you have a solution to your problem! I suspected that the odds were good given the ease at which I was able to run your code on my Active State machine. I've found the AS ppm (Perl Package Manager) to be quite good.

      Yes, DataFromExcel is a "one trick pony". It only has one trick (convert worksheet to Array of Array), but it does that one trick well. It doesn't have convenience functions like accessing a cell like "D4", you have to go to $data->[3,3]. I just needed 2 columns from one sheet of a 5 sheet Workbook and that was enough for me. Mileage varies. The trade-off between complexity and features happens all the time.

      Thanks++ for reporting that installing Spreadsheet::ParseExcel did what you needed. That feedback may help somebody else further down the road.

Re^2: Unable to read values from Excel file
by youhaveaBigEgo (Novice) on Aug 20, 2016 at 17:52 UTC
    Thank-you, I will try it out if suggested recommendations here doesn't work.