help wanted
Métriques du dépôt
- Stars
- (33 728 stars)
- Métriques de merge PR
- (Aucune PR mergée en 30 j)
Description
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);
}
谢谢大家了！！救救孩子