in reply to read from xlsx is throwing error

Hello ajaykannan,

The only problem with the code shown is that you’re using say without first declaring it:

use feature qw( say );

[download]

Apart from that, your code works fine for me. The error message you report is saying that the Spreadsheet::Read module is not located in any of the directories in @INC. This has nothing to do with Spreadsheet::Read being able to delegate to other modules such as Spreadsheet::ParseXLXS. I suggest you check your paths to ensure that Spreadsheet::Read is installed in a directory listed in @INC. For example, what output do you get from the following one-liner?

12:52 >perl -MSpreadsheet::Read -wE "say $Spreadsheet::Read::VERSION;"
0.64

12:54 >

[download]

Hope that helps,

Athanasius <°(((>< contra mundum Iustus alius egestas vitae, eros Piratica,

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

    Can't locate Spreadsheet/Read.pm in @INC (you may need to install the Spreadshee t::Read module) (@INC contains: C:/Strawberry/perl/site/lib C:/Strawberry/perl/v endor/lib C:/Strawberry/perl/lib .). BEGIN failed--compilation aborted. am getting this error

[reply]

      It seems you are on Windows and in another reply you claim that Spreadsheet::Read is installed.

      Perl thinks it is not installed and it cannot find it in the directories listed. To diagnose whether the files have been installed, run the following and post its output:

      dir /b /s C:\Strawberry\perl\Read.pm

      [download]

      You should find a file Spreadsheet\Read.pm somewhere there. If not, then Perl is right and you did not install the module.

      To install the module, run:

      C:\Strawberry\perl\bin\cpan Spreadsheet::Read

      [download]
[reply]
[d/l]
[select]

        i run this command as you said C:\Strawberry\perl\bin\cpan Spreadsheet::Read and it is also being installed but still am getting error. Thank you for the help and can you help me

[reply]

In Section Seekers of Perl Wisdom