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

we need to protect password for excel file using perl script without prompt password. Any Sample codes available let me know.we need to which package should install for that

Replies are listed 'Best First'.
Re: protect excel file in perl script
by madtoperl (Hermit) on Jan 17, 2017 at 14:04 UTC
    If I understand your question correctly, you are trying to open the password protected excel file and parse it, 
    Use Win32::OLE module and try this.
my $sheet =
  $Excel->Workbooks->Open( { FileName => $filetoread, Password => $pas
+s } );

    [download]
[reply]
[d/l]
Re: protect excel file in perl script
by kevbot (Vicar) on Jan 18, 2017 at 07:06 UTC
    If you want to write an Excel file that contains protected worksheets, then take a look at the Excel::Writer::XLSX module. It has a protect method that can be used to password protect a worksheet.
[reply]
      Hello there I am looking opening excel file(.xlsx or .xls) it should ask the password to open and view the excel file .Is it possible in perl script ?
[reply]
[reply]

Back to Seekers of Perl Wisdom