help wanted
仓库指标
- Star
- (33,728 star)
- PR 合并指标
- (30 天内没有已合并 PR)
描述
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);
}
谢谢大家了！！救救孩子