java下载 xlsx文件_如何在java中使用zip压缩和下载xlsx文件(How to compress and download a xlsx file using zip in java)...

如何在java中使用zip压缩和下载xlsx文件(How to compress and download a xlsx file using zip in java)

我正在使用poi创建一个xlsx并将其保存在fileSystem上。 我需要在servlet调用上下载文件，由于内存限制，我没有创建xssf工作簿对象，而是使用以下代码：

byte[] buf = new byte[1024];

ServletOutputStream sOut = response.getOutputStream();

FileInputStream input = null;

try {

long length = fileToRead.length();

input = new FileInputStream(fileToRead);

while ((input != null) && ((length = input.read(buf)) != -1)) {

sOut.write(buf, 0, (int) length);

}

其中fileToRead是文件系统中存在的文件。

I'm creating a xlsx using poi and saving it on fileSystem. I need to download the file on a servlet call and due to memory constraints I did not create a xssf workbook object and used the following code instead :

byte[] buf = new byte[1024];

ServletOutputStream sOut = response.getOutputStream();

FileInputStream input = null;

try {

long length = fileToRead.length();

input = new FileInputStream(fileToRead);

while ((input != null) && ((length = input.read(buf)) != -1)) {

sOut.write(buf, 0, (int) length);

}

Where fileToRead is the file present at the file system.

原文：https://stackoverflow.com/questions/22088745

2019-10-10 09:35

满意答案

你可以用

ZipOutputStream zos = new ZipOutputStream(response.getOutputStream());

....

ze = new Zi