报表导出

爱吃黄牛肉的牛哥

于 2020-11-01 22:58:03 发布

阅读量111

点赞数

分类专栏：工具

本文链接：https://blog.csdn.net/lnn112233/article/details/109440351

版权

工具专栏收录该内容

18 篇文章 0 订阅

订阅专栏

@GetMapping("/export")
    public void toList(HttpServletResponse response) throws UnsupportedEncodingException {
        List<Goods> list = new ArrayList<Goods>();
        for (int i = 0; i < 50; i++) {
            Goods g = new Goods();
            g.setId(Long.parseLong((1 + i) + ""));
            g.setGoodsDetail("aaaa" + i);
            g.setGoodsImg("http///" + i);
            g.setGoodsName("商品" + i);
            g.setGoodsStock(i);
            list.add(g);
        }
        // List导出报表
        ExcelWriter writer = ExcelUtil.getWriter();
        writer.addHeaderAlias("id", "id");
        writer.addHeaderAlias("goodsImg", "图片");
        writer.addHeaderAlias("goodsName", "商品名");

        writer.merge(5, "商品表");
        writer.write(list, true);
        response.setContentType("application/vnd.ms-excel;charset=utf-8");

        String name = "test";
        // 此处需要转码为utf-8
        response.setHeader("Content-Disposition", "attachment;filename=" + name + ".xls");
        ServletOutputStream out = null;
        try {
            out = response.getOutputStream();
            writer.flush(out, true);
        } catch (
                IOException e) {
            e.printStackTrace();
        } finally {
            writer.close();
        }
        IoUtil.close(out);
    }