help wanted
Metriche repository
- Star
- (33.728 star)
- Metriche merge PR
- (Nessuna PR mergiata in 30 g)
Descrizione
WriteSheet writeSheet = EasyExcel.writerSheet(0, "整改情况分析列表")
.registerWriteHandler(new LongestMatchColumnWidthStyleStrategy())
.registerWriteHandler(new FontColorHandler())
.registerWriteHandler(new LockSheetHandler())
.head(DswtZgxqzbExportVO.class)
.build();
LockSheetHandler：：：
@Override
public void afterSheetCreate(WriteWorkbookHolder writeWorkbookHolder, WriteSheetHolder writeSheetHolder) {
Sheet sheet = writeSheetHolder.getSheet();
//锁定工作簿，设置保护密码
sheet.protectSheet("1qaz!QAZ");
// 锁定单元格不可选中(防止别人直接复制内容到其他excel修改)
// ((SXSSFSheet) writeSheetHolder.getSheet()).lockSelectLockedCells(true);
}
谢谢大家了！！救救孩子