I am trying to write a simple perl script that reads some fields from a password protected XSLX file.
I looked at Table :: XLSX and SimpleXlsx , but it does not seem to support password protected files.
Any idea how this can be done?
Using Win32 :: OLE This is done as follows:
my $Book =
$Excel->Workbooks->Open( { FileName => $file, Password => $password } );
source
share