aspose file tools*
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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
Problem in reading the excel file path from WINDOWs machine from UNIX environment
Streaming an xcel file using servlets
CSV file opening in Excel - cell auto adjustment using JasperReports
Saving data to Excel files
Java - COM Communication