如何使用poi删除excel文件中多行数据

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

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

public class ExcelDataDeletion {
    public static void main(String[] args) {
        String filePath = "path/to/excel/file.xlsx";
        int sheetIndex = 0; // 工作表索引，从0开始
        int startRow = 2; // 要删除的起始行号，从0开始
        int endRow = 4; // 要删除的结束行号，从0开始

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

            Sheet sheet = workbook.getSheetAt(sheetIndex);

            for (int i = startRow; i <= endRow; i++) {
                Row row = sheet.getRow(i);
                if (row != null) {
                    sheet.removeRow(row);
                }
            }

            // 移动删除行后面的行，使行号连续
            sheet.shiftRows(endRow + 1, sheet.getLastRowNum(), startRow - endRow - 1);

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

            System.out.println("删除行数据成功！");
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}