in reply to Re^8: protect excel file in perl script
in thread protect excel file in perl script

installed perl-Spreadsheet-ParseExcel.x86_64 0.3200-3.el5

That looks like a version from 2007. Version 0.56 November 9 2009 has this comment

Changed Parse() method name to parse() for consistency with the rest of the API. The older method name is still supported but not documented.

so try

my $workbook = $parser->Parse($input);
poj

Replies are listed 'Best First'.
Re^10: protect excel file in perl script
by arunks (Novice) on Feb 02, 2017 at 07:15 UTC
    Can you please provide the latest version link to download the package
        send me the link of Spreadsheet::ParseXLSX package. my perl version : This is perl, v5.8.8 built for x86_64-linux-thread-multi my installed package perl-Spreadsheet-XLSX.noarch 0.13-8.el5 installed am getting below error: Can't locate Spreadsheet/ParseXLSX.pm in @INC (@INC contains: /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at pfiz_files2xl_merger.pl line 5. BEGIN failed--compilation aborted at pfiz_files2xl_merger.pl line 5. -bash-3.2$
Re^10: protect excel file in perl script
by arunks (Novice) on Mar 15, 2017 at 08:23 UTC
    installed perl-Spreadsheet-ParseExcel.x86_64 0.3200-3.el5 we have this module version installed on Linux v5.8.8. our code is not making password protection excel sheets do we need to upgrade perl version or module version.please advice

      What error messages are you getting ?

        NO error throwing in my code.Making Password protection functionality is not working on my perl version v5.8.8 and current installed parse excel module version: perl-Spreadsheet-ParseExcel.x86_64 0.3200-3.el5 #!/usr/bin/perl -w use strict; use Spreadsheet::ParseExcel; my $file='/home/muthum/excel1.xls'; my $parser = Spreadsheet::ParseExcel->new( Password => 'secret' ); my $workbook = $parser->Parse($file);
Re^10: protect excel file in perl script
by arunks (Novice) on Mar 01, 2017 at 06:07 UTC
    We have a requirement to protect excel sheet with password using Perl Script. Current version of Parse Excel Module which we have is " perl-Spreadsheet-ParseExcel.x86_64 0.3200-3.el5 " Issue Faced while upgrading current version into "perl package (Spreadsheet-ParseExcel-0.65.tar.gz)" : Unable to locate dependency modulesCan't locate Digest/Perl/MD5.pm in @INC (@INC contains: /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-

      You need to install prerequisites, to make life easy use cpan or cpanm:

      cpan Spreadsheet::ParseExcel

      Alternatively use the package manager that ships with your OS.