Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Installation error of Spreadsheet::ParseXLSX in CPAN on Linux ( RedHat) server

by chandantul (Scribe)
on Feb 04, 2021 at 22:38 UTC ( #11127900=perlquestion: print w/replies, xml ) Need Help??

chandantul has asked for the wisdom of the Perl Monks concerning the following question:

Hello, I was unable to install Spreadsheet::ParseXLSX module and i am getting below error. Could you please help me to identify the error and how i can get rid of this issue?

REDHAT_SUPPORT_PRODUCT_VERSION="7.9" -------------- # Failed test 'Spreadsheet/ParseXLSX/Decryptor/Agile.pm loaded ok' # at t/00-compile.t line 40. # got: '512' # expected: '0' Can't locate Crypt/Mode/CBC.pm in @INC (@INC contains: /root/.cpan/bui +ld/Spreadsheet-ParseXLSX-0.27-zhPVoH/blib/arch /root/.cpan/build/Spre +adsheet-ParseXLSX-0.27-zhPVoH/blib/lib /root/.cpan/build/Spreadsheet- +ParseXLSX-0.27-zhPVoH/blib/lib /root/.cpan/build/Spreadsheet-ParseXLS +X-0.27-zhPVoH/blib/arch /usr/local/lib64/perl5 /usr/local/share/perl5 + /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64 +/perl5 /usr/share/perl5 .) at /root/.cpan/build/Spreadsheet-ParseXLSX +-0.27-zhPVoH/blib/lib/Spreadsheet/ParseXLSX/Decryptor.pm line 7. BEGIN failed--compilation aborted at /root/.cpan/build/Spreadsheet-Par +seXLSX-0.27-zhPVoH/blib/lib/Spreadsheet/ParseXLSX/Decryptor.pm line 7 +. Compilation failed in require at (eval 2) line 2. ...propagated at /usr/share/perl5/base.pm line 84. BEGIN failed--compilation aborted at /root/.cpan/build/Spreadsheet-Par +seXLSX-0.27-zhPVoH/blib/lib/Spreadsheet/ParseXLSX/Decryptor/Agile.pm +line 7. Compilation failed in require at -e line 1. # Failed test 'Spreadsheet/ParseXLSX/Decryptor/Standard.pm loaded ok +' # at t/00-compile.t line 40. # got: '512' # expected: '0' Can't locate Crypt/Mode/CBC.pm in @INC (@INC contains: /root/.cpan/bui +ld/Spreadsheet-ParseXLSX-0.27-zhPVoH/blib/arch /root/.cpan/build/Spre +adsheet-ParseXLSX-0.27-zhPVoH/blib/lib /root/.cpan/build/Spreadsheet- +ParseXLSX-0.27-zhPVoH/blib/lib /root/.cpan/build/Spreadsheet-ParseXLS +X-0.27-zhPVoH/blib/arch /usr/local/lib64/perl5 /usr/local/share/perl5 + /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64 +/perl5 /usr/share/perl5 .) at /root/.cpan/build/Spreadsheet-ParseXLSX +-0.27-zhPVoH/blib/lib/Spreadsheet/ParseXLSX/Decryptor.pm line 7. BEGIN failed--compilation aborted at /root/.cpan/build/Spreadsheet-Par +seXLSX-0.27-zhPVoH/blib/lib/Spreadsheet/ParseXLSX/Decryptor.pm line 7 +. Compilation failed in require at (eval 2) line 2. ...propagated at /usr/share/perl5/base.pm line 84. BEGIN failed--compilation aborted at /root/.cpan/build/Spreadsheet-Par +seXLSX-0.27-zhPVoH/blib/lib/Spreadsheet/ParseXLSX/Decryptor/Standard. +pm line 7. Compilation failed in require at -e line 1. # Looks like you failed 4 tests of 4. t/00-compile.t ............. Dubious, test returned 4 (wstat 1024, 0x4 +00) Failed 4/4 subtests
  • Comment on Installation error of Spreadsheet::ParseXLSX in CPAN on Linux ( RedHat) server
  • Download Code

Replies are listed 'Best First'.
Re: Installation error of Spreadsheet::ParseXLSX in CPAN on Linux ( RedHat) server
by marto (Cardinal) on Feb 04, 2021 at 22:51 UTC

    Spreadsheet::ParseXLSX has Crypt::Mode::CBC as a dependency. IIRC the defaults for cpan are to follow dependencies, if you've altered this:

    cpan> o conf prerequisites_policy 'follow' cpan> o conf build_requires_install_policy yes cpan> o conf commit

    cpanm is a better, faster installer IMHO. If you are using the system perl consider yum could install perl-Spreadsheet-ParseExcel.

      I have done the below settings but its still not able to install the dependencies cpan> o conf prerequisites_policy 'follow' cpan> o conf build_requires_install_policy yes cpan> o conf commit Do you want me to install from command line of the linux server by downloading DOY/Spreadsheet-ParseXLSX-0.27.tar.gz through cpanm?

        its still not able to install the dependencies

        Is it at least trying to install Crypt::Mode::CBC ?
        What happens if you run cpan -i Crypt::Mode::CBC before running cpan -i Spreadsheet::ParseXLSX

        Cheers,
        Rob

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://11127900]
Approved by marto
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (3)
As of 2021-05-13 10:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Perl 7 will be out ...





    Results (134 votes). Check out past polls.

    Notices?