使用apache poi从excel文件中的特定列中筛选特定单元格值？

import org.apache.poi.ss.usermodel.*;

import java.io.FileInputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

public class ExcelFilter {
    public static void main(String[] args) {
        String filePath = "path/to/excel/file.xlsx";
        int columnIndex = 2; // 特定列的索引，从0开始
        String filterValue = "特定值";

        try (FileInputStream fis = new FileInputStream(filePath);
             Workbook workbook = WorkbookFactory.create(fis)) {

            Sheet sheet = workbook.getSheetAt(0); // 获取第一个工作表

            List<String> filteredValues = new ArrayList<>();

            for (Row row : sheet) {
                Cell cell = row.getCell(columnIndex);
                if (cell != null && cell.getCellType() == CellType.STRING) {
                    String cellValue = cell.getStringCellValue();
                    if (cellValue.equals(filterValue)) {
                        filteredValues.add(cellValue);
                    }
                }
            }

            // 处理筛选结果
            for (String value : filteredValues) {
                System.out.println(value);
            }

        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}