java xml读取xlsx_java – 使用POIFSFileSystem读取xlsx文件

我需要取消保护受保护的xlsx file.e.g Book1.xlsx

下面的代码第一次运行正常,Reads Book1.xlsx,解密它并再次将其写入相同的文件名.

public static void unprotectXLSXSheet(String fileName, String password) {

try{

POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(fileName));

EncryptionInfo info = new EncryptionInfo(fs);

Decryptor d = Decryptor.getInstance(info);

d.verifyPassword(password);

InputStream is = d.getDataStream(fs);

System.out.println(is.available());

XSSFWorkbook wb = new XSSFWorkbook(OPCPackage.open(is));

FileOutputStream fileOut;

fileOut = new FileOutputStream(fileName);

wb.write(fileOut);

fileOut.flush();

fileOut.close();

}catch(FileNotFoundException ex){

ex.printStackTrace();

}catch(IOException ex){

ex.printStackTrace();

但是当相同的代码尝试访问新创建的不受保护的Book1.xlsx(或任何其他未受保护的xlsx文件)时,它会失败并显示

Exception in thread "main" org.apache.poi.poifs.filesystem.OfficeXmlFileException: The supplied data appears to be in the Office 2007+ XML. You are calling the part of POI that deals with OLE2 Office Documents. You need to call a different part of POI to process this data (eg XSSF instead of HSSF)

at org.apache.poi.poifs.storage.HeaderBlock.(HeaderBlock.java:131)

at org.apache.poi.poifs.storage.HeaderBlock.(HeaderBlock.java:104)

at org.apache.poi.poifs.filesystem.POIFSFileSystem.(POIFSFileSystem.java:138)

at com.wolseley.Excel.TestMainDummy.unprotectXLSXSheet(TestMainDummy.java:113)

at com.wolseley.Excel.TestMainDummy.main(TestMainDummy.java:52)

我需要帮助阅读xlsx文件,并使用密码解锁,如上所述.