Manning's Countdown to 2014
. Use discount code crdotd14 all month for 50% off every deal.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
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".
Ping & DNS, my free Android app for network diagnostics
It is sorta covered in the
JavaRanch Style Guide
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