[fpspreadsheet] Read from ods with password

[bonmario]

Hi,
sorry for my bad english ...

When i must read from a file Ods, i use this code:

Code: Pascal  [Select][+][-]

1. MyWorkbook.ReadFromFile(NomeDocSaleranoTmp, sfOpenDocument);

If a file is protected from a password, how can i read from this?



Thanks, Mario

[wp]

Sorry, password-protection is supported, in a very elemental form, only for Excel XLSX.

[bonmario]

Don't worry, it's no problem.
Thanks anyway for the excellent work done with this Package

Hi Mario

[wp]

OK - here is a reader for encrypted ods files. Not heavily tested, but it works at least with my test file. Please note that it depends on the Abbrevia (because the FPC zipper cannot extract the encrypted xml subfiles) and DCPCrypt (because FPC does not provide AES decryption) libraries. You can find both libraries in the OPM. No need to install, just download and open the lpk package file so that the IDE knows where they are. Afterwards you can compile the demo program in the attachment.

[rvk]

Please note that it depends on  (...) and DCPCrypt (because FPC does not provide AES decryption) libraries.

If you don't want the dependency with DCCrypt, I think this could, theoretically, also be done with calls to openssl (aes-256-cbc) 

(Not sure if FPC exposes all the necessary calls.)

[wp]

Found Wolfgang Ehrhardt's crypto library (https://github.com/chadilukito/www.wolfgang-ehrhardt.de/tree/master/src/crypto) which can be integrated into fpspreadsheet-crypto more easily. Here is the same sample project, now without dependence on DCPcrypt.

[rvk]

Found Wolfgang Ehrhardt's crypto library (https://github.com/chadilukito/www.wolfgang-ehrhardt.de/tree/master/src/crypto) which can be integrated into fpspreadsheet-crypto more easily. Here is the same sample project, now without dependence on DCPcrypt.

It wasn't the dependency to DCPcrypt perse, but if it was possible to use openssl (which would be installed by default everywhere in FPC) that would have been much easier.

But using the openssl functions currently present in FPC to decrypt AES-256-CBC isn't as easy as it looks (but should be possible).
(An example in Delphi https://stackoverflow.com/a/9733823/1037511 but the key creation is somewhat different there)

But for now including Wolfgang's library should be sufficient for use case of TS (and others).

[wp]

but if it was possible to use openssl (which would be installed by default everywhere in FPC) that would have been much easier.

But still the openssl dlls would have to be available at runtime. I would like to keep fpspreadsheet clean of such requirements.

[rvk]

But still the openssl dlls would have to be available at runtime. I would like to keep fpspreadsheet clean of such requirements.

Ah, Ok. No problem. In that case a 3dparty folder in fpspreadsheet is preferable above including the dependency to openssl dlls.

(I guess openssl dll's aren't as standard as I thought  )

[wp]

Reading a password-protected ods workbook is now included in the svn version of fpspreadsheet (package laz_fpspreadsheet_crypto.lpk)

https://wiki.lazarus.freepascal.org/FPSpreadsheet#Workbook_protection - last paragraph and code.

[bonmario]

Reading a password-protected ods workbook is now included in the svn version of fpspreadsheet (package laz_fpspreadsheet_crypto.lpk)

https://wiki.lazarus.freepascal.org/FPSpreadsheet#Workbook_protection - last paragraph and code.

HI,
sorry for the delay, but I didn't realize there were new replies.
I've seen them now, and I've tried the modifications: you've done a splendid job.

Thanks, Mario