Example #1
0
  @Override
  protected void getCorrespondances(List<ImportationSchemeModelDTO> schemeModelList)
      throws Throwable {
    for (ImportationSchemeModelDTO schemeModelDTO : schemeModelList) {
      // GetThe variable and the flexible element for the identification
      // key

      switch (scheme.getImportType()) {
        case ROW:
          Table sheetTable = null;
          if (scheme.getSheetName() != null && !scheme.getSheetName().isEmpty()) {
            sheetTable = doc.getTableByName(scheme.getSheetName());
          } else if (doc.getTableList().size() > 0) {
            sheetTable = doc.getTableList().get(0);
          }
          if (sheetTable != null) {
            int firstRow = 0;
            if (scheme.getFirstRow() != null) {
              firstRow = scheme.getFirstRow();
            }

            for (int i = firstRow; i < sheetTable.getRowCount(); i++) {
              getCorrespondancePerSheetOrLine(schemeModelDTO, i, scheme.getSheetName());
            }
          }
          break;
        case SEVERAL:
          for (Table sheet : doc.getTableList()) {
            getCorrespondancePerSheetOrLine(schemeModelDTO, null, sheet.getTableName());
          }
          break;
        case UNIQUE:
          getCorrespondancePerSheetOrLine(schemeModelDTO, null, null);
          break;
        default:
          break;
      }
    }
  }