You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by 冯如超 <fe...@126.com> on 2011/10/11 01:17:46 UTC
how to create a workbook with read-protected-password
To All,
Excuse me, I need to create a workbook with read-protected-password so that others cannot read it.
Now in POI thers is a method(writeProtectedPassword) that can create a write protected workbook.. However,I do not know how to create a workbook with read-protected-password.
IF anyone knows, would you please mail back to me?
Thanks a lot.
Re: how to create a workbook with read-protected-password
Posted by Ja...@bbh.com.
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 james.rourke@bbh.com
It works and I have not seen or heard from anyone with a better idea!!!
From: Guillaume de GENTILE <gd...@finbox-solutions.com>
To: POI Users List <us...@poi.apache.org>
Cc: "user@poi.apache.org" <us...@poi.apache.org>
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 <br...@hku.hk> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
*************************** 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.
********************************************************************************
Re: how to create a workbook with read-protected-password
Posted by Guillaume de GENTILE <gd...@finbox-solutions.com>.
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 <br...@hku.hk> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: how to create a workbook with read-protected-password
Posted by Brenda <br...@hku.hk>.
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: how to create a workbook with read-protected-password
Posted by Maxim Valyanskiy <ma...@jet.msk.su>.
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
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org