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");