aspose file tools
The moose likes Java in General and the fly likes Setting Range Protection in Excel File using Jakarta POI Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Java » Java in General
Reply Bookmark "Setting Range Protection in Excel File using Jakarta POI" Watch "Setting Range Protection in Excel File using Jakarta POI" New topic
Author

Setting Range Protection in Excel File using Jakarta POI

Manasa Daggubati
Greenhorn

Joined: Jul 07, 2009
Posts: 1
posted private message
0
Quote
I am using Jakarta HSSF POI to create an excel file in Java. I am able to set password protection for the whole sheet.

But I need to set it only for a few columns and the others should be editable.

I checked in Excel and there is an option "Allow Users to Edit Ranges".

Is this feature available in Jakarta or are there any other APIs that have this feature.

Please Help.

Thanks
M
ram prasad A
Greenhorn

Joined: Jul 22, 2009
Posts: 1
posted private message
0
Quote
hi you said... I am able to set password protection for the whole sheet.
can you share that code...

[ UD: Please UseTheForumNotEmail ]
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 35241
    
    7
posted
0
Quote
The HSSFSheet class has methods to protect a sheet. Search its javadocs for "password".

Android apps – ImageJ plugins – Java web charts
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Setting Range Protection in Excel File using Jakarta POI
 
Similar Threads
Create Spreadsheet
Saving data to Excel files
excel charts
Restricting special characters while writing to excel
xml to ms word