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

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
[download]

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` [download] cpanm is a better, faster installer IMHO. If you are using the system perl consider `yum` could install `perl-Spreadsheet-ParseExcel`.	[reply] [d/l] [select]
Re^2: Installation error of Spreadsheet::ParseXLSX in CPAN on Linux ( RedHat) server by chandantul (Scribe) on Feb 04, 2021 at 23:25 UTC
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?	[reply]
Re^3: Installation error of Spreadsheet::ParseXLSX in CPAN on Linux ( RedHat) server by syphilis (Archbishop) on Feb 05, 2021 at 00:12 UTC
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	[reply] [d/l] [select]
Re^4: Installation error of Spreadsheet::ParseXLSX in CPAN on Linux ( RedHat) server by chandantul (Scribe) on Feb 05, 2021 at 01:52 UTC


Clear questions and runnable code get the best and fastest answer
	PerlMonks