Q: We've been using your "Excel from RPG" stuff, and love it. But I've been unable to figure out a way to lock cells in a spreadsheet with POI! We're generating a form in which users can fill in some fields, but we don't want them to change others. How can we lock the cells against changes? A: Locking cells in HSSF is easier than you might think. You first have to protect the sheet by calling the protectSheet() method of the HSSFSheet class and assigning a password that will be ...

REGISTER NOW TO ACCESS THIS ARTICLE

All registered users get access to premium content on iPro Developer for free.

Already registered? here.