This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Setting Range Protection in Excel File using Jakarta POI

 
Manasa Daggubati
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi you said... I am able to set password protection for the whole sheet.
can you share that code...

[ UD: Please UseTheForumNotEmail ]
 
Ulf Dittmer
Rancher
Pie
Posts: 42966
73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The HSSFSheet class has methods to protect a sheet. Search its javadocs for "password".
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic