IO流实现excel 导入

最新推荐文章于 2021-11-05 15:28:39 发布

兜不兜先生

最新推荐文章于 2021-11-05 15:28:39 发布

阅读量607

点赞数

分类专栏： JAVA 文章标签： excel

本文链接：https://blog.csdn.net/qq_36609053/article/details/110647169

版权

JAVA 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

1.文件上传

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
<form action="/marketing/coupon-batch/import/DELAY" method="post" enctype="multipart/form-data">
    <input type="file" name="file" value="请选择文件">
    <input type="submit" value="上传">
</form>
</body>
</html>

在这里插入图片描述
java 运用

    @PostMapping("/coupon/import/{operateType}")
    public  R.Result batchImportCouponOperate(@RequestParam("file")MultipartFile file, @PathVariable String operateType){
        return couponOperationService.batchImportCouponOperate(  file, operateType );
    }

public String batchImportCouponOperate(MultipartFile uploadFile, String operateType) throws IOException {
        InputStream inputStream = uploadFile.getInputStream();
        String originalFilename = uploadFile.getOriginalFilename();
        try {
            Map<String, List<List<Object>>> params = ExcelUtils.importExcel(inputStream, originalFilename);
            List<List<Object>> datas = params.get("Sheet1");
            if (CollectionUtils.isNotEmpty(datas)) {
                for (List<Object> param : datas) {
                        //处理逻辑
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return  "ok";
    }