关于Java：使用Apache POI HSSF从Excel工作表中删除一行

LD is tigger forever，CG are not brothers forever， throw the pot and shine forever.
Modesty is not false, solid is not naive, treacherous but not deceitful, stay with good people, and stay away from poor people.
talk is cheap, show others the code and KPI， Keep progress，make a better result.
Survive during the day and develop at night。

目录

概 述

HSSFSheet.removeRow( int rowNum )方法。

/**

• Remove a row by its index
• @param sheet a Excel sheet
• @param rowIndex a 0 based index of removing row
  */
  public static void removeRow(HSSFSheet sheet, int rowIndex) {
  int lastRowNum=sheet.getLastRowNum();
  if(rowIndex>=0&&rowIndex<lastRowNum){
  sheet.shiftRows(rowIndex+1,lastRowNum, -1);
  }
  if(rowIndex==lastRowNum){
  HSSFRow removingRow=sheet.getRow(rowIndex);
  if(removingRow!=null){
  sheet.removeRow(removingRow);
  }
  }
  }

小结

参考

资料和推荐阅读

1.链接: 参考资料.