XLSRWException when reading password protected files.

[d3nton]

Hello!

I am unable to open password protected files (xlsx and xls). In both cases I receive XLSRWExceptions.
Test files can be downloaded from this link:
https://fileshare.jam-software.de/share ... id=0vtUzb9
Password is: 1234

Code: Select all

 try
   lXLSReadWrite := TXLSReadWriteII5.Create(Self);
   try
     lXLSReadWrite .Filename := lFilePath;
     lXLSReadWrite .Password := lPassword;
     lXLSReadWrite .Read; 
   except
     // => Exception occurs
     Exit;
   end;
   finally
     FreeAndNil(lJAMXLSReadWrite);
   end;

Thanks for your help.

[larsa]

Hello

The issue with XLSX files is fixed in update 6.00.43. XLS files don't seems to be possible to decrypt if they are encrypted with Excel 2016. Something has probably changed with the encryption method.