使用io流打包excle为 zip
public static void main(String[] args) throws Exception{
InputStream inputStream = new FileInputStream("/Users/adminz/Desktop/codeDemo/li_0910/li_bishe_boot/src/main/resources/static/img/工作簿1.xlsx");
ByteArrayOutputStream baos = new ByteArrayOutputStream();
int len = 0;
byte[] buffer = new byte[1024];
while((len = inputStream.read(buffer))!= -1){
baos.write(buffer, 0, len);
}
byte[] bus = baos.toByteArray();
FileOutputStream fos= new FileOutputStream("/Users/adminz/Desktop/codeDemo/li_0910/li_bishe_boot/src/main/resources/static/files/test.zip");
ZipOutputStream zos = new ZipOutputStream(fos);
zos.putNextEntry(new ZipEntry("customer.xlsx"));
zos.write(bus);
zos.closeEntry();
inputStream.close();
baos.close();
zos.close();
fos.close();
}
下载文件
File file = new File(“文件地址”, fileName);
FileInputStream is = new FileInputStream(file);
response.reset();
response.setContentType("application/octet-stream");
response.setHeader("Content-Disposition", "attachment;filename=" + URLEncoder.encode(file_name.getName() ,"UTF-8"));
ServletOutputStream os = response.getOutputStream();
IOUtils.copy(is,os);
IOUtils.closeQuietly(is);
IOUtils.closeQuietly(os);