如何用Java密码保护压缩的Excel文件？

I have a question about password protecting an Excel file.

我有一个关于密码保护Excel文件的问题。

The situation is that, I have a zip file, that has an Excel file in it. I need to write a Java program, to password protect the Excel file. Hence, the user should be able to unzip the file (the zip file need not be password protected). But, the Excel needs to be password-protected. When the user tries to unzip the file, he should be able to do so. And when he tries to open the Excel file (which is inside the unzipped folder), it must ask for a password. The question is similar to Protect excel file with java, with the added complexity that, the Excel file is zipped.

情况是，我有一个zip文件，里面有一个Excel文件。我需要编写一个Java程序，以密码保护Excel文件。因此，用户应该能够解压缩文件（zip文件不需要密码保护）。但是，Excel需要受密码保护。当用户尝试解压缩文件时，他应该能够这样做。当他试图打开Excel文件（在解压缩文件夹中）时，它必须要求输入密码。问题类似于使用java保护excel文件，增加的复杂性是Excel文件是压缩的。

I have code, that password protects only the zip file, but this is not what I want.

我有代码，密码只保护zip文件，但这不是我想要的。

import java.io.File;
import java.util.ArrayList;
import net.lingala.zip4j.core.ZipFile;
import net.lingala.zip4j.exception.ZipException;
import net.lingala.zip4j.model.ZipParameters;
import net.lingala.zip4j.util.Zip4jConstants;

/**
* Demonstrates adding files to zip file with standard Zip Encryption
*/

public class AddFilesWithStandardZipEncryption
{
    public AddFilesWithStandardZipEncryption()
    {
    try {
            // Initiate ZipFile object with the path/name of the zip file.
            //ZipFile zipFile = new ZipFile("c:\\ZipTest\\AddFilesWithStandardZipEncryption.zip");
            ZipFile zipFile = new ZipFile("C:\\homepage\\workspace\\PasswordProtectedFiles\\new.zip");

            // Build the list of files to be added in the array list
            // Objects of type File have to be added to the ArrayList
            ArrayList filesToAdd = new ArrayList();
            //filesToAdd.add(new File("C:\\homepage\\workspace\\passwordprotectedzipfile\\profile\\profile.txt"));
            filesToAdd.add(new File("C:\\homepage\\workspace\\PasswordProtectedFiles\\new.xlsx"));
            //filesToAdd.add(new File("c:\\ZipTest\\myvideo.avi"));
            //filesToAdd.add(new File("c:\\ZipTest\\mysong.mp3"));

            // Initiate Zip Parameters which define various properties such
            // as compression method, etc.
            ZipParameters parameters = new ZipParameters();
            parameters.setCompressionMethod(Zip4jConstants.COMP_DEFLATE); // set compression method to store compression

            // Set the compression level
            parameters.setCompressionLevel(Zip4jConstants.DEFLATE_LEVEL_NORMAL); 

            // Set the encryption flag to true
            // If this is set to false, then the rest of encryption properties are ignored
            parameters.setEncryptFiles(true);

            // Set the encryption method to Standard Zip Encryption
            parameters.setEncryptionMethod(Zip4jConstants.ENC_METHOD_STANDARD);

            // Set password
            parameters.setPassword("test123!");

            // Now add files to the zip file
            // Note: To add a single file, the method addFile can be used
            // Note: If the zip file already exists and if this zip file is a split file
            // then this method throws an exception as Zip Format Specification does not 
            // allow updating split zip files
            zipFile.addFiles(filesToAdd, parameters);
        }
        catch (ZipException e)
        {
            e.printStackTrace();
        }
    }

    public static void main(String[] args)
    {
        new AddFilesWithStandardZipEncryption();
    }
}

3 个解决方案

#1

Without uncompressing, Its impossible to password protect excel which is inside a zip file.

如果没有解压缩，就无法密码保护zip文件中的excel。

Here is what you can do

这是你可以做的

Unzip the content using tips in What is the best way to extract a zip file using java and Compressing and Decompressing Data Using Java APIs
使用提示解压缩内容使用Java提取zip文件的最佳方法是什么？使用Java API压缩和解压缩数据
Password protect extracted excel file using tips in Password Protected Excel File
密码保护使用密码保护的Excel文件中的提示保护提取的Excel文件
Zip the password protected excel file using tips in Java Compress Large File
使用Java Compress Large File中的提示压缩受密码保护的excel文件

#2

Use java.util.zip or zip4j to decompress file to some temp direcotry or to memory, if you know it's small.
如果你知道它很小，可以使用java.util.zip或zip4j将文件解压缩到某个临时目录或内存。
Then use HSSFWorkbook.writeProtectWorkbook from Apache POI library
然后使用Apache POI库中的HSSFWorkbook.writeProtectWorkbook
Compress Excel workbook again.
再次压缩Excel工作簿。

#3

I think you should check out truezip (Truezip website). It provides read/write access to ZIP, JAR, EAR, WAR etc and supports appending to existing ZIP files.

我想你应该看看truezip（Truezip网站）。它提供对ZIP，JAR，EAR，WAR等的读/写访问，并支持附加到现有ZIP文件。

I suggest you create your zip file without the excel file in it, create your passworded excel file as directed in the link you provided and then use truezip to write this excel file to the archive. Hope this helps

我建议您创建不带excel文件的zip文件，按照您提供的链接创建passworded excel文件，然后使用truezip将此excel文件写入存档。希望这可以帮助

#1