easyexcel导出多个excel生成压缩包

好的，您可以使用Java中的ZipOutputStream类来实现压缩多个Excel文件。以下是一个简单的示例代码：

import com.alibaba.excel.ExcelWriter;
import com.alibaba.excel.metadata.Sheet;
import com.alibaba.excel.metadata.Table;
import com.alibaba.excel.support.ExcelTypeEnum;
import org.apache.commons.compress.archivers.zip.ZipArchiveEntry;
import org.apache.commons.compress.archivers.zip.ZipArchiveOutputStream;

import java.io.*;
import java.util.ArrayList;
import java.util.List;

public class ExportExcel {

    public static void main(String[] args) throws IOException {
        // 创建多个Excel文件
        List<File> fileList = createExcelFiles();

        // 创建压缩包文件
        File zipFile = new File("excel_files.zip");
        ZipArchiveOutputStream zipOutputStream = new ZipArchiveOutputStream(zipFile);
        zipOutputStream.setMethod(ZipArchiveOutputStream.DEFLATED);

        // 将多个Excel文件压缩到压缩包中
        for (File file : fileList) {
            ZipArchiveEntry entry = new ZipArchiveEntry(file.getName());
            entry.setSize(file.length());
            zipOutputStream.putArchiveEntry(entry);
            FileInputStream fis = new FileInputStream(file);
            byte[] buffer = new byte[1024];
            int len;
            while ((len = fis.read(buffer)) > 0) {
                zipOutputStream.write(buffer, 0, len);
            }
            fis.close();
            zipOutputStream.closeArchiveEntry();
        }

        // 关闭ZipOutputStream流
        zipOutputStream.finish();
        zipOutputStream.close();

        // 删除临时Excel文件
        for (File file : fileList) {
            file.delete();
        }
    }

    private static List<File> createExcelFiles() throws FileNotFoundException {
        List<File> fileList = new ArrayList<>();
        for (int i = 1; i <= 3; i++) {
            // 创建Excel文件
            File file = new File("excel_" + i + ".xlsx");
            OutputStream out = new FileOutputStream(file);

            // EasyExcel导出数据
            ExcelWriter writer = new ExcelWriter(out, ExcelTypeEnum.XLSX);
            Sheet sheet = new Sheet(1, 0);
            sheet.setSheetName("Sheet1");
            Table table = new Table(1);
            List<List<String>> data = new ArrayList<>();
            for (int j = 1; j <= 10; j++) {
                List<String> row = new ArrayList<>();
                row.add("Data" + j);
                data.add(row);
            }
            table.setData(data);
            writer.write0(table, sheet);
            writer.finish();

            // 添加Excel文件到列表中
            fileList.add(file);
        }
        return fileList;
    }
}

在上面的代码中，我们首先创建了3个Excel文件，然后将它们压缩到一个名为“excel\_files.zip”的压缩包中。最后，我们删除了临时的Excel文件。注意，我们使用了Apache Commons Compress库来实现压缩操作。