Setting excel encryption problem

[weijs <we...@gmail.com>]

Hi.
I have to check a lot of data.
I use this"writeProtectWorkbook(String passwrod,Sting user)" method.
This method can realize I want results,but It popup hints, have "read-only"
option, I don't want this.
Others will also through "read-only" into the form.
So,I just want to others input password to enter the excel.Other ways can't.
Poi have such methods satisfy my request?


-- 
View this message in context: http://apache-poi.1045710.n5.nabble.com/Setting-excel-encryption-problem-tp3319124p3319124.html
Sent from the POI - Dev mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

Re: Setting excel encryption problem

[Mark Beardsley <ma...@tiscali.co.uk>]

If I understand your question correctly, you are trying to find a technique
where if the user is unable to supply the password for the workbook then
they are not offered the option of opening a read only version of the file.

If this is correct, then you are trying to circumvent the way the
application - Excel itself - works and it will not be possible to do this
using POI IMO. It might be possible to code an add-on to Excel that would
emulate this behaviour but you will have to ask for help on this at an Excel
forum.

Yours

Mark B
-- 
View this message in context: http://apache-poi.1045710.n5.nabble.com/Setting-excel-encryption-problem-tp3319124p3319514.html
Sent from the POI - Dev mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org