in reply to Re^5: read from xlsx is throwing error
in thread read from xlsx is throwing error

Or install Spreadsheet::Read on all installed perl versions :)


Enjoy, Have FUN! H.Merijn

Replies are listed 'Best First'.
Re^7: read from xlsx is throwing error
by ajaykannan (Novice) on Dec 19, 2016 at 18:07 UTC

    it is installed but still getting error friends. please help me .

      So far, you have been shown three approaches to diagnose where your problem might be.

      If you have already tried all three, please report back with the output of the suggested commands.

      If you have not tried the suggestions, why not? I recommend that you try them and report back with the output.

        thank you for the patience and time upone me corion i tried all of the methods in which you freinds suggested me .But still am not getting exact output. Here is the command used install install install Spreadsheet::Read and result is nolock_cpan> install Spreadsheet::Read Spreadsheet::Read is up to date (0.69). my code is

        #!/usr/bin/perl use strict; use warnings; use Spreadsheet::Read qw(ReadData); my $book = ReadData ('simple.xlsx'); say 'A1: ' . $book->[1]{A1}; my @rows = Spreadsheet::Read::rows($book->[1]); foreach my $i (1 .. scalar @rows) { foreach my $j (1 .. scalar @{$rows[$i-1]}) { say chr(64+$i) . " $j " . ($rows[$i-1][$j-1] // ''); } }