java - How to use POI to prohibit users from adding sheets in EXCEL
给我你的怀抱
给我你的怀抱 2017-05-17 10:01:18
0
1
780

Excel generated by POI can add sheets. How to disable this function
In addition, how to use POI to only allow users to modify the style of the table but not the content of the table

给我你的怀抱
给我你的怀抱

reply all(1)
为情所困

Do you want to prevent the cell value from being modified? You can set itCellStyle

CellStyle unlockedCellStyle = wb.createCellStyle();
unlockedCellStyle.setLocked(true); 
cell.setCellStyle(unlockedCellStyle);
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template