springBoot + easyPoi 导出表格字段大小写问题

一、问题说明

        easypoi 导出数据，如果对象中的含有大写开头的变量，导出会报错，比如如下写法，导出时会报错 该字段在对象中找不到。

@ApiModelProperty("影像时间")
@Excel(name = "影像时间")
@JsonProperty("TePosition")
private String TePosition;

二、解决方案

        使用map 导出，将所有的key值统一转成小写或者大写

public static  Map beanToMapLo(T bean) {
        Map map = Maps.newHashMap();
        if (bean != null) {
            BeanMap beanMap = BeanMap.create(bean);
            for (Object key : beanMap.keySet()) {
                map.put(key.toString().toLowerCase() + "", beanMap.get(key));
            }
        }
        return map;
    }

List beanList = new ArrayList();
        List SysArchivesPieceList = sysArchivesPieceDao.findSysArchivesPieceAllList(sysArchivesPiece);
        ExportParams exportParams = new ExportParams("档案案片信息导出","档案案片信息列表");
        List> list = new ArrayList>();
        SysArchivesPieceList.stream().forEach(e->{
            list.add(beanToMapLo(e));
        });
        exportParams.setStyle(ExcelStyleUtil.class);
        SysArchivesItem sysArchivesItem = sysArchivesItemDao.findSysArchivesItemById(sysArchivesPiece.getArchivesItemId());
        SysArchivesPieceConfig sysArchivesPieceConfig = new SysArchivesPieceConfig();
        sysArchivesPieceConfig.setCatalogId(sysArchivesItem.getArchivesCatalogId());
        sysArchivesPieceConfig.setShowStatus("0");
        List sysArchivesPieceConfigList = sysArchivesPieceConfigDao.findSysArchivesPieceConfigAllList(sysArchivesPieceConfig);
        sysArchivesPieceConfigList.stream().forEach(e->{
            if(StringUtils.isNotEmpty(e.getNewName())){
                beanList.add(new ExcelExportEntity(e.getNewName(), e.getOldColumnName().toLowerCase()));
            }else{
                beanList.add(new ExcelExportEntity(e.getOldName(), e.getOldColumnName().toLowerCase()));
            }
        });
        return ExcelExportUtil.exportExcel(exportParams, beanList, list);

new ExcelExportEntity 中的key 也是需要转成小写，这样才能匹配。