java excel导入校验_java Excel导入过程中的校验 不合格数据描述详细返回到前台就行提示...

public Result importGoodsInfoExcel(

@RequestParam(value = "file", required = true) MultipartFile file) throws Exception {

List result = this.fileToObject(provinceCode, cityCode, file, createBy, createByName);

// 返回错误信息

if (result.get(0) instanceof ExcelErrorInfo) {

StringBuilder sb = new StringBuilder();

ExcelErrorInfo exceerror1 = new ExcelErrorInfo();

for (Object exceerror : result) {

exceerror1 = (ExcelErrorInfo) exceerror;

if (exceerror1.getColumn().equals("文件格式不正确,请导入excel文件")) {

exceerror1.setMsg("文件格式不正确,请导入excel文件");

sgecResult.setDatas(exceerror1);

return super.outJsonStringFail(sgecResult);

} else {

//                    sb.append("sheet名为").append(exceerror1.getSheetNo()).append("的")

//                            .append(sb.append("第").append(exceerror1.getRow()).append("行"))

//                            .append(exceerror1.getColumn()).append(exceerror1.getError()).append("；");

sb.append("sheet名为").append(exceerror1.getSheetNo()).append("的").

append("第").appe