alibaba/easyexcel

获取单元格的类型不准确

Open

#4087 opened on Feb 14, 2025

View on GitHub
 (0 comments) (0 reactions) (0 assignees)Java (33,728 stars) (7,599 forks)batch import
help wanted

Description

获取单元格的类型不准确

现在将表格的某一列单元格类型设置为了文本,这一列的数据都是 102这种数字,执行下面的代码: ''' public static class ArrayDataListener extends AnalysisEventListener<Map<Integer, String>> {

    @Override
    public void invokeHead(Map<Integer, ReadCellData<?>> headMap, AnalysisContext context) {
        log.info("解析到一条头数据:{}", JSON.toJSONString(headMap));
        for (Integer key : headMap.keySet()) {
            ReadCellData cellData = headMap.get(key);
            System.out.println(cellData.getStringValue() + ":" + cellData.getType().name());
        }
    }


    @Override
    public void invoke(Map<Integer, String> dataMap, AnalysisContext analysisContext) {
        return;
    }

    @Override
    public void doAfterAllAnalysed(AnalysisContext analysisContext) {
    }
}

''' 输出接口是STRING

请问easyexcel对于单元格的类型是根据数据内容来推断的吗?

Contributor guide