Excel文件上传解析

1.一直以来都想写一下关于excel 文件上传解析下载的文章,盆友推荐给我一个非常好用的hutool 工具类
这个是官网地址:https://www.hutool.cn/docs/#/

2.引入相关pom

<!-- Hutool超级工具类 http://hutool.mydoc.io/ -->
<dependency>
    <groupId>cn.hutool</groupId>
    <artifactId>hutool-all</artifactId>
    <version>4.0.9</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>3.17</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml-schemas -->
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml-schemas</artifactId>
    <version>3.17</version>
</dependency>

3.如果你和我一样,解析excel文件.那么hutool 一行代码就能帮你解决

ExcelReader reader = ExcelUtil.getReader("F:\\test.xls");