如何使用Java从Excel (csv)文件中删除行？

import java.io.FileInputStream;
import java.io.FileOutputStream;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ExcelRowDeletion {
    public static void main(String[] args) {
        String filePath = "path/to/excel/file.xlsx";
        int rowToDelete = 2; // 要删除的行号

        try {
            FileInputStream file = new FileInputStream(filePath);
            Workbook workbook = WorkbookFactory.create(file);
            Sheet sheet = workbook.getSheetAt(0);

            // 删除指定行
            sheet.removeRow(sheet.getRow(rowToDelete));

            // 重新调整行号，使行号连续
            int lastRowNum = sheet.getLastRowNum();
            for (int i = rowToDelete + 1; i <= lastRowNum; i++) {
                Row row = sheet.getRow(i);
                if (row != null) {
                    sheet.shiftRows(i, i, -1);
                }
            }

            // 写回到文件中
            FileOutputStream outFile = new FileOutputStream(filePath);
            workbook.write(outFile);
            outFile.close();

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