Hi, as far as I know you cannot password-protect a workbook from a Perl module. (Maybe it's possible with a Win32 module, unknown to me...) The following code "protects" the worksheet, requiring a password to change/add any data, but as noted in the doc for Excel::Writer::XLSX, the "protection" is very weak.

use strict; use warnings; 

use Excel::Writer::XLSX;

my $workbook = Excel::Writer::XLSX->new( '1202661.xlsx' );
my $worksheet = $workbook->add_worksheet();
$worksheet->write( 'A1', 'foo' );
$worksheet->write( 'B1', 'bar' );
$worksheet->write( 'A2', 'baz' );
$worksheet->write( 'B2', 'qux' );

$worksheet->protect('s3kr1t');

__END__
[download]

If you're on a Windows system and have Excel installed, you can use Win32::OLE to automate Excel. Anything that you can do manually in Excel is possible to do via Win32::OLE. But this is a case of Perl automating an external program (Excel). Personally I have not used any of the modules that attempt to manipulate Excel files without using Excel itself, so I can't comment on their capabilities or suggest an alternative.

I had tried Excel::Writer::XLSX, it only protect something to write on it..Not making excel file password protected.

Hello dgupta,

Welcome to the Monastery. This question was asked in the past on the Monastery Password Protect Excel File. I do not see any answer that can assist you on the relevant question but they propose a few other approaches.

Read it through maybe it will assist you. If you manage to resolve your problem update your question so other people can benefit from it too.

Hope this helps, BR.