single cell read only in excel using java

Question

hi,

how can i make a cell read only in excel using java

Thanks in advance

Answer 1

Take a look at the Apache POI project, specifically the HSSF & XSSF subprojects, that provides a Java library to manipulate Excel documents.

Answer 2

Maybe you can try jExcel. It is quite simple and easy to use.

Answer 3

You may use apache POI library to achive this. Here is a simple code sample:

HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("Test");

Row row = sheet.createRow(0);

CellStyle style = wb.createCellStyle();
style.setLocked(true);
cell = row.createCell(0);
cell.setCellStyle(style);

// this is important as locking is pnly activated if sheet is protected
sheet.protectSheet("");

Answer 4

You can try SmartXLS for java.