Hello there,
Hope all is well. I am using poi 3.7 and 1.6 jdk. I am using both HSSF and
XSSF ( 2003 and 2007 excel files). All I wanted to do was to read the
password protected files and I do have the password with me.
In excel 2007 ... I can provide Workbook password protection using 1)
Under Review --> Protect workbook 2) Save As --> Tools --> General Option 3)
Prepare --> Encrpt document ...... these 3 mechanisms to password protect my
workbook.
When I did search on the forum, I see that encrypted workbook can't be
opened with POI. But which of the above mentioned 3 password protection
mechanism encrypt the excel workbook....all of them or only # 3 from above.
If only # 3, can someone please provide sample code/link to read password
protected workbook that are not encrypted. Something like
Workbook.open("username","Password").
Please let me know if I have missed on something.
Thanks in advance,
Sam
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Re-Open-password-protected-XLS-XLSX-workbook-tp4301888p4301888.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
