Hi Team, We are generating 3 sheets( sheet1,sheet2,sheet3) in excel workbook using POI. We are able to protect sheet but we are not able to protect the entire workbook using POI. But in MSExcel there is a feature to protect entire workbook . is workbook protection possible through POI?
My actual requirement is like : I am hiding one sheet (sheet2), so if user will download excel he will get excel workbook with two sheets (sheet1,sheet3) visible and one sheet (sheet2) hidden . I don't want the user to see sheet2.I want to disable UNHIDE option in the downloaded excel workbook so that the user thinks that there are only two sheets (sheet1,sheet2). APPROACH 1: If we protect the entire workbook it will disable HIDE ,UNHIDE options . is it possible using APACHE POI ? Is there any other approach to solve this ?? -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Is-it-possible-to-proctect-entire-excel-HSSF-Workbook-using-apache-POI-tp5713811.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
