读取Excel文件并跳过空行但不是空列

I wish to read an Excel file and skip the empty rows. My code skips empty cells but it skips empty columns, too. How can I skip empty rows but maintain empty columns? I'm using JXL Java.

我希望阅读一个Excel文件并跳过空行。我的代码跳过空单元格,但它也会跳过空列。如何跳过空行但保留空列?我正在使用JXL Java。

for (int i = 0; i < sheet.getRows(); i++) {
    for (int j = 0; j < sheet.getColumns(); j++) {
        Cell cell = sheet.getCell(j, i);
        String con = cell.getContents();
        if (con != null && con.length() != 0) {          
            System.out.print(con);
            System.out.print("|");
        }
        else {
            continue;
        }
    }
}

1 个解决方案

#1

Try this:

for (int i = 0; i < sheet.getRows(); i++) {
    boolean rowEmpty = true;
    String currentRow = "";
    for (int j = 0; j < sheet.getColumns(); j++) {
        Cell cell = sheet.getCell(j, i);
        String con=cell.getContents();
        if(con !=null && con.length()!=0){
            rowEmpty = false;
        }
        currentRow += con + "|";
    }
    if(!rowEmpty) {
        System.out.println(currentRow);
    }
}

What you were doing is:

你在做的是:

Loop through rows
- Loop through columns
  - Print cell if it's empty only, skip it otherwise (your continue statement does nothing as it's the last instruction in the loop anyway, and a break statement would just stop reading the row once it reaches an empty cell)

循环遍历行循环遍历列打印单元格如果它只是空的,否则跳过它(你的continue语句不执行任何操作,因为它是循环中的最后一条指令,并且一旦它到达空单元格,break语句就会停止读取该行)

What this does is:

这样做是:

Loop through rows
- Loop through columns
  - Append the cell to the row's string, and if it's non-empty then set rowEmpty to false (as it contains at least one non-empty cell)
- Print the row only if it's not empty

遍历行循环遍历列将单元格附加到行的字符串,如果它是非空的,则将rowEmpty设置为false(因为它至少包含一个非空单元格)仅在它不为空时才打印该行

1 个解决方案

#1

更多相关文章

随机推荐