1、给execl加密(打开时需要密码才能看)
2、还是给sheet加密等(可以打开查看,但是无法编辑)
1、HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(bp.resourcesDir + "origin.xls"));
wb.writeProtectWorkbook("password", "username");
2 、Sheet sheet = wb.createSheet("sheetName");
Row row = sheet.createRow(1);
Cell cell = row.createCell(0);
Font font1 = wb.createFont();
font1.setBoldweight(Font.BOLDWEIGHT_BOLD);
style = createBorderedStyle(wb);
style.setAlignment(CellStyle.ALIGN_LEFT);
style.setFont(font1);
style.setLocked(true);
cell.setCellStyle(style);
sheet.protectSheet("password");