A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
The Mikado Method
this week in the
Agile and other Processes
Java in General
Setting Range Protection in Excel File using Jakarta POI
Joined: Jul 07, 2009
Jul 07, 2009 14:28:54
I am using Jakarta HSSF POI to create an
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.
ram prasad A
Joined: Jul 22, 2009
Jul 22, 2009 01:59:00
hi you said... I am able to set password protection for the whole sheet.
can you share that code...
[ UD: Please
Joined: Mar 22, 2005
Jul 22, 2009 02:07:11
The HSSFSheet class has methods to protect a sheet. Search its javadocs for "password".
Java web charts
I agree. Here's the link:
- 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
Saving data to Excel files
Restricting special characters while writing to excel
xml to ms word
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013