2021-09-26表格导入的错误提示整理

先在导入逻辑里记录错误的行号格号 result的结构是<行号，格号List>
//更新优化，列数可匹配成excel的英文字符列

            StringBuffer sb = new StringBuffer();
            sb.append("表格(不含表头)");
            if (result.size() != 0) {
                String[] abc = {
                        "A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z",
                        "AA","AB","AC","AD","AE","AF","AG","AH","AI","AJ","AK","AL","AM","AN","AO","AP","AQ","AR","AS","AT","AU","AV","AW","AX","AY","AZ"};
                for (Integer rowNumber : result.keySet()) {
                   sb.append("第"+rowNumber );
                    sb.append("行");
                    for (Integer integer : result.get(rowNumber)) {
                        sb.append(abc[integer]);
                        sb.append("、");
                    }
                    sb.deleteCharAt(sb.length() - 1);
                    sb.append("列，");
                }
                sb.deleteCharAt(sb.length() - 1);
                sb.append("存在格式不正确的数据，请检查。");
                sb.append("\n");
            }
            if (sb.length() > 10) {
                map.put("msg", sb.toString());
            } else {
                map.put("msg", "导入成功");
            }

//之前的版本

         StringBuffer sb = new StringBuffer();
            if (result.size() != 0) {
                sb.append("表格第");
                for (Integer rowNumber : result.keySet()) {
                    sb.append(rowNumber );
                    sb.append("行第");
                    for (Integer integer : result.get(rowNumber)) {
                        if (integer==99){
                            sb.append(2);
                        }else {
                            sb.append(integer);
                        }
                        sb.append("、");
                    }
                    sb.deleteCharAt(sb.length() - 1);
                    sb.append("列，");
                }
                sb.deleteCharAt(sb.length() - 1);
                sb.append("存在格式不正确的数据，请检查。");
                sb.append("\n");
            }