读取resource的excel报错NotOfficeXmlFileException

1,580 阅读1分钟

接收一项目,读取springboot resource下面的xxx.xlsx文件解析。 用hutool工具

ExcelReader reader = ExcelUtil.getReader("base.xlsx");

结果报错: NotOfficeXmlFileException: No valid entries or contents found, this is not a valid OOXML (Office Open XML) file

查看pom文件

<resource>
    <directory>src/main/resources</directory>
    <filtering>true</filtering>
</resource>

发现是maven把文件压缩了 于是:

<resource>
    <directory>src/main/resources</directory>
    <filtering>false</filtering>
    <includes>
        <include>*.xlsx</include>
    </includes>
</resource>

搞定