Yes you can protect the sheet. I have done it with 3.2 and I used a different password for each sheet. I don't have the code at hand but can send the code to you in another 6 hrs. ------Original Message------ From: MSB To: [email protected] ReplyTo: POI Users List Subject: Re: Protect workbook for structure Sent: Jul 3, 2009 2:51 AM
Hello, Is it possible to do this using Excel itself? The reason I ask is that I am not sure you could prevent anyone from copying information from a sheet but I could be wrong. The first thing I do if I am unsure about how to accomplish anything is to try and do it using Excel. That often indicates whether the setting I am after applies to the workbook, a sheet, etc. Also, it helps to point me in the direction of the setting I am after. If I have the time, and I cannot promise anything as I am working on another project for a list member currently, then I will take a look. Yours Mark B kevintong wrote: > > I have a JAVA program which uses POI library to generate a xls file, and I > want to prevent users to add, delete or copy the worksheets. I try to use > the writeProtectWorkbook function in HSSFWorkbook class, but it doesn't > work. Is there any other way to do so? > Please advice, thank you very much! > > Kevin > > -- View this message in context: http://www.nabble.com/Protect-workbook-for-structure-tp24316602p24319095.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] Sent via BlackBerry by AT&T
