xlsx with password ?

Hi Skrol29,

I am looking for a solution for an export operation in some paranoic site.

Do You think it is possible to create an excel file with a password ?
Or is there a trick to just create a zipped file wih a password ?

Do You think this is something you might include in some future version of tbszip or opentbs ?


Thanks

Hi,

Docx ansd Xlsx documents can be protected with a password for opening.
This make a strong encryption in the sub-file structure. I have no idea how difficult it could be to decrypt such a Docx or Xlsx file with PHP

Docx ansd Xlsx documents can also be protected with a password for editing.
In this case, he password is just a property of the document or of the sheet, and you can still use OpenTBS for merging, just like i there was no protection.

> Do You think this is something you might include in some future version of tbszip or opentbs ?

Yes if I find the PHP code for decrypt protected Docx and Xlsx.

Hmm,

Thanks for responding but i am not sure if we imagine the same.

My idea is - maybe in some future - prepare an uncrypted xlsx or ods template file, but deliver via web the same file with data of course, but with a password, so i can open it from a LibreOffice or MSOffice program. I think the result may be even read only (no editing).

I think there would be no need to decrypt from php ;).

Do you mean a password for downloading the document, or a password to be able to open it in LibreOffice ?

The password to open it in LibreOffice.
The password for encryption should be some variable in the php script (and known to the end user).
But php does not need to "open" the file after generation.