Java org.apache.poi.ss.usermodel.Cell.getCellType()Lorg/apache/poi/ss/usermodel/CellType问题解决

本是古典何须时尚 2022-09-07 12:28 788阅读 0赞

### 问题描述： ###

org.springframework.web.util.NestedServletException: Handler dispatch failed;

nested exception is java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.getCellType()Lorg/apache/poi/ss/usermodel/CellType;

### 问题分析： ###

1、使用Hutool工具包的ExcelReader.read()方法报错，因为poi3.17版本的Cell.getCellType()返回int而不是org.apache.poi.ss.usermodel.CellType。

public List<List<Object>> readData(MultipartFile file) {
            List<List<Object>> resultList = new ArrayList<>();
            try {
                //读取数据
                ExcelReader reader = ExcelUtil.getReader(file.getInputStream());
                resultList = reader.read();
            } catch (Exception e) {
                e.printStackTrace();
            }
            return resultList;
        }

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70][]

解决办法：

加入Poi4.0.0依赖即可。

<dependency>
                <groupId>org.apache.poi</groupId>
                <artifactId>poi</artifactId>
                <version>4.0.0</version>
            </dependency>
            <dependency>
                <groupId>org.apache.poi</groupId>
                <artifactId>poi-ooxml</artifactId>
                <version>4.0.0</version>
            </dependency>
            <dependency>
                <groupId>org.apache.poi</groupId>
                <artifactId>poi-ooxml-schemas</artifactId>
                <version>4.0.0</version>
            </dependency>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTc0NjM4_size_16_color_FFFFFF_t_70]: /images/20220829/8ad5ec7b01184b24bd3d3d0ea5446651.png