EasyExcel/Excel表格的文件上传和下载

最新推荐文章于 2023-04-14 16:19:40 发布

名字随便就好

最新推荐文章于 2023-04-14 16:19:40 发布

阅读量235

点赞数

分类专栏： Excel 文章标签： EasyExcel Excel上传数据库操作文件下载 MultipartFile

本文链接：https://blog.csdn.net/weixin_50016732/article/details/115132164

版权

Excel 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

标题：EasyExcel/Excel表格的文件上传和下载



    /**
     * 将表格上传，存入数据库
     * @param file## 标题
     * @throws IOException
     */
    @Override
    public void uploadMemberExcel(MultipartFile file) throws IOException {
    
        EasyExcel.read(file.getInputStream(), Member.class, new AnalysisEventListener<Member>() {
            @Override
            public void invoke(Member member, AnalysisContext analysisContext) {
                memberMapper.insertSelective(member);
            }

            @Override
            public void doAfterAllAnalysed(AnalysisContext analysisContext) {
                System.out.println("++++++++++解析完成++++++++++++");
            }
        }).sheet().doRead();

    }

    /**
     * 将数据库表格导出
     * @param response
     * @throws IOException
     */
    @Override
    public void downLoadMember(HttpServletResponse response) throws IOException {
        /*防止乱码*/
        response.setContentType("application/vnd.ms-excel");
        response.setCharacterEncoding("utf-8");

        String fileName = "member.xlsx";
        /*固定格式*/
        response.setHeader("Content-disposition","attachment;fileName="+fileName);

        EasyExcel.write(response.getOutputStream(),Member.class).sheet("member")
        .doWrite(memberMapper.selectMembers());

    }