help wanted
Repository metrics
- Stars
- (33,728 stars)
- PR merge metrics
- (No merged PRs in 30d)
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);
}
谢谢大家了！！救救孩子