如何在 Java 中删除 Excel 工作表的内容? [英] How to delete contents of an Excel sheet in Java?

问题描述

如何使用 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 工作表的内容?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！