poi 删除行

 

其中impled = StringBuffer("");

 

其中数字代表excel中行下标 由0开始.

 

 if(imped.length() > 0){
             
             List<Integer> list = new ArrayList<Integer>();
             String[] errLineNum = imped.toString().split(",");
             for(String s:errLineNum){ 
                   list.add(Integer.valueOf(s));
             }
            
             Collections.sort(list, new Comparator<Integer>(){
            public int compare(Integer res1, Integer res2) {
             // TODO Auto-generated method stub
             return res1 - res2;
            }
          });
            
             int k = 0;
             for(Integer i:list){
              sheet.shiftRows(i+1-k, sheet.getLastRowNum()+1, -1);
              k++;
             }
             
            }