/**
* encryptionExcel 加密excel
* @param imgPath
* @param filePath
*/
public static boolean encryptionExcel(String sourceFilePath, String destPath) {
try {
FileInputStream fis = new FileInputStream(new File(sourceFilePath)); // 这里换成你本地的excel相对路径或绝对路径
String excelhz = sourceFilePath.substring(
sourceFilePath.lastIndexOf("."), sourceFilePath.length());
String encryptionPwd = PlatformConfigUtil.getString("encryptionPwd");
FileOutputStream fos = new FileOutputStream(new File(destPath));// 这里换成你本地的excel相对路径或绝对路径
if(excelhz.endsWith(".xls")){
HSSFWorkbook workbook = new HSSFWorkbook(fis);
int sheetNumbers = workbook.getNumberOfSheets();
for (int i = 0; i < sheetNumbers; i++) {
HSSFSheet sheet = workbook.getSheetAt(i);
sheet.protectSheet(encryptionPwd);
}
workbook.write(fos);
fis.close();
fos.close();
}else if(excelhz.endsWith(".xlsx")){
XSSFWorkbook workbook = new XSSFWorkbook(sourceFilePath);
int sheetNumbers = workbook.getNumberOfSheets();
for (int i = 0; i < sheetNumbers; i++) {
XSSFSheet sheet = (XSSFSheet) workbook.getSheetAt(i);
sheet.protectSheet(encryptionPwd);
}
workbook.write(fos);
fis.close();
fos.close();
}
} catch (Exception e) {
}
return true;
}
poi对excel文件进行加密不可编辑处理
最新推荐文章于 2024-06-04 16:18:30 发布