Apache-poi:希望遍历excel列并汇总下一列中出现的相应值

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

import java.io.FileInputStream;
import java.io.IOException;

public class ExcelReader {
    public static void main(String[] args) {
        String filePath = "path/to/your/excel/file.xlsx";
        String sheetName = "Sheet1";
        int targetColumnIndex = 0; // 目标列的索引，从0开始
        int nextColumnIndex = 1; // 下一列的索引，从0开始

        try (FileInputStream fis = new FileInputStream(filePath);
             Workbook workbook = new XSSFWorkbook(fis)) {

            Sheet sheet = workbook.getSheet(sheetName);
            if (sheet == null) {
                System.out.println("Sheet '" + sheetName + "' not found!");
                return;
            }

            int rowCount = sheet.getLastRowNum() + 1;
            int sum = 0;

            for (int i = 0; i < rowCount; i++) {
                Row row = sheet.getRow(i);
                if (row != null) {
                    Cell targetCell = row.getCell(targetColumnIndex);
                    Cell nextCell = row.getCell(nextColumnIndex);

                    if (targetCell != null && nextCell != null) {
                        if (targetCell.getCellType() == CellType.NUMERIC) {
                            double targetValue = targetCell.getNumericCellValue();
                            double nextValue = nextCell.getNumericCellValue();
                            sum += nextValue;
                        }
                    }
                }
            }

            System.out.println("Sum of values in the next column: " + sum);

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