excel

public static void encryptExcel_xlsx(String excelFilePath, String excelPassword) throws Exception {
    FileInputStream readFile = new FileInputStream(excelFilePath);
    XSSFWorkbook wb = new XSSFWorkbook(readFile);
    XSSFSheet st = wb.getSheetAt(0);
    //设置工作表保护密码
    st.protectSheet(excelPassword);
    FileOutputStream writeFile = new FileOutputStream(excelFilePath);
    wb.write(writeFile);
    writeFile.close();
}

public static void encryptExcel_xlsx(String excelFilePath, String excelPassword) throws Exception {
    POIFSFileSystem fs = new POIFSFileSystem();
    EncryptionInfo info = new EncryptionInfo(EncryptionMode.standard);
    Encryptor enc = info.getEncryptor();
    //设置密码
    enc.confirmPassword(excelPassword);
    //加密文件
    OPCPackage opc = OPCPackage.open(new File(excelFilePath), PackageAccess.READ_WRITE);
    OutputStream os = enc.getDataStream(fs);
    opc.save(os);
    opc.close();
    //把加密后的文件写回到流
    FileOutputStream fos = new FileOutputStream(excelFilePath);
    fs.writeFilesystem(fos);
    fos.close();
}`在这里插入代码片`