Axolot Data

Posted: **Mon Aug 20, 2018 2:22 pm**

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.

Posted: **Fri Aug 24, 2018 10:25 am**

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.

Axolot Data

XLSRWException when reading password protected files.

XLSRWException when reading password protected files.

Re: XLSRWException when reading password protected files.