java - apache poi - 找到条件后继续循环

Question

我有这段代码，现在我想做的是检查这个循环是否找到了 ABC01，然后它将继续循环寻找“2018”。我尝试像代码中那样进行检查和增量，但它不起作用。请帮助我。

public static void ReadFile() throws Exception {
    FileInputStream file = new FileInputStream(new File("C:xx"));
    XSSFWorkbook wb = new XSSFWorkbook(file);
    XSSFSheet sheet = wb.getSheetAt(0);

    for (Iterator<Row> iterator = sheet.rowIterator(); iterator.hasNext();) {
        XSSFRow row = (XSSFRow) iterator.next();
        for (int i = 0; i < row.getPhysicalNumberOfCells(); i++) {
            XSSFCell cell = row.getCell(i);
            DataFormatter formatter = new DataFormatter();
            String val = formatter.formatCellValue(cell);
            /* System.out.println(val); */

            if (val.equals("ABC01")) {
                i++;
            }
            if (val.equals("2018")) {
                System.out.print("XX");
            }

        }

    }
}

Answer 1

根据评论中的讨论，以下代码应该适合您

public static void ReadFile() throws Exception {
FileInputStream file = new FileInputStream(new File("C:xx"));
XSSFWorkbook wb = new XSSFWorkbook(file);
XSSFSheet sheet = wb.getSheetAt(0);
XSSFRow row = null;
XSSFCell cell = null;

DataFormatter formatter = new DataFormatter();
String val;

for (Iterator<Row> iterator = sheet.rowIterator(); iterator.hasNext();) {
    row = (XSSFRow) iterator.next();

    for (int i = 0; i < row.getPhysicalNumberOfCells(); i++) {
        cell = row.getCell(i);           
        val = formatter.formatCellValue(cell);
        /* System.out.println(val); */

        if (val.equals("ABC01")) {
            i++;

            cell = row.getCell(i);
            val = formatter.formatCellValue(cell);

            if (val.equals("2018")) {
                System.out.print("XX");
            }
        }


        }

    }
}