j2se导出多个excel 并压缩输出

最新推荐文章于 2023-06-25 12:30:10 发布

sdqdscy1994

最新推荐文章于 2023-06-25 12:30:10 发布

阅读量248

点赞数

分类专栏： java技术

本文链接：https://blog.csdn.net/scqdscy1994/article/details/53740593

版权

java技术专栏收录该内容

2 篇文章 0 订阅

订阅专栏

导出多个excel表从压缩输出

这里的ZipOutputStream导入的是apache的jar包

public static void downloadZip(String[] caption,List<HSSFWorkbook> workbooks,HttpServletResponse response) throws Exception{
		response.reset();
		response.setHeader("Content-Disposition", "attachment;filename="+new String(("资源数据.zip").getBytes("UTF-8"),"iso-8859-1"));
		response.setContentType("application/octet-stream;charset=UTF-8");
		OutputStream  out=null;
		ZipOutputStream zip = null;
		try{
			
			out=response.getOutputStream();
			zip = new ZipOutputStream(out);
			
			
			for (int i=0; i<workbooks.size(); i++) {
				ZipEntry entry = new ZipEntry(caption[i]+".xls");
				zip.putNextEntry(entry);
				workbooks.get(i).write(zip);
			}
			zip.setEncoding("gbk");
			zip.flush();
			zip.close();
			out.close();
		}catch(Exception e){
			e.printStackTrace();
			if(zip!=null)zip.close();
			if(out!=null)out.close();
		}
	}