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