Password protected xls/xlsx file in java

[Happy S Singh]

I have created password protected zip file which has xls file with the help of this http://java.sys-con.com/node/1258827.

My question is ,Is there any java api which will create password protected xls file instead of zip file. I want to directly apply password on xls file.Encryption/Decryption is the option but want to prompt when when double clicked on file.

[Ulf Dittmer]

Apache POI can do this.

[Happy S Singh]

thanks.

[Junilu Lacar]

Did you check out the org.apache.poi.poifs.crypt package? There's not much in the JavaDocs but you might look around for examples. Just a thought it would be worth looking into before you dismiss what Ulf said just like that.

[Happy S Singh]

I got this

HSSFSheet.protectSheet("xyz");

,but it only makes sheet read only.


Even I have tried this

hssfworkbook.writeProtectWorkbook("abc", "abc");

,but its not prompting for password.

Did you check out the org.apache.poi.poifs.crypt package?

I didn't got example of

org.apache.poi.poifs.crypt package

.Please share the link of example.