java.io.IOException: Your InputStream was neither an OLE2 stream, nor an OOXML stream

流读取文件时可能报以下错误:

java.io.IOException: Your InputStream was neither an OLE2 stream, nor an OOXML stream
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:258)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:221)
at com.ruoyi.common.utils.poi.ExcelUtil.importExcel(ExcelUtil.java:186)
at com.ruoyi.common.utils.poi.ExcelUtil.importExcel(ExcelUtil.java:173)

此错误一般是文件上传时，用Workbook工厂或者实体类直接创建new HSSFWorkbook/XSSFWorkbook时出现。
解决方法很简单有两种：
1、在项目的pom.xml文件内新增或补足以下代码块

<plugin>
    <groupId>org.apache.maven.plugins</groupId>
    <artifactId>maven-resources-plugin</artifactId>
    <configuration>
        <encoding>UTF-8</encoding>
        <nonFilteredFileExtensions>
            <nonFilteredFileExtension>xlsx</nonFilteredFileExtension>
            <nonFilteredFileExtension>xls</nonFilteredFileExtension>
        </nonFilteredFileExtensions>
    </configuration>
</plugin>

2、用更简单的cn.hutool.poi.excel.ExcelReader类，样例如下:

import cn.hutool.poi.excel.ExcelReader;
import org.springframework.web.multipart.MultipartFile;

	try (
	        InputStream inputStream = file.getInputStream()
	) {
	    ExcelReader reader = ExcelUtil.getReader(inputStream).setIgnoreEmptyRow(true);
	    List<Sheet> sheets = reader.getSheets();
	    Sheet sheet = sheets.get(0);//根据sheet的下标取值
	} catch (IOException e) {
	
	}