如何消除POI XSSFWorkbook中零值数据条

XSSFWorkbook workbook = new XSSFWorkbook();

XSSFSheet sheet = workbook.getSheet("Sheet1"); // 获取指定名称的工作表
// 或者
XSSFSheet sheet = workbook.createSheet("Sheet1"); // 创建一个新的工作表

for (int i = sheet.getLastRowNum(); i >= 0; i--) {
    XSSFRow row = sheet.getRow(i);
    boolean isZeroRow = true;
    for (int j = 0; j < row.getLastCellNum(); j++) {
        XSSFCell cell = row.getCell(j);
        if (cell != null && cell.getCellType() == CellType.NUMERIC) {
            double cellValue = cell.getNumericCellValue();
            if (cellValue != 0) {
                isZeroRow = false;
                break;
            }
        }
    }
    if (isZeroRow) {
        sheet.removeRow(row);
    }
}

FileOutputStream outputStream = new FileOutputStream("path/to/output.xlsx");
workbook.write(outputStream);
outputStream.close();
workbook.close();