Springboot+thymeleaf实现excel文件上传+后台数据搜索

废话不多说，直接上代码

先说excel文件上传

用的是poi框架 先贴maven配置

<!--    poi导入excel文件-->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>4.0.1</version>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
            <version>4.0.1</version>
        </dependency>

前端表格+逻辑：

<form id="fileForm" action="/upload" method="POST" enctype="multipart/form-data">
    <input id="file" type="file" name="file" class="btn btn-outline-primary"/>
    <input id="btnSubmitFile" type="button" value="upload file to /upload"/>
</form>

JavaScript对应代码

<script type="text/javascript">

    $(function () {
   

        $("#btnSubmitFile").click(function () {
   
            var form = new FormData(document.getElementById("fileForm"));
            $.ajax({
   
                url: "/upload",
                type: "post",
                data: form,
                processData: false,
                contentType: false,
                success: function(data) {
   
                    $("#outputDiv").html(data);
                },
                error: function(e) {
   
                    console.log(e);
                }
            });
        });

    });

</script>

controller层

 /**
     * 上传excel保存在本地并加载
     * @param file
     * @return
     * @throws IOException
     * @throws InvalidFormatException
     */