Step # 2: Write a program like following in your machine. Step # 1: Just download latest poi.jar from following location See if of any help to anyone here at any point of time. Anyway, I found that a password protected excel sheet can be created in Java.
Don't know why everyone ignored such thing. Well, my problem is not solved yet and it seem a time-consuming one as many of the Java APIs have taken into consideration of only PDF Files security but not of Excel sheets. In Formatting restrictions, Editing restrictions and Start enforcement, you can make selections that meet your formatting and editing needs. Select Restrict Formatting and Editing.ģ. On the Review tab, click Protect Document.Ģ. In the Confirm Password dialog box, in the Reenter password box, type the password again, and then click OK.ġ. Encryption is a standard method used to help make your file more secure.ģ. By default, this feature uses AES 128-bit advanced encryption. In the Encrypt Document dialog box, in the Password box, type a password, and then click OK. Click the Microsoft Office Button (the Round, point to Prepare, and then click Encrypt Document.Ģ. Now, enter a secure password for your Excel spreadsheet. I'm reading this as "How to password protect excel sheets" (office 2007) - Here's the solution:ġ. Select Protect Workbook, then Encrypt with Password from the dropdown menu.
0 kommentar(er)
