public class ReadExcelFile {

    public static void main(String[] args) throws IOException {
        // Create a FileInputStream object for the Excel file
        FileInputStream fis = new FileInputStream(new File("MyExcelFile.xls"));

        // Create a Workbook object from the FileInputStream object
        HSSFWorkbook workbook = new HSSFWorkbook(fis);

        // Get the first sheet from the workbook
        Sheet sheet = workbook.getSheetAt(0);

        // Get the iterator for the rows in the sheet
        Iterator<Row> rowIterator = sheet.iterator();

        // Iterate over the rows
        while (rowIterator.hasNext()) {
            // Get the current row
            Row row = rowIterator.next();

            // Get the first cell in the row
            Cell cell = row.getCell(0);

            // Get the value of the cell
            String value = cell.getStringCellValue();

            // If the value is "Yes", then print the values of all the cells in the row
            if (value.equals("Yes")) {
                for (int i = 1; i < row.getLastCellNum(); i++) {
                    Cell cell2 = row.getCell(i);
                    System.out.print(cell2.getStringCellValue() + " ");
                }
                System.out.println();
            }
        }

        // Close the workbook
        workbook.close();
    }

}

此代码将读取Excel文件“MyExcelFile。xls”并打印第一个单元格包含值“Yes”的所有行的值。
下面是代码的解释：

The first line creates a FileInputStream object for the Excel file.
The second line creates a Workbook object from the FileInputStream object.
The third line gets the first sheet from the workbook.
The fourth line gets the iterator for the rows in the sheet.
The fifth line iterates over the rows.
The sixth line gets the first cell in the row.
The seventh line gets the value of the cell.
The eighth line checks if the value is "Yes".
If the value is "Yes", then the ninth line prints the values of all the cells in the row.
The tenth line closes the workbook.