java编写限制密码,我如何使用POI API来访问受密码保护的Excel工作簿中的Java

I want to read from and write to password protected Excel files. How can I do so using Apache POI API.

解决方案

POI should be able to open both protected xls files (using org.apache.poi.hssf.record.crypt) and protected xlsx files (using org.apache.poi.poifs.crypt). Have you tried these?

If you're using HSSF (for a xls file), you need to set the password before opening the file. You do this with a call to:

org.apache.poi.hssf.record.crypto.Biff8EncryptionKey.setCurrentUserPassword(password);

After that, HSSF should be able to open your file.

For XSSF, you want something like:

POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream("protect.xlsx"));

EncryptionInfo info = new EncryptionInfo(fs);

Decryptor d = new Decryptor(info);

d.verifyPassword(Decryptor.DEFAULT_PASSWORD);

XSSFWorkbook wb = new XSSFWorkbook(d.getDataStream(fs));

.

Alternately, in newer versions of Apache POI, WorkbookFactory supports supplying the password when opening, so you can just do something like:

Workbook wb = WorkbookFactory.create(new File("protected.xls"), "password"));

That will work for both HSSF and XSSF, picking the right one based on the format, and passing in the given password in the appropriate way for the format.