如何在Java中删除Excel工作表的内容?

问题描述

如何使用Java SE和Apache POI删除Excel工作簿中Excel工作表的内容?

How to delete contents of an Excel sheet in an Excel workbook, using Java SE and Apache POI?

推荐答案

如先前评论中所述

Sheet sheet = wb.getSheetAt(0);
for (Row row : sheet) {
   sheet.removeRow(row);
}

此代码向我抛出ConcurrentModificationException.因此，我已经修改了代码，并且可以正常工作.这是代码:

this code throwing ConcurrentModificationException to me. So, I have modified the code and it's working fine. Here is the code:

Sheet sheet = wb.getSheetAt(0);
Iterator<Row> rowIte =  sheet.iterator();
while(rowIte.hasNext()){
    rowIte.next();
    rowIte.remove();
}

这篇关于如何在Java中删除Excel工作表的内容?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！