poi 启用保护后取消_我们如何使用POI API读取受保护的密码excel文件(.xls)

这是读取Excel文件的代码，检查.xls和.xlsx(密码受保护或没有密码保护)作为完整的示例代码。

private Workbook createWorkbookByCheckExtension() throws IOException, InvalidFormatException {

Workbook workbook = null;

String filePath = "C:\\temp\\TestProtectedFile.xls";

String fileName = "TestProtectedFile.xls";

String fileExtensionName = fileName.substring(fileName.indexOf("."));

if (fileExtensionName.equals(".xls")) {

try {

FileInputStream fileInputStream = new FileInputStream(new File(filePath));

workbook = new HSSFWorkbook(fileInputStream);

} catch (EncryptedDocumentException e) {

// Checking of .xls file with password protected.

FileInputStream fileInputStream = new FileInputStream(new File(filePath));

Biff8EncryptionKey.setCurrentUserPassword("password");

workb