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);
}
}
}
}
网友评论