Reading password protected XLSX on linux (and windows) using Perl

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 } );
+5
source share
2 answers

None of the current Perl xlsx reader modules support reading encrypted files.

It’s not easy to decrypt these files, because the encrypted XML files are stored in an OLE container document, and not in a regular ZIP container.

+3

"" OpenOffice/LibreOffice. , xlsx , , LibreOffice, , .

OpenOffice:: OODOC Perl, , - .

+1

All Articles