Our organization found an open-source piece of java code that runs only on a Windows server that can password protect an Excel document. Underneath the covers, it is actually invoking a piece of VB script using Excel to perform the password assignment.
Therefore, you must run the open-source software on a Windows box. Microsoft warns about placing office components on a server but we did it anyway and haven't experienced any issues. To be on the safeside we have a WM small windows server dedicated to this task. We wrote a web service that we invoke passing it a database key that provided the web service with access to an Oracle blob, which contains the serialized Excel file. The web service reads the blob when uses its contents as the Excel file and invoked the open-source software to assign the password, you pass the desired password along with the Excel file (in this case the contents of the blob). Once the password has been assigned, the web services writes the blob back to the database and returns control to the web service caller. The caller then reads the blob and now has the password protected Excel document. If anyone wants more info please email me at [email protected] It works and I have not seen or heard from anyone with a better idea!!! From: Guillaume de GENTILE <[email protected]> To: POI Users List <[email protected]> Cc: "[email protected]" <[email protected]> Date: 01/03/2013 03:20 AM Subject: Re: how to create a workbook with read-protected-password hi Brenda, a workaround could be to zip the excel doc in a password protected Zip file. Regards, Guillaume Envoyé de mon iPhone Le 2 janv. 2013 à 05:03, Brenda <[email protected]> a écrit : > Maxim Valyanskiy <maxcom <at> jet.msk.su> writes: > >> >> Hello! >> >> 11.10.2011 03:17, 冯如超 пишет: >>> Excuse me, I need to create a workbook with read-protected-password so > that >>> others cannot read it. >> AFAIK currently we have read-only support for encrypted files, creation of > such >> files is not implemented >> >> best wishes, Max > > > Hello Max, > > When such a function will implement on the poi HSSFWorkbook and SXSSFWorkbook > classes? I am urgent to need this function for my organization to create > excel file. Any temporary solution for that? > > Thanks. Happy New Year! > > Regards, > Brenda > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] *************************** IMPORTANT NOTE*****************************-- The opinions expressed in this message and/or any attachments are those of the author and not necessarily those of Brown Brothers Harriman & Co., its subsidiaries and affiliates ("BBH"). There is no guarantee that this message is either private or confidential, and it may have been altered by unauthorized sources without your or our knowledge. Nothing in the message is capable or intended to create any legally binding obligations on either party and it is not intended to provide legal advice. BBH accepts no responsibility for loss or damage from its use, including damage from virus. ********************************************************************************
