A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Refactoring for Software Design Smells: Managing Technical Debt
this week in the
OO, Patterns, UML and Refactoring
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
. 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".
Have you checked out
subject: Setting Range Protection in Excel File using Jakarta POI
Restricting special characters while writing to excel
xml to ms word
Saving data to Excel files
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015