コード例 #1
0
  /**
   * Process a (Item) section.
   *
   * <p>Each section has a heading row that is used to identify what field each cell relates to in
   * the domain object.
   *
   * @param section
   * @return
   */
  protected boolean processSectionData(SpreadsheetSection section) {
    List<SpreadsheetRow> rows = section.getSectionRows();
    currentSheetName = section.getSheetName();

    if (section.getSectionHeadingString().startsWith(PAGE_ITEMS_UPPER)) {
      currentPage = new ExtractItems(application, currentPage).processSectionData(section);
      if (currentPage == null) {
        logger.debug("Warning: no current page returned for section. " + section.toString());
        return true;
      }
      return true;
    }

    for (Iterator<SpreadsheetRow> rowIter = rows.iterator(); rowIter.hasNext(); ) {
      SpreadsheetRow spreadsheetRow = (SpreadsheetRow) rowIter.next();
      if (spreadsheetRow.getRowItems().size() == 0) {
        continue;
      }
      if (section.getSectionHeadingString().startsWith(InformerSpreadsheetLoader.SHEET_END)) {
        // ignore the rest of the rows, although should never have got here
        logger.debug("Did not expect to be processing a Sheet End section - ignoring!");
        break;
      }
    }

    return true;
  }
コード例 #2
0
  /**
   * Identify the Page related sections (Item) that we want to process, and initiate that.
   *
   * @return true if all sections processed OK
   */
  public boolean processPages() {
    for (Iterator<SpreadsheetSection> iterator = data.iterator(); iterator.hasNext(); ) {
      SpreadsheetSection section = (SpreadsheetSection) iterator.next();
      if (section.isProcessed()) {
        continue;
      }

      if (!processSectionData(section)) {
        logger.debug(
            "Failed to process section "
                + section.getSectionHeadingString()
                + " for sheet "
                + section.getSheetName());
        return false;
      }
    }

    return true;
  }