删除特定行Apache Poi

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

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

public class ExcelUtils {

    public static void deleteRow(String filePath, String sheetName, int rowIndex) throws IOException {
        FileInputStream fis = new FileInputStream(filePath);
        Workbook workbook = WorkbookFactory.create(fis);
        Sheet sheet = workbook.getSheet(sheetName);

        if (sheet != null) {
            Row row = sheet.getRow(rowIndex);
            if (row != null) {
                sheet.removeRow(row);
                // 移动行，使删除的行不留空白
                int lastRowNum = sheet.getLastRowNum();
                if (rowIndex >= 0 && rowIndex < lastRowNum) {
                    sheet.shiftRows(rowIndex + 1, lastRowNum, -1);
                }
            }
        }

        fis.close();

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

    public static void main(String[] args) {
        try {
            String filePath = "path/to/your/excel/file.xlsx";
            String sheetName = "Sheet1";
            int rowIndex = 2; // 要删除的行索引，从0开始计数

            deleteRow(filePath, sheetName, rowIndex);
            System.out.println("删除行成功！");
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}