Ejemplo n.º 1
0
  /**
   * 生成标准字段评审文档
   *
   * @param wb excel工作页
   * @param stdList 模型对象数组
   */
  public void standardFieldWriter(HSSFWorkbook wb, List<PDMStandardField> stdList) {
    HSSFSheet sheet = wb.getSheet(STD_SHEET);
    for (int i = 0; i < stdList.size(); i++) {
      HSSFRow row = sheet.createRow(i + 2);
      PDMStandardField std = stdList.get(i);
      // 1
      HSSFCell cell = row.createCell(1);
      cell.setCellValue(std.getOldName());
      cell.setCellStyle(getTextStyle(wb));
      // 2
      cell = row.createCell(2);
      cell.setCellValue(std.getOldChineseName());
      cell.setCellStyle(getTextStyle(wb));

      // 3
      cell = row.createCell(3);
      cell.setCellValue(std.getOldBusType());
      cell.setCellStyle(getTextStyle(wb));
      // 4
      cell = row.createCell(4);
      String tables = "";
      for (int j = 0; j < std.getBelongTableList().size(); j++) {
        if (j != 0) {
          tables = tables + ",";
        }
        tables = tables + std.getBelongTableList().get(j);
      }
      cell.setCellValue(tables);
      cell.setCellStyle(getTextStyle(wb));
      // 5
      cell = row.createCell(5);
      String bolongSubSystem = "";
      if (std.getBolongSubSystemList().size() > 0) {
        bolongSubSystem = std.getBolongSubSystemList().get(0);
      }
      cell.setCellValue(bolongSubSystem);
      cell.setCellStyle(getTextStyle(wb));
      // 6
      cell = row.createCell(6);
      cell.setCellValue(std.getGenName());
      cell.setCellStyle(getTextStyle(wb));
      // 7
      cell = row.createCell(7);
      cell.setCellValue(std.getNewName());
      cell.setCellStyle(getTextStyle(wb));
      // 8
      cell = row.createCell(8);
      cell.setCellValue(std.getNewChineseName());
      cell.setCellStyle(getTextStyle(wb));
      // 9
      cell = row.createCell(9);
      cell.setCellValue(std.getGenBusType());
      cell.setCellStyle(getTextStyle(wb));
      // 10
      cell = row.createCell(10);
      cell.setCellValue(std.getNewBusType());
      cell.setCellStyle(getTextStyle(wb));
      // 11
      cell = row.createCell(11);
      cell.setCellValue(std.getOldComment());
      cell.setCellStyle(getTextStyle(wb));
      // 12
      cell = row.createCell(12);
      cell.setCellValue(std.getNewComment());
      cell.setCellStyle(getTextStyle(wb));
      // 13
      cell = row.createCell(13);
      cell.setCellValue(std.getDictId());
      cell.setCellStyle(getTextStyle(wb));
      // 14
      cell = row.createCell(14);
      cell.setCellValue(std.getModefyDesc());
      cell.setCellStyle(getTextStyle(wb));
      // 15
      cell = row.createCell(15);
      cell.setCellValue(std.getImportPath());
      cell.setCellStyle(getTextStyle(wb));
    }
  }
Ejemplo n.º 2
0
  /**
   * 标准字段列表读取
   *
   * @param is 需要读取的文件流
   */
  public List<PDMStandardField> standardFieldReader(HSSFWorkbook wb) {
    List<PDMStandardField> stdList = new ArrayList<PDMStandardField>();
    HSSFSheet sheet = wb.getSheet(STD_SHEET);
    if (sheet == null) {
      return stdList;
    }
    HSSFFormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator();
    for (int i = 2; i <= sheet.getLastRowNum(); i++) {
      HSSFRow row = sheet.getRow(i);
      PDMStandardField std = new PDMStandardField();
      stdList.add(std);
      // 1
      HSSFCell cell = row.getCell(1);
      std.setOldName(POIUtils.getCellStringValue(cell, evaluator));
      // 2
      cell = row.getCell(2);
      std.setOldChineseName(POIUtils.getCellStringValue(cell, evaluator));

      // 3
      cell = row.getCell(3);
      std.setOldBusType(POIUtils.getCellStringValue(cell, evaluator));
      // 4
      cell = row.getCell(4);
      String[] tableNameArray =
          StringUtils.split(
              StringUtils.defaultIfBlank(POIUtils.getCellStringValue(cell, evaluator), ""), ",,");
      for (String tableName : tableNameArray) {
        std.getBelongTableList().add(tableName);
      }
      // 5
      cell = row.getCell(5);
      std.getBolongSubSystemList().add((POIUtils.getCellStringValue(cell, evaluator)));
      // 6
      cell = row.getCell(6);
      std.setGenName(POIUtils.getCellStringValue(cell, evaluator));
      // 7
      cell = row.getCell(7);
      std.setNewName(POIUtils.getCellStringValue(cell, evaluator));
      // 8
      cell = row.getCell(8);
      std.setNewChineseName(POIUtils.getCellStringValue(cell, evaluator));
      // 9
      cell = row.getCell(9);
      std.setGenBusType(POIUtils.getCellStringValue(cell, evaluator));
      // 10
      cell = row.getCell(10);
      std.setNewBusType(POIUtils.getCellStringValue(cell, evaluator));
      // 11
      cell = row.getCell(11);
      std.setOldComment(POIUtils.getCellStringValue(cell, evaluator));
      // 12
      cell = row.getCell(12);
      std.setNewComment(POIUtils.getCellStringValue(cell, evaluator));
      // 13
      cell = row.getCell(13);
      std.setDictId(POIUtils.getCellStringValue(cell, evaluator));
      // 14
      cell = row.getCell(14);
      std.setModefyDesc(POIUtils.getCellStringValue(cell, evaluator));
      // 15
      cell = row.getCell(15);
      std.setImportPath(POIUtils.getCellStringValue(cell, evaluator));
    }
    return stdList;
  }