This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Other Open Source Projects and the fly likes POI - How to Block the cell of an excel. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "POI - How to Block the cell of an excel." Watch "POI - How to Block the cell of an excel." New topic
Author

POI - How to Block the cell of an excel.

vishnu vyasan
Ranch Hand

Joined: May 27, 2008
Posts: 39
Hi,

I am creating an excel file using jakartha POI. now i have to block some fields of the excel so that the user wont be modifing it. I have tried the HSSFCellStyle class and its setLocked(true) method, but unfortunatly not working for me.

any help on this would be appriciated.
Regards
vishnu nv
Kuladip Yadav
Ranch Hand

Joined: Jul 30, 2008
Posts: 162

For that first you want to protect your sheet

using

and then use setLocked(true) to cells that you are interested.

Try This.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: POI - How to Block the cell of an excel.
 
Similar Threads
Java - COM Communication
CSV file opening in Excel - cell auto adjustment using JasperReports
Streaming an xcel file using servlets
Saving data to Excel files
Problem in reading the excel file path from WINDOWs machine from UNIX environment