POI导出

最新推荐文章于 2024-12-03 14:20:06 发布

原创最新推荐文章于 2024-12-03 14:20:06 发布 · 262 阅读

CC 4.0 BY-SA版权

try {
            String filename = "tourist-"+ DateUtils.formatDate(new Date(), com.gzl.product.base.utils.DateUtils.FORMAT_PATTERN_YYYYMMDD);
            OutputStream outputStream = response.getOutputStream();
            response.setCharacterEncoding("utf-8");
            response.setContentType("application/vnd.ms-excel");
            response.setHeader("Content-disposition",
                    "attachment;filename="+new String(filename.getBytes("utf-8"),"ISO-8859-1")+".xls");
            workbook.write(outputStream);
            outputStream.flush();
            outputStream.close();

        } catch (IOException e) {
            log.error("写出游客列表excel文件出现异常",e);
        } finally {
            try {
                response.getOutputStream().close();
            } catch (IOException e) {
                log.error("关闭写出文件流出现异常",e);
            }
        }