InputStream in = null;
OutputStream out = null;
SXSSFWorkbook wb = result.getData();
try {
Date today = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
//文件名
String fileName = "数据导出.xlsx";
ByteArrayOutputStream os = new ByteArrayOutputStream();
//wb文件流只能输出一次
wb.write(os);
byte[] byteArray = os.toByteArray();
//将输出流写入
in = new ByteArrayInputStream(byteArray);
response.addHeader("Content-Length", String.valueOf(in.available()) + "");
response.setHeader("Cache-Control", "no-cache");
response.setHeader("Cache-Control", "no-store");
response.setHeader("Pragma", "no-cache");
response.setDateHeader("Expires", 0);
response.setContentType("application/octet-stream");// 设置强制下载不打开
//设为"UTF-8"IE乱码,谷歌正常,设为"gb2312"
POI SXSSFWorkbook 导出文件同时获取文件长度
最新推荐文章于 2023-09-08 16:50:56 发布