Lock single column in Excel using Apache POI

Question

I want to create a Excel in which only a specific column is locked(Read-only), and the rest are editable,

I am using the following approach, but that doesn't seem to work.

Create two CellStyles, one with setLocked(true) and other with setLocked(false).

Then apply the locked style for all the cells in the column which needs to be locked, and the unlocked style for all the other cells.

Protect the sheet using sheet.protectSheet("");

But when I open the created Excel in open office, I notice that all the cells are locked!

None of them are editable.

How can I achieve the above requirement?

P.S : I cant use the data validation approach.

stackoverflow.com/questions/8502552/…

2787184
– 2787184

2015-10-09 11:09:16 +00:00
Commented Oct 9, 2015 at 11:09 — 2787184
– 2787184, Commented Oct 9, 2015 at 11:09

Kai · Accepted Answer · 2012-02-08 17:00:21Z

32

If you do the opposite it works. Protect the whole sheet and call setLocked(false) for the cells which should be editable.

String file = "c:\\poitest.xlsx";
FileOutputStream outputStream = new FileOutputStream(file);
Workbook wb = new XSSFWorkbook();

CellStyle unlockedCellStyle = wb.createCellStyle();
unlockedCellStyle.setLocked(false);

Sheet sheet = wb.createSheet();
sheet.protectSheet("password");
Row row = sheet.createRow(0);
Cell cell = row.createCell(0);
cell.setCellValue("TEST");
cell.setCellStyle(unlockedCellStyle);

wb.write(outputStream);
outputStream.close();

answered Feb 8, 2012 at 17:00

Kai

39.8k14 gold badges92 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bobo Over a year ago

to be more clear, the entire workbook is locked including the cell that is supposed to be unlocked.

Collectives™ on Stack Overflow

Lock single column in Excel using Apache POI

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related