读取execl中配置的规则进行json的拼接

1.execl中的规则

2.功能代码
2.1 拼接需要用到的参数
package com.beagledata.gaea.workbench.entity;

/**

• Created by mahongfei on 2019/6/10.
  */
  public class ScoreCard {
  private String fact;
  private String weight;
  private String scoringType;
  private String assignObject;
  private String field;
  private String constraints;
  private String score;
  private String salience;

  public String getFact() {
  return fact;
  }

  public void setFact(String fact) {
  this.fact = fact;
  }

  public String getWeight() {
  return weight;
  }

  public void setWeight(String weight) {
  this.weight = weight;
  }

  public String getScoringType() {
  return scoringType;
  }

  public void setScoringType(String scoringType) {
  this.scoringType = scoringType;
  }

  public String getAssignObject() {
  return assignObject;
  }

  public void setAssignObject(String assignObject) {
  this.assignObject = assignObject;
  }

  public String getField() {
  return field;
  }

  public void setField(String field) {
  this.field = field;
  }

  public String getConstraints() {
  return constraints;
  }

  public void setConstraints(String constraints) {
  this.constraints = constraints;
  }

  public String getScore() {
  return score;
  }

  public void setScore(String score) {
  this.score = score;
  }

  public String getSalience() {
  return salience;
  }

  public void setSalience(String salience) {
  this.salience = salience;
  }

  @Override
  public String toString() {
  return “ScoreCard{” +
  “fact=’” + fact + ‘’’ +
  “, weight=’” + weight + ‘’’ +
  “, scoringType=’” + scoringType + ‘’’ +
  “, assignObject=’” + assignObject + ‘’’ +
  “, field=’” + field + ‘’’ +
  “, constraints=’” + constraints + ‘’’ +
  “, score=’” + score + ‘’’ +
  “, salience=’” + salience + ‘’’ +
  ‘}’;
  }
  }

2.2 读取execl中的规则进行json拼接
package com.beagledata.gaea.workbench.service.impl;

import com.beagledata.gaea.workbench.entity.Assets;
import com.beagledata.gaea.workbench.entity.ScoreCard;
import com.beagledata.gaea.workbench.mapper.AssetsMapper;
import com.beagledata.gaea.workbench.rule.define.Fact;
import com.beagledata.gaea.workbench.rule.define.Field;
import com.beagledata.gaea.workbench.rule.util.BomUtils;
import com.beagledata.gaea.workbench.service.ScoreCardService;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.util.CellRangeAddress;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.web.multipart.MultipartFile;

import java.io.InputStream;
import java.util.*;

/**

• Created by mahongfei on 2019/6/11.
  */
  @Service
  public class ScoreCardServiceImpl implements ScoreCardService {
  @Autowired
  private AssetsMapper assetsMapper;

  @Override
  public String importScoreCardExecl(String name, String projectUuid, int version, MultipartFile file) {
  Map<String, ScoreCard> map = new LinkedHashMap<>();

   try {
       map = importExcel(file.getInputStream(), file.getOriginalFilename());
   } catch (Exception e) {
       e.printStackTrace();
   }
  
   StringBuilder sb = new StringBuilder();
   sb.append("{");
   sb.append("\"name\":\"");
   sb.append(name);
   String factUuid = null;
   String weight = null;
  
   for (String key : map.k