poi删除excel行

package com.xzp.utils;

import org.apache.commons.collections4.CollectionUtils;
import org.apache.poi.ss.usermodel.Sheet;

import java.util.Comparator;
import java.util.List;
import java.util.Objects;

public class ExcelUtils {

    /**
     * 删除指定行
     *
     * @param sheet Sheet
     * @param rowNumList 行号列表，excel的rowNum从0开始
     */
    public static void removeRows(Sheet sheet, List<Integer> rowNumList){
        if(Objects.isNull(sheet) || CollectionUtils.isEmpty(rowNumList)){
            return;
        }
        int lastRowNum = sheet.getLastRowNum();
        rowNumList.sort(Comparator.reverseOrder());
        for (Integer rowNum : rowNumList) {
            if(Objects.equals(rowNum,lastRowNum)){
                sheet.removeRow(sheet.getRow(rowNum));
            }else{
                sheet.shiftRows(rowNum + 1, lastRowNum, -1);
            }
        }
    }
}