项目读取excel报错, poi版本从3.7升到4.1.2
使用高版本api
workbook = WorkbookFactory.create(inputStream);
出现无法读取的错误
Your stream was neither an OLE2 stream, nor an OOXML stream
思前想后 发现maven构建项目excel文件到target目录classes文件夹下会自动进行编译 导致poi读取文件流错误
添加排除指定文件的maven配置即可
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-resources-plugin</artifactId>
<configuration>
<encoding>UTF-8</encoding>
<nonFilteredFileExtensions>
<nonFilteredFileExtension>xlsx</nonFilteredFileExtension>
<nonFilteredFileExtension>xls</nonFilteredFileExtension>
<nonFilteredFileExtension>xml</nonFilteredFileExtension>
<nonFilteredFileExtension>zip</nonFilteredFileExtension>
<nonFilteredFileExtension>rar</nonFilteredFileExtension>
<nonFilteredFileExtension>properties</nonFilteredFileExtension>
</nonFilteredFileExtensions>
</configuration>
</plugin>
</plugins>
</build>