向上移动单元格- Apache POI Get t

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 ExcelMoveCell {
    public static void main(String[] args) throws IOException {
        String filePath = "path/to/your/excel/file.xlsx";
        Workbook workbook = new XSSFWorkbook(new FileInputStream(filePath));
        Sheet sheet = workbook.getSheetAt(0);

        // 获取 A2 单元格
        Row rowA2 = sheet.getRow(1);
        Cell cellA2 = rowA2.getCell(0);

        // 获取 A1 单元格
        Row rowA1 = sheet.getRow(0);
        Cell cellA1 = rowA1.getCell(0);

        // 如果 A1 单元格不存在，则创建它
        if (cellA1 == null) {
            cellA1 = rowA1.createCell(0);
        }

        // 复制 A2 单元格的内容到 A1 单元格
        cellA1.setCellValue(cellA2.getStringCellValue());

        // 清除 A2 单元格的内容
        cellA2.setCellValue("");

        // 保存修改后的 Excel 文件
        try (FileOutputStream fileOut = new FileOutputStream(filePath)) {
            workbook.write(fileOut);
        }

        workbook.close();
    }
}