用JAVA实现excel中字符串中ID字段的递增

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

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

public class ExcelIDIncrementer {
    public static void main(String[] args) {
        String filePath = "path/to/excel/file.xlsx";
        int idColumnIndex = 0; // ID字段所在的列索引

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

            Sheet sheet = workbook.getSheetAt(0); // 假设ID字段在第一个工作表中

            for (Row row : sheet) {
                Cell idCell = row.getCell(idColumnIndex);
                if (idCell != null && idCell.getCellType() == CellType.STRING) {
                    String idValue = idCell.getStringCellValue();
                    int incrementedId = Integer.parseInt(idValue) + 1;
                    idCell.setCellValue(String.valueOf(incrementedId));
                }
            }

            try (FileOutputStream fos = new FileOutputStream(filePath)) {
                workbook.write(fos);
            }

            System.out.println("ID字段递增完成。");

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